cancel
Showing results for 
Search instead for 
Did you mean: 

Scope of Analysis & Aggregation

Former Member
0 Kudos

Hi All,

I am new to Business Objects Egde and I am struggling to do something quite simple. I have the following tables:

Table 1

Sales rep | Target

A |$100

Table 2

State | Sales Rep | Clinic |Revenue

NSW |A |X |$5

NSW |A |Y |$8

In Web Intelligence, I want a report to return the target at the state level first and then using the drill-down functionality at the sales rep and clinic level. When using the state/sales rep scope of analysis I get the right result, but as soon as I add the clinic to the scope the result is wrong.

Results

Scope of analysis = State/Sales Rep

State |Target |Revenue

NSW |$100 |$13

Scope of analysis = State/Sales Rep/Clinic

State |Target |Revenue

NSW |$200 |$13

How should I define the target (in the universe or in WebI) so that I can get the right results (ie, $100) and the clinic in the scope of analysis?

Thanks in advance.

Regards,

Emilie

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Removed

Edited by: Efstratios Karaivazoglou on Nov 24, 2009 10:18 AM

0 Kudos

Hi

BO Edge works as follows:

since you are displaying the data of two queries in one table it builds the product of the two tables:

State | Sales Rep | Clinic |Revenue| Target

NSW |A |X |$5 | $100

NSW |A |Y |$8 | $100

If you assign only the State and the Sales Rep dimensions in your table then WebI aggregates the Target and Revenue key figures. I assume that you have assigned your key figures in the universe the sum operator.

Table 3

State | Sales Rep | Revenue| Target

NSW |A |X |($5 + $8) | ($100 + $100)

Keep in mind that first the aggregated table is build internally (Table 3) and then the drill is done.

Regards,

Stratos

Former Member
0 Kudos

Hi Stratos,

Thanks for the quick reply. I do understand the way WebI aggregates the 2 queries, but is there a way around that (ie, re-design of the universe and/or WebI)?

Thanks in advance.

Regards,

Emilie