How many ways you can restrict data in business objects?
- 5 Answers
- 13524 Views
- TCS, I also Faced
- E-Mail Answers
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 is the syntax for aggregate awareness?
3 Answers Exilant, i-Tree, Wipro,
When we go for OLAP , and When we go for OLTP for generating the reports ?
Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
In a report i want to fetch teh data from 2 data Providers. which condetion wil satisfy to link the 2 data providers. ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns. requirement is like i want to get all the columns from those 2 tables in report level..like A,B,C,X,Y,Z in a single report.
what is slice & dice?
3 Answers Cognizant, Saama Tech, TCS,
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
What is self join
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
What we need to discuss with designer before starting the universe designing.
What are the diffrences between Business Objects 5.1 & 6.5 ?
1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.
what is fantrap?
Teradata 
