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
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