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 |
How you get the requirement from client?
What is the difference b/w breaks and sections
Explain what is the difference between business requirement document and use case document.
what is fantrap?
How to execute the MACRO through Infoview?
how to overcome overflow of data in a report
how we improve the performance of report and universe?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?
what is diff between Decode and case ? Give some Example?
Draw the architecture of traps?
What is the definition of derived table ?