Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    9

    Question Unanswered: olap: mdx: member properties II:

    still plugging away at mdx syntax.

    i can create an mdx query that uses an intrinsic member property eg. "Key" or "Name", but when i create a new member property, "Alias"
    then i get an mdx error msg of "Property Name is not valid".

    the querys are :

    this one works..

    SELECT {[Actual 01/02]} ON COLUMNS,
    Filter ([Measures].Members, [Measures].CurrentMember.Properties( "Name" ) = "A3998" ) ON ROWS
    FROM [cube10]
    WHERE ([Local] , [Base Dimension 6] , [O2100] , [Base Dimension 7], [P04] )

    and this one doesnt.. (Property Name is not valid)

    SELECT {[Actual 01/02]} ON COLUMNS,
    Filter ([Measures].Members, [Measures].CurrentMember.Properties( "Alias" ) = "Profit" ) ON ROWS
    FROM [cube10]
    WHERE ([Local] , [Base Dimension 6] , [O2100] , [Base Dimension 7], [P04] )

    The cube is ROLAP, real-time cube. The dimensions tables are parent-child.
    Querying the cube via 'MDX Sample Application"
    I have reprocessed dimensions and cube to the max, to no avail.
    When browsing the dimension data, the property displays correctly under Member Properties in the dimension editor.

    I would be grateful for any tips, ideas from experienced OLAP people out there.
    thanks

  2. #2
    Join Date
    Nov 2002
    Location
    UK
    Posts
    1
    I solved it by removing the "All Members" level from the hierarchy. The All Members level can't have custom properties and hence causes the error.

    I suspect that an IIF in the Filter to explicitly check for the correct levels prior to applying test would also work.

    Regards,

    Rob

  3. #3
    Join Date
    Mar 2002
    Posts
    9
    Originally posted by Robert Lee
    I solved it by removing the "All Members" level from the hierarchy. The All Members level can't have custom properties and hence causes the error.

    I suspect that an IIF in the Filter to explicitly check for the correct levels prior to applying test would also work.

    Regards,

    Rob
    Thanks rob,
    will try that.
    jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •