Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE 12.2.1.3 HTML columns are not visible for User with Role "BI Author Role"

Received Response
23
Views
7
Comments
User_MRIVI
User_MRIVI Rank 2 - Community Beginner
edited Aug 13, 2024 5:52PM in Oracle Analytics Cloud and Server

in the Version OBIEE 12.2.1.3 HTML columns are not visible for User with Role "BI Author Role". For users with authorization "BI Administrator Role" these columns are displayed.

An any idea how to fix it? Which settings need to be changed?

Answers

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

    edit: easier - just read MOS Doc ID 2309701.1

  • User_MRIVI
    User_MRIVI Rank 2 - Community Beginner

    the option <EnableSavingContentWithHTML> true </ EnableSavingContentWithHTML> is already set, otherwise it was not possible to save the report.

    Privilege Assignments:

    Aktionen mit eingebettetem HTML-Code speichern     Authenticated User

    Inhalt mit HTML-Markup speichern                              Authenticated User

    Auf HtmlViewService Service zugreifen                       Authenticated User

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

    Ok so from your posting history I see you just started an upgrade from 10 to 12 and now are facing security issues so my next question is: How did you migrate your catalog?

  • User_MRIVI
    User_MRIVI Rank 2 - Community Beginner

    All in one with BI Migration Script (migration-tool.sh).

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

    Uuugh yuck.

    Ok so can you do a test where you run a proper 12c webcat to see whether the issue persists?

    It may simply be your privs that are messed up

  • User_MRIVI
    User_MRIVI Rank 2 - Community Beginner

    It is tested with the same user and the same Answers Report.

    If the user gets the right "BI Administrator Role" assigned, all is fine. If the user gets the right ""BI Author Role" assigned, the HTML Column is not visible.

  • Ebin Cherian
    Ebin Cherian Rank 5 - Community Champion

    Hi,

    I faced a similar issue with 12.2.1.1 Issue is explained in detail in thread below. Raised an SR with Oracle and got reply saying its a bug. I think your issue is also similar the issue I had and probably this might be still an issue in newer version as well.

    Bug 21086656 : DATA FORMAT PROPERTIES SHOW ONLY LIMITED PROPERTIES

    Thanks

    Ebin