cancel
Showing results for 
Search instead for 
Did you mean: 

Measure based on two aggregate aware contexts?

Former Member
0 Kudos

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.)

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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?

Former Member
0 Kudos

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?

Former Member
0 Kudos

I think you're going some way to answering your own question.

Is uptime the sum of all components' uptime?

Is, by definition, uptime for a component equal to 24 hours - number of down hours?

There may be something that you can achieve with a derived table depending upon the answers to those.

TammyPowlas
Active Contributor
0 Kudos

Moved to Semantic Layer space

Please post this type of content there in the future