Q1 : What is SAP business objects?
A : SAP Business Objects is a business intelligence tool that provides the combination of analysis, reporting and querying intended to find instant answers to the business related questions and help management improve their decision-making process.
Q2 : Write the kinds of users linked with business objects.
A : There are various kinds of users
- Supervisor Designer
- Designer
- Graphical Interface
- Supervisor
- General Supervisor
- Versatile User
- End User
Q3 : What is Slice in Business Objects.
A : It is used to reset, rename and omit the blocks. It works with the master or detailed reports.
Q4 : Explain the pros of using business objects.
- User friendliness
- Business terms that are familiar
- Graphical interface
- Deployment of documents on an enterprise basis by making use of WebI
- Dragging and dropping
- Powerful reports for a lesser amount of time.
Q5 : Write the schema supported by Business Objects Designer.
A : There are five different schemas supported by Business Objects designer
- Snowflake schema.
- Star schema
- Normalized production schema
- Multistar schema.
- Data warehouse with aggregates
Q6 : Write the different products linked with Business Objects.
A : There are various products related with business objects
- Broadcast Agent
- Info View
- Supervisor
- Auditor
- Designer
- Set Analyzer
- User module
Q7 : Define personal connection?
A : It can be made only by one user and can’t be used by the others. The details for the same are kept in a PDAC.LSI file.
Q8 : What is Chasm Trap.
A : It is a situation which arises at the time when the value in the fact table get wrong when it is measured from two various fact tables.
Q9 : What are the kinds of modes associated with designer and business objects?
A : There are especially two different kinds of modes associated with these platforms, they are
- Enterprise mode
- Workgroup mode
A : Arrays of advantages are there in making use of Business Objects. These are as follows:
1. Graphical Interface
2. Dragging and Dropping
3. Terms those are familiar in business
4. User friendliness
5. Powerful reports for short span of time
6. Use of documents on basis of an enterprise using Webl
Q11 : What is a secured connection?
A : Secured connection is a kind of connection that can be helpful in overcoming the various limitations associated with the former connections. The rights related with this kind of connection can be set over documents as well as objects. Universes can be brought inside the central repository only by making use of secured connection. The parameters regarding these connection care usually saved inside CMS.
Q12 : How can Chasm Trap be solved?
A : Chasm trap should be solved by making use of two different methods.
- In the case of SQL parameters in universe, the option generates numerous queries for each and every measure that needs to be chosen. This helps in generating SQL statement for every measure and gives the correct results.
- Another approach is to include two joints in different contexts, where the problem will get solved by generating two synchronized queries.
Q13 : Define data mining.
A : Data mining is the process through which you can extract the required details from the database, which can be made used for making conclusions.
Q14 : What are custom hierarchies?
A : The custom hierarchies are used to define the universe for assisting drill down that is not only customized but can also occur between objects from same or different classes taking into consideration the user requirements.
Q15 : Explain the difference between Slice and Dice.
A : Slice helps in renaming, resetting and deleting the blocks, Dice helps in displaying and removing the data. In other sense, Slice works with the detail/master report, while Dice helps in turning the tables and crosstabs into charts and charts in crosstabs/tables.
Q16 : When a context can be used?
A : Context is formed when the dimension objects are available in one or both fact tables.
Q17 : Define the process of accessing one derived table from another.
A : One derived table can be accessed from another with the help of @Derived_table function. The syntax is as follows:
@derived_table (used as the derived table name)
Q18 : How many possible ways are there for linking universes?
A : There are three ways:
- The Master approach.
- The Kernal approach.
- The Component approach.
Q19 : Define the term fan trap?
A : A one to many join links to a table which respond with another one to many join links is called fan trap.
Q20 : What are the restrictions over user objects?
A : User objects are not shared with other end users. It is stored in a specific user object definition file. So if any end-user tries to refresh or edit the query contains another user’s user object, it will be automatically cleaned and removed.
Q21 : What you meant by report bursting?
A : To maintain the version documents according to the user profiles, we use report bursting.
Q22 : Define strategies.
A : To automatically extract structural information from database or from a flat file we use a script known as strategy.
Q23 : What is Shared connection?
A : This is a kind of connection that is usually made used by other users via a server which is shared one. The details regarding the connection can be stored within the SDAC>LSI file which can be found within the installation folder of the business objects.
Q24 : List out the @functions.
A : The @functions are:
- @Aggregate_Aware
- @Script
- @Select
- @Variable
- @where
- @Prompt
Q25 : Define Data provider.
A : The query or the data source is called as the data provider.