SAP BusinessObjects

what is prompt? Cascading prompt? Syntax
To prompt the values and it is used on where condtion and filter
row
syntax
@select(class\object )= @prompt
('message','type','{values1,values2...},class\object,mono\mu
lti,free\constrained)
How you get the requirement from client?
client gets the information. that information is not in the order.they
r unable to under stand info.it can not helpfull to take the
decessions. then the clint meets the company.
what is drill down?
action of navagating thorough levels of data. by drill down your can
reach the more refined or detailed information.
what is slice & dice?
slice and dice is to arrange the the data in differnt ways. it can
chage as rows to columns and columns to rows.
what are the features in BO?
define scope of analysis.
define condiations.
create master and detail reports.
add formulas,local variables and functions
breakeup tables and disply tha calculations.
create charts.
analyze the data in drill mode.
use slice and dice.
formate reports.
export reports.
.why we are going to data warehouse?
data warehouse is used for to store the large volumes of
data.it can be used for future forecasting.it is the
collection of key pieces of information that can be used for
to take the dession by the managers.
what are the multidimensional analyses
multidimensional analyses that can be used to wide view varities of
data or information
what is data mart?
datamart is nothing but a database. it can be stored data about the
particular orginazation.
5.what is LOV? where it is store?
LOV is the list of values.it can retrive the data values associated
with the particular object.
this can be stored in sub folder of USERDOCS with .lov extension.
what is repository? Types
repository is the set of data structers that can be stored in the
database.
what is alias?
one user prefrom different roles is called alias
eg
1
two dept are there sales , HR user of sales working in HR with
different row is called alias
alias is logical popint to alternate to the table name.this can be used
to resolve the loops.
What is loop? How resolve the loop?explain it?
a situation occures more than one path exists from one table to
another table. to reslove the loops we can use the allias ans
context. if a loop contains only one lookup table then the loop can
be resolved by detecting the alias. if a loop is having 2 or more fact
tables(multiple fact
tables) then the loop can be resolved by detecting context.
what is context? How u create? With example
it is a set of joins that specefies one of several paths through tables
in loop.
if a loop is having 2 or more fact tables(multiple facttables) then the
loop can be resolved by detecting context
tools-->insert context
then
you can select the path.
How can we improve performance
By making use of Aggregate tables.
What is the use of BO SDK?
Bo SDK main use is to suppress “no data to fetch” using
Macros.
What are the general issues in migration process?
Alignment, performance.
Why do we need metrics and sets?
Metrics are used for analysis and Sets are used for grouping.
what is the source for metrics?
measure objects
What is the use of AFD? Where it can be stored?
used to create dashboards. It can be stored in repository, corporate
or personal.
What is a Set?
Its nothing but grouping of users.
What is metrics?
Metrics are a system of parameters or ways of quantitative
and periodic assessment of a process that is to be measured. These
are used to track trends, productivity.
What is the difference between master-detail and Breaks?
In break common fields are deleted whereas in master-detail , we
declare certain entity as a master to get the detailed information or
report in this case the table format is changed.
What are Alerter, Filters, Breaks and Conditions?
Alters are nothing but they are used to draw attention to a block of
data by highlighting.
Breaks are nothing but grouping the data without any change in the
format. Condition is used to retrieve data which meets certain
criteria. Filters are used to get necessary data.
2
What is a join? Explain different types of joins?
Join is used to link to tables depending upon the data requested by
the user, Usually we have Inner Join, Outer Join, Left Join, Right Join,
Full Outer join.
What is a loop? How can we overcome?
Loop is nothing but a closed circular flow; it can be overcome by
making use of Alias and Context.
What is the size of data base?
In general it will be anything between 4-8 Terabytes.
What do you mean by Object qualification?
Object qualification represents what kind of object is that, usually
we have three types of object qualifiers they are measure,
dimension, detailed.
What is a category
It is nothing but grouping of certain entities.
How do you restrict access to rows of a database?
In XI version it can be done by using row-level security in designer
module whereas in 5i/6i it is done by supervisor.
Can we have multiple domains?
Yes
When is the Repository created?
In 5i/6i versions after installing the software, whereas in Xi version
a repository is created at the time of installation.
What is domain? How many are there in a basic setup? What
are they?
Domain is nothing but logical grouping of system tables,
There are three domains usually in a basic setup, They are
Secure, Universe, Document. Business objects are sometimes called
domain objects , and
a domain model represents the set of domain objects and the
relationships between them.
What is BOMain.Key?
BoMain.Key file contains the information about the repository site i.e
it contains the address of the repository security domain.
Explain in Detail about Measure Objects? and what is the
use of it? How to create it?
It is a numeric data.
What is the local filter and global filter in bo's?
Local Filter is to single block to which it is created, but a global filter
is to all the blocks which consists of that column
Types of universes in business objects?
This is not Universe types.
Personal,Shared, Secured are Unverse connections.
most prefered Secured , we can export all changes made in
unverse. where as other connection does not allow.
3
DATAWARE HOUSING FAQ’S
can a dimension table contains numeric values?
Yes.But those datatype will be char (only the values can
numeric/char).
What is the difference between view and materialized view
View - store the SQL statement in the database and let you use it as
a table. Everytime you access the view, the SQL statement
executes.
Materialized view - stores the results of the SQL in table form in the
database. SQL statement only executes once and after that
everytime you run the query, the stored result set is used. Pros
include quick query results.
What are the vaious ETL tools in the Market
Various ETL tools used in market are:
Informatica
Data Stage
Oracle Warehouse Bulider
Ab Initio
Data Junction
Wht r the data types present in bo?n wht happens if we
implement view in the designer n report
Three different data types: Dimensions,Measure and Detail.
View is nothing but an alias and it can be used to resolve the loops
in the universe.
What is VLDB
The perception of what constitutes a VLDB continues to grow. A one
terabyte database would normally be considered to be a VLDB.
Differences between star and snowflake schemas
Star schema : A single fact table with N number of Dimension
Snowflake schema : Any dimensions with extended dimensions are
know as snowflake schema
What is ER Diagram
The Entity-Relationship (ER) model was originally proposed by Peter
in 1976 [Chen76] as a way to unify the network and relational
database views.
Simply stated the ER model is a conceptual data model that views
the real world as entities and relationships. A basic component of
the model is the Entity-Relationship diagram which is used to
visually represents data objects.
4
Since Chen wrote his paper the model has been extended and today
it is commonly used for database design For the database designer,
the utility of the ER model is:
it maps well to the relational model. The constructs used in the ER
model can easily be transformed into relational tables.
it is simple and easy to understand with a minimum of training.
Therefore, the model can be used by the database designer to
communicate the design to the end user.
In addition, the model can be used as a design plan by the database
developer to implement a data model in a specific database
management software.
What is surrogate key ? where we use it expalin with
examples
surrogate key is a substitution for the natural primary key.
It is just a unique identifier or number for each row that can be used
for the primary key to the table. The only requirement for a
surrogate primary key is that it is unique for each row in the table.
Data warehouses typically use a surrogate, (also known as artificial
or identity key), key for the dimension tables primary keys. They
can use Infa sequence generator, or Oracle sequence, or SQL Server
Identity values for the surrogate key.
It is useful because the natural primary key (i.e. Customer Number
in Customer table) can change and this makes updates more
difficult.
Some tables have columns such as AIRPORT_NAME or CITY_NAME
which are stated as the primary keys (according to the business
users) but ,not only can these change, indexing on a numerical
value is probably better and you could consider creating a surrogate
key called, say, AIRPORT_ID. This would be internal to the system
and as far as the client is concerned you may display only the
AIRPORT_NAME.
2. Adapted from response by Vincent on Thursday, March 13, 2003
Another benefit you can get from surrogate keys (SID) is :
Tracking the SCD - Slowly Changing Dimension.
Let me give you a simple, classical example:
On the 1st of January 2002, Employee 'E1' belongs to Business Unit
'BU1' (that's what would be in your Employee Dimension). This
employee has a turnover allocated to him on the Business Unit 'BU1'
But on the 2nd of June the Employee 'E1' is muted from Business
Unit 'BU1' to Business Unit 'BU2.' All the new turnover have to
belong to the new Business Unit 'BU2' but the old one should Belong
to the Business Unit 'BU1.'
If you used the natural business key 'E1' for your employee within
5
your datawarehouse everything would be allocated to Business Unit
'BU2' even what actualy belongs to 'BU1.'
If you use surrogate keys, you could create on the 2nd of June a new
record for the Employee 'E1' in your Employee Dimension with a
new surrogate key.
This way, in your fact table, you have your old data (before 2nd of
June) with the SID of the Employee 'E1' + 'BU1.' All new data (after
2nd of June) would take the SID of the employee 'E1' + 'BU2.'
You could consider Slowly Changing Dimension as an enlargement
of your natural key: natural key of the Employee was Employee
Code 'E1' but for you it becomes Employee Code + Business Unit -
'E1' + 'BU1' or 'E1' + 'BU2.' But the difference with the natural key
enlargement process, is that you might not have all part of your new
key within your fact table, so you might not be able to do the join on
the new enlarge key -> so you need another id.
Difference between Snow flake and Star Schema. What are
situations where Snow flake Schema is better than Star
Schema to use and when the opposite is true?
Star schema contains the dimesion tables mapped around one or
more fact tables.
It is a denormalised model.
No need to use complicated joins.
Queries results fastly.
Snowflake schema
It is the normalised form of Star schema.
contains indepth joins ,bcas the tbales r splitted in to many
pieces.We can easily do modification directly in the tables.
We hav to use comlicated joins ,since we hav more tables .
There will be some delay in processing the Query .
What is the main differnce between schema in RDBMS and
schemas in DataWarehouse....?
RDBMS Schema
* Used for OLTP systems
* Traditional and old schema
* Normalized
* Difficult to understand and navigate
* Cannot solve extract and complex problems
* Poorly modelled
DWH Schema
* Used for OLAP systems
* New generation schema
* De Normalized
* Easy to understand and navigate
* Extract and complex problems can be easily solved
* Very good model
What are the possible data marts in Retail sales.?
Product information,sales information
6
What is the definition of normalized and denormalized view
and what are the differences between them
Normalization is the process of removing redundancies.
Denormalization is the process of allowing redundancies.
What is meant by metadata in context of a Datawarehouse
and how it is important?
Meta data is the data about data; Business Analyst or data modeler
usually capture information about data - the source (where and how
the data is originated), nature of data (char, varchar, nullable,
existance, valid values etc) and behavior of data (how it is
modified / derived and the life cycle ) in data dictionary a.k.a
metadata. Metadata is also presented at the Datamart level,
subsets, fact and dimensions, ODS etc. For a DW user, metadata
provides vital information for analysis / DSS.
What is a linked cube?
Linked cube in which a sub-set of the data can be analysed into
great detail. The linking ensures that the data in the cubes remain
consistent.
what is junk dimension? what is the difference between junk
dimension and degenerated dimension?
Junk dimension: Grouping of Random flags and text Attributes in a
dimension and moving them to a separate sub dimension.
Degenerate Dimension: Keeping the control information on Fact
table ex: Consider a Dimension table with fields like order number
and order line number and have 1:1 relationship with Fact table, In
this case this dimension is removed and the order information will
be directly stored in a Fact table inorder eliminate unneccessary
joins while retrieving order information.
1.what is incremintal loading? 2.what is batch processing?
3.what is crass reference table? 4.what is aggregate fact
table
Incremental loading means loading the ongoing changes in the
OLTP.
Aggregate table contains the [measure] values ,aggregated
/grouped/summed up to some level of hirarchy.
What are the different architecture of datawarehouse
I think, there are two main things
1. Top down - (bill Inmon)
2.Bottom up - (Ralph kimbol)
What is hybrid slowly changing dimension
Hybrid SCDs are combination of both SCD 1 and SCD 2.
It may happen that in a table, some columns are important and we
need to track changes for them i.e capture the historical data for
them whereas in some columns even if the data changes, we don't
care.
For such tables we implement Hybrid SCDs, where in some columns
are Type 1 and some are Type 2.
What is Data warehosuing Hierarchy?
7
Hierarchies
Hierarchies are logical structures that use ordered levels as a means
of organizing data. A hierarchy can be used to define data
aggregation. For example, in a time dimension, a hierarchy might
aggregate data from the month level to the quarter level to the year
level. A hierarchy can also be used to define a navigational drill path
and to establish a family structure.
Within a hierarchy, each level is logically connected to the levels
above and below it. Data values at lower levels aggregate into the
data values at higher levels. A dimension can be composed of more
than one hierarchy. For example, in the product dimension, there
might be two hierarchies--one for product categories and one for
product suppliers.
Dimension hierarchies also group levels from general to granular.
Query tools use hierarchies to enable you to drill down into your
data to view different levels of granularity. This is one of the key
benefits of a data warehouse.
When designing hierarchies, you must consider the relationships in
business structures. For example, a divisional multilevel sales
organization.
Hierarchies impose a family structure on dimension values. For a
particular level value, a value at the next higher level is its parent,
and values at the next lower level are its children. These familial
relationships enable analysts to access data quickly.
Levels
A level represents a position in a hierarchy. For example, a time
dimension might have a hierarchy that represents data at the
month, quarter, and year levels. Levels range from general to
specific, with the root level as the highest or most general level. The
levels in a dimension are organized into one or more hierarchies.
Level Relationships
Level relationships specify top-to-bottom ordering of levels from
most general (the root) to most specific information. They define the
parent-child relationship between the levels in a hierarchy.
Hierarchies are also essential components in enabling more
complex rewrites. For example, the database can aggregate an
existing sales revenue on a quarterly base to a yearly aggregation
when the dimensional dependencies between quarter and year are
known.
What is Dimensional Modelling
Dimensional Modelling is a design concept used by many data
warehouse desginers to build thier datawarehouse. In this design
8
model all the data is stored in two types of tables - Facts table and
Dimension table. Fact table contains the facts/measurements of the
business and the dimension table contains the context of
measuremnets ie, the dimensions on which the facts are calculated.
What is degenerate dimension table?
Degenerate Dimensions : If a table contains the values, which r
neither dimesion nor measures is called degenerate dimensions.Ex :
invoice id,empno
what is the datatype of the surrgate key
Datatype of the surrogate key is either integer or numeric or
number
What is data validation strategies for data mart validation
after loading process
Data validation is to make sure that the loaded data is accurate and
meets the business requriments.
Strategies are different methods followed to meet the validation
requriments
What are the advantages data mining over traditional
approaches?
Data Mining is used for the estimation of future. For example, if we
take a company/business organization, by using the concept of Data
Mining, we can predict the future of business interms of Revenue
(or) Employees (or) Cutomers (or) Orders etc.
Traditional approches use simple algorithms for estimating the
future. But, it does not give accurate results when compared to Data
Mining.
What is a CUBE in datawarehousing concept?
Cubes are logical representation of multidimensional data.The edge
of the cube contains dimension members and the body of the cube
contains data values.
What is conformed fact?
Conformed dimensions are the dimensions which can be used
across multiple Data Marts in combination with multiple facts tables
accordingly
What is BUS Schema?
BUS Schema is composed of a master suite of confirmed dimension
and standardized definition if facts.
What is the main difference between Inmon and Kimball
philosophies of data warehousing?
Why fact table is in normal form?
What is Difference between E-R Modeling and Dimentional
Modeling.
Basically the fact table consists of the Index keys of the
dimension/ook up tables and the measures.
so when ever we have the keys in a table .that itself implies that the
table is in the normal form.
What are the steps to build the datawarehouse
9
As far I know...
Gathering bussiness requiremnts
Identifying Sources
Identifying Facts
Defining Dimensions
Define Attribues
Redefine Dimensions & Attributes
Organise Attribute Hierarchy & Define Relationship
Assign Unique Identifiers
Additional convetions:Cardinality/Adding ratios
BUSINESS OBJECTS
What happens to business objects report if the cardinality is
not specified??
loops cann't be detected, hence you cann't justify the structure
while cheking integrity
What is the difference between Sort and Filter function
e.g i have a column having data as 1, 5, 7, 3, 4, 5, 9
Sorting will sort as 1,3,4,5,5,7,9
What will ranking do???
What is the differnce between count & count all function
Count All:- for measure objectCount :- for dimension and detail
object
Why there is no global or local repository like in informatica?
Why BO is not using any server like informatica
Actually, we have a global repository in Business Objects like
informatica. It contains the users and domain information such as
security domain, universe domain, document domain all are
combinely called as metadata. After creation of general supervisor
and repository, you can able to access that repository and you can
save your universes, documents and etc.
can any one tell me if there is two user groups as
follows.Group1user1 -------Report-1user2Group2user1
Yes, user 2 has access to report 1 provided there are appropriate
rights to the group and the user. Always remember, Denial rights
take over Granted rights.
In BO supervisor how many types of users are there. and
what are they.
6 types of users
1. General Supervisor
2. Supervisor
3. Supervisor Designer
4. Designer
5. User
6. Versatile
10
can we save or create more than one universe in one
repository.
Yes. We can create more than one universe or you can save the
existing universe in different names.
What is Infoview in BO? andWhat are the differences
between BO 6.5 and BO XIR2?
BusinessObjects Enterprise comes with InfoView, a web desktop that
acts as a window to a broad range of useful business information
around your company. From InfoView, you can access Crystal
reports, OLAP Intelligence reports, Web Intelligence documents,
Desktop Intelligence documents, and other objects, and organize
them to suit your preferences.The features that are available in
InfoView vary by content type, but in general, you can view
information in your web browser, export it to other business
applications (such as Microsoft Excel), and save it to a specified
location. BusinessObjects Enterprise also provides access to a range
of analytic tools that help you explore information in more detail.
In BO 6.5 InfoView is a web application that must be deployed after
Business Objects installation using the Configuration
Tool, wdeploy, or manual procedures.
In XI R2 it is available in JSP and ASP platforms.The out-of-the-box
portal in BusinessObjects Enterprise XI is also called InfoView.
Available for both Java and .NET platforms, its interface is somewhat
different from the BusinessObjects 6.x
application.
What is Business Object
business objects is a repoting tool for generating the reports from
either the databases or the online data available.
How do I prevent overlapping of the tables in webi?
Right click and adjust the "position" of the second table with respect
to the first table. That way they do not overlap even when the data
of the first table increases.
by adjusting the overlap table with corresponding to the first table
from the appearence settings of the Format Table
what is Data Profiling in Business Objects?What is Data
Synchronization in Business Objects?
data synchronisation is used to synchronise data from say 2 data
providers :
1 say all list of sent emails
2 say all list of recd emails
you can synchronise these 2 lists using merged dimensions in webi
however what works in deski using formula may not work in webi;
bcos things work differently and the engines are difft. and so it is
not advised to use formula but just use merged dimensions and
synchronise data.
and u can only synch data on dimension not on measures !
for more info ... go to BO site... download the guides which are there
and read them.......for more elaborate explanation.
but this is the basic funda abt sync of data
11
Can we open the full cleint reports on thin cleint and vice
verse?
Inorder to open the full client report in thin client first export the
report to the repositry, log on to thin client (WEBI) and when you set
the filter to ALL TYPES you be be able to see the full client
report. Click to open
The main difference full-client (BusinessObjects) and the thin-client
(WebIntelligence).
how to improve performance at universe level and at report
level ? plz help me...
At universe level 3 ways we can improve the query performance.
1. Using aggregation tables in scheme.
2. Chnge the Array Fetch parameter.
3. Using shot cut joins.
4. Puting indexes on tables.
How do u migrate BOs Universes,users and user groups,and
report from version BO6.5 to XIR2?
Import Wizard allows us to import most objects in the repository
including user accounts,groups,folders,universes,documents as well
as objects stored in inbox,personal folders on cluster servers to our
new Business Objects Enterprise XIR2. It acts as a bridge between
the 6.x to XIR2
Hi all.Can you please tell me whether we can able to create
a Universe for a text file. If yes, what
Universe can be created on anything that has a an odbc connection
and MS has an ODBC for text files.
BUSINESS OBJECTS OCT07
Cardinality Cardinality expresses the minimum and maximum
number of instances of an entity B that can be associated with an
instance of an entity A. The minimum and the maximum number of
instances can be equal to 0, 1, or N.
Cartesian product A Cartesian join will get you a Cartesian
product. A Cartesian join is when you join every row of one table to
every row of another table. You can also get one by joining every
row of a table to every row of itself.
Class A class is a logical grouping of objects within a universe. In
general, the name of a class reflects a business concept that
conveys the category or type of objects. For example, in a universe
pertaining to human resources, one class might be Employees.
A class can be further divided into subclasses. In the human
resources universe, a subclass of the Employees class could be
Personal Information.
As designer, you are free to define hierarchies of classes and
subclasses in a model that best reflects the business concepts of
your organization.
12
Condition Lets you create a condition. The conditions that you
define appear within the Universe window. From the Query Panel, a
user can drag the conditions from the Classes and Objects box to
the Conditions box.
Or
A component that controls the type and the amount of data
returned by a specific object in a query. A condition created in the
Designer module is referred to as a predefined condition.
Connection Set of parameters that provides access to an RDBMS.
These parameters include system information such as the data
account, user identification, and path to the database. Designer
provides three types of connections: secured, shared, and personal.
Detail object An object qualified as a detail provides descriptive
data about a dimension object. A detail object cannot be used in
drill down analysis.
Dimension object An object being tracked in multidimensional
analysis; the subject of the analysis. Dimensions are organized into
hierarchies.
Or
1 Double-click the object in the Universe window.
The Edit Properties dialog box is displayed.
2 In the Definition tab, change the object's type, if necessary.
3 Click the Properties tab.
4 In the Qualification box, click the Dimension radio button.
If the object is of type date, click the Automatic Time Hierarchy
button, enter the necessary options, and then click the OK button.
5 Click the OK button.
Document domain The area of the repository that stores
documents, templates, scripts, and lists of values. all the document
informations are stored here
Drill The action of navigating through levels of data. When you drill
up, you obtain more summarized or general information. By drilling
down, you can reach more refined or detailed information.
There can be 3 types of Drill Analysis- Drill Down,Drill Up and Drill
Through.
Within the same universe one can Drill Up/Down like Country-State-
City;of course with facts that relate to the same grain.
13
A Drill through is possible when we can link different Data Marts like
Profitability as defined by details of Asset,Liability,Income and
Expense.
Equi-join A join based on the equality between the values in the
column of one table and the values in the column of another.
Because the same column is present in both tables, the join
synchronizes the two tables.
Enterprise mode A work mode whereby a designer creates
universes in an environment with a repository. The mode in which a
universe is saved determines whether other designers are able to
access it. By default, a universe is saved in the mode in which the
designer is already working.
Or
Enterprise mode means that you are working in an environment
with a repository. Workgroup mode means that you are working
without a repository. The mode in which you save your universe
determines whether other designers are able to access them.
Hierarchy An ordered series of related dimensions used for
multidimensional analysis.
Join A relational operation that causes two tables with a common
column to be combined into a single table. Designer supports equijoins,
theta joins, outer joins, and shortcut joins.
List of values A list of values contains the data values associated
with an object. These data values can originate from a corporate
database, or a flat file such as a text file or Excel file. In Designer
you create a list of values by running a query from the Query Panel.
You can then view, edit, purge, refresh and even export this file. A
list of values is stored as an .lov file in a subfolder of the UserDocs
folder.
Loop A situation that occurs when more than one path exists from
one table to another in the universe.
Measure object An object that is derived from an aggregate
function. It conveys numeric information by which a dimension
object can be measured.
Object A component that maps to data or a derivation of data in
the database. For the purposes of multidimensional analysis, an
object can be qualified as a dimension, detail, or measure. Objects
are grouped into classes.
14
Offline mode The work mode in which the designer works with
universes stored locally.
The designer can design the universe in offline mode for that you
need to login at least once
Outer join A join that links two tables, one of which has rows that
do not match those in the common column of the other table.
Personal connection A personal connection is used to access
resources such as universes or documents. It can be used only by
the user who created it. Information about a personal connection is
stored in both the PDAC.LSI and PDAC.SSI files; its definition is static
and cannot be modified.
Qualification A property of an object that determines how it can be
used in multidimensional analysis. An object can be qualified as one
of three types: a dimension, detail or measure.
Query In Designer a query is a technique for creating or modifying
a list of values associated with an object. From the Query Panel, a
designer builds a query from the classes, objects, and conditions of
a universe. In the BusinessObjects User module, a query is a type of
data provider. An end user builds a query from a universe, and then
runs the query to generate a BusinessObjects report.
Quick Design A wizard in the Designer module that provides
guided instructions for creating a basic universe. It lets a designer
name a universe, set up a connection to a database, select
strategies, create classes and objects, as well as generate joins with
cardinalities.
If you click the File/New starts Quick Design wizard check box in the
General tab (Tools menu, Options command) the New command
automatically launches the Quick Design wizard.
Repository A centralized set of relational data structures stored in
a database. It enables BusinessObjects users to share resources in a
controlled and secured environment. The repository is made up of
three domains: the security domain, the universe domain, and the
document domain.
Secured connection A secured connection is used to access
universes or documents that may be restricted or confidential. It can
be shared by several authorized users. Stored in the repository, the
definition of a secured connection is updated dynamically.
Shared connection A shared connection is used to access
common resources such as universes or documents. It can be used
15
by several users. Information about a shared connection is stored in
a SDAC.LSI or SDAC.SSI file; its definition is updated dynamically.
Shortcut join A join that links two tables by bypassing one or more
other tables in the universe.
Strategy Scripts that automatically extract structural information
about tables, columns, joins, or cardinalities from a database.
Designer provides default strategies but a designer can also create
strategies. These are referred to as external strategies.
Structure pane The graphical component within the main Designer
window that shows the schema of the universe. It reflects the
underlying database structure of the universe.
Insert tables in the Structure pane
1 Select the Tables command from the Insert menu.
2 In the Table Browser, click the tables you want to add to the
universe structure.
To select several contiguous tables, hold down the Shift key, then
click the first table and the last table. All the tables between the
selected tables will be highlighted. To select several tables that are
not contiguous, click each table while holding down the Ctrl key.
3 Click the Insert button.
Subclass A component within a class that groups objects. A
subclass can itself contain other subclasses or objects.
Table Browser The graphical component within the main Designer
window that lets you create the classes and objects of the universe
from the tables and columns of a database.
Theta join A join that links tables based on a relationship other
than equality between two columns. theta join is when you connect
2 columns from one table to one column of another table
Universe A universe is a business-oriented mapping of the data
structure found in databases: tables, columns, joins, etc. It can
represent any specific application, system, or group of users. For
example, a universe can relate to a department in a company such
as marketing or accounting.
Universe domain The area of the repository that holds exported
universes. The universe domain makes it possible to store,
distribute, and administrate universes. There may be multiple
universe domains in a repository.
16
Universe pane The graphical component within the main Designer
window that displays a hierarchical view of the classes, objects, and
conditions in a universe. Two radio buttons on the lower edge of the
pane filter
User object An object created by the end user from the
BusinessObjects User module. A user object can be inserted into a
universe by the designer. Insert a user object
1 Select the User Objects command from the Insert menu.
The Insert User Objects dialog box is displayed.
2 Click a user object file.
A user object file has a .udo extension
3 Click the Open button.
Workgroup mode A work mode whereby a designer creates
universes in an environment without a repository. The mode in
which a universe is saved determines whether other designers are
able to access it. By default, a universe is saved in the mode in
which the designer is already working.
Or
Designer lets you save universes in either enterprise or workgroup
mode.
Enterprise mode means that you are working in an environment
with a repository. Workgroup mode means that you are working
without a repository. The mode in which you save your universe
determines whether other designers are able to access them.
What is Designer? Designer is a BusinessObjects IS module used
by universe designers to create and maintain universes. Universes
are the semantic layer that isolates end users from the technical
issues of the database structure. Universe designers can distribute
universes to end users by moving them as files through the file
system, or by exporting them to the repository.
1. It is one of the business object’s components
2. It is used to create universes
3. It is used to define measures/metrics
4. It is used to do the calculations
How do you design a universe?
The design method consists of two major phases.
During the first phase, you create the underlying database structure
of your universe. This structure includes the tables and columns of a
17
database and the joins by which they are linked. You may need to
resolve loops which occur in the joins using aliases or contexts. You
can conclude this phase by testing the integrity of the overall
structure.
During the second phase, you can proceed to enhance the
components of your universe. You can also prepare certain objects
for multidimensional analysis. As with the first phase, you should
test the integrity of your universe structure. You may also wish to
perform tests on the universes you create from the BusinessObjects
User module. Finally, you can distribute your universes to users by
exporting them to the repository or via your file system.
For a universe based on a simple relational schema, Designer
provides Quick Design, a wizard for creating a basic yet complete
universe. You can use the resulting universe immediately, or you
can modify the objects and create complex new ones. In this way,
you can gradually refine the quality and structure of your universe.
Alias A logical pointer to an alternate table name. The purpose of
an alias is to resolve loops in the paths of joins
what are the precautionary measures you will take in the
project? First of all kindly specify your question.
In my opinion
We can take precaution in many sense like following:
1) Security
    Make user groups
    Make universe level access rights
    Report or document level access rights
