Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

OBIEE Data Level Security

Received Response
1
Views
1
Comments
2693347
2693347 Rank 4 - Community Specialist
edited Aug 13, 2024 5:54PM in Oracle Analytics Forum

Hi,

I have Imported the cube in the RPD and put the data level security in the RPD .In Manage-->Identity i have set of Application roles where i have added Data level security like CostCenter=1234.

Then i got a new requirement to add new dimension in the cube so i need to import the cube again in the RPD.But in that case i have lost all the data level security what i have applied in the cube.

I that any way we can save before we import the cube so we can not lost it?

Let me  know if anyone help me on that.

Shashikant.

Answers

  • ArijitC
    ArijitC Rank 6 - Analytics & AI Lead

    My suggestion, if you need data level security, try to apply that in the cube through essbase filter (read or metaread filter). In your case say read filter on the essbase cube on cost center. Then  in RPD instead of using generic user to connect to the cube use :USER and : Password

    pastedImage_2.png

    In that way you will not have to tinker with rpd identity management every time you  pull cube in RPD. You have to do that every-time number of level changes in any dimension.

    Thanks

    Arijit