Asked by:

Deployment wizard problems with MDX scripts

Question

I am trying to move and process SSAS solution with deployment wizard from SQL SErver 2008 R2 to SQL SERVER 2012. It cant process data because of error for all MDX scripts based in CALCULATION tab in SSDT project.

Error is MdxScript (10 ,10) xxxxxxxxxxxxxxxx The level object was not found in the cube when the string xxxxx is parsed.

It looks like it has problem to deploy those scripts before simple cube is processed.

So I tried to comment all MDX scripts in my SSDT project and build solution again. Then I deployed and process solution again with deployment wizard and I was successfull.

Could anyone give me hint how to do that with wizard ? If I need to seperate processing without scripts and processing of only MDX scripts ?