Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

LookupCube (MDX)

Updated: 17 July 2006

Returns the value of a Multidimensional Expressions (MDX) expression evaluated over another specified cube in the same database.


Numeric expression syntax
LookupCube(Cube_Name, Numeric_Expression )

String expression syntax
LookupCube(Cube_Name, String_Expression )

Cube_Name

A valid string expression that specifies the name of a cube.

Numeric_Expression

A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.

String_Expression

A valid string expression that is typically a valid Multidimensional Expressions (MDX) expression of cell coordinates that returns a string.

If a numeric expression is specified, the LookupCube function evaluates the specified numeric expression in the specified cube and returns the resulting numeric value.

If a string expression is specified, the LookupCube function evaluates the specified string expression in the specified cube and returns the resulting string value.

The LookupCube function works on cubes within the same database as the source cube on which the MDX query that contains the LookupCube function is running.

ms144720.note(en-US,SQL.90).gifImportant:
You must provide any necessary current members in the numeric or string expression because the context of the current query does not carry over to the cube being queried.

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft