Calcul between differents cubes

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

Hello,

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 ?

Thanks,

NC.

Coordinator
Sep 11, 2009 at 2:56 PM

The function you want is LookupCube if the cube is in the same database as the cube you're querying. http://technet.microsoft.com/en-us/library/ms144720.aspx

If you have any further questions, this is the wrong place to ask general MDX questions. The proper place is:
http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/threads/

Hope that helps

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

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

Coordinator
Sep 25, 2009 at 2: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