Tuesday, December 11, 2007

OBIEE empty presentation tables in a repository in a multi-user environment

If you check in a repository in a multi-user environment, you will notice that it doesn't accept empty presentation tables, which you might use for table indentation.

One solution is to using a dummy column:

To make it invisible for the other users you can make a special user HideColumn:


And set the persions only for this user:

This way OBIEE checks in and out without any problems.



2 comments:

Anonymous said...

Hi John,
Not sure why creating the additional user is needed. If the permission to view the item is simply revoked for Everyone, I would assume that should do the trick as well.
Regards,
Karl

John Minkjan said...

Hi Karl,

The reason for the additional user is to suppress any warnings about the column during the consistence check when checking the repository back in.

Regards John