Help on MDX 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!

 

[Bryant Likes]

I am trying to create an MDX expression (first time ever) in the cube
configuration area.

You should try the SQL Server groups, this group is for Microsoft Project
Server.