Returns the value of a Multidimensional Expressions (MDX) expression evaluated over another specified cube in the same database.
LookupCube(Cube_Name, Numeric_Expression )
LookupCube(Cube_Name, String_Expression )
A valid string expression that specifies the name of a cube.
A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.
A valid string expression that is typically a valid Multidimensional Expressions (MDX) expression of cell coordinates that returns a string.
with
member measure.SSSSSS as lookUpCube("logistics.test", "(measure.cost)")
select
{ ( measure.[sales amount] ), (measure.SSSSSS) } on 0,
children(Calendar.[ALL].[2021]) on 1
from [Online Store] ;
| sales amount | SSSSSS | |
| Q1 | 4320 | 123722340.5395404 |
| Q2 | 4320 | 123722340.5395404 |
| Q3 | 22088 | 123722340.5395404 |
| Q4 | 21231 | 123722340.5395404 |