none
question about mdx

    Question

  • Hi everyone,

     

    I want all the values of the dimension Lines in a mdx query.

    The column is a dummy value.

     

    SELECT {[123]} ON 0, [Line].[Lines].members PROPERTIES UNIQUE_NAME, MEMBER_CAPTION, LEVEL_NUMBER, PARENT_UNIQUE_NAME ON 1 FROM BPR_WEB

     

    This query has always worked verry good, but now I got an error:

     

    Query (1, 9) The dimension '[123]' was not found in the cube when the string, [123], was parsed.

     

    Has anybody an idea what the cause of this error is?

     

    thanks!!

     

    Filip

     

    Tuesday, September 04, 2007 1:23 PM