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
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
how many reports have u created ? explain a few.
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Did you face any problems while creating reports? Name? Solutions?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain difference between zabo and webi?
Explain how to schedule the report in b.o?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain what is the difference between business requirement document and use case document.
What are the data types present in bo? What happens if we implement view in the designer and report?
How to open a universe with out using the Designer ??
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What sort of existing documents should business analysts refer to when starting on a new project?
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?
