Hi, All!
It is not urgent but it is interesting for me to know...
.....
As a consequence of the question of Cone( 2 Databases in a Olap Cube )
- I have built a virtual cube, bases on two cubes from different databases
Now, I tried to combine data but I see (and it is logic) that I cannot really combine data from two databases, but only ask this virtual cube using Dimensions from the first cube or the second cube - but not together.
If somebody succeeded to ask MDX query (and get results) combining dimensions from both cubes, e.g. making sum of values from two cubes from the data of specific time - please, send me an example.
Personally I think, it is not logic to combine dimensions from two different databases, but I am not sure in this...
Thank, Issahar
It is not urgent but it is interesting for me to know...
.....
As a consequence of the question of Cone( 2 Databases in a Olap Cube )
- I have built a virtual cube, bases on two cubes from different databases
Now, I tried to combine data but I see (and it is logic) that I cannot really combine data from two databases, but only ask this virtual cube using Dimensions from the first cube or the second cube - but not together.
If somebody succeeded to ask MDX query (and get results) combining dimensions from both cubes, e.g. making sum of values from two cubes from the data of specific time - please, send me an example.
Personally I think, it is not logic to combine dimensions from two different databases, but I am not sure in this...
Thank, Issahar