Parallel period 1

[Guest_imported]

anyone - i'm trying to get an olap cube displaying two sets of measures for different periods. I tried to create 2 cubes with private time dimention and merge them using a virtual cube - failure.

i think you need to use the parallel period function - but i dont know how or where, i think u build a calculated measure - has anyone got example code for this function? am i right - do u use this function?

thankyou Parmz

 

[Welshbird]

Ignore all the help files information on ParallelPeriod- Its all a lie! I finally got it to work by using the following grammer:

iif ( (ParallelPeriod ( [Time Weeks].[Year] ,1 ) , [Version].[Actual] )=0, 0, (ParallelPeriod ( [Time Weeks].[Year] ,1 ) , [Version].[Actual] ))

where Time Weeks is the name if the hierachichal (spell?) time dimension (it needs to have year as a level), nad version.actual is the version dimension to show as last year. You can then use this calculated member in other calculations as long as you set the calculation level correctly (i.e. this one needs to be caclulted first)

Mail me with problems at: willif@mosspharmacy.co.uk

Good luck!

Fiona

Fiona Williams