BusinessObjects-Merged Dimension Incompatible Object

Merging dimension is always a need by creating webi documents. But by default you can use only dimensions from one query, merged dimensions and the measures. If you want to use dimensions from other query and you can't merge them, you got an error message "Cannot drop here - the object is incompatible". See pic below.

To avoid this problem you have to create a detail variable object and associated it to the merged dimension. In the example above you want to use the phone numbers from Query2. Select the type as "detail" and associated object.

Now you can use this variable with your Query1 dimensions.

To understand why this works with detail please refer to this document:
http://michaelwelter.wordpress.com/2011/04/18/tips-for-merging-dimensions/

Tweet

ORACLE-Merge Command

You can use the Merge command to insert and update at the same time with one query. So you don't need to write a procedure which includes insert, exception and update.

Use of the command;

Merge Into Table1 T1

Using (select * from Table2 where ...) T2

On (T1.Field1 = T2.Field1 And ...)

When Matched Then

Update

Set T1.Field2 = T2.Field2

When Not Matched Then

Insert (T1.Field2) Values (T2.Field2)

Table2 is our source table. Table1 is our destination table.

The fields in the "on" clause are the unique fields for T1 and works like a where clause.