Results 1 to 5 of 5
  1. #1
    Join Date
    May 2002
    Posts
    1

    Question Measures and Dimensions

    hi!

    i am very new to mdx. i am currently using ms mdx sample application to get data from a cube. i was wondering how come doing the following:

    select
    {<measures>.<member1>, <measures>.<member2>, <dimension1>.members} on columns,
    <dimension2>.members on rows
    from <cube>

    causes the following error:

    unable to open cellset
    formula error - unknown error


    Is it against rules to combine measures and dimensions in a column?

    can someone help me find documentations regarding mdx. if possible programmer's references with examples

  2. #2
    Join Date
    May 2009
    Posts
    1

    Thumbs up

    you are getting unable to open cellset error because you query failed and cellset was not populated.

    try this type of MDX

    select
    ({<measures>.<member1>, <measures>.<member2>}, <dimension1>.members) on columns,
    <dimension2>.members on rows
    from <cube>

    or

    select
    Crossjoin({<measures>.<member1>, <measures>.<member2>}, <dimension1>.members) on columns,
    <dimension2>.members on rows
    from <cube>

    or

    select
    {<measures>.<member1>, <measures>.<member2>} * <dimension1>.members on columns,
    <dimension2>.members on rows
    from <cube>

    Measures are similar type of sets and hence there union is possible, however the collection of Dimension Members is a Tuple and hence cannot be treated as a set and combined with measures.

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Heh - you might have just set the record for longest wait for a solution - 7 years!
    Testimonial:
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Wot - nothing from Rudy to express outrage at someone replying to an old post?

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Finally jacq can finish his project.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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