Please can someone help me with a very basic question.
As an example I want to add another measure to the FoodMart sales cube
showing last years (or equivalent period) Store Sales. I understand that
ParallelPeriod is the function to use, but I can't get it to work - my
calculated measure always comes up empty.
Please could someone tell me the correct expression to use.

Very basic, but very frustrating for a newbie!

--
Message posted via http://www.sqlmonster.com

Anybody able to help?

--
Message posted via http://www.sqlmonster.com

Since the Foodmart Sales cube only has data for 1997, here's an example
for the Foodmart Warehouse cube:

'([Measures].[Units Shipped],
ParallelPeriod([Time].[Year]))'

Select {[Measures].[Units Shipped],
[Measures].[Prev Shipped]} on columns,
[Time].[1998].[Q2].Children on rows
from Warehouse

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

thanks Deepak.
Your suggestion has helped me apply it to my cube and it is now working!
Thank you...
Out of interest, I dont have the Foodmart Warehouse loaded. How can I get
that one loaded?

--
Message posted via http://www.sqlmonster.com

Hi Denise,

I'm glad that you were able to get ParallelPeriod() working for your
cube. The Warehouse cube should get installed with the sample Foodmart
database, which is an option when installing Analysis Services. It's
been a while since I did that, so someone else on the group may know
more?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!