Page2
1.What is the difference between detect alias and detect context?
Answer we should use Detect Aliases and Detect Contexts to formally identify and resolve loops.
I.e. if a loop contains only one lookup table then the loop can be resolved by detecting the alias.
If a loop is having 2 or more fact tables (multiple fact tables) then the loop can be resolved by detecting context.
2.What do prefer an Alias or a context? Why?
3.What is a Chasm Trap?
. A chasm trap is a common problem in relational database schemas in which a
Join path returns more data than expected. A chasm trap is a type of join path between three tables when two "many-to-one" joins converge on a single table, and there is no context in place that separates the converging join paths
4.What is a Fan Trap?
A fan trap is a less common problem than chasm traps in a relational database
Schema. It has the same effect of returning more data than expected. A fan trap is a type of join path between three tables when a “one-to-many” join links a table which is in turn linked by another “one-to-many” joins. The fanning out effect of “one-to-many” joins can cause incorrect results to be returned when a query includes objects based on both tables.
5.How Do You Resolve a Fan Trap?
There are two ways to solve a fan trap problem.
• Create an alias for the table containing the initial aggregation, then use Detect
Contexts (Tools > Detect Contexts) to detect and propose a context for the
Alias table and a context for the original table. This is the most effective way
To solve the fan trap problem.
6.What is a fan trap in Business Objects?
Actually FAN TRAP is a problem that occurs in Universe Level. Loop occurs while we design the universe. Two Types of Loop Problem:
1) FANTRAP PROBLEM solved by ALIAS METHOD:
Definition: Two One-to-many table links each other is in turn linked another one-to-many table.
2) CHASM TRAPS PROBLEM solved by CONTEXT METHOD:
Definition: Two Many-to-one table converges on one single lookup table.
Loop can be detected while INTEGRITY CHECK is done. An option is there as "Check for LOOPS" available. By "Detect Loop" we can choose what to be applied for solving the loop.
Â
When there is a series of one to many join in the tables, a Fan trap is resulted.
This may cause incorrect results to be returned when a query includes objects based on both tables.
For example: Associate, A Project, Â Dept tables.
One associate may work for N Projects, and those N projects may be Executed by N Dept....The report executed with the Associate table and the Dept table objects may produce that One Associate belongs to many departments.
To avoid this
Create an Alias table for Project A, which is A joined to the Associate as One to one mapping table.
Create an Alias table for Dept, which is A joined to the Project as One to one mapping table.
That means one associate, will be shown working for one project, and one project belongs to one dept.
Which will now result in one associate working for one Dept.?
Â
There are many other methods to solve Fan trap!!
Creating Manual Context, Using @ Aggregate Awareness Etc - based on the Business scenario these can be used
36i have some queries that I have one project in business objects, like computer peripheral(nrps) for sales, in that I have face question like what is the main objectives of ur projects
7.What is an alias?
Aliases are references to existing tables in a schema. An Alias is a table that is
An exact duplicate of the original table (base table), with a different name. The
Data in the table is exactly the same as the original table, but the different name
"Tricks" the SQL of a query to accept that you are using two different tables.
8.How we drill up week to Month?
In data Warehouse when u change + symbol to - , u would c all the aggregation level in that + this is called rolling down.
So if u again click over that - it would again compressed back to +. This is call drill up.
Your Aggregation levels would b like
Year>Month>Week>Day>Hour>Minutes>Seconds.
So by changing the symbol from - to + at month aggregation level u can drill up.
9.What is a join? Explain different types of joins?
Join is used to link to tables depending upon the data requested by the user, Usually we have Inner Join, Outer Join, Left Join, Right Join, Full Outer join.
10. What’s universal join in BOs?
The level of join between two universes with a matching column
11. What is a join? Explain different types of joins?
Join is used to link to tables depending upon the data requested by the user, Usually we have Inner Join, Outer Join, Left Join, Right Join, Full Outer join.
12. What is a join? Explain different types of joins?
- Join is used to link to tables depending upon the data requested by the user, Usually we have Inner Join, Outer Join, Left Join, Right Join, Full Outer join.
13. How achieve the many to many relation ship in Busi...
A) If you have two tables with many to many relation ships, take the keys of those tables and form a 1-1 relationship table. Then you can connect both the existing tables to the newly formed table using the key.
B) Create an intermediate table with 2 keys. i.e., the primary keys of both tables. Join each table to its primary key in the intermediate table.
C)
m to m relation ship
m to 1 1 to m
This way you can join
14. What is the difference between condition & filter?
A) Condition allows us to limit the data displayed from the database and Filter allows us to hide the data which is already generated in the report.
B) Conditions: these retrievals the data based on the condition (universe level)
Filter: it brings the data and filter; performance will be slow (report level)
C) Condition allows us to limit the data displayed from the database and Filter allows us to hide the data which is already generated in the report.
D) A Condition feature that forces a query to retrieve only the data that meets specified criteria. Condition is placed on a report query to show the specific data. To define a condition Name, Description and Where clause are required
A Filter enables you to view only necessary data in a report .i.e. it allows you to restrict the no. of rows displayed in the report they affect only the data currently displayed in the block but not query results
Ex: Select values for a variable in the report to apply a simple filter
In a report can we hide a particular object?
Yes we can show/hide a particular object in a table by using the pivot tab of the format table dialog box
15. What are Alerter, Filters, Breaks and Conditions? –
Alters are nothing but they are used to draw attention to a block of data by highlighting. Breaks are nothing but grouping the data without any change in the format. Condition is used to retrieve data which meets certain criteria. Filters are used to get necessary data.
16. How to filter repetitive values in the report to get distinct values?
A) In the Query panel we have tab "Options” Click there to get "eliminate duplicate enable this options.
Example: In any database we can use distinct command but My Report source is flat file. Therefore I can’t manipulate source system.
B) Using the eliminate duplicates option is one way.
In a slightly different scenario, duplicates could come up due to the design structure of the report.
E.g. In some specific cases, one may want to display a value in one field (say in a folded report) but multiple values come up (which could give you a COMPUTATION ERROR). To avoid such situation, one can define a variable which would e the max of the original field required. That ways the same value is fetched and also only one value is returned.
C) One other way possible is by doing "No Duplicates" radio button in the Options of the data provider in the Definition (the black cube)
But sometimes in free-hand sql reports it is not possible.
17. When to use local filter and when to use global Filter?
Think this should be in the Reporter Forum but, a local filter would apply to just a single block (table, cross tab or chart) within your report.
A global filter would apply to all blocks in your report, so if you had many tables the filter would apply to all of them
Local Filter is to single report to which it is create, but a global filter is to all the reports which consists of that column
18. Is there any command or function to filter repeating records/values in the report?
Using the eliminate duplicates option is one way.
In a lightly different scenario, duplicates could come up due to the design structure of the report. E.g. in some specific cases, one may want to display a value in one field (say in a folded report) but multiple values come up (which could give you a COMPUTATION ERROR). To avoid such situation, one can define a variable which would e the max of the
Original field required. That ways the same value is fetched and also only one value is returned
19. What is drill filter and its usage? How many types of filters are there?
I don’t think there is any number of types in drill through filter, drill through filter is used to fetch the particular data from the report or other report by click browse while in the drill through process.
20. What is drill filter and its usage? How many types...
Three types of drill is in BO.1.drill up, 2.drill down, 3.drill thro'.
Drill up means second->minutes->hour->->day
Drill down means region->country->state->district
Drill thro'--whatever u want that element
Drill filters acts as query conditions when you bring new data from database
We can not say there are different types of drill filters, because we apply filters through scope of analysis and set the apply drill filters option by
Tools >options>drill tab
There are different drill modes like drill up, drill down, drill through
21. What are the steps to do to use Alerts in BO?
Alerts are used to alert some part of the data if any change occurs. select the part of the data in the report where u want to keep alerts n just click on alerts in the tool bar which is present in the third line from menu bar besides rank then a window pops up n we ca n give some condition where in if it crosses that an alert is sent
22. Please explain about Alerts in Bo's, under what situation we need to use alerts
Hello friends, here alert means to highlighted data in a particular report. In every report we can apply alerts situation like, sales revenue per city wise. Here city field we can apply alert, condition like sales revenue >=50,000
23. What are Alerter, Filters, Breaks and Conditions?
Alters are nothing but they are used to draw attention to a block of data by highlighting. Breaks are nothing but grouping the data without any change in the format. Condition is used to retrieve data which meets certain criteria. Filters are used to get necessary data.
24. Can you create Alerts in WEB Intelligence?
In Version6 we can't create alerts in WEBi but it is available in XIR2
25. Can you add the Cascading prompts in Business Objects?
Answer: - if you select one prompt value based on that prompt value gives other low (that low value is have relate that 1st prompt value) you can select one or more from that value.
South (region) > TN, AP, kr, kl (state)
North (region) > nd, jk, hr, up (state)
If I select region south I can see only south region state. (This is cascading prompt)
It should create universe level.
Double click state object >
Edit properties > properties > edit
You can see the query pan, there pull down that region object and use that prompt conditions and save that
Now you click display button you can see how that prompts are working.