Help on MXD expression

[Avi]

I am trying to create an MDX expression (first time ever) in the cube
configuration area. Below is the MDX expression. The intention is to
format Budget cost field using the VBA round function. I could be
totally wrong .. but i need to get this done and found the below
sample code on technet. can somebody please look and help?

WITH MEMBER [Measures].[Budget Cost formatted] AS VBA!ROUND([Measures].
[Budget Cost],0) SELECT { [Measures].[Budget Cost formatted] } ON 0,
NON EMPTY{ [Customer].[Customer].[Customer] } ON 1 FROM
[MSP_PORTFOLIO_ANALYZER]

This is in PS2007 SP1

thanks!

 

[Paul Conroy]

AVI,

You're more likely to get a response if you post this question to the
Project Developer Forum.

Paul
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.
http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

 

[Avi]

AVI,

You're more likely to get a response if you post this question to the
Project Developer Forum.

Paul
--
Did this post help you. Consider passing on the good will by making a
donation this great charity.http://www.fundraiseonline.co.nz/TheProjectServerGuru/

http://theprojectserverguru.spaces.live.com

I am trying to create an MDX expression (first time ever) in the cube
configuration area.  Below is the MDX expression.  The intention is to
format Budget cost field using the VBA round function.  I could be
totally wrong .. but i need to get this done and found the below
sample code on technet.  can somebody please look and help?

WITH MEMBER [Measures].[Budget Cost formatted] AS VBA!ROUND([Measures].
[Budget Cost],0) SELECT { [Measures].[Budget Cost formatted] } ON 0,
NON EMPTY{ [Customer].[Customer].[Customer] } ON 1 FROM
[MSP_PORTFOLIO_ANALYZER]

This is in PS2007 SP1

thanks!- Hide quoted text -

- Show quoted text -

Thank you Paul