none
Linking different measures from different cubes on to same report ,

    Question

  • Team ,

    I have a report  which is targetting CUBE_1 retrieving dimensions A,B,C and Measures X,Y,Z . Now i also want to retrieve some more measures from a different Cube CUBE_2 which is  still has same dimensions  onto same report .

    I do not want to use a SubReport here .I dont want to use LooKUp's() too ..

    Can you please advise with some pointers how can we achieve this using MDX  ? Thanks in advance !


    Rajkumar Yelugu



    Friday, February 21, 2014 9:01 AM

Answers

  • Hi Rajkumar,

    According to your description, what you want it that retrieving dimensions A,B,C and Measures X,Y,Z from Multiple CUBE1 and CUBE2 in an MDX query.

    The short answer is yes. To query multiple cubes from a single MDX statement use the LOOKUPCUBE function (you can't specify multiple cubes in your FROM statement). The LOOKUPCUBE function will only work on cubes that utilize the same source database as the cube on which the MDX statement is running. For the detail information about it, please refer to the link below to see the blog.
    Retrieving Data From Multiple Cubes in an MDX Query Using the Lookupcube Function

    Hope this helps.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, February 24, 2014 2:44 AM

All replies

  • Hi Rajkumar,

    According to your description, what you want it that retrieving dimensions A,B,C and Measures X,Y,Z from Multiple CUBE1 and CUBE2 in an MDX query.

    The short answer is yes. To query multiple cubes from a single MDX statement use the LOOKUPCUBE function (you can't specify multiple cubes in your FROM statement). The LOOKUPCUBE function will only work on cubes that utilize the same source database as the cube on which the MDX statement is running. For the detail information about it, please refer to the link below to see the blog.
    Retrieving Data From Multiple Cubes in an MDX Query Using the Lookupcube Function

    Hope this helps.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, February 24, 2014 2:44 AM
  • Thank You Charlie ..This looks like a similar LooKup() Function in SSRS  though .

    Rajkumar Yelugu

    Tuesday, February 25, 2014 11:52 AM