DV: Column Name in a Subject Area is missing

3673447

I am using OBIEE 12.2.1.4. which has the DV capability and when I open a DV Project,it complains me that a column in the subject area is missing and it removes the LIST_NAME column automatically from the canvas. LIST_NAME was used as global filterin the canvas and once I click on OK button it disables this column from the global filter section.

But the same DV Project with the same rpd is working in another machine, I compared the rpds and couldn't find any difference and even cleared the OBIEE cache and the error still persists.

[Deleted User]

Are you sure it't not a permission issue? I.e. that on tha tcolumn there are appl role permissions or -  worse - user permissions nad between the anvs you just don't have the same rights?

3673447

Ya Christi,

What you said is correct.When I am accessing the DV Project as a BI Service Administrator privileged user it doesn't complain about the column missing from the subject area but when I access the DV Project as a BI Content Author privileged user it complains about the column missing from the subject area.I am not able to open the actual presentaion table with  500 Internal Server Error using BI Content Author privileged user,but however I am able to access the table using BI Service Administrator privileged user.

The presentation table in which this column resides,has a presentation hierachy table and is this the reason why I am not able to access the table using BI Content Author user. So how can I fix this since access to BIServiceAdministrator user is restricted.By the way, below are the permissions assigned to the table

[Deleted User]

3673447 wrote:The presentation table in which this column resides,has a presentation hierachy table and is this the reason why I am not able to access the table using BI Content Author user. So how can I fix this since access to BIServiceAdministrator user is restricted.By the way, below are the permissions assigned to the table

If the presentation hierarchy is the problem, then why do you look at the permissions of the table?

Look at the permissions of the presentation heirarchy. Look at the permission of the columns.