Regarding Analysis Services

  • I have written the query in MDX Query Editor in SOL Server 2008 Successfully,

    But the problem is when we implement the same query in Cube(as expression in calculated measure) its not working in SSAS 20008

    The Error is:- Select statement is not correct in MDX Expression

  • Can you provide the MDX statement and the calculation or expression that you are trying to add to the cube? I am assuming you have created a calculation and want to add this into the Calculations tab in the cube.

    If you can provide more details as to what you are trying to do along with the actual MDX statement that you created or at least something that is comparable in the the Adventure Works DW then maybe we can help you out.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply