SAP BO FAQ'S
Q)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.
Q)What is Designer?
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.
Designer is a window based tool. To created Universe between reports and back end database.
Q)How many modes are there in BO & Designer?
There are two modes are there in BO and Designer are :
Enterprise Mode
Workgroup Mode
Post Your Answers
Q)What are the different types of data providers supported by BO?
Queries on Universe
Stored procedure
Free hand SQL
Text files or Spread sheets
VBA Procedures
OLAP servers
SAP
Q)What are the different multidimensional analysis methods available in Business Objects?
There are two multidimensional analysis methods available in BO, they are :
Slice and Dice
Drill Down
Q)What are the different @ Functions?
• Aggregate_Aware
• Prompt
• Script
• Select
• Variable
• Where
Q)What is the difference between @Prompt and @Script?
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).
Q)What is a context?
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.
Q)What are the disadvantage of using contexts?
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.
Q)What is BO?
BO is an excellent tool for generation of reports, carrying out detailed analysis, graphical presentation of the results and generation of alerts.
Q)What is a Loop?
In a relational database, a loop occurs when joins form multiple paths between lookup tables. if a query includes more than one path, the information returned can be incorrect. The rows that are returned are an intersection of the results for each path, so fewer rows are returned than expected.
Q)What is universe?
• A universe is a set of classes and objects intended for a specific application or group of users.
• Universe is semantic layer or meaningful layer to create reports between back end and target database.
Q)What are the types of OLAP?
• ROLAP (Relational OLAP)
• MOLAP (Multidimensional OLAP)
• HOLAP (Hybrid OLAP)
Q)What are the different schemas supported by BO Designer?
• Star Schema
• Snowflake Schema
• Multi star Schema
• Normalized production Schema
• Data warehouse with aggregates
Q)What is the repository?
The repository is the database in which the information about the users and data is present. It is created and maintained by the general supervisor. It is used to share resources of business objects.
Q)What are the types of repository domains?
There are three types of repository domains
Universe domain : It holds all the exported universes and there may be more than one universe domain in the repository.
Document domain : It holds all exported documents, templates, scripts, and lists of values.
Security domain : secured connections are stored in this
.
Q)How is a fan trap solved?
A Fan trap is solved in the following way :
Creating an Alias and applying Aggregate Aware function. Using Multiple SQL statements for each Measure.
Q)What is user objects?
User objects are end–user personal objects that are not shared with other end-users. This is because the user objects are stored locally in a specific user object definition file. If an end-user tries to refresh or edit query that contains another user's user object, the user object is automatically removed from the query and report. A user object is stored inside the Universe folder
.
Q)What are the various Business Objects products?
• User Module
• Designer
• Supervisor
• Auditor
• Set Analyzer
• Info View (Web Intelligence)
• Business Objects Software Development Kit (SDK)
• Broadcast Agent
Q)What are strategies?
A strategy is a script that automatically extracts structural information from a database or flat file.
Q)What are the different types of Strategies?
In Designer we can specify two types of strategies :
Built in strategies
External strategies
Q)What are the types of users in Business Objects?
• General Supervisor
• Supervisor
• Designer
• Supervisor Designer
• End User
• Versatile User
Q)What is Web Intelligence?
Web Intelligence is a decision support solution designed to meet critical query, reporting and analysis needs over the World Wide Web and has features very similar to Business Objects.
Q)What are master/detail reports?
Master/detail reports enable you to split large blocks of data into sections. This type of presentation allows you to avoid repeating values and also to display subtotals.
Q)What are calculation contexts?
By default, BUSINESSOBJECTS determines the result of a measure based on the dimension or dimensions in the part of the report in which the measure is inserted. These sets of dimensions are called calculation contexts. Calculation contexts are dynamic in BUSINESSOBJECTS.
Q)What is Dimension?
It is a structural attribute of a cube, which is used for multidimensional analysis.
Q)What is supervisor?
Supervisor is the product is used to set up and maintain a secure environment for Business Objects products.
Q)What are the types of dimensions?
• There are four types of dimensions are :
• Informational Dimension
• Structural Dimension
• Categorical Dimension
• Partitioning Dimension
Q)What is a Data Provider?
The data source (Query) is called as the data provider
.
Q)What are the tasks of the universe designer?
• The responsibilities that universe designer has
• Designing, Creating and maintaining the Universe
• Distributing the Created Universes
Q)What are different types of parsing?
• There are two types of parsing are :
• Quick parsing
• Thorough parsing
Q)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.
Q)What is Designer?
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.
Designer is a window based tool. To created Universe between reports and back end database.
Q)How many modes are there in BO & Designer?
There are two modes are there in BO and Designer are :
Enterprise Mode
Workgroup Mode
Post Your Answers
Q)What are the different types of data providers supported by BO?
Queries on Universe
Stored procedure
Free hand SQL
Text files or Spread sheets
VBA Procedures
OLAP servers
SAP
Q)What are the different multidimensional analysis methods available in Business Objects?
There are two multidimensional analysis methods available in BO, they are :
Slice and Dice
Drill Down
Q)What are the different @ Functions?
• Aggregate_Aware
• Prompt
• Script
• Select
• Variable
• Where
Q)What is the difference between @Prompt and @Script?
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).
Q)What is a context?
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.
Q)What are the disadvantage of using contexts?
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.
Q)What is BO?
BO is an excellent tool for generation of reports, carrying out detailed analysis, graphical presentation of the results and generation of alerts.
Q)What is a Loop?
In a relational database, a loop occurs when joins form multiple paths between lookup tables. if a query includes more than one path, the information returned can be incorrect. The rows that are returned are an intersection of the results for each path, so fewer rows are returned than expected.
Q)What is universe?
• A universe is a set of classes and objects intended for a specific application or group of users.
• Universe is semantic layer or meaningful layer to create reports between back end and target database.
Q)What are the types of OLAP?
• ROLAP (Relational OLAP)
• MOLAP (Multidimensional OLAP)
• HOLAP (Hybrid OLAP)
Q)What are the different schemas supported by BO Designer?
• Star Schema
• Snowflake Schema
• Multi star Schema
• Normalized production Schema
• Data warehouse with aggregates
Q)What is the repository?
The repository is the database in which the information about the users and data is present. It is created and maintained by the general supervisor. It is used to share resources of business objects.
Q)What are the types of repository domains?
There are three types of repository domains
Universe domain : It holds all the exported universes and there may be more than one universe domain in the repository.
Document domain : It holds all exported documents, templates, scripts, and lists of values.
Security domain : secured connections are stored in this
.
Q)How is a fan trap solved?
A Fan trap is solved in the following way :
Creating an Alias and applying Aggregate Aware function. Using Multiple SQL statements for each Measure.
Q)What is user objects?
User objects are end–user personal objects that are not shared with other end-users. This is because the user objects are stored locally in a specific user object definition file. If an end-user tries to refresh or edit query that contains another user's user object, the user object is automatically removed from the query and report. A user object is stored inside the Universe folder
.
Q)What are the various Business Objects products?
• User Module
• Designer
• Supervisor
• Auditor
• Set Analyzer
• Info View (Web Intelligence)
• Business Objects Software Development Kit (SDK)
• Broadcast Agent
Q)What are strategies?
A strategy is a script that automatically extracts structural information from a database or flat file.
Q)What are the different types of Strategies?
In Designer we can specify two types of strategies :
Built in strategies
External strategies
Q)What are the types of users in Business Objects?
• General Supervisor
• Supervisor
• Designer
• Supervisor Designer
• End User
• Versatile User
Q)What is Web Intelligence?
Web Intelligence is a decision support solution designed to meet critical query, reporting and analysis needs over the World Wide Web and has features very similar to Business Objects.
Q)What are master/detail reports?
Master/detail reports enable you to split large blocks of data into sections. This type of presentation allows you to avoid repeating values and also to display subtotals.
Q)What are calculation contexts?
By default, BUSINESSOBJECTS determines the result of a measure based on the dimension or dimensions in the part of the report in which the measure is inserted. These sets of dimensions are called calculation contexts. Calculation contexts are dynamic in BUSINESSOBJECTS.
Q)What is Dimension?
It is a structural attribute of a cube, which is used for multidimensional analysis.
Q)What is supervisor?
Supervisor is the product is used to set up and maintain a secure environment for Business Objects products.
Q)What are the types of dimensions?
• There are four types of dimensions are :
• Informational Dimension
• Structural Dimension
• Categorical Dimension
• Partitioning Dimension
Q)What is a Data Provider?
The data source (Query) is called as the data provider
.
Q)What are the tasks of the universe designer?
• The responsibilities that universe designer has
• Designing, Creating and maintaining the Universe
• Distributing the Created Universes
Q)What are different types of parsing?
• There are two types of parsing are :
• Quick parsing
• Thorough parsing
No comments:
Post a Comment