DV: Column Name in a Subject Area is missing — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

DV: Column Name in a Subject Area is missing

Received Response
1
Views
3
Comments
3673447
3673447 Rank 3 - Community Apprentice

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.

pastedImage_0.png

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.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    3673447 Rank 3 - Community Apprentice

    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

    pastedImage_0.png

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner
    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.