on 11-24-2009 6:08 AM
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
Removed
Edited by: Efstratios Karaivazoglou on Nov 24, 2009 10:18 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
80 | |
24 | |
11 | |
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.