cancel
Showing results for 
Search instead for 
Did you mean: 

Incompatible measures?

Former Member
0 Kudos

I have four fct tables and four dmn tables;

f.cur

f.target

f.prior yr cur (alias of cur)

f.prior yr tar (alias of target)

d.dateA (alias of calendar date table)

d.dateB (alias of calendar date table)

d.type

d.location

each dmn table joins (1:n) to each fct table

I also have a context for each fct table

When I try to create a report with d.dateA.sysdate, d.type.new, f.cur.budamt, f.target.targetamt it works fine, (two select statements) however, when I try to add a measure to the universe "var_amt" defined as sum(f.cur.budamt - f.targetamt), I get incompatible objects?

????

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You cannot create a measure that combines columns from multiple fact tables in a universe object.

You will need to create it at the report level.

I've read that this will be possible in v4 - certainly beats user education!

Answers (3)

Answers (3)

Former Member
0 Kudos

thx

Former Member
0 Kudos

thx

Former Member
0 Kudos

Yes, when you define a measure where both of the columns which you used in calculation are from different contexts. So compatability issue comes.