1. Define Business objects.
Business object can be considered as integrated analysis,
reporting and query for the purpose of finding solution to some business
professionals that can be helpful for them to retrieve data from the
corporate databases in a direct manner from the desktop. This retrieved
information can be presented and analyzed within a document that of
business objects. Business objects can be helpful as an OLAP tool by the
high level management as a major part of Decision Support Systems.
2. Explain the pros of using business objects.
There are many advantages in making use of business objects and they are
- 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.
3. List out the different products related with Business Objects.
There are various kinds of products related with business objects and they are
- User module
- Designer
- Supervisor
- Auditor
- Set Analyzer
- Info View
- Business Objects – Software Development – Kit
- Broadcast Agent
4. Define Designer.
Designer is a module related with Business Objects
IS used by the designers for creating and maintaining universes.
Universes can be considered as semantic layer that can isolate the end
users from the various issues that are technical and related with the
structure of database.
Universe designers has the possibility for distributing the universes
to the end users after moving these as file through the system of files
or can be done by exporting the files to the repository.
5. What are the kinds of modes associated with designer and business objects?
There are especially two different kinds of modes associated with these platforms, they are
- Enterprise mode
- Workgroup mode
6. List out the various kinds of methods related with multidimensional analysis that is inside business objects.
There are two different methods related with multidimensional analysis available inside BO and these methods are
7. List out the kinds of users associated with business objects.
There are various different kinds of users associated with business object, they are
- General supervisor
- Supervisor
- Graphical Interface
- Designer
- Supervisor Designer
- End User
- Versatile User
8. What are the various data sources available?
Business objects help you in accessing the data from
variety of sources. You have the possibility of accessing data from
RDBMS like oracle, MS SQL server and IBM DB2.
9. Define the kinds of data providers?
There are various kinds of data providers available for the business objects and they are
- Stored procedures
- Queries over universe
- Free hand – SQL
- VBA procedures
- SAP
- OLAP servers
- Personal data files
10. Define drill mode.
This is a kind of analysis mode associated with business
objects and helps in breaking down data as well as in viewing data from
all the possible angles and the levels of detail for discovering the
factor that has caused good – bad result.
11. What is a personal connection?
Personal connection can be created only by a single user and
it can’t be made used by others. The details regarding such a connection
can be usually stored inside PDAC.LSI file.
12. What is Shared connection?
This is a kind of connection that is usually made
used by other user 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.
13. What is a secured connection?
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
central repository only by making use of secured connection. The
parameters regarding these connection care usually saved inside CMS.
14. Define custom hierarchies?
The custom hierarchies can be used for defining the universe for
facilitating drill down that is customized and can happen between
objects from different or same classes considering the user
requirements.
15. How can custom Hierarchies be created?
The custom hierarchies can be created by following the path tools ->hierarchies in BO designer.
16. Define a context in the universe.
Context can be defined as the particular path of join between a
specific group of joins or the tables for the purpose of a particular
query. A particular object that can be found inside the column of a
table, belonging to particular context is supposed to be compatible to
all the various kinds of objects belonging to the same context. In the
case of objects that are from the various kinds of context, different
kinds of SQL can be generated, and the results can be merged inside
micro cube. This is for making sure that there is no incorrect result
associated with a loop or any other kind of issue related with join
path.
17. How can Contexts be created?
Context can be created by making use of feature associated
with context or by manual procedures. The context are usually created by
making use of logical calculation or based on the business
requirements. The detect context may not be much useful in this case and
so it should be done by making use of manual procedure.
18. Define a Chasm Trap.
Chasm trap is a condition that arises when the values inside
the fact table get inflated at the time of measuring the values from two
different fact tables by considering the dimensions inside dimension
table.
19. How can Chasm Trap be solved?
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.
20. What are the utilities of Derived tables?
Using SQL queries from the database level, Derived tables are
created in the universe. The columns of the derived table will be the
columns selected in the query. Derived table can be used in the complex
calculations which are difficult to be achieved in the report levels.
Using a dblink, tables can be accessed from a different schema, is
another use of derived tables.
21. Define User Objects.
User objects is a universe of classes and objects which is
created by the universe designer. Once the objects consisted in the
universe does not matches your necessities, then the user can create his
own objects called User objects.
22. List out the @functions.
The @functions are:
- @Aggregate_Aware
- @Script
- @Select
- @Variable
- @where
- @Prompt
23. Describe the uses of @functions.
The @prompt function asks the end user to enter any specific
values. The Visual Basics for applications macro’s results will be
recovered by using @Script function. An existing statements SELECT
statement can be re-used by using @Select function. For a name or
variable, the value assigned to it will be referenced using @Variable.
An existing object’s where clause can be re-used by @Where functions.
24. How many Domains are there in Business Objects? What are they?
There are three Domains in Business Objects and they are:
- Security
- Document
- Universe
25. How to access one derived table from another?
Using @Derived_table function, we can access one derived table from another. The syntax is as ,
@derived_table(the derived table name)
26. Define Slice in Business Objects.
Slice works with the master or detail reports and it is used to rename, reset and delete the blocks.
27. Differentiate Dice and Slice.
- Slice: It renames, reset and delete the blocks. It works with the master/detail report.
- Dice: It displays the data and removes the data. It turns the crosstabs and tables into c harts and vice versa.
28. What is a master/detail report?
- Large blocks of data can be split into sections by using
master/detail report. Repeating values can be avoided by using this and
also the subtotals can be displayed.
29. Define a class.
The class can be defined as a collection of objects in a
universe. Subclasses can be derived from classes and using these classes
and the subclasses, we can create a hierarchy.
30. How many approaches are there for linking universes?
There are three approaches available for linking the universes and they are:
- The Kernal approach.
- The Master approach.
- The Component approach.
31. Define data mining.
Data mining is the process through which you can extract the required details from the database, which can be made used for making conclusions.
32. List out the available Drill modes.
Drill modes helps to analyze data from different angles and different state of details. The available Drill modes are;
- Drill up.
- Drill down.
- Drill by.
- Drill through.
33. Define aggregate_awarness.
when we have a same fact tables in different grains,we use
aggregate_awarness function to define one object for measures in fact
tables.the syntax is as,
@aggregate_aware(highest_level.lower level)
34. Define the term fan trap?
A one to many join links to a table which respond with another one to many join links is called fan trap.
35. Define Data provider.
The query or the data source is called as the data provider.
36. When we use a context?
Context is created when the dimension objects are present in one or both fact tables.
37. What is a standard mode?
Only the users within the group can be accessed in this mode.
38. List out the schemas supported by Business Objects Designer.
There are five different schemas supported by Business Objects designer and they are:
- star schema.
- Snowflake schema
- Multistar schema
- Normalized production schema.
- Data warehouse with aggregates.
39.Define Channel.
Channel is a website with ‘push’ technology. It is to make the
users know up-to-date information. Each and every Business Objects
channel will be associated with a broadcast agent, who can have several
channels.
40. What are the restrictions over user objects?
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.
41. List out the tasks of universe designer.
The tasks consists of,
- Designing the universe.
- Creating the universe.
- Maintaining the universe.
- Distributing the universe
42. List out the main components of designer interface.
The main components it consists of are:
- The table browser.
- The structure pane.
- The universe pane.
43. What you meant by report bursting?
To maintain the version documents according to the user profiles, we use report bursting.
44. Define WEBI.
Web intelligence is a solution that is specialized in supporting the decisions related with queries, reports and analysis.
45. Abbreviation of DSS is?
Decision Support Systems.
46. Define strategies.
To automatically extract structural information from database or from a flat file we use a script known as strategy.
47. Give a definition for universe.
It is a set of objects and classes.these objects and clss es will be intended for an application or a group of users.
48. Define secured mode.
Secured mode restrict the access of specific users over specific commands
49. What is Drill by?
Using drill by we can move to other hierarchy and analyze the other data, which belongs to another hierarchy.
50. What is a list of values?
It is file which contains the data values associated with an object.