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
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
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 which versions are used in the bo dashboard work?
can anybody tell me about complicated object you have created
any difficulitis have you phase while creating bo reports and how did u solve it
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
what is the difference b/w the refresh and buffered data?
What is the difference between user and versatile user?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What sort of existing documents should business analysts refer to when starting on a new project?
What is the functional & architectural differences between business objects and web intelligence reports?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Difference between b.o 5.1 and 6.1b?
Explain about alerts in bos, under what situation we need to use alerts?
How would you format some text using css to be verdana and bold?
