Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the tables used in health care domain project and columns used in report?
Explain about a task that really tested your analytical abilities?
Can more than 1 metric be applied on an analytic in business objects?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain which versions are used in the bo dashboard work?
What is a fantrap in business objects?
When we use aggregate awareness function in designer?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
How we drill up week to month?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain the data types present in bo and what happens if we implement view in the designer and report?
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,
Explain when to use local filter and when to use global filter?
Explain what is the difference between business requirement document and use case document.
