Hi,

I am just wondering whether anyone has done this before; I have a sales fact
table in the system and I would like to (using just the analysis service MMC
without writing too much of a query, to create a calculated cell that returns
a growth percentage).

Ie. if CurrentMember = '0405' the find the figure for last year and divide
it to give me a percentage. I have had a look at the parallel period but
since our dimenision for the finanical calendar is not set as time... I don't
know if it will work.

Any info would be appericated.

Thanks

ParallelPeriod() can be used with dimensions that are not labelled as
"Time" dimensions, if you override defaults:

From SQL Server BOL>>

ParallelPeriod([«Level»[, «Numeric Expression»[, «Member»]]])

This function has the following defaults:

Default «Member» value is Time.CurrentMember if «Level» is not
specified. Otherwise it is dimension.CurrentMember, where dimension is
the dimension to which level belongs.

Default «Numeric Expression» is 1.

Default «Level» is the level of the parent of «Member».

- Deepak

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