Sum up different measures from two different contexts

building semantic layer
1

Hello,
is it possible to sum up two different measures from two different contexts?

I have two measures, first comes from the fact1 and the second one comes from the fact2.
Now I have to sum them up.

Is it normal situation or some redesign should be considered?

bobmeediake :estonia: (BOB member since 2008-12-01)

2

hi,

Is there a join between thw two facts and is there any common keys between the two facts?
You can sum up the measures from two facts but there needs to be common dimensions for the same.

Please provide us with an example to clarify your situation

Thanks
Siddhartha

siddhartha.dubey :india: (BOB member since 2006-09-13)

3

You can’t sum across contexts in the universe, but you should be able to do so in the report.

Dave Rathbun :us: (BOB member since 2002-06-06)

4

Thanks for answers. We already solved the problem using Oracle-s Materialized View-s.
We just expanded the original fact_table with the help of mat. view in oracle and everything works fine.

bobmeediake :estonia: (BOB member since 2008-12-01)