on 11-04-2013 9:03 AM
Good morning
In Business Objects XI3, I am trying to create a measure that is based on two seperate measures. Each of these measures is aggregate aware, and works on different contexts.
This parses Ok in Business Objects Universe, but the errors in Webi with SQL Generation Failed. The first two measures work perfectly.
I can create this calculation in Webi fine, just not in the Universe layer, which is where it really needs to be.
A more detailed summary:
Measure1:
@Aggregate_Aware(Table1.MetricA,Table2.MetricA,Table3.MetricA)
Measure2:
@Aggregare_Aware(Table4.MetricB,Table5.MetricB,Table6.MetricB)
Measure3:
@Select(Measure1)+@Select(Measure2)
(This is the one that fails.)
You can't and you shouldn't.
Are the granularities of Table1 and Table4 exactly the same?
Are the granularities of Table2 and Table5 exactly the same?
Are the granularities of Table3 and Table6 exactly the same?
If you've answered yes to any of these, then why are the corresponding metrics in different tables?
If you've answered no to any of these, then that confirms why you shouldn't be adding the values together at the universe level - you're going to incorrectly inflate the results.
Indeed, can you guarantee that the same level of aggregate will be chosen?
Say your aggregates are monthly, weekly and daily.
Something in your query may dictate that one piece of the SQL goes to the weekly table (Table2) and the other goes to the daily table (Table6). How would you expect @Select(Measure1) + @Select(Measure2) to work?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks mark
the issue is that the aggregates are based on;
> downtime by component by day / month / year
> uptime by day / month / year
so uptime can't be held in the same table as uptime is an overall daily figures, and cannot be split by component.
because of this I need to create a calculation based on the two contexts.
so to clarify, there is no way of doing a calculation based on two contexts in the universe layer, only in the webi layer?
Moved to Semantic Layer space
Please post this type of content there in the future
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
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.