PS2007 Cube configuration

[mike.mahoney]

Hi

Can someone provide an example of a suitable mdx expression to enter
in the calculated measures section of the Cube Configuration (PS2007 /
SQL2000). I am doing the following:

Using MSP_Portfolio Analyser (also tried Resource Timephase)

Member Name - Cum Work
MDX Expression - Sum(PeriodsToDate([Time].[All]),Work)

but a window pops up and says " Type the member name and definition"
- what am I doing wrong?

Thanks

Mike

 

[mike.mahoney]

Hi

Can someone provide an example of a suitable mdx expression to enter
in the calculated measures section of the Cube Configuration (PS2007 /
SQL2000). I am doing the following:

Using MSP_Portfolio Analyser (also tried Resource Timephase)

Member Name - Cum Work
MDX Expression - Sum(PeriodsToDate([Time].[All]),Work)

but a window pops up and says " Type the member name and definition"
- what am I doing wrong?

Thanks

Mike

Please ignore
- the problem was caused by an invalid entry which I was not aware
of. Entries are not validated until you save, so probably best to do
one at a time.

Thanks

Mike