BusinessObjects Board

Problem Joining Data Providers

building reports desktopintelligence
#1

Hi All,

I am very new to Desktop Intelligence so dont be to hard on me.

I have two queries:

Query 1 contains the columns:

APP_ID
STATUS
MONTH
YEAR

Query 2 contains the columns:
EGRANT_ID
STATUS_CD
DATE

They are each from different data providers.

What I am trying to do is JOIN on the ID’s so basically it will look like

ID STATUS MONTH YEAR STATUS_CD DATE

so basically I just want to show only the ID’s that match up.

I just dont know where to even start with this. I read in the documentation about linking data providers but that doesnt really help.

Can anybody help me please??

Thanks.

prayfoursurf (BOB member since 2007-05-15)

#2

Hi

Open your Datamanager window and come to Definition Tab and select the object of your first dataprovider and click Link to. This will take you the objects of your second dataprovider. Select the object which you wanted to link in the second dataprovider and give ok.

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

#3

I did that. I linked the app_id with the egrant_id but I am not able to create a report with these columns:
ID STATUS MONTH YEAR STATUS_CD DATE

I can get a report with
ID STATUS MONTH YEAR

but I can not add STATUS_CD and DATE to the report.

Any suggestions on how to add them?

prayfoursurf (BOB member since 2007-05-15)

#4

They need to be “detail” objects rather than “dimension” objects, otherwise you will get a message about the variables being incompatible. A description for this can be found in the FAQ for Business Objects. The FAQ post describes what you can or cannot use together.

So to pull everything into one block, you link by dimensions and then can combine detail or measure objects. But additional dimensions that are not linked are considered as a potential cartesian (cross-product) join and therefore are not allowed to be used.

Dave Rathbun :us: (BOB member since 2002-06-06)

#5

Thank you very much Dave, I got them all in the report but now I want to make it so that the report only shows the ID’s from APP_ID that match with the ID’s in EGRANT_ID.

Is there a way to do that?

I appreciate all the help.

Scott

prayfoursurf (BOB member since 2007-05-15)

#6

It’s another FAQ :wink:

Dave Rathbun :us: (BOB member since 2002-06-06)

#7

Thank you very much Dave I appreciate it. It works now!! :yesnod:

prayfoursurf (BOB member since 2007-05-15)