Answer Posted / 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 |
Post New Answer View All Answers
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What are the steps to be taken to schedule the report?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain in detail about type 1?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain in detail about type 2(scd),
Explain what are the measure objects?
What is the difference between slice and dice and cross tab report?
Can you please send me the migration related issues .
in sap bi we have wad, then why we go for sap bo
What we need to discuss with designer before starting the universe designing.
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
How to schedule the report in b.o?
how to prepare the documentation in business objects and where to get the requirement?
Explain when we use aggregate awareness function in designer?