Explore topic-wise InterviewSolutions in Current Affairs.

Analysis in BO is Utility in BO with the help of that we can manage our DOCUMENT..

Anlysis in BO with the help we can Slide, Dice and Drill the REPORTS.

Analysis in BO is Utility in BO with the help of that we can manage our document..

Anlysis in BO with the help we can Slide, Dice and Drill the reports.

GENERAL SUPERVISOR

general supervisor

Multipass: Breaking one large SQL into multiple SQLs.If you are using the star schema with TWO or more fact tables,and you enable this FEATURE, BO will automatically generate two or more SQLs (i.e. one SQL for each fact table object used in the report). Then the RESULTS will be synchronised in the report.

Multipass: Breaking one large SQL into multiple SQLs.If you are using the star schema with two or more fact tables,and you enable this feature, BO will automatically generate two or more SQLs (i.e. one SQL for each fact table object used in the report). Then the results will be synchronised in the report.

A data mining EXTENSION can be used to SLICE the data the source cube in the ORDER as DISCOVERED by data mining. When a cube is mined the case table is a DIMENSION.

A data mining extension can be used to slice the data the source cube in the order as discovered by data mining. When a cube is mined the case table is a dimension.

Data warehousing is merely extracting data from different sources, cleaning the data and storing it in the warehouse. Where as data mining aims to examine or explore the data using queries. These queries can be FIRED on the data warehouse. Explore the data in data mining helps in reporting, planning strategies, finding meaningful PATTERNS etc.

E.g. a data warehouse of a COMPANY stores all the relevant information of projects and employees. Using Data mining, one can USE this data to generate different reports like PROFITS generated etc.

Data warehousing is merely extracting data from different sources, cleaning the data and storing it in the warehouse. Where as data mining aims to examine or explore the data using queries. These queries can be fired on the data warehouse. Explore the data in data mining helps in reporting, planning strategies, finding meaningful patterns etc.

E.g. a data warehouse of a company stores all the relevant information of projects and employees. Using Data mining, one can use this data to generate different reports like profits generated etc.

first thing we are under the member(user) of the REPOSITORY.and we need to rights to ACCESS repository. we also need to CREATE perticular user name and pass.

first thing we are under the member(user) of the repository.and we need to rights to access repository. we also need to create perticular user name and pass.

INTEGRITY Check is the OPTION through which ONE can TEST the universse in BO.

Integrity Check is the option through which one can test the universse in BO.

In 5i/6i VERSIONS after installing the SOFTWARE, WHEREAS in Xi VERSION a REPOSITORY is created at the time of installation.

In 5i/6i versions after installing the software, whereas in Xi version a repository is created at the time of installation.

YES.
we have MULTIPLE domains,but security domain is not multiple,only document domain and UNIVERSE domain is multiple.

Yes.
we have multiple domains,but security domain is not multiple,only document domain and universe domain is multiple.

In XI VERSION it can be done by USING row-level SECURITY in DESIGNER module whereas in 5i/6i it is done by SUPERVISOR.

In XI version it can be done by using row-level security in designer module whereas in 5i/6i it is done by supervisor.

In GENERAL it will be ANYTHING between 4-8 TERABYTES.

In general it will be anything between 4-8 Terabytes.

loop is a CLOSED path between end to end.continuous floe of data.creation of alias table is solution to resolve loops

Loop is nothing but a closed circular flow; it can be overcome by MAKING USE of Alias and Context.

A loop is a set of joins that defines a closed path through a set of TABLES in a schema. Loops occur when joins form multiple paths between lookup tables.

Loops can be solved by USING aliases or contexts.

loop is a closed path between end to end.continuous floe of data.creation of alias table is solution to resolve loops.

loop is a closed path between end to end.continuous floe of data.creation of alias table is solution to resolve loops

Loop is nothing but a closed circular flow; it can be overcome by making use of Alias and Context.

A loop is a set of joins that defines a closed path through a set of tables in a schema. Loops occur when joins form multiple paths between lookup tables.

Loops can be solved by using aliases or contexts.

loop is a closed path between end to end.continuous floe of data.creation of alias table is solution to resolve loops.

Its NOTHING but GROUPING of USERS.

Its nothing but grouping of users.

USED to CREATE dashboards. It can be stored in repository, CORPORATE or PERSONAL.

