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
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?
...or he means hidden by permissions
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.
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 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?
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?
for a particular report, when some users click on the link, the new tab opens but after about 10 minutes of loading the system returns
Summary: Hello experts, We are using WLF_ASSIGNMENT_TASKS_F to fetch the data from the learn tables The WLF_ASSIGNMENT_TASKS_F table, in the LAST_UPDATED_BY field, doesn't reflect who actually updates the task. I've attached the query used. Can you please help me? Content (please ensure you mask any confidential…
https://blogs.oracle.com/analytics/announcing-the-general-availability-of-oracle-analytics-server-2026 As announced, OAS 2026 has moved to FMW 14. What does this mean for the future of OBIA? Given that 103PS4 is for 12.2.1.4 , it would seem another required upgrade beyond 103ps4 will have to happen. What should customers…
Hi everyone, we're experiencing an interesting issue with report filters in Oracle Learning Management (or similar). Problem: When we use filters based on SQL queries, for some specific users the report filters disappear completely, making the report non-functional. Technical Details: We've identified the critical point in…
We use OAS 2025, EBS 12.2.12, OBIA 7.9.6.4, Oracle 19c db on Linux. We are trying to build Project to GL Cost reconciliation report that runs for a period, currently it is done manually, by running three analytics reports (one on Project - Cost subject area to get total cost for Contract and Resources, another report on…
