1. What is business objects?
- Business objects provides a set of tools for building data warehouses very efficiently. Business objects is an integrated query, reporting and analysis solution for business professionals that allow them to access the data in their corporate databases directly from their desktop and present and analyze this information in a business objects document.
- Designer is the Business objects product that is intended to develop the universes. These universe is the semantic layer of the database structure that isolates from technical issues of the database structure.
- There are two modes are there in BO and Designer are :
- Enterprise Mode
- Workgroup Mode
- Queries on Universe
- Stored procedure
- Free hand SQL
- Text files or Spread sheets
- VBA Procedures
- OLAP servers
- SAP
- There are two multidimensional analysis methods available in BO, they are :
- Slice and Dice
- Drill Down
- @Aggregate_Aware
- @Prompt
- @Script
- @Select
- @Variable
- @Where
- The @Prompt function lets you create an interactive object. In the Query Panel, this type of object causes a message to appear. This message prompts the end user to enter a specific value. This function recovers the results of Visual Basic for Applications macro (VBA macro).
- A context is a rule by which determines which of two paths can be chosen when more than one path is possible in the database.
- The disadvantage of using context is that you expose the business objects end user to the database structure. They are forced to decide which context they want to use to run their query. The role of the universe is to shield end users from the database structure, so they do not have to make such decisions.
- BO is an excellent tool for generation of reports, carrying out detailed analysis, graphical presentation of the results and generation of alerts.
