business objects interview qa-2

Q) How many Universes did you create?

Q) Tell me how many classes where there, and objects in each class?

Q) What is an Object?
A) An object is the most refined component in a universe. It maps to data or a derivation of data in the database. Using objects, end users can build queries to generate reports.

Q) What is Object qualification?
A) For the purposes of multidimensional analysis, objects are qualified as one of three types: dimension, detail, or measure.

Q) Tell me about a complicated object you have created?
Q) What was the size of the database? Which server?
Q) What was the Database? Was it a data warehouse?
Q) What problems you have faced while creating a universe?
Q) Tell me an incident and how you went about solving it?
Q) How many Tables was the universe built?
Q) What is a loop, how do you resolve them? A) A situation that occurs when more than one path exists from one table to another in the universe.

Q) What do prefer an Alias or a context? Why? A) Alias - A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. A) Context - A context is a rule by which Designer can decide which of two paths to choose when more than one path is possible from one table to another. Contexts can be used to resolve loops in the universe. You can create contexts manually, or cause them to be detected by Designer. When contexts are useful, Designer suggests a list of contexts that you can create.

Q) What is join? Explain different types of joins? A) A relational operation that causes two tables with a common column to be combined into a single table. Designer supports equi-joins, theta joins, outer joins, and shortcut joins.

Q) What are linked universes? Have you worked with them, problems faced and solutions?
A) Linked universes are universes that share common components such as parameters, classes, objects, or joins. Among linked universes, one universe is said to be the kernel or master while the others are the derived universes.

BusObj Questions

Q) How many reports have you created? Explain a few?
Q) What are alerter's, filters, breaks, conditions? A) The Alerters dialog box allows you to create and apply alerters. Alerters use special formatting to make data that fits specified conditions stand out from the rest of the data. This helps draw attention to trends and exceptions in report data.
A) A filter enables you to hide the data you do not want to view and display only the data you want to focus on. In the Apply a Filter on Variable Name dialog box, you choose which values of the selected variable you want to display in the selected block.
A) Select the variables you want to use to insert a break. When you close the dialog box, the variable you select is displayed in the Breaks dialog box. Break Level, sets the level that the block of data will have in the report. You can have more than one break level to organize blocks of data. A) Conditions - feature that forces a query to retrieve only the data that meets specified criteria.

Q) What's the difference between master-detail and Breaks?
Q) What's the difference between filters and conditions?
Q) What are pre-defined conditions? Compare with report conditions? Justify?
Q) What are the differences between a formula, variable and user objects?
Q) Did you face any problems while creating reports? Name? Solutions?
Q) How do you schedule the reports?
Q) What is a microcube? How many can a document have? A) Local structure in which the data retrieved by a data provider is stored; contains the data users can display in reports inside a document.
Q) Have you worked with multiple data sources? If yes. How do you link them?
Q) What are templates? Explain what you have created?
Q) How do you resolve #multivalue and #computation errors?
Q) Difference between Foreach and Forall? A) Foreach - Adds a dimension to the calculation environment.
A) Forall - Specifies the dimensions you want to include in the calculation.

Q) Define a Cell, Block, and Section?