Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 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
Having issues in giving Security/ Permission in OBIEE 11.1.1.9
Answers
-
Hi FTisiot,
Thanks for your reply
- Create a table with all Department-Region combination for each user
Achieving this as of now is bit difficult since all DW implementation is already completed and most of the reports are using these tables.
So is there any way to achieve apart from this?
0 -
Hi @3402619
Well, you need a matrix that tells you all allowed Depts-Region combinations (or the not-allowed ones) that a user can see.
As others said you can't just have 2 distinct filters on the two dimensions.
If you can't setup a proper extra role like "Filtered Users Role" this will have an impact on all users accessing the table.
however if you setup a new Role then you can assign the filter to the new role specifically.
0 -
Hi FTisiot
As per your suggestion I have created a new role and a group for this user.
After that in administrator tool I have opened that application role. Now can you tell me where exactly I have to specify the filter for the above requirement. If you can tell me with one example it will be of great helpful for me.
0 -
Look here
https://www.rittmanmead.com/blog/2012/03/obiee-11g-security-week-row-level-security/
If you find answers helpful please mark them as such
or If you got the answer to your question you can maybe close the thread?
0 -
"One particular user should have access to two departments with different regions(one department with all regions and one department with only one region)."
you can only get that if you apply it to distinct logical fact stars... if you only have one fact than the 'can have it all' filter supersedes the other one. in fact., if you had two filters dept A can see region 1,2,3 and Dept B can see 3,4,5 and I'm in both I see 1,2,3,4,5
"Once if he selects Department1 then he should be able to see all the regions and if he selects Department2 .." ??? security isn't something the user selects - it's imposed on him. Are you really asking for filtered prompts based on user? If so, @FTisiot has it right, you need a matrix style table to join to assist in the generation of the prompted values.
Your requirement, as described, is still a bit unclear...
0 -
Hi Thomas Dodds
Thanks for your reply.
I am not asking about the prompt filtering here. The requirement is something like that. User is responsible to look at Departments with selected regions only.
0 -
Hi FTisiot
Thank for your reply.
To be honest I was knowing these steps. The problem am facing is how I can write a query in Init Block to join two dim tables. Am planning of Factless fact here. Don't know exactly. Let me check all the possible options and let you guys know the update on the same.
0 -
"I am not asking about the prompt filtering here. The requirement is something like that. User is responsible to look at Departments with selected regions only."
Again your answer is very unclear. User is responsible to look at departments with selected regions ... that to most everybody indicated a pre-defined filter on the prompt. But you say no to that.
If you have one fact table and that user's row filtering is set by department--that use gets 2 filters: A) IT filter restricts nothing,
Sales restricts to one regionOutcome:
SELECT * FROM TABLE WHERE
(REGION in (1,2,3)) <-- IT filter
AND (REGION = 1) <-- Sales filter
What do you expect as the outcome?
0 -
You guys have the patience of saints.
0
