I've tried to add a Calculated Measure to the MSP_Portfolio_Analyzer cube to calculated Resource Availability using advice from this site:
How to: Calculate Resource Availability in OLAP Cubes
I've used this MDX:
Availability = [Capacity] - [Work]
The cube build now fails with this error:
Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to process the Analysis Services database EPMCubeTest on the sydmssql01 server. Error: Server: Operation completed with 1850 problems logged. Parser: The query contains the Availability parameter, which is not declared. Parser: The syntax for 'Availability' is incorrect. Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to process the Analysis Services database EPMCubeTest on the sydmssql01 server. Error: Server: Operation completed with 1850 problems logged. Parser: The query contains the Availability parameter, which is not declared. Parser: The syntax for 'Availability' is incorrect.
Where am I going wrong ?