Calculated Measures MDX error

M

Meghanath Singh

I am trying to create some custom Calculated Measures using the Cube
Configuration page. I am using Project Server 2007.

The Calculated Measures are as follows:

Capacity = ValidMeasure([Measures].[Temporary Capacity])

Billable Hours = SUM([Measures].[Work],[Project Category_Project].[Project
Category_Project].&[{A010DE96-287F-443D-8E43-ECF713F4286D}])

However I get the following error message:

Failed to build the OLAP cubes. Error: Analysis Services session failed with
the following error: Failed to process the Analysis Services database
TSProjectData2 on the 192.168.1.5 server. Error:
MdxScript(MSP_Project_Timesheet) (1, 89) Parser: The syntax for ')' is
incorrect. MdxScript(MSP_Project_Timesheet) (1, 84) Parser: The syntax for
',' is incorrect. MdxScript(MSP_Project_Timesheet) (1, 98) Parser: The syntax
for ',' is incorrect. MdxScript(MSP_Project_Timesheet) (1, 82) Parser: The
syntax for ',' is incorrect. MdxScript(MSP_Project_Timesheet) (1, 93) Parser:
The syntax for ')' is incorrect. MdxScript(MSP_Project_Timesheet) (1, 99)
Parser: The syntax for ')' is incorrect. MdxScript(MSP_Project_Timesheet) (1,
86) Parser: The syntax for ',' is incorrect. MdxScript(MSP_Project_Timesheet)
(1, 82) Parser: The syntax for ',' is incorrect.
MdxScript(MSP_Project_Timesheet) (1, 87) Parser: The syntax for ')' is
incorrect. MdxScript(MSP_Project_Timesheet) (1, 99) Parser: The syntax for
')' is incorrect. MdxScript(MSP_Project_Timesheet) (1, 93) Parser: The syntax
for ')' is incorrect.

Is there anything wrong that I seem to be doing here?

Thanks

Meghanath
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top