Does Merge dimension button work on BI OLAP Universe webi reports

[Former Member]

Hello all,

we are using BI 7.0 queries as our datasource for creating universes. When we are using the webi rich client to create a query, there is add query button and we are able to add query but once I add query I am not able see the Merge dimensions button active, is there some setting that is missing or this capability is not active for BI OLAP query universes?

Thanks in advance for the answers.

[amitrathi239 · Accepted solution]

HI,

Merge Dimension button is working on webi report based on OLAP universes.

Check you have the rights in CMC for merge dimension if it is happening all reports.

Under Home > BusinessObjects Enterprise Applications > Web Intelligence it is possible to set the Merge dimensions for synchronization right for groups and users.

[Former Member · Accepted solution]

Maybe a silly question, but you say "we are able to add query". I assume that you've added two queries? You can't merge dimensions if you only have one query (sorry if that was obvious).

[Former Member · Accepted solution]

Amit,

Thanks for the reply, you are right I should have checked first in Dev or Qa. I do not have right security in Prod, but in dev and qa I do see the mereg button.

Thanks,