2)Â Naming conventions used to differentiate Classes objects
3)Â Where to use aggregate functions
4) Where/who can use prompts, Do they increase the speed and
performance of     report.
5)Â According to user categories how do they provide the options to
use Web doc or any other doc.
What is the drill up , drill down, drill by , drill trough ? drill up
: One level up in the HirearchyDrill down: One level down in the
Hirearchydrill by : direct selection of level in the Hirearchydrill
trough : to drill data from one Hirearchy to another Hirearchy.
Explain the SQL Queries activated to data base from Data
provider in BO ?
BO automatically generates the SQL query when objects are
selected into query panel. When you run the query, the query is
processed to database based on your connectivity. for ex: If you run
18
query using, Local Machine Full Client (BO reporter), the query
directly connects to database through midilleware
Full Client <---> Database If you run query using Webi, the webi
browser will connects to Web Server and Webserver will proces
request to Database.
WEBI <--->Web Server <---> Database
What are steps to be taken care to create a good Universe?
1)make the joins with optimization
2)reduce the creation userobjects more in the universe
3)class should not be more than 60
4)try to use aggreateware on measure objectsGive meaningful
name to the Universe
2.Give meaningful names for objects as the user may nt be aware of
the technical terms of underlying objects
3.Group all similar objects(coming from single table) into same
class/subclass
4. Give meaningful,similar names to alias tables
5. set cardinalities to all the joins present
6.resolve loops.
7.Resolve fan trap and chasm trap if any
8.Define contexts according to the requirement
9.Use aggregate awareness if necessary
What are the steps to taken care to improve the Report
performance?In DESIGNER Level
1)eliminate the unnecessory joins
2)use conditions as much as at the database level
3)edit the SQL query in the Query Panel as per requirment
In REPORTER level
1)eliminate the filters as much as possible
2)try to reduce the user variables
Or
I can explain why a report performance is increased when we apply
a filter at the universe level rather than at the report level
When we apply a filter in the universe level,after the query is
fired,the data is filtered and then the required rows returned
But when the filter is applied at the report level,the query is
fired,rows retrieved and then filtered by the report level filter.
In the first case(universe level filter),less rows are retrieved from the
database whereas in the second case(report level filter),data is
fetched and then filter applied. It is more time consuming and the
performance is affected.
19
whether sevirity and priority are synonyms no, these are
antonyms
How can we acheive Correlated sub-query in Designer?can
anyone help me in this regard. right click on any object,go to the
properties.specify the query in select and put the next query in
where clause, like select COLNAME from TABNAME1 where
COLNAME IN(select colname2 from tab2)
broadcost agent Lets you set the user identification and
properties for the administrator of the Broadcast Agent. Broadcast
Agent is a BusinessObjects product that handles the scheduled or
batch processing of documents.
The administrator enters this user identification to log into
Broadcast Agent. The user identification consists of the name of the
Broadcast Agent and a password.
In the User pane, a group with a user identification for a Broadcast
Agent is identified with the symbol.
how toconnect one to one report? using union operator in the
querry pannel window
what are the diffrences between Business Objects 5.1 &
6.5 ? Main difference between BO 5.1 and 6.5 is Web
Intelligence(info view).Using BO 5.1 info view : we can only view the
reports that are created using USER module. we can't modify those
reports.Using BO 6.5 info view:We can view and create the reports .
we neednot have BO installed on out systems to do this.
---With Webi 6.5, use of multiple data providers are allowed.....but
the the only problem is that there is no syncronisation..i.e, Data
providers cannot be linked!
---with 6.5, infact from 6.1 onwards, you can directly save a report
into .xls, .pdf, .rtf...etc formats.
---there is a lot of improvement in Application Foundation with many
new features
One More other difference is they have introduced Derived Tables
Concept in 6.5 Version.This is very usefull to create Agregated data
with different tables at Designer level,it will improve the Query
Performance .
in 6.x version you can save universe in PDF Format,This format can
be easily understand by the End users while UAT.
20
Web Intelligence XI Release 2 has been enhanced to
deliver query authoring power and ease-of-use
interactivity features so that organizations can broaden
the reach of ad hoc analysis through a zero-client
interface. Enhancements include:
1. • Synchronized multiple data providers that allow
users to bring together data from two universes into a
single table or chart and then explore this information
2. • Combined queries using the ‘Union,’
‘Intersect,’ and ‘Minus’ operators
3. • Access to OLAP data via universes
4. • Sub queries – allowing users to use the results of
a query as a filter for a further query
5. • Conditional queries based on object-to-object
comparison
6. • Manual editing of the SQL
Additionally, Web Intelligence XI Release 2 provides
greatly enhanced report creation capabilities such as:
1. • Ranking of both query results and report content
2. • Custom sorting
3. • Advanced formula language functions
Finally, Web Intelligence XI Release 2 provides the
ability to view the ETL metadata from BusinessObjects
Data Integrator.
How do you connect the facts and dimensions in the tables
1. Smart Matching columns
2. Manually you can link
i want to restrict top 26 rows ...in reportis there any rownum
object from which i can do this : Restrict Top 26 Rows: Depends
on how you want to do it.
In a report: Drag the Dimention and measures into report. Click on
the Dimention object and use the RANK button on the tool bar. you
can specify the the Top 26 or Bottom(Depending on the
requirement) values of a measure. It also provides some calculation
like Sum/Percentage
If you want to restrict the Top 26 in the query itself, you might have
to create an object in the universe. May have to use the analytical
functions based on which you need to Rank the Data.
21
for ex: use the Designer function : RANK() OVER (PARTITION BY ()
ORDER BY ())
what is the local filter and global filter in bo's? Local Filter
>>Specific to a block (Table/cross tab/ chart etc..)
Global Filter >> Specific to a TAB in a report
If a report has multiple Tabs, each can have its own Local and
Global filters.
What is pragma? A PRAGMA statement appears in a PL/SQL block.
It is not an executable statement, but it provides instructions to the
compiler.
How will you know the version of Bo using designer?
1. Select the component business object Designer
2. Now it will prompt for userid/password/security domain
3. You will find a Help button, click that and find out what ever
you want
could any one expain me how to create cascading prompts?
if you have source system > source location field. double
click source system > edit properties menu will display, click
properties tab and click edit you will get query pane there you pull
down source location object in conditon pane and click inlist and
click type new prompt type there "XXXXX" and save that.
now you click display button first source system lov will display and
you select any one, based on that selection the source location lov
will display. this is cascading prompt
what is slicing and dicing in business objects? Slice & Dice is
facility in BO. we can enables change the positions of data in
Report..here in Bo we slice & dice panel by using this we can create
cross tables and masterdetails tables. Slice and Dice is used for
extensive data analysis.
What's the Functional & Architectural Differences between
Business Objects & Web Intelligence Functional Differences :
1.BusinessObjects client needs to be installed on every PC from
where you want to build / access reports. WebI needs just a browser
& URL(of the server from where it will access BO). 2.BOMAIN.Key file
needs to be copied on every individual PC that uses BO client. WebI
doesn't need it. 3.You need to stick to those PCs which have BO
client installed, WebI can let you access even when you are roaming
anywhere in the world(provided the access conditions i.e.
internet/VPN enabled WebI web server)
22
Architectural Differences : 1.BO Client : client machine calls
BOMAIN.key on it's local drive, that sends info to BO Server's
BOMAIN.key, validates it, then checks it into Repository, after
repository validation user can access the BO services. 2.WebI : user
logs into WebI using InfoView from web-browser, it talks to the WebI
Web server, web server's BOMAIN.key checks the privilages of that
user, send info to BO server's BOMAIN.key, that validates the info &
forwards to Repository, if it validates the info, gives access to the
universe & underlying dabase.
How to Implement the the Built-in Strategy Script in BO
Designer? using quick design wizard for developing the universe
will invoke the built-in strategy
universe is provided with default strategy also known as built in
strategy.
if you want to create new strategy, edit the .SBO file and mention
your strategy ,and this strategy is called external strategy.
What's is the Guidelines to Build Universe with Better
Performance? R Performance tuning Issue To enhance the
performance of the universe, we have to do the following:
1) Keep universe light,
2) Deselect multiple SQL statements for each measure options,
3) Try to avoid outer joins,
4) Use off-line mode if possible,
5) Remove unnecessary list of values
6) Use aggregations if possible and
7) Take off all variables and objects.
Can anybody please tell me the test methodology for testing
BO Universes?
("Tools-->Check Integrity" option is fine, I am looking for indepth
solution.) Testing a universe based on user requirements is
possible.
1. Make sure that the universe is pointing to the correct repository
2. Universe is locked/unlocked depending on the requirement. If it is
locked noone else can modify and if more than one person is
working on the universe,there is no point in locking as the second
person's effort can go waste.
3.Make sure that there are no loops and whether all the cardinalities
are set.
4.Contexts are defined properly w.r.t the requirement
5. Please generate a test report by dragging objects from different
classes. You can identify if there is any incompatibility/cartesian
products coming up.
what is the difference in creating filters in Designer and
Business Objects? say we have a generalised condition which
23
needs to be applicable to say 10 reports,so we need not write the
same conditions 10 times just define it in the designer part and then
export the particular universe when you come to the reporter u can
see the same condition here and u can use it to any number of
reports.
In addition to this,when we use the filter in Universe ,it filters the
data when the query run against the database. This will increase
the performance. when we use the filter condition in report ,it query
the data from the database and filetr the data in the report
level.This decrease the performance.
How to create Context? I b'live that you know that Contexts are
used to avoid Loops in Universe Design. To create context :
goto Tools --> Detect Loops, BO will detect loops if there are any &
will suggest the context candidate (something like Sales, Costs that
is related to that specific subject area)
Select the suggested candidate & click on create Context. It will
map all those joins that are required for say Sales subject area & put
it in Sales Context. same with Costs.
So it will avoid the confilcts in path by using Contexts.
This Auto Detection works in most of the times....but not always.
How to create Generic TIME CLASS, which includes Objects
Year,Month and Qtr?Database in use is Oracle. If your
database consist all dates something like 01/02/2000 or 01-Feb-
2000, you will need to break the date field into year, qtr,month & if
required date. to do this, create a class named TIME, under that
create new object, in it's select box use oracle's date functions to
get required information.
For E.g. : to_char(sales_date, 'YYYY') for getting only year from the
date.
similarly, for quarter you can use to_char(sales_date, 'Q')
& for month to_char(sales_date, 'MM') for month number, instead of
'MM' if you use 'MON' it will return you abrevations like Jan for
January & so on. for full name of month use 'MONTH'
How to create Universe using Flat file in BO6.0 if you are using
only 1 flat file, you can create a ODBC connection & in File DNS
define ODBC Text Connection. this connection can be used for an
universe to be created using flat file. creating a universe for just a
single flat file, as per my knowledge & experience, doesn't make
24
sense. because you will need different dimensions, fact tables &
creation of which from single file is very tedious job. Apart from that
Analytical reports are used for aggregated OLAP data that is huge in
amount & 1 text or cvs file containing this data sounds practically
imposible.
if you want to use that file for reports, you can simply call it in BO
Reporter when you are defining Data Provider & use it's data.
what are templates in which way it is help full?what is data
provider?what is freehand sql?di
Templates : They are predefined format of the report which you can
re-use to create multiple reports with the same design look and feel.
The way to create a Template is the create a normal BO report,
format it the way you want it with the colour, font size, font colour,
border thickness and all. Now save this report with a .ret extension.
Next time when you choose to create a report from the template
you will see your template in the list as well...you can just use it and
fill in the data and you can have multiple reports with the same
look.
DataProviders, are the source of data from which the report is being
created. It can either be a Univers, a Free Hand SQL, Exel file, txt
documents etc.
Free Hand SQL is a type of dataprovider which can be accessed
form the Personal Files option on the Specify Data Access Window in
the report generation wizard. Using Free Hand SQL you can use you
oqn SQL Script to generate a report. Free Hand SQL connect directly
to the database and can fetch data from the DB to generate the
reports.
What are the security level used in BO?
The given explanations are not exactly the one to answer the
question. Those are only security types or ways. In BO, the security
levels are applied to row level and column level. Both have been
handled by the administrator in supervisor tool or in designer tool.
These two levels of securities are used to restrict the data at row
level or column level in case of a particular user or user group.
Please explore Business Objects forum to get more information
about row level security and column level security.
Users of this forum, please make sure about your answers before
publishing them. Otherwise, please keep quiet.
25
We have securities in business objects
Like
1. Windows authentication
2. RDBMS securities
3. BO admin’ ie Repository username / password
4. Supervisor level securities,
Windows authentication: This means securities provided by the
operating system
RDBMS: Data base level security (like scoot/tiger)
BO admin’: Repository user name /password
Supervisor level: Supervisor can give access level to each
user and user group
What are steps we have to follow in designing the
userfriendly Universe?
What are Universe requirements?
How do you schedule the report for different regions?
what is block? types of blocks?what is locking systm in
universe?what is shortcut join where it is necessary
block is a generic term to desribe table. Types of blocks:
Table, financial table,cross tab. Locking universe allow one
designer at a time to modify the universe
How to create groups in business objects designer?
How to do NORMSINV function on business objects XI rease
2?
What is method overriding?
What is the difference between Cube, Schema, and Universe
?
1. What is a universe?2. Analysis in business objects?3.
Who launches the supervisor product in BO for the first
time?4. How can you check the universe?5. What are
universe parameters?6. Types of universes in business
objects?7. What is security domain in BO?8. Where will
you find the address of repository in BO?9. What is
broad cast agent?10. In BO 4.1 version what is the
alternative name for broadcast agent?11. What
26
services the broadcast agent offers on the server side?
12. How can you access
1. universe is the symantic layer that isolates the end use from the
complex structure of database
2.There are two types of analysis . i. slice and dice ii. drill
3.General Supervisor launches supervisor product
4.we can check unverse in 2 ways
a. visual inspection of joins,cardenalities,detecting loops and traps
and solving them by defining aliases and contexts
b. referential integrity check
5.Universe parameters are used to define universe.
name of universe,description and rdbms connection
6. simple universe and complex universe
7. security domain is bomain.key that allocates each user with a
name and password.
8. bomain.key
9. brodcasting agent are used to refresh or publish the document at
a regular interval of time broadly speaking BCA is used to schedule
the document.
14. alerters are used to draw attention to a block of data either by
highlighting or displaying some message near to the cells
18. yes, we can take the report in exel sheet
What is the difference between Cube, Schema, and Universe
?
Cube : Local structure to hold the data returned by a query
schema: graphical representation of database
universe: symantic layer that isolates end user from the
comlex structure of databse
hi all can u tell me the differnec between BO 6.5 and B.OXI
-R2
27
In what situation we have to use alias& and in what
situation we to use contexts?
HiAlias can be used when there is less complexity in loops and few
fact tables where as Context can be used to resolve loops when
more fact tables are present in the universe design.
How to create metrics in the Desinger. I want to use it in the
Dashboards/Performance Management.I saw in the
dashboard manager to crate metrics we have SET,
Measures, Attributes....where do the SET/Subset defined????
1. At PM home page, Create calender to associate with the
measures.
2. Select Dimensions.
3. Create Metrix, using Dimensions and Measures associated
with the calenders.
Remember After Metrix creation, Refresh it. If It is refreshing
then your Metrix is correct.
Reason for incorrect Metrix, inconsistency between Data type
at database level and selected format at PM level.
Hai..... i hvae linked 2 data provider..and generate the
report ..in that report how can i find the which data is
comming from which data provider...?
You can using View Data from Data from the menu and you can
link them by using Primary Key from the 2 Data Provider .
What is the difference between BO and Web intelligence
Infoview is a portal to access the Business Objects in Web
intelligence.
Business Objects web
intelligence
1.Multiple data providers not
possible
2.data access via(stored procedures,free hand SQL, not
possible
personal data files
3.we can use report templates not
possible
28
4.we can create more than one report in single
document not
possible
5.multiple views of the same data ina single report
(like chart,cross tab,tabular etc.,) not
possible
6. we can create variables in document level
not possible
7.we can access other OLAP servers not
possible
8.we can send Business objects reports via email not
possible
9.ranking is possible
not possible
10.ability to buid two or more query by using set operators
not possible
What is Infoview in BO?What are the differences between
BO 6.5 and BO XIR2?
Infoview is a BI portal through which you can access the
WebIntelligence and the 3-tier full client documents along with the
word and excel files.
Difference between 6.5 and BOXIR2 is,
The architecture for both is entirely different
There is no concept like Supervisor Module in XIR2. Instead CMS is
there
You can create WebI reports from Multiple Universes in XIR2
Merging of dimensions is possible in XIR2
Feature of cascading prompts is provided in XIR2
What is the difference between Aggregate Awareness and
Index Awareness? Where are they used and how
What is meant by Kernel Approach and component
approach?
kernel approach one universe contains the core components. These
are the components common in all universes. The derived universes
that you create from this kernel universe contain these core
components as well as their own specific components. Component
29
approachThe component approach involves merging two or more
universes into one universe.
what are TRPA and TRPI reports? How are they created? x
What is the difference between transaction report and
holding report? x
if we have a user group and we want to give the access to
the report from 1990 to 2000. and from that group we want
one user to restrict to see the report from 1990 to 1995.
Then what to do in BO designer, so that this can be possible(
Not in report level).
I am not sure, but can't you try this by providing for row level access
in the Time Dimension.
What is the difference between Input context and Output
context
HiThe input context determines what dimension to go into the
calculations to produce the values. whereas the out put context
determines how the values are combined. It is generated by the cell
location with the report.
how to avoid the cartesian products while generating the
report?
Hi,Open your Universe in Designer, just check "Prevent" optioin in
UNIVERSE PARAMETERS>>SQL tab under CARTESIAN PRODUCTS
How to run universe scripts? x
what is row level security
It is a security implemented by the supervisor for accessing
particular data from the database .
This can be done by
1.login to BO supervisor .
2.Go to universe tab
3.select the user or group
4.select the universe in the universe tab
5. Press ctrl+entr or right click and select properties
6.select the row tab.
7.add the condition
30
for example consider emp table in scott user,if the user or group
want to see data only when the deptno=10
we can specify by
table --> scott.emp
where Clause ---> scott.emp.deptno=10
What are the best practices you need to follow while you are
creating the Universe?
The two best practices are "keep your universe simple", and "Align
your Universe with your business goals".
What are the main issues handled by the designer, while
creating a Universe?
What type of architecture does Businees Objects 6.5 follow?
3-tier architecture
what is the need of creating derived tables in the BO
universe design
Derived tables are mainly created to have some precalculations
done so that they save processing time .
Complex calculations involving huge amounts of data at report level
reduces the performance of the report.
Moreover they can provide real-time data analysis unlike summary
tables using aggregate awareness that are costly to maintain and
needs regular refreshing.
Moreover they can also include prompts.
What do you mean by Drill Across?
31
32
33