BusinessObjects Board

Variable not compatible Error

building reports desktopintelligence
#1

Hi All,

I am getting an error Variable not compatible.

The report consists of two Data Providers, with links to Sales order id and Line item num.

Query 1 is the main query.

Query 2 is linked to the main query on the above two fields.

I am trying to create a report from Query1 and Query2. I am able to add few fields from Query 2. But when I add other fields from Query 2 I get the error Variable not compatible.

Please help with a possible solution.

Thanks,

Regards,

Prabhakar.

pchettiar9 (BOB member since 2002-10-30)

Link between 2 data sources in BO Reporter
Display all the columns in both the dataproviders
#2

You need to see the DP synchronizatoin related concepts. This will be helpful to you

Hope it helps.

salam :pakistan: (BOB member since 2005-01-27)

#3

Hi Prabhakar,

You cannot add all the fields from query2. You can add the measure objects but not all the dimension objects. You can add only those dimension objects which are linked to the dataprovider (Query1 in your case).

Raja Saripalli :us: (BOB member since 2005-12-14)

#4

Create a detail object in your report and add thiis detail object to your table!!

Mahi (BOB member since 2004-07-22)

#5

Thanks a lot !

I created a detail object and associated it with the Dimension and it worked.

Thanks,

Prabhakar

pchettiar9 (BOB member since 2002-10-30)