---
title: "LookupCube (MDX) | Microsoft Docs"
ms.date: 06/04/2018
ms.prod: sql
ms.technology: analysis-services
ms.custom: mdx
ms.topic: reference
ms.author: owend
ms.reviewer: owend
author: minewiskan
---
# LookupCube (MDX)


  Returns the value of a Multidimensional Expressions (MDX) expression evaluated over another specified cube in the same database.  
  
## Syntax  
  
```  
  
Numeric expression syntax  
LookupCube(Cube_Name, Numeric_Expression )  
  
String expression syntax  
LookupCube(Cube_Name, String_Expression )  
```  
  
## Arguments  
 *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.  
  
## Remarks  
 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.  
  
> [!IMPORTANT]  
>  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.  
  
 Any calculation using the **LookupCube** function is likely to suffer from poor performance. Instead of using this function, consider redesigning your solution so that all of the data you need is present in one cube.  
  
## Examples  
 The following query demonstrates the use of LookupCube:  
  
 `WITH MEMBER MEASURES.LOOKUPCUBEDEMO AS`  
  
 `LOOKUPCUBE("Adventure Works", "[Measures].[In" + "ternet Sales Amount]")`  
  
 `SELECT MEASURES.LOOKUPCUBEDEMO  ON 0`  
  
 `FROM [Adventure Works]`  
  
## See Also  
 [MDX Function Reference (MDX)](../mdx/mdx-function-reference-mdx.md)