[2007] MDX Expression in PWA

[jcano]

Hi everyone:
I don't know if this is for this forum or for the MSDN one. I have a problem
creating MDX expressions in the cube configuration page of PWA. I've been
trying to set an MDX expresion for Availability (the one which appears in the
SDK) and then appears an error message that says something like these:
- The number of custom fields aggregated as dimensions can be more than 100
- Each custom field name is valid for OLAP cube
- The custom field, calculated measures and integrated OLAP objects of
Project Server have a different name between themselves.
(Sorry for the translation, but I think it is a good approximation)
What I wrote is, in the MSP_Portfolio_Analyzer cube
Integrated Member: Availability
MDX Expression: [Capacity]-[Work]

 

[Dale Howard [MVP]]

jacano

I think the formula for the Measure you wish is:

[Measures].[Capacity] - [Measures].[Work]

Let us know if this helps.

 

[jcano]

Hi Dale:
I've tried it, and doesn't work. I've no idea why it doesn't work. Have you
tried this MDX expression?
Anyway thanks

jacano

I think the formula for the Measure you wish is:

[Measures].[Capacity] - [Measures].[Work]

Let us know if this helps.

Hi everyone:
I don't know if this is for this forum or for the MSDN one. I have a
problem
creating MDX expressions in the cube configuration page of PWA. I've been
trying to set an MDX expresion for Availability (the one which appears in
the
SDK) and then appears an error message that says something like these:
- The number of custom fields aggregated as dimensions can be more than
100
- Each custom field name is valid for OLAP cube
- The custom field, calculated measures and integrated OLAP objects of
Project Server have a different name between themselves.
(Sorry for the translation, but I think it is a good approximation)
What I wrote is, in the MSP_Portfolio_Analyzer cube
Integrated Member: Availability
MDX Expression: [Capacity]-[Work]

 

[Dale Howard [MVP]]

jcano --

Yes, I have not only tried the expression on my owns system, but it actually
works. Sorry I can't be more help.

Hi Dale:
I've tried it, and doesn't work. I've no idea why it doesn't work. Have
you
tried this MDX expression?
Anyway thanks

jacano

I think the formula for the Measure you wish is:

[Measures].[Capacity] - [Measures].[Work]

Let us know if this helps.

Hi everyone:
I don't know if this is for this forum or for the MSDN one. I have a
problem
creating MDX expressions in the cube configuration page of PWA. I've
been
trying to set an MDX expresion for Availability (the one which appears
in
the
SDK) and then appears an error message that says something like these:
- The number of custom fields aggregated as dimensions can be more than
100
- Each custom field name is valid for OLAP cube
- The custom field, calculated measures and integrated OLAP objects of
Project Server have a different name between themselves.
(Sorry for the translation, but I think it is a good approximation)
What I wrote is, in the MSP_Portfolio_Analyzer cube
Integrated Member: Availability
MDX Expression: [Capacity]-[Work]