OBIEE 11g - How to find out hidden fields in the OBIEE presentation layer

user12193810

I have an existing OBIEE 11g rpd which has some fields that are hidden in the presentation layer.

How do I find out which are the hidden fields?

Thanks

Gianni Ceresa

What do you mean by hidden fields in the Presentation layer of your RPD? You mean you used the "Hide object if" option and want to find all the presentation objects with this option set?

[Deleted User]

...or he means hidden by permissions

Robert Angel

Hi,

1. open the subject area in answers, expand the dimension and fact folders.

2. open the rpd in the Admin tool and expand the dimension and fact folders in the presentation layer.

3. Compare the 2, the fields you cannot see in the subject area are hidden....

Or

1. open the rpd in the Admin tool and expand the dimension and fact folders in the presentation layer.

2. expand the field properties by double clicking and see the property - 'Hide If' - if this is populated then the field 'may' be hidden, depending on whether the 'if' is true

Suspect if you translate the rpd to XML you may be able to find this property in a similar fashion and could then search through the entire document faster, but I have not tested this presumption.

Hope this helps,

Robert.

user12193810

We have an existing RPD for one site A. As part of replication project, we use RPD from site A as base and enhance it for site B.  Understand that some fields are hidden in presentation layer in site A's.

What we wanted to do is similarly hide same fields in the presentation layer for site B.

Of course, we can do it column by column compare which would be tedious.

Is there any easier way?

Thanks

user12193810

Thanks for the advice.

This would be very tedious if I have many fields to compare.

What I heard is that there is some SQL that allows us to query the RPD.

Is there any out there?

Thanks

Gianni Ceresa

There is a tool giving you all the presentation columns with a visibility condition.

Open the RPD, "Tools" > "Query Repository..." and there you set the condition.

You select "Type = Presentation Column" and add an additional Filter with the condition "Visibility filter <> "" " and there you have a nice list (and you can export it etc.).

If that's what you are after (you can't query by SQL the RPD natively as it doesn't exist in a DB and you aren't looking to query the data coming from the RPD but the metadata defining the RPD itself) can you maybe mark if needed and close the thread to help other users with similar questions?