Hi,

In SSAS2005, all dimensions are shared. So, I have two cubes, one (A)
with data story, and one (B) with real-time data. Both cubes have the
same dimensions with the same grain level. I want to read the measures
of Cube A from Cube B using a calculated member with the command
LookUpCube. In AS2000 it's possible but I must specified the common
dimensions in order to read the measure. In AS2005 can I specify only
the cube-measure and not the dimension, such as:

LookUpCube("myCube","Measures.myValue")

?

thanks!

Cristian Marchi Anildo
DaisyLabs - a Business Intelligence Company
www.DaisyLabs.com

Hi Cristian,

I haven't yet tried LookupCube() in AS 2005, but still wondering why you
wouldn't use 2 partitions for real-time and history in the same cube,
rather than 2 separate cubes?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak,

because the analysis type is different between real-time analysis and
history analysis. So, also the multidimensional model it's changed. The
measures are the same, but the dimensions of analysis are a subset. So,
there are two cubes and only one, the history, is partitioned for week.

The Fact Table of Rolap Cube contain only the last week of data with
more than three millions of rows. This fact table is also a Fact
Dimension. While, the MOLAP cube is very big...more or less 600GByte,
and the fact tables contain five years of story with more than 150
millions of rows for year

Regards

Cristian marchi anildo

Deepak Puri ha scritto: