--> Complex Reports
TV BOM is a complex report with lots of alerters, filters where the user wants to see both filtered and unfiltered grand totals
--> Difference between filters and Condition and which is better
Filters are conditions designed at Universe level and Conditions are defined at Report level.
Filters are better since it filters the data at database level making the report to run fast.
--> Difference between Formula and a variable and their advantages
When a formula is assigned a name it becomes a variable. Formulas should always be converted to variables if they are used more than once in a report
--> Can u use multiple database in a universe
No We cannot use multiple data providers in a universe .
--> What are shortcut joins
A shortcut join is a join that provides an alternative path between two tables. Shortcut joins improve the performance of a query by not taking into account intermediate tables, and so shortening a normally longer join path.
--> How do u migrate/promote universe and reports from dev to test environments
Business Objects as such does not have any tool for version controlling, hence a detailed document is maintained about the changes done in each release.
QMF is a tool used for version controlled promotions. It has its own repository, before promoting the new universe/report it backs up the old one in the repository
--> Problems from migrating from 5x to 6x
--> How do you restrict data based on user profiles
Row Level security in Supervisor can be used to restrict data.
--> What are fan traps and Chasm traps
Many to one joins from two fact tables converge on a single lookup table. This type of join convergence can lead to a join path problem called a chasm trap.
A one to many join links a table which is in turn linked by a one to many join. This type of fanning out of one to many joins can lead to a join path problem called a fan trap.
--> Ways to solve these traps
These traps can be solved by applying contexts and using aliases. Aliases are better than contexts because contexts lays open the database structure to the end user.
TV BOM is a complex report with lots of alerters, filters where the user wants to see both filtered and unfiltered grand totals
--> Difference between filters and Condition and which is better
Filters are conditions designed at Universe level and Conditions are defined at Report level.
Filters are better since it filters the data at database level making the report to run fast.
--> Difference between Formula and a variable and their advantages
When a formula is assigned a name it becomes a variable. Formulas should always be converted to variables if they are used more than once in a report
--> Can u use multiple database in a universe
No We cannot use multiple data providers in a universe .
--> What are shortcut joins
A shortcut join is a join that provides an alternative path between two tables. Shortcut joins improve the performance of a query by not taking into account intermediate tables, and so shortening a normally longer join path.
--> How do u migrate/promote universe and reports from dev to test environments
Business Objects as such does not have any tool for version controlling, hence a detailed document is maintained about the changes done in each release.
QMF is a tool used for version controlled promotions. It has its own repository, before promoting the new universe/report it backs up the old one in the repository
--> Problems from migrating from 5x to 6x
--> How do you restrict data based on user profiles
Row Level security in Supervisor can be used to restrict data.
--> What are fan traps and Chasm traps
Many to one joins from two fact tables converge on a single lookup table. This type of join convergence can lead to a join path problem called a chasm trap.
A one to many join links a table which is in turn linked by a one to many join. This type of fanning out of one to many joins can lead to a join path problem called a fan trap.
--> Ways to solve these traps
These traps can be solved by applying contexts and using aliases. Aliases are better than contexts because contexts lays open the database structure to the end user.
No comments:
Post a Comment
To watch the SAP BO information visit:www.sapboxi.blogspot.com