BusinessObjects Board

Multiple DataProvider - only show commun results

building reports desktopintelligence
#1

Hello,

I’m in BO 5.1.2 full client - using an Oracle Database - DataProviders based on one same universe.

I’ve 3 DP

  • First one gives me the list of country and the sales details
    (contry, date, saler)

  • France / 15/03/2006 / Alex

  • France / 15/03/2006 / David

  • France / 18/03/2006 / Bertrand

  • Germany / 15/03/2006 / Alex
    …

  • Second one gives me the list of country that are in a region

  • Europe / France

  • Europe / Germany

  • Europe / Spain
    …

  • Third one gives me the salers for a country

  • France / Alex

  • France / Vincent

  • France / Fabrice

  • Germany / Alex
    …

I’ve linked the 3 DP on the country -
What I’d like to do is to get only the country wich are in the 3 DP.
If no sales are done in the country I don’t want to display it in the report.
But, as they are in the two ohters, it is shown. What do I have to do to avoid this ?

Thanks for your help.

persone selling ship and the number of sales
Alex - 50
David - 100

allex2108 :fr: (BOB member since 2005-10-07)

#2

This post should cover everything you need.

#3

Hi,

Thanks for this presentation but it didn’t help…
I didn’t find the answer to my question.
What I’d like to do is define a variable which would be the intersection of the same variable of all the 3 DP.

For example,

If the result are :
DP1 - France, Germany, Spain,
DP2 - France, USA, Japan
DP3 - France, Portugal, Greece

The only one country shown in my table would be “France” and if the “France” isn’t in the third DP, the table would be empty.

Is there a way to do that ?

Thanks for your help.

allex2108 :fr: (BOB member since 2005-10-07)

#4

Have you tried creating a flag/filter or two to resolve this?

=If Not IsNull(<Object(DP1)>) Then 1 Else 0)

and then filter on the results of these?

Regards,
Mark