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.

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

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.

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.

Answer / o

It is used to restrict the data to particular rows to
particular users.

Answer / amir

Adding to it row level security can also be provided at
universe level through access restrictions..

Thanks
Amir

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

What is pragma?

1 Answers  

How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.

1 Answers   Cognizant, WinAlliance,

IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

1 Answers   Accenture,

IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?

3 Answers   Accenture,

HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?

3 Answers  

Explain the SQL Queries activated to data base from Data provider in BO ?

1 Answers   Polaris,

5.what is slowly changing dimension ?

2 Answers   IBM,

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

0 Answers   Arkema pte Ltd,

What is the use of AFD? Where it can be stored?

1 Answers  

Difference between zabo and webi?

0 Answers  

Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..

2 Answers  

what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?

4 Answers   Fujitsu, Virtusa,