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

Scope of Analysis & Aggregation

16 Views

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