Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS ROW LEVEL SECURITY IN BO?
- 7 Answers
- 24493 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumarbng
HI.. The above answer refers to Row limit where we can
restrict users to run reports for specific row limits like
5000 rows or 10000 rows just to have a good server
performance.
where Row level security is allowing the end user who runs
the report to view the data which he is authorized to view.
For Example you are trying to run a report which pulls data
contaings of 2 departments of the organization.
If you belong to DEP 1 then you will see data related to
DEP1 only and a user belonging to DEP2 can see DEP2 data
only. if you belong to both the groups then you can view
data without restrictions.
| Is This Answer Correct ? | 25 Yes | 4 No |
Answer / ramesh reddy v
You have two choices depending on the setup you have.
If there is a security table containing the user access to
his/her office/dept, then it can be joined with the fact
table along with the @variable('BOUSER') function as
Code:
SECURITY_TBL.DEPTNO = FACT_TBL.DEPTNO AND
SECURITY_TBL.USERID=@VARIABLE('BOUSER')
where userid in your security table is same as BOBJ user
account
If there is no security table then you will have to use the
manage security- manage access restrictions option in
Designer and assign a where clause to each user/group which
will be dynamically shown in the generated SQL
Code:
FACT_TBL.DEPTNO = 10
This is also termed as multi pass/refresh report bursting
Publication feature in XIr2 can be used to burst reports in
single pass/refresh to users/groups
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / pradeep -> wipro
Yes you are right Kumar.
In Bo 6.5, the row level security can do in superviver
domain but in Xi R2 the Designer can do since this future
is implemented in Designer itself.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / naveen.g
hi,
rowlevel security and object level security in 6.5
supervisor.
in xir2 designer level option is there.
for example in emp.deptno=10;
the data will restirect to particular user.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / o
It is used to restrict the data to particular rows to
particular users.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / amir
Adding to it row level security can also be provided at
universe level through access restrictions..
Thanks
Amir
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / srinivas
in bo 6.5 row level security
restric the rows in the table
In supervisor level, click on resource pane, select
universe right click, on properties on, select rowlevel
how many rows he want select that rows and apply ok
| Is This Answer Correct ? | 6 Yes | 15 No |
How to add additional objects or tables into the universe,and what are steps we need to follow to achieve the above task.
limitaions of cross tab ?
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
Tell me the difference between cmc and cms?
what is crystal reports?how to migrate them?
What is the difference between business requirement document and use case document.
Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?
Explain what are the steps to do to use alerts in bo?
when and where we use @varialble function
when we go for snow flake schema rather than star schema ?
REGULAR CLASSES for Hyperion Financial Management+ODI+HFR+FDQM is Starting From Sunday, 23th Oct, 7:00 AM IST.
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Teradata 
