Calculation error in report from mulitple data providers

building reports desktopintelligence
1

I’m having a problem with a report that has 2 data providers both pulling data from the same universe. The first data provider pulls Product, Channel, Quarter, Order #, Ports (measure). The second data provider pulls Product, Channel, Quarter, Order #, Revenue (measure). Because of the way the tables set up and the needs of the user I need to pull with 2 data providers so that I can have one row per order. The queries works fine and they are automatically linked base on Product, Channel, Quarter and Order #. The problem I have run into is breaking and totals. I have a variable that I created based on Ports called Port Range with the following logic:

If Ports <= 4 then “0-4” else if Ports <= 8 then “5-8” etc.

I have included this in my report, however when I break on Port Range I get a #COMPUTATION error for the Revenue Total (see sample below). The other breaks (Product, Channel, Quarter) all produce the correct totals for Revenue. I’m assuming the problem is because the Ports Range variable is based on an object from a different data provider than the one that produces Revenue, the other break objects are in both data providers.

Product Channel Quarter Port Range Order
Ports Revenue
200 Direct 199803 1-4 1000 4
10,000
200 Direct 199803 1-4 2000 4
8,000

200 Direct 199803 1-4 8
#COMPUTATION

I tried having Business Objects create the sum and then tried several different approaches with calculation context, but can’t seem to get it to work. Does anyone have a suggestion on how to solve this?

Thanks,
Sandy Osterback
Lucent Technologies - OMD
408) 324-4304
sosterba@lucent.com

Listserv Archives (BOB member since 2002-06-25)

2

I have 1 suggestion, but you may not like it. What you are doing is the very reason that Business Objects uses Context in the Designer. If you implement Contexts, then you would only need 1 data provider. You would then be able to do all of the summarization you need.

Listserv Archives (BOB member since 2002-06-25)

3

Sandy wrote:

I’m having a problem with a report that has 2 data providers both pulling data from the same universe. The first data provider pulls Product, Channel, Quarter, Order #, Ports (measure). The second data provider pulls Product, Channel, Quarter, Order #, Revenue (measure). Because of the way the tables set up and the needs of the user I need to pull with 2 data providers so that I can have one row per order. The queries works fine and they are automatically linked base on Product, Channel, Quarter and Order #.
The problem I have run into is breaking and totals. I have a variable that
I created based on Ports called Port Range with the following logic:

If Ports <= 4 then “0-4” else if Ports <= 8 then “5-8” etc.

I have included this in my report, however when I break on Port Range I get a #COMPUTATION error for the Revenue Total (see sample below). The other breaks (Product, Channel, Quarter) all produce the correct totals for Revenue. I’m assuming the problem is because the Ports Range variable is based on an object from a different data provider than the one that produces
Revenue, the other break objects are in both data providers.

Product Channel Quarter Port Range Order
Ports Revenue
200 Direct 199803 1-4 1000 4
10,000
200 Direct 199803 1-4 2000 4
8,000

200 Direct 199803 1-4 8
#COMPUTATION

I tried having Business Objects create the sum and then tried several different approaches with calculation context, but can’t seem to get it to work. Does anyone have a suggestion on how to solve this? ____________________________________________ Sandy,
What formulas have you used. If you haven’t tried t yet, you may want to use the same formulat for Product Ports from the detail lines in the total line. Also, does it generate it correctly if you break on a different dimension?

Glenn Fredericks
Data Warehouse Specialist
glenn_fredericks@aal.org
(920) 730-4700 x4236 or 1-800 CALL AAL

Aid Association for Lutherans
4321 N. Ballard Road
Appleton, WI 54919-0001
Visit our Web site at www.aal.org or e-mail us at aalmail@aal.org

AAL… Financial services. Lutheran heritage. A powerful combination.

Listserv Archives (BOB member since 2002-06-25)