Post reply

Substitute for OpenRowSet() function in MDX

  • March 25, 2008 at 4:12 am

    #204664

    I want to access the cube stored on different server by using MDX function and not by using T-sql OpenRowSet()

  • March 26, 2008 at 7:13 am

    #793999

    Try the LookupCube() Function. Here is the syntax:

    LookupCube(cube_string, string_expression)

    example:

    LookupCube("Budget", "[Account].[Total Expense]")

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

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