I entered an MDX query for the Project Non Timephased cube that had incorrect syntax causing the cube to fail. I removed the query from the PWA Cube Configuration screen, but it
keeps re-appearing in the build, triggering the same error. I used SQL Server Business Intelligence Development Studio to remove the MDX calculations and was able to successfully process the cube. But every time the scheduled cube is built, triggered from
PWA, the MDX query appears again, causing an error and failing to build the cube.
Where is the MDX query data being stored? I know I can just rename the cube and this error will probably go away, but that's not a good long term solution as I would have to repoint
all the Data Analysis views to the cube.
Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to process the Analysis Services database ITPrjPrt
on the Idesql3.ead.external.lmco.com server. Error: MdxScript(Project Non Timephased) (1, 67) Parser: The syntax for '-' is incorrect. MdxScript(Project Non Timephased) (1, 81) Parser: The syntax for '-' is incorrect.
Any help is greatly appreciated!
Travis
