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
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain is data mart?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain about a time when you discovered a more efficient way to do a work task?
What three things do you consider to be the most important factors for a manager?
Explain how many universes can be created in a project?
What Is Snow Flake Schema?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Difference between zabo and webi?
Explain about alerts in bos, under what situation we need to use alerts?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
what will be the contents for a functional requirements specifications
Explain how to execute the plsql procedure from the report by clicking with mouse?
What is the difference between business requirement document and use case document.
