Skip to Content
Former Member
Nov 24, 2009 at 06:08 AM

Scope of Analysis & Aggregation


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.


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.