This project has moved and is read-only. For the latest updates, please go here.

Calcul between differents cubes

Topics: Resolved
Sep 11, 2009 at 1:26 PM


I'm starting using OLAP PivotTable Extensions and i would like to know if we can make a calcul with values wich are in two differents cubes ? If we can, what is the syntaxe to use ?



Sep 11, 2009 at 3:56 PM

The function you want is LookupCube if the cube is in the same database as the cube you're querying.

If you have any further questions, this is the wrong place to ask general MDX questions. The proper place is:

Hope that helps

Marked as answer by furmangg on 6/10/2014 at 3:46 PM
Sep 25, 2009 at 1:43 PM

Thanks you for answer, but can i use MDX query in the Calculation field in OLAP Pivot Table?

Sep 25, 2009 at 3:48 PM

In the Formula field you want to put something like this:

LookupCube("Direct Sales", "[Measures].[Internet Sales Amount] * 2")

Hope that helps. If you have questions beyond that, you should ask them in the forum I mentioned above, as this is not the place for general MDX questions.

Marked as answer by furmangg on 6/10/2014 at 3:46 PM