How many ways you can restrict data in business objects?
Answers were Sorted based on User's Feedback
Answer / ravi
Universe level Filters,By giving object lefvel condition in
univerese .Report level filters ,,Block level
filteres.etc...
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / gowthami
1. Universe Level restriction
a. Universe level filter
i. Object level filter
ii. Pre-defined filter
b. Join between tables can also restrict the data
c. Creation of parameter in universe also restrict the data
2. Report Level Restriction
a. Query level filter
b. Drill filter/Report level filter
c. Block filter
d. Input Control
Is This Answer Correct ? | 12 Yes | 0 No |
There are many ways to restrict the data in Bo.
Universe side
1)Universe join
2)Object where class
3)Universe prompts
4)you can also ristrict the data by creating derived tables with certain condtions
Report side
1)Query Filter
2)Report Filter
3)Quick(show/hide)Report Filter
4)Creating variables with certain conditions like
=If([Country]="USA") Then 1 else 0
select 1 to display only USA data.
www.futuresoftworld.com
Thanks
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / meera nair
In BO,one way of restricting data is by using join.A join
is basically a condition that restricts the result set of a
query.
Is This Answer Correct ? | 6 Yes | 6 No |
What are the traps ? What are the disadvantages of traps?
when you have three fact table and there is no relationship between them. How you will tackle the issue.
Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..
What is the difference between Sychronisatio and join?
How to make alternative rows red and green in WebI Report?
WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash
how many times can use the union operator in a report?
Can we link the Universes from two different sourcess?Explain?
What is security domain in Business Objects?
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.