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
Explain what is aggregate table and aggregate fact table ... Any examples of both?
is it possible to export the webi reports to crystal reports?with out using businessview?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what are the measure objects?
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 what is the difference between business requirement document and use case document.
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain the difference between detect alias and detect context?
Explain how we drill up week to month?
Explain about a task that really tested your analytical abilities?
What task is 98% of the required work of a business analyst?
Explain what are the steps to do to use alerts in bo?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
how many reports have u created ? explain a few.
