data refreshing after de-pivot

xuanzheng · November 15, 2010 1:42PM

Hi,
I am just wondering if it possible to get data refreshed after depivoting the dataset,
I basically depivot the orginal dataset twice. if i updated the data, will the depivot result get updated as well.
Thanks
Xuan

steve · November 15, 2010 5:29PM

If you're using Omniscope 2.5 or Pro edition, you'll need to import your data from an external source (rather than enter it into the table view yourself), then depivot. Subsequently refreshing from source will repeat the depivot.

If you're using Omniscope 2.6 DataManager edition, you'll be able to visualise the data sources and operations such as depivot. Whenever you refresh the sources, depivot will automatically refresh. You can use the auto refresh settings to make the refreshes happen in the background and immediately after the source changes. See Data menu > Automatic refresh.

Welcome!

Categories

Ideas Parade