Measures for different Dimensions 1

[boligoma]

Hi, I have a problem in using 2 measures with different levels, let me give you an example:

I have a measure "Money" in the folowing Dimensions: Company, and Store. And another measure "sales" that is only in the level company.

The next step is to make that the measure "Sales" be the same one (the one that is on the top level that is company) on the Dimension store.

like this:


Company Store Money Sales
----------------------------------------
1 1 100 200
1 2 75 200
1 3 45 200
1 4 32 200
1 TOTAL 252 200

I'm using OLAP Cubes, I've Created two regular cubes: one with the information for the money measure (with dim's company and store) and the other one with the information for the sales (with the dimension for company).

And then I created a Virtual Cube from the first ones, in order to have the same information levels from the cubes. The problem is that the information for the measure Sales is null when you see it through the dim Store.

For the Cognos users is like using two separated sources with different levels of information and use the property to make one measure to be constant in one atribute in particular.

thanks,

 

[Patlin]

Create a calculated measure called Sales_blablabla with the formula:

ValidMeasure ([Measures].[Sales])

I had the same problem and tried to use the cognos solution
but found this solution instead
hope this will work
Best Regards
Patrik

 

[anotherkiwi]

Thanks Patlin

I have been searching for ages for this tip. So to replicate Cognos's Constant allocation of measures to out of scope dimensions use the validmeasure(your measure) in the virtual cube in A.S.