BusinessObjects Board

Merging Dimensions is not working when object is dragged in

I am creating a report in Webi. There are 2 queries, both are on the same table and both retrieve same columns. Now I created a merged dimension on the key column (task id), Now I can drag and drop columns from my first query results into the report, however when i drag any column from the second query and drop it in the report next to the last column which was added from the first query, the new column does not get added at all, there is no error nothing happens. Not sure what is it that I am doing wrong.

The main dimension which is the task Id is already merged, even if i include this dimension in the report, still I can only use data from only 1 query, not both.

Please help


sarfaraz812 (BOB member since 2015-01-26)

hi sarfaraaz
main imp thing is to drag the mergd dimension instead of draging the common columns,first drag the id then join other columns and mainly wen both the columns are compatable then y ur opting for merge dimension?


arun pandey (BOB member since 2015-04-05)

Try ForceMerge(), for only objects which are from queries you merged.

Hope this will help… :mrgreen:


PathFinder :india: (BOB member since 2012-01-05)