on 04-12-2011 7:26 PM
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?
????
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, when you define a measure where both of the columns which you used in calculation are from different contexts. So compatability issue comes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.