used to create dashboards. It can be stored in repository, corporate or personal.

MEASURE OBJECTS.

measure objects.

METRICS are USED for ANALYSIS and SETS are used for GROUPING.

Metrics are used for analysis and Sets are used for grouping.

Bo SDK main USE is to suppress ?no DATA to fetch? using MACROS.

The BusinessObjects Enterprise SDK allows you to build web applications that interface directly with your BusinessObjects Enterprise system.

BO SBK Means, BO Software Development Kit.

It USED for BO With Java or BO With Dot Net Integration. You can integrate BO in java or .Net application. It provide Java & .Net Api classes & functions.

Bo SDK main use is to suppress ?no data to fetch? using Macros.

The BusinessObjects Enterprise SDK allows you to build web applications that interface directly with your BusinessObjects Enterprise system.

BO SBK Means, BO Software Development Kit.

It Used for BO With Java or BO With Dot Net Integration. You can integrate BO in java or .Net application. It provide Java & .Net Api classes & functions.

By making use of AGGREGATE TABLES.
1)usinf aggregated tables
2)using shortcut joins
3)removing unwanted CLASSES and objects
4)removing unwanted joins
5)lov should be based on smaller look up tables

By making use of Aggregate tables.
1)usinf aggregated tables
2)using shortcut joins
3)removing unwanted classes and objects
4)removing unwanted joins
5)lov should be based on smaller look up tables

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 fact tables) then the loop can be resolved by detecting context
TOOLS-->insert context
then
you can SELECT the path.

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 fact tables) then the loop can be resolved by detecting context
tools-->insert context
then
you can select the path.

We can't FIND traps i.e. CHASM trap and fan trap. It can be identified only by VISUALIZATION.

We can't find traps i.e. chasm trap and fan trap. It can be identified only by visualization.

gobal FILTER ACTS on all FIELDS in the REPORT table.

gobal filter acts on all fields in the report table.

THE MOST COMMON PROBLEM IS JOIN PATH PROBLEM
i.e,
LOOPS
CHASAM TRAPS
FAN TRAPS.

THE MOST COMMON PROBLEM IS JOIN PATH PROBLEM
i.e,
LOOPS
CHASAM TRAPS
FAN TRAPS.

you can CREATE different UNIVERSE for different SOURCES and LINK them in BO.

you can create different universe for different sources and link them in BO.

a) To check the universe weather it is correct or in correct, MEANS that any isolated joins, DIVERGENCE, loops, contexts, wrong joins, parsing happened in the universe.

b) An integrity check detects:
1. Invalid SYNTAX
2. Loops
3. Isolated tables
4. Isolated joins
5. Loops with in contexts
6. MISSING and Invalid cardinalities.

a) To check the universe weather it is correct or in correct, means that any isolated joins, divergence, loops, contexts, wrong joins, parsing happened in the universe.

b) An integrity check detects:
1. Invalid syntax
2. Loops
3. Isolated tables
4. Isolated joins
5. Loops with in contexts
6. Missing and Invalid cardinalities.

a) Bo is a reporting tool to Query the DATABASE or DATA warehouse.
b) Bo is a query, reporting and analysis tool.
c) Bo is an OLAP tool. (ROLAP)

a) Bo is a reporting tool to Query the database or data warehouse.
b) Bo is a query, reporting and analysis tool.
c) Bo is an OLAP tool. (ROLAP)

Isolated JOINS, CROSS join, NON equi join.

Isolated joins, cross join, non equi join.

From the designer u can spot the already mentioned HIERARCHY and also u can change or edit the same.
Go to Tool->Hierarchies
Here u can ether ADD a NEW one or can also edit the existing one.

From the designer u can spot the already mentioned hierarchy and also u can change or edit the same.
Go to Tool->Hierarchies
Here u can ether add a new one or can also edit the existing one.

The measure of specifying USER can RETRIEVE which rows of data based on a COLUMN of data or combination of COLUMNS is called row LEVEL security.

The measure of specifying user can retrieve which rows of data based on a column of data or combination of columns is called row level security.

YES, it is possible to use different UNIVERSE to generate a single report....MULTIPLE DATA providers.

Yes, it is possible to use different universe to generate a single report....multiple data providers.

