OLAP Question

[Nosferer2]

Hi All

Please help if you can. I am trying to generate Sales reports on OLAP datacubes. What I need to know -

Is there any way that I can update several pivot tables with the same filter? (I need to look up sales and qty values for Brands, Products, Sales people etc. but the filter criteria will all be the same)

How in goodness to you get the % difference from previous to work in an OLAP environment?

Any help would be gretly appreciated.

Regards,

Nosferer2

 

[Nosferer2]

Sorry, that sound a bit confusing - in value field settings I want Year 2008 sales represent as a percentage difference from 2009. OLAP does not support calculated members so I am trying to do it through value field settings. I am sure this works somewhere in the world - just not in my world.