MS SQL Server OLAP - Virtual Cube and MDX

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Virtual Cube and MDX

ricocali@hotmail.com

2005-08-31, 1:24 pm

I have two cubes that I want to join together but don't want to use a
virtual cube. How is this constructed using MDX? Do I use "FROM"

mike

2005-08-31, 8:24 pm

virtual cube is easiest way to go, but if you don't want to create a virtual
cube then using the "lookupcube()" mdx function may get you what you want.
You need to be careful though that you are doing the lookup at the same
dimension / member level in the 2nd cube you are using.

"ricocali@hotmail.com" wrote:

> I have two cubes that I want to join together but don't want to use a
> virtual cube. How is this constructed using MDX? Do I use "FROM"
>
>

Sponsored Links