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 to find the size of the report
Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?
what is BIAR file in business objects xi r2
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 aggregate navigation?
3 Answers Countrywide, CTS, HCL,
What is thin client And thick client..?
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?
How to change English language to Chinese in BO Desiner (Universe)?
in sap bi we have wad, then why we go for sap bo
What is difference between webi and infoview?
where are objects are stored ?
what is variable ?