A query is one or more statements that request DATA from a DATABASE. If the data is available, then the requested data returns in the form of a table which contains rows and columns. QUERIES are sent to the databases in a language CALLED SQL. However, when using the Report Panel, SQL knowledge is not REQUIRED.

A query is one or more statements that request data from a database. If the data is available, then the requested data returns in the form of a table which contains rows and columns. Queries are sent to the databases in a language called SQL. However, when using the Report Panel, SQL knowledge is not required.

Ad hoc reporting is a user friendly FEATURE designed for all LEVELS of users. Custom REPORTS are created using queries.

Ad hoc meant for management users.

Example BO is ad hoc reporting tool used to make quick decisions.
Example: if you have a one shopping MALL u want find out the stock status. For clearance of the stock u need to take a decision what type of decision u need to take for clearance of stock.

Ad hoc reporting is a user friendly feature designed for all levels of users. Custom reports are created using queries.

Ad hoc meant for management users.

Example BO is ad hoc reporting tool used to make quick decisions.
Example: if you have a one shopping mall u want find out the stock status. For clearance of the stock u need to take a decision what type of decision u need to take for clearance of stock.

BUY a CAR is context & rent a car is alias
Because, buy a car is a fact & rent a car is a LOOK up, alias is created on look up tables.

Buy a car is context & rent a car is alias
Because, buy a car is a fact & rent a car is a look up, alias is created on look up tables.

Provide FAST and effective way of MONITORING key measures.
SCORECARD is a concept used for measuring a company's activities in terms of its vision and strategies, to GIVE managers a comprehensive view of the performance of the business.

Provide fast and effective way of monitoring key measures.
Scorecard is a concept used for measuring a company's activities in terms of its vision and strategies, to give managers a comprehensive view of the performance of the business.

Master data occur in the OLTP system and that can't change regularly, when the changes are OCCURRED in the OLTP system, that changes can be handled by the dimension tables. Such type of DIMENSIONS is called slowly changing dimensions.
There are three TYPES of dimensions
TYPE1 (MAINTAIN only current data)
TYPE2 (Maintain complete historic data)
TYPE3 (Maintain one time historic data)

Master data occur in the OLTP system and that can't change regularly, when the changes are occurred in the OLTP system, that changes can be handled by the dimension tables. Such type of dimensions is called slowly changing dimensions.
There are three types of dimensions
TYPE1 (Maintain only current data)
TYPE2 (Maintain complete historic data)
TYPE3 (Maintain one time historic data)

1) Shared: Available to multiple USERS
2) Personal: Belongs to user, who created it, OTHERS cannot use it.
3) Secured: These are centralized and any ONE can use it and used to deploy BUSINESS OBJECTS reports.

1) Shared: Available to multiple users
2) Personal: Belongs to user, who created it, others cannot use it.
3) Secured: These are centralized and any one can use it and used to deploy business objects reports.

Universes are two TYPES
1) Simple UNIVERSE and
2) Complex Universe
b) Derived Universe, LINKED Universe and Core Universe are the Types of Universe.
Simple and complex (linked universe)

Universes are two types
1) Simple Universe and
2) Complex Universe
b) Derived Universe, Linked Universe and Core Universe are the Types of Universe.
Simple and complex (linked universe)

a) Shortcut join: it is direct join between source and destination
Example: country-->region-> city
We can connect country and city using shortcut join
Theta join: NON equality condition between two TABLES.

B) Short cut Join providing an alternative path between two tables. passing INTERMEDIATE tables, leading to the same result, regardless of direction. Optimizes query time by cutting long join paths as short as possible.
Theta join Link tables BASED on a relationship other than equality between two columns.

a) Shortcut join: it is direct join between source and destination
Example: country-->region-> city
We can connect country and city using shortcut join
Theta join: non equality condition between two tables.

b) Short cut Join providing an alternative path between two tables. passing intermediate tables, leading to the same result, regardless of direction. Optimizes query time by cutting long join paths as short as possible.
Theta join Link tables based on a relationship other than equality between two columns.

Through WEB INTELLIGENCE and through BROWSER.

Through web intelligence and through browser.

We can hide a table in WEBI when the table is empty.
From the properties tab, DESELECT 'Show when empty' CHECK BOX.

We can hide a table in webI when the table is empty.
From the properties tab, deselect 'Show when empty' check box.

Ad-hoc reports means with in the ORGANIZATION user can create reports by directly INTERACT with IT peoples. That is TIME depended reports not detailed reports.

Ad-hoc reports means with in the organization user can create reports by directly interact with IT peoples. That is time depended reports not detailed reports.

YES we can create REPORTS without creating UNIVERSE.

Yes we can create reports without creating Universe.

A local filter is applicable only to a PARTICULAR BLOCK i.e. the block on which it is CREATED like on a particular table or cross TAB.

A local filter is applicable only to a particular block i.e. the block on which it is created like on a particular table or cross tab.

Only ONE.

Only one.

Mainly the tracing concept is coming in designer level. Tracing means if you have 2 tables, if you select one table column DRAG the cursor to the NEXT table column, at that time cursor will turns into PENCIL SYMBOL.

Mainly the tracing concept is coming in designer level. Tracing means if you have 2 tables, if you select one table column drag the cursor to the next table column, at that time cursor will turns into pencil symbol.

In STATIC filter, record set is filtered based on a table FIELD value.
In DYNAMIC filter, record set is filtered based on the value SPECIFIED for a specific business object property.

In Static filter, record set is filtered based on a table field value.
In Dynamic filter, record set is filtered based on the value specified for a specific business object property.

No

No

a) By giving filters and conditions in the report LEVEL.
b) OVERFLOW occurs when a calculation returns a value that is too large for Web Intelligence to handle.
c) Select the properties at the report level and choose appearance from the tab. You can adjust the tables horizontally and vertically.
d) When you have huge number of rows in report then u will GET partial RESULTS in that report.
For that you have to increase the (LIMIT Size of the Results) check box button in Universe Parameters. Then your report will not overflows.

a) By giving filters and conditions in the report level.
b) OVERFLOW occurs when a calculation returns a value that is too large for Web Intelligence to handle.
c) Select the properties at the report level and choose appearance from the tab. You can adjust the tables horizontally and vertically.
d) When you have huge number of rows in report then u will get partial results in that report.
For that you have to increase the (Limit Size of the Results) check box button in Universe Parameters. Then your report will not overflows.

In Deski: all the data for all objects will be RETRIEVED from the database and that is STORED in MICRO cube. Whenever you want to drill down for next level dimension, it doesn‟t need to connect to the database.

In Webi: all VALUES for all objects that are dragged into the query panel will be retrieved. Hierarchical objects values won‟t be retrieved like deski. When ever you drill down the report, to DISPLAY the values this report is to meet database again and retrieves the data.

In Deski: all the data for all objects will be retrieved from the database and that is stored in micro cube. Whenever you want to drill down for next level dimension, it doesn‟t need to connect to the database.

In Webi: all values for all objects that are dragged into the query panel will be retrieved. Hierarchical objects values won‟t be retrieved like deski. When ever you drill down the report, to display the values this report is to meet database again and retrieves the data.

By DEFAULT, you can do only up to 3 LEVELS. But with CUSTOM, you can do more than 3 levels.

By default, you can do only up to 3 levels. But with custom, you can do more than 3 levels.

a) Surrogate Key is a primary key in data warehousing, the only difference between surrogate key and primary key is that surrogate key allows duplicate values and primary key doesn‟t.
b) Surrogate key is the dummy key which is used to allow the duplicate values.
C) Surrogate key is contiguous numbers generated by DB in a table which acts as a primary key since surrogate key has unique values.
d). It is used for duplicate values in a DATABASE. Primary keys cannot be changed when a unique error occurs. With the help of this surrogate key a new column values will be created and that will be as primary keys.
e) Surrogate key is unique key which is used in TYPE 2 dimension.

a) Surrogate Key is a primary key in data warehousing, the only difference between surrogate key and primary key is that surrogate key allows duplicate values and primary key doesn‟t.
b) Surrogate key is the dummy key which is used to allow the duplicate values.
c) Surrogate key is contiguous numbers generated by DB in a table which acts as a primary key since surrogate key has unique values.
d). It is used for duplicate values in a database. Primary keys cannot be changed when a unique error occurs. With the help of this surrogate key a new column values will be created and that will be as primary keys.
e) Surrogate key is unique key which is used in type 2 dimension.