Merge Dimension Grey out :(

[Former Member]

I am trying to create a merge dimension from two different folders. They both are from the same universe and same name but different folder. When I choose two object, the OK option disappear.

Please Help

Thanks in advance

[amitrathi239 · Accepted solution]

are you using two webi queries?Merge dimension will enable when objects are from two different queries with same datatype.

If both objects are from different webi queries then check data type is same or not.

[Former Member · Accepted solution]

Yes Amit, they are from two different Queries. Data type is the same for both Dimension.Please let me know what else I can try?

[amitrathi239 · Accepted solution]

is there any one or both objects are displayed in Bold in webi objects panel?

similar to this.

If yes then drag objects in one sample tab in the report and refresh the report and try.

[Former Member · Accepted solution]

No Amit, There is nothing in Bold. The 'OK' option is still grayed out? I wander if I have to make any setting and configuration changes ? Do you think of anything like that? Thanks

[amitrathi239 · Accepted solution]

Check in BO CMC->Applications->Web Intelligence->User security if Merge dimension access is enabled for your user/group.

[Former Member · Accepted solution]

This solve the Puzzle Amit, Thanks you

[Former Member · Accepted solution]

Thanks for this useful information!!

[former_member198519]

There are rules to merging dimensions

- Only dimensions defined in the universe can be merged. You cannot merge using variables.

- Objects must have the same data type. You cannot merge a number with a string, even if the values match.

- Any number of queries can be merged. There is no limit.

- Any number of dimension objects can be merged between two queries. Again, no limit.

- Values are case-sensitive. So, if the values are the same, but of different case, they will not match. They will be shown as different values.

- Watch out for trailing blanks. Even if the values look exactly the same, they won’t match if one has a trailing blank, and the other one doesn’t.

See if your objects falling in this criteria.

Hope this helps.

- Kuldeep

[Former Member]

No Kuldeep Its not falling under this criteria. The 'OK' option is still grayed out?

[former_member198519]

Have a look to the below KB article and check if this helps you out: -

1204901 - Merge Dimension icon is disabled

Also grant permission at

CMC --> Applications --> Web Intelligence --> user Security --> Add/Remove Rights --> Application (Webi) --> Grant (Merge dimensions for synchronization)

- Kuldeep