BusinessObjects Board

Variablres are not compatible

building reports desktopintelligence
#1

I have the following problem -
I have two data providers in one report. The tabular display , by default will have column headings like “Studio (Query1 with Universe1)” and uses the formula Nameof(<Studio (Query1 with Universe1)">) I am trying to replace these default headings by texts like “Studio” etc. I tried various options - BO always indicates “Variables are not compatible” I am using BO 4.1.6
What is the method of changing default column headings in a table ? Thanks
Abhijit Bhattacharya

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

Column Headings cannot be edited
#2

If your only trying to change the column headings, you should be able to double click on the heading and type any text you want.

Minal :slight_smile:

I have the following problem -
I have two data providers in one report. The tabular display , by default
will have column headings like “Studio (Query1 with Universe1)” and uses the
formula Nameof(<Studio (Query1 with Universe1)">) I am trying to replace these default headings by texts like “Studio” etc. I
tried various options - BO always indicates “Variables are not compatible”
I am using BO 4.1.6
What is the method of changing default column headings in a table ? Thanks
Abhijit Bhattacharya

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

#3

I am trying to replace these default headings by texts like “Studio” etc. I tried various options - BO always indicates “Variables are not compatible” I am using BO 4.1.6
What is the method of changing default column headings in a table ?

Try this…

In the data manager. Go to the smaller of the two queries (the one with fewer result objects). Link all objects in this query to an object in the second query. The links don’t need to be logical. Return to your data grid. Change your headings. Return to the data manager and unlink your queries on all but the original logical field(s). Presto!

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

#4

Hi,

If you can not type the strings in the header (which is a malfunction of B.O. up to my opinion), try to create a variable which just holds the string. Make it a detail object linked to nothing. Put this variable in your header and see … it works !

Good Luck

Kind regards,

Paul Vandenhende
BusinessObjects Consultant
Tel : 0477/390.637
http:/www.sofico.be

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

#5

In a message dated 00-03-15 21:24:47 EST, you write:

I have two data providers in one report. The tabular display , by default
will have column headings like “Studio (Query1 with Universe1)” and uses
the
formula Nameof(<Studio (Query1 with Universe1)">) I am trying to replace these default headings by texts like “Studio” etc. I tried various options - BO always indicates “Variables are not compatible” I am using BO 4.1.6
What is the method of changing default column headings in a table ?

Combining queries in BusObj requires linked dimensions. Any dimensions from different data providers that are not linked are said to be incompatible. However, there are a couple of loopholes where BusObj will slip up and allow you to insert objects (dimensions) that are truly incompatible.

Once this happens (and I have seen it at three different client sites, at least) they BusObj locks up and won’t even let you change column headings.

So, your problem isn’t that you can’t change the heading, your problem is that you have managed to sneak something else into the report that is incompatible.

Here’s my suggestion: remove your dimensions from your report one at a time. After each dimension, try to change your heading. If it works, you have foundthe problem and you need to resolve the incompatible object. If you still can’t change the heading, click “undo” to put the removed object back and move on to the next one.

Eventually you should find the object that is causing the problem.

Alternatively, you can look at a list of dimension objects in both data providers. Ignore any linked dimensions, as they will not be causing the problem. Find all of the other dimensions, and identify which ones are coming from different queries. I am betting that you may find that you have any number of dimensions from one query, and at most one (unlinked) dimension from the other query. Remove that object and you should be fine.

Again, even though the problem seems to be that you can’t change the heading, every time I have encountered this problem the actual source of the problem was an incompatible dimension.

Good luck…

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

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