This content has been marked as final. Show 6 replies
Just create the session variable which hold the "profit center name" for a particular user.
Create a role in obiee say "Profit Center Group" and apply data filter for this role with the condition using the session variable(profit center name).
Assign all the users to that particular role(Profit Center Group).
Thanks MVSST , appreciate your response.
But say a user of CFO level having access to all the Profit Center , would have 30,000 profit center in the IN CLAUSE as the session variable holds teh profit center name separated by semicolon/comma.
As I know oracle supports only 1000 values in the IN clause. Pls. help.
Yes, any dimension filters are applied only when you include that dimension in your analysis.
As a workaround, you could create a filter as "Profit Centre" is not equal to 'Dummy Profit Centre' with "Protect Filter as ON" and add this filter to all of your analysis.
So what it does is, even though you do not refer to profit centre dimension in your analysis, the filter in each analysis makes sure that the profit centre dimension is always mapped and the data restriction is applied.
Hope this helps.
Thanks.Can we do this in the RPD itself as the requirement is to build te RPD and give to business user . Only they can create the analysis. And the data should be visible to them as per the Profit Center security access.
Can I just create a single Role OR use eixting Role -BI Consumer and assign this security filter in required dimensions - Profit Center & The Fact like. Profit center is not equal to "Dummy Profit Center".