Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12c row level security on Essbase data source not working
Hi ,
I'm using shared logon in Essbase connection pool.
I tried to implement row-level security in the same process followed for relational source - create initialization block using security_table, assign returned business_units to session variable(with row-wise initialization) and use the session variable in Application roles :
VALUEOF(NQ_SESSION.SEC_BU_CUBE) <> 'NO_ACCESS' AND VALUEOF(NQ_SESSION.SEC_BU_CUBE) <> 'FULL_ACCESS' AND "GL_Balances_Cube"."Business_Unit"."Business Unit Description" IN (VALUEOF(NQ_SESSION.SEC_BU_CUBE))
No error comes in consistency check.
The same statement works for relational source, but Essbase report is throwing error - a generic error message. Please help. It is very urgent.
Regards.
Answers
-
Hi,
2714750 wrote:...but Essbase report is throwing error - a generic error message.
Why not to post the "generic error message" ? Because there are hundreds of "generic error messages" in OBIEE / Essbase.
Did you checked the logs for the generated MDX? Is it a valid MDX?
In general I would say that for Essbase you better your Essbase filters for doing that.
Something like this https://www.rittmanmead.com/blog/2013/08/obiee-11-1-1-7-essbase-essbase-filters-within-fusion-middleware-11g-security/ , also covered in the doc here Configuring Data-Level Security Using Essbase Filters
0
