SAP BusinessObjects

boquestions & Answers
1. WHAT IS THE DIFFERENCE BETWEEN THIN CLIENT & THICK CLIENT?
Thin Client is a browser based version, whereas thick client is a desktop based version. In
thick client, you have lot of functions and formatting options.
Desktop Intelligence is full client. It is 2 tier architecture, where Web-I is 3 tier
with Enterprise server in between.
Desktop-I and Web-I differs in some syntaxes.
E.g: [] in Web-I, <> in Deski.
Also scheduling can be done directly in Web-I (Xi R2), where as we need additional
software to schedule Deski reports.
You can view the Deski reports in Web-I, but not Web-I reports in Deski.
But we can schedule the Deski reports via Web-I.
WebI: it is 3tier architecture. and also known as thin Client.
In boxir2 wise merge option available, edit sql also.
Scheduling directly, Reports will generate not only corporate doc's, others also(excel,
PDF--),hide option is not available,
Deski: it is 2 tier architecture & also known as full client. Here hide option, edit Sql,
rank options are available. Desktop intelligence reports are dynamic. desktop
intellegence is window base tool and need installation on every PC where as
WebI is web base tool and can be access any where through
internet explorer
Crystal reports are static and page wise.
Infoview: WebI is a part of infoview. it generates java based reports, While open the
reports through infoview.
2. IN BOXIR2 WE HAVE FOLLOWING TOOLS.
Import Wizard
Report Conversion Tool
Repository Migration Wizard
3. MULTI PASS SQL:
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 synchronized in the report.
4. WHAT IS ISOLATED JOINS IN CHECK INTEGRITY
Isolated join is the join which is not included in any of your contexts, so you are getting
that error.
Solution :
First of all find what are all the joins you left with out including in any of your contexts
and join them to any of the context which you think appropriate.
5. MIGRATION PROCESS:
To migrate the Bo 6.5 to XIR2:--
a) Open the migration wizard
b) Select Ur source location (Here give Ur BO 6.5 doc)
c) Click next
d) Select Ur destination location (Ur BoXIR2 environment)
e) Select the users or admin or specific users
f) Click next
f) Click ok.
6. Difference b/w Break & section?
Break removes duplicates but the same thing cannot be done by section.
Break displays data within the same cell content and Sectioning appears outside the grid.
When you do any arithmetic operation on break say sum or count, you can see the sum
for individual block and for all the blocks in bottom.
In Section it performs operation only on individual block.
7. What is master-detail report?
Master-Detail report allows us to display the result in Section wise. It splits large blocks
of data into sections. It minimizes the repeating values. We can have subtotals also.
It displays the data section wise. If you have the following in a report, for e.g. Country,
Store, Sales, you can change it into a master detail report country wise by dragging and
dropping Country as a section when the cursor shows the text 'Drop here to create a
section' you can seethe data country wise.
8. How big is Ur Team?
in my environment their are 1500 Business End Users and 4 report Developers and Two
Universe Designer and one Administrator.
9. Is it possible to creating reports without universe?
it is possible to creating reports without universe. By Using personal data files & free
hand sql
By Using personal data files & free hand sql. This is possible only in deski reports not in
WebI.
11. How to solve #multivalue, #syntax, #error. I want complete solution
process in practical wise?
#Multivalue: - this error will occur in 3ways
1) #multivalue in aggregation
2) #multivalue in breaks header or footer
3) #multivalue in section level.
1:-- the o/p context not include i/p context its situation this error occurs.
Ex: in a report i have year, city dia's & Revenue measure is there.
=<revenue> In <year>
The above condition will to run the query getting revenue column #multi value error
occurs.
solution: click the formula bar in view menu
Select the error contain cell, edit the formula to write below condition.
= <revenue> In(<city>,<year>) In <year>
The above formula will run correct data will appear in the report.
Note: the above condition by default it will take agg "sum" function.
#syntax:--
the variable in the formula no longer exist in the condition.
Ex:- <product price> * <quantity sold>
The above condition will run this error will occur.
Solution:- Click edit dataprovider--> new object will be need --> select error cell -->
edit formula --> click ok.
#error:--
the variable in the formula is incorrect. This error will occur.
solution :
go for data menu --> click variable
select the error containing a cell --> copy the formula in edit menu
--> paste it in new cell --> go for formula bar in view menu --> take the first error
containg cell -->edit the formula --> repeat the above steps.
12. What is the difference B/W Variable & Formula?
Whenever we execute the formula , the result will be stored in the variable.
13. what is meant by incompatible object error in the report level?
When the contexts are not properly defined we will get the error as incompatible
combination of objects.
14. In a report i want to fetch the data from 2 data Providers. Which
condition will satisfy to link the 2 data providers.
ex: Q1 have columns A,B,C Q2 has X,Y,Z columns. Requirement is like i
want to get all the columns from those 2 tables in report level. like
A,B,C,X,Y,Z in a single report.
in BOxir2 wise it is possible. Would u have base uni & dervied uni's. i think ur
requirement is solve by using "combining query" option & just select "union" operator
wise ur query is solve.
Another wise u go for WebI, select "MERGE" option it is possible.
otherwise, ur requirement is not possible. Because ur columns names are not matching.
u go for deski, select "data manager" --> click "link to" Option it is possible.
15. What is meant by FOR EACH, FOR ALL function? In which case we use
the option in BO?
for each-add all objects to the context
for all-delete all objects from the context
we use Forall for summary purpose and Foreach for detail purpose
16. How we improve the performance of report and universe?
By creating the summary tables and using aggregate awareness.
17. In xir2 how to send reports to end user
You can send reports to any user via the scheduling options for a report. The report will
then run as per the scheduled options and when successful, it will send a copy to the
user's email address or inbox (in BO), depending on the options selected.
18.which is the best way to resolve loops? Context or Alias?
in a schema we have only one look loop u can create Alias. But, when we have multiple
look up u can create contexts.
most of the cases are using context can be use to resolve the loops. why because more
number of complexity loops and also schema contains 2 or more fact tables in ur
universe design.
If there are more than one fact table use a context or if only one fact table use alias.
19. How do we link 2 universes?
The linking can be done at reporter level by linking of data providers. We can link the
dimensions and measures of two different universes with 2 different connections by
linking the data providers built upon them.
20. What r the types of joins universe supports?
Inner Join, outerjoin, left, right outer join, full outer Join.
21. What r the universe connection types?
Shared connection
Secured connection
Personal connection - used only stand alone system.
22. what r the advantages of creating the universe?
The main fact behind creating universes is "Business users need not have strong SQL
back ground. But sometimes they need to develop reports". In such case the importance
of universe comes. The universe designer needs to have a strong SQL back ground and
he/she will create universe which in turn has objects like dimensions, measures, etc,...
The business user then uses these objects just by dragging and dropping in the query
editor pane. Dragging, dropping and running is more easy for him rather than writing
SQL by his own.
23. How do u drag 2 sources from 2 diff data providers, how we take these 2
sources into 1 single report?
By using data synchronization Option.... synchronization is the term used to describe the
merging of data from multiple data sources into a single block in a report
24. what is merged dimension in 6.5 and webi?
in xi r2 they introduced Merged dimension concept to synchronize the multiple data
providers in webi by merging them on common dimension...
25. Aggregate Awareness?
Aggregate awareness is a term that describes the ability of a universe to make use of
aggregate tables in a database. These are tables that contain pre-calculated data. You can
use a function called @Aggregate Aware in the Select statement for an object that directs
a query to be run against aggregate tables rather than a table containing non aggregated
data. Using aggregate table’s speeds up the execution of queries, improving the
performance of SQL transactions. The reliability and usefulness of aggregate awareness
in a universe depends on the accuracy of the aggregate tables. They must be refreshed at
the same time as all fact tables. A universe that has one or more objects with alternative
definitions based on aggregate tables is said to be “aggregate aware”. These definitions
correspond to levels of aggregation. For example, an object called Profit can be
aggregated by month, by quarter, or by year. These objects are called aggregate objects.
Queries built from a universe using aggregate objects return information aggregated to
the appropriate level at optimal speed.
26. What is BO Main Key?
BO Main key will store the address for repository of the security domain. General path
for BOMainKey C:\Program Files\Business Objects\BusinessObjects Enterprise
6\LocData
27. How to Link 3 fact tables?
Fact tables are tables with lots of measure values and are uniquly identified by a key, also
a fact table can have a foreign key.
For Example custumer fact table is connected to loan fact table via customer_id,
and each record in loan fact table is uniquely identified by a primary key on
cod_acct_no. Similarly customer table can be connected to Savings fact table through
customer id.
28. What is hierarchy & Drilling?
Heirarchies will be used in drill reports.
We will select Drilling levels in Query panel.
There are 4 types of levels are there.
1.level
2.level
3.level3
4.custom level
drill down --->navigation of levels,like one by one
drill through--->selecting new level of heirarchy at the time drilling
drill by--->directly selecting required drilling level
so,from your point a-b-c is drill down
a-->c is drill by
29. How to Hide rows & columns in a report ?
hide the colomn ---
menu>formate>table formate>pivote>hide button,
Rows can be hide only when the break is applied on a particular column using...
Format-->Breaks-->Fold
30. What do u mean by Merged dimensions in B.O.?
merged dimension is nothing but to synchronize the data from different data sources
with a common dimension.
Web Intelligence allows you to synchronize multiple data providers in the same
document. This allows you to build reports which synchronize data from multiple
sources. When you synchronize queries through merging, you can include report objects
from different queries in the same report block.
31. What we have to do to increase performance tuning & to decrease the
response time of a report.
if we run a report it is taking so much time to display the result to be fallowed as :
1) Use aggregate tables(contains pre calculated data)
2) Pre defined conditions, LOV's
3) Summary tables.
in a real time scenario query contains a large if statements. Some times we need to wait
max of 30 min to run particular statement...not all
If the question is not pertaining to query optimization, I would prefer not to use much of
formatting on the page. One can keep the report without formatting. Try not to use the
slice & dice panel as this would also take considerably long time.
32. What is Full path Client?
Full path client is nothing but an info-view.
33. How to sort on a particular object, that object is not picked up while
creating the cross tab but we need to sort on the object that is not in the
cross tab????
Go to Format--Sorts then click on Add. We will get all the objects select the object and
apply it which is not in the Cross tab report.
34. How can we retrieve particular number of rows from data ware house?
For EX: my report wants to display with 10 records in a report? How?
We can do this in 2 levels in BO.
1. In Universe parameters, set the no of records for your requirements.
But I will apply to all reports.
2. We can do this to a particular report in the query panel.
Select OPTION button (Left side down placed) and set the no of records how many you
want.
35. What is custom sorting?
Custom sorting is nothing but sorting as per our requirement suppose months like
jan
feb
mar
apr
may
jun
jul
We can display first jan next mar next jun for these purpose we can use custom sort
36. How do we apply sql query on selected variables?
If u drag the variable, automatically sql query will be added.
Or if u select new variable, one window will appear. In this window u select the
qualification (dimensional or detail or measure) in definition window. Go for formula
tab, window will appear here write a formula by using objects & operators.
if u have any errors or not plz check once parse condition.
Click apply > click ok.
37. what are the differences between web intelligence reports and crystal
reports ?
bo reporting is prefered for dwh,where as crystal is preffered for transaction database
which involves lots of queries and joins.
webI : it is ad-hock reporting.
we can change the report as per reqirement for managenment quick dessions.
for management
Crystal Reports:
it is standered reporting
daily transactions(example bank ,shopping malls)
for production users.
38. What is Fan Trap & Chasm Trap?
1) FANTRAP PROBLEM solved by ALIAS METHOD:
Definition: Two One-to-many table link each other is in turn linked another one-to-many
table.
2) CHASM TRAP PROBLEM solved by CONTEXT METHOD:
Definition: Two Many-to-one table converges on one single lookup table.
Loop can be detected while INTEGRITY CHECK is done. An option is there as "Check for
LOOPS" available. By "Detect Loop" we can choose what to be applied for solving the
loop.
39.How do u migrate from 6.5 to XI ?
migration is done with the help of import wizard in xir2.
other wise u can manually migrate universe or report. when u try to open a 6.5 or 5x
version report or universe they will automatically updated to xi and they cannot open
again in the previous version once they converted to xi. that is why it is better to take a
back up before migration.
40. What is metrics?
A metric is the measure of actual performance. A metric is defined using objects in the
universe. These are used to track trends and productivity
41. What is Dashboards?
Dashboards is nothing but collection of information
42. IN BOXIR2 creating universe by using Designer and Business View.
What is the difference b/t two?
Business view is used to create a lovs in crystal reports. This can be schedule to refresh to
daily. business view can be used by only in crystal reports
a universe can also be a source for crystal reports as well as web intelligence.
in business view we can connect to multiple database and create a business view, it is not
there in universe
43. Why do we use crystal reports rather than web intelligence reports?
Crystal reports: we use most of the times daily basis. we have to know the day to day
status. Example daily transaction of the persons in a bank. End of the day whole sales
reports of the same branch. It is for production .it is a predefined template
Web I: it is only for manage ment users.
they want to take own decessions for their own like take a sales mall giving offers
like end of
season sale and clearence sales occational offers.
Webi report- it is ad-hoc report, we can modified as per request and analysis the reports.
but in Crystal reports--> we cant not modify the reports and it contains daily bases i.e.,
day to day
infromation .example: shopping mall and customer details in bank.
44. What is chasm trap & Fan Trap?
Fantrap means one-to-many joins of the tables it is detected by visval analysis. By using
fantrap problem is many rows than expected. Through aliases,context and check mutiple
sql statements for each measures option we can solve this problem.
chasm trap means two or more many to one joins converge on to a single lookup table
Chasam Trap:
chasm trap means many-to-one and one-to-many join relation converge on to a single
lookup table, because of this we get incorrect results i.e., cartision product, We will
resolved by using some times alias, some times context, some times shortcut join and
check mutiple context for each measures option.
Fan Trap:
Fantrap means one-to-many and one-to-many join relation of the tables it is detected by
visval analysis, because of this we get incorrect results i.e., cartision product, We will
resolved by using some times alias, some times shortcut join and check mutiple sql
statements for each measures option.
45. How many universe did you create if you have 2 years of experience in
BO ?
1. Two Universe
2. Depends on my data base and my project. example. In my project if i have 100 tables i
will create 6 universes.
any way u have a two years of exp in bO .u don’t have chance to create universe. we need
min 5 to 6 + exp and good domain knowledge
46. Iam having an report there four cloums and n number of rows if i click
ang one cell the report want to go to another report page which gives the
detail of the cell which i click pls help me with example
This is hyperlinking.The cell can be defined as a hyperlink and parameters can be passed
to the destination report to open.
47. Iam having an report it contain n number of rows i want to desplay each
rows in one colur
Insert a vertical table on the existing table or click drag drop the rows into columns.
BY USING ALETER we can display each row in different colour.
48. What are the Errors in BO Pls Explain with Examples
#Multi value: When any variable yield more than on result
#Syntax: Occurs when we remove any object from report that is used in the formula of
any variable.
#Error: Generic Error
#Incompatible, Context Error: Generally occurred when we context is not properly
defined for calculation and when we try to place two incompatible objects in one table.
#Div: Divide by Zero
49. How to Shedule the reports in Xi R2
You could see the option of scheduling in infoview, right below your report...
otherwise u cud schedule it from Central management Console
50. Explain about the different between 6.5 & Xi R2
B.O 6.5:-- > 3tier architecture
> Rep created after the installation
> In Webi wise :--
> There is no alerters & There is no merge option
> In 6.5 Contains 57 tables are there
> In security level wise also some changes are there :
> in supervisor access security services option is there.
>In 6.5 There is no Casading prompt.
> Here separate Supervior & B.C.A
BOXIR2 : Desiner wise—
> directly to restict data in designer level.
> New feautuer is Cascading prompt
Webi wise :
> here alerters & sub alerters also possible
> Merge Option is also possible
> BCA + Supervisor combined in CMC.
>doc domain & uni domains are located in form of folders
> here secured & Saved in folders & categories.
> Sheduled directly in Webi.
Architecture wise lot of difference is there between BO6.5 and BOXI.
1. In BO6.5 we have to copy BO. main key in each system to install s/w.
For BOXI no need of copying BO. main key.
2. In Bo6.5 Supervisor control all the aspects. While in Bo xi Supervisor is replaced by
CMC (Central management console) is take care under CMS (Central Management
Service)
3.6.5 is user centric and XI is object centric
4. BO 6.5 is a 3 tier architecture Universe Domain, Document Domain & Security
Domain. Where as B.O. XI is 5 tier architecture with Client, Application, Intelligence,
Processing and Data tiers.
51. how to restrict null values in webi report?
I believe you can define a formula like below Not IsNull(object). This formula should
bypass all records that has null values..There might be some other ways too..
52. how to do scheduling in desktop intelligence in BO XI R2 ?
To schedule a Report first you to export the report to the Administrator and select the
Folder then select the object and select schedule and you will get the choice to select like
once, ondemand , weekly, monthly so on. if you still confusion then go through the
Administrative Guide.
Once the Report is saved, then click on file, go to Export, and export the export which
you want. Once the report is exported then a small dialog box appears which shows that
Exporting is done successfully, then save ok. Now go to Crystal Enterprise (Infoview) and
open the report which you exported earlier in Desktop Intelligence. Click on that folder
and you can see the Report over there. Then from there we can schedule the report like,
daily, hourly, monthly, qtrly, yearly etc.......
53. what is difference between folders and category ?
folders: folders and subfolders are used to organize documents
categories: categories are a way to classify your information for example, you could place
your financial reports and documents into a folder name finance and you could classify
or tag your reports that deal with specific financial matters as payroll, accounts, payble
and accounts receivable.
54. Tell me about linked universe?
a) Linked universes are universes that share common components such as parameters,
classes, objects and joins. Among linked universes one universe is said to be kernel or
master while the others are the derived universes.
b) If the data provided is from two different data providers then we can link those two
universes. Such universes are called as linked universes.
c) In real time scenario we will work with linked universe. here same data source and diff
data source is not a issue. We can fetch max 15 to 17 tables in single universe. More than
that u will create another universe and link it.
File-->parameters -links
d) Concept of linked universes is based on inheritance. You can specify your common
classes and objects in Parent universe (Kernel) and then link this universe in child
universe (Derived Universe) to make use of these classes and objects. In Derived
universe one can add their own tables, classes and objects.
However linking universe does not link following...
->Parameters
->contexts
->Aggregation
55. How do you share the universe?
By moving it as a file through the file server and exporting it to the repository
56. How do you give security to universe?
We can secure the universe by applying security restrictions through Universe Designer.
We can apply following types of security restrictions on different users:
1. Object Restriction
2. Row Level Restriction.
3. Table Mapping.
4. Connection Restriction
57. What are zero client and thin client?
Zero-client viewers do not require client-side software to be installed or downloaded.
Instead these viewers display the reports as DHTML.
Thin Client Viewers require components to be downloaded and installed on the client’s
computers. These client viewers offers better report fidelity but can require more
administrative overhead
58. What is a Variable?
a) Variables are used to prevent the same computation being performed several times as
the variable allows you to store the values so that they can be used later.
b) A variable represents specific data or a value, and acts as a placeholder for that value.
Unlike a constant value, which is fixed and unchanging, a variable can be repeatedly
assigned different values. You assign a value to a variable and the variable maintains the
value until you later assign a new value. Because of this flexibility, it is necessary for you
to declare variables before you use them. Variables can be treated as a normal attribute,
that is, it can be a source or target of a transform
59.@prompt ('message', ['type'], [lov], [mono/multi], [free/constraint])
what is Constraint?
Free Means, User can either enter value or select value from Lov.
Constraint Means, User can’t enter their value, they should select value from LOV
60. What is a Micro cube?
a) A cube contains data in multi dimensional analyzed format.
Its components are:
1) Measure / Fact: - It's an object which is been analyzed.
2) Dimension : - It's an object with respect to which we perform Analysis.
3) Detailed : - It's an object which provide extra information about a dimension.
b) Micro Cube is a processing Unit. It is composed of facts & Dimensions & measures.
Micro Cube is cleared by using "Purge" Option.
61. How to Analyze ‘Join’ problem and which method is the best to resolve
that?
Join problems are analyzed by Integrity checking and resolve by setting cardinalities
62. Say, the query gets executed and we got the results. In case if we have a
large number of rows, how can we know the exact no of rows returned?
a) From the data manager tab we can know the no of rows returned and the time taken to
run the report.
b) Click on any column in result set, right click and select count all. This will display the
total number of columns in the result set.
64. Is there any way to know how long the report executes and how many
records will be returned before hitting the "run" option?
a) Go to Definition tab in the data manager there u find these query options.
b) Before run a report just click on view button u can see the report.
c) Simple! Take the report query and modify to take the count in the query and execute it
at the back end.
65. There are 2 types of strategies are there?
1. Built-in Strategy
2. External Strategy.
Can you please explain them in complete that what are these?
Built-in Strategies:
Designer provides a number of default strategies which we can use. These are strategies
for extracting joins, detecting cardinalities, and creating default classes and objects.
Options for indicating default strategies are located in the Database tab of the Options
dialog box.
External Strategies:
We can also create our own strategies. Such strategies are referred to as external
strategies.
With an external strategy, we can specify the exact way that objects and joins are to be
extracted from the database structure. The strategy we use, for example, can be a script
generated from a CASE Access tool. An external strategy is specific to one RDBMS.
b) External Strategies are script files used how to read the data dictionary of source
database. Data dictionary of source database having meta data information of tables,
columns, views, synonyms, stored procedures etc.
66. What is the difference b/w 6.5 & XiR2?
a) 1. XI R2 has a 5 tier architecture, where as 6.5 has 3 tier
2. In XI R2 we have some new tools like Import wizard, conversion tool etc.
3. In 6.5 we have a product called Business objects but now it is been renamed as
Desktop intelligence.
4. I n 6.5 we have supervisor, but there is no supervisor in XI and they have introduced
the new concept of CMC which is used to created users, user groups etc.
5. In 6.5 reports are being stored in document domain of repository, now they have
introduced the concept of folders and categories.
6. In 6.5 we have BCA (broad cast agent)to schedule the repots but in XI there is no BCA,
u can schedule the reports using "Scheduler" in CMC
7. Not only these even in designer, deski & webi, u have some new enhancements
WEBI:--
In 6.5 there is no "Alerts", In Bo xi having "alerts & Sub Alerts" also
b) In Business Objects 6.5 Repositories are created by Supervisor after installing the
software, Where as in BO XIR2 by default 3 repositories are created while installing the
software.
They are central management repository, File repository and Audit repository.
67. How to connect to a server in a business objects
There are some third party software are there to connect like "CITRIX"
68. What are slowly changing dimensions & confirm dimensions?
a) Slowly Changing Dimensions are basically those dimensions whose key value will
remain static but description might change over the period of time. For example, the
product id in a companies, product line might remain the same, but the description
might change from time to time, hence, product dimension is called slowly changing
dimension.
Where as confirmed dimensions are some thing, which can be shared by multiple Fact
Tables or multiple Data Marts.
b) Conformed Dimensions (CD): These dimensions are something that is built once in
your model and can be reused multiple times with different fact tables.
For example, consider a model containing multiple fact tables, representing different
data marts. Now look for a dimension that is common to these facts tables. In this
example, let us consider that the product dimension is common and hence can be reused
by creating short cuts and joining the different fact tables.
Some of the examples are time dimension, customer dimensions, product dimension.
c) Confirm dimension:
Confirm Dimension which is used to link more then 0ne fact table or data mart.
For example In our project, we have created five data mart of different subject area ,our
client requirements is to create a report by linking all the data mart or subject area .To
achieve that report we linked all the data mart through Person confirmed dimension .
d) A confirmed Dimension (CD) is a dimension which is shared by different fact tables.
For examples, there are different data marts are there say Loans, Deposits, Withdrawals
etc.....in this there is a dimension called Date which is common to all. We can link to
different data marts using a common dimension called Date in this example.
e) Confirmed Dimension, it is a dimension linked with two or more fact tables.
Suppose we have two fact tables like sales and production link with dimension product
dimension here Product is the confirmed dimension
f) A dimension that carries the same meaning across the different fact tables is called
conformed dimension. Confirmed dimension are a must to put a no. of data marts
together to create a enterprise data warehouse
g) In the schema a dimension which is shared by multiple fact table that dimension is
called confirmed dimension.
70. How do u migrate BO 6.x to XI?
There are 2ways to migrate 6.5 to xi.
1) Open migrate wizard. IMPORT WIZARD window appears. Import wizard is a tool to
migrate reports, Universes, Repository objects to one environment to other environment
with in XI and also from prior versions to XIR2 versions.
2) While using this option, Report Conversion tool.
71. Draw the architecture of traps?
a)Fan trap:-
Customers----->orders---->order lines
b) Chasm trap:
Reservation line
Service <
Invoice line
Fan trap:
Client->sales->sales model
72. What is the syntax for aggregate awareness?
a) @ Aggregate _Aware (sum (agg_table_1), ... sum(agg_table_n))
b) Aggregate awareness is a feature that makes use of predefined aggregate tables to
enhance the performance of SQL transactions. It is used to improve the speed by which
aggregates are calculated in the database. To set up aggregate awareness in a universe,
you define or more objects using the @ Aggregate_Aware function. The syntax for this
function is as follows:
@Aggregate_Aware (aggregate_table_1, ... aggregate_table_n)
c) The arguments of this function are all the names of alternative aggregate tables. When
you formulate the syntax, you should be aware of the order of the arguments.
The precedence is from left to right; this means that Business Objects determines the
aggregate to use beginning from the leftmost argument.
73. What is the Computation error? How to solve it?
The computation error is related to the misuse of context operators in formula
74. An index has been done on the primary key of a table. An update
operation was performed on that table. Now my question is
1> what about the performance? Means faster or slower due to indexing?
2> does the operation affect to the primary key constraint?
Normally database takes to 2 hours of refresh time. But client asked I want
to refresh with in 5 min that same database. Do you have any option in BO
and Oracle? Explain me briefly.
When we use an INDEX, performance will increases.........
In fact the main purpose of index is to increase the performance only.(very fast).
2. The index, generally works based on primary key or unique key.
When we use index refreshing time will reduces.
75. You are a universe designer and report developer in BO, what type of
information you gather from client? Briefly explain?
We can gather information by asking QUESTION TO THE CLIENT like WHAT, WHY,
WHEN and HOW.
Role of BO Developer is,
--->Firstly we have to understand the Business Process and user requirement of the
client.
--->Based on that we have to design and develop Universe.
--->test the universe.
--->Finally, view and share reports between end users.
76. 2 tables are there, columns are with different names, but data type is
same, 2tables values are same. How to you find out both values are same?
In Designer,
In the file tab-->parameter-->Strategy
We join the two tables. We have lot options to join like ‘match by column names, match
by values’ etc.
77. Table A, Table B are there, columns are different like table A contain (A
varchar (9), B varchar(2), date), table B contain(D varchar(10), E
varchar(2), F date) , i want 2 compare mismatch data type length in both
table, how? Do you know any in built function?
Using describe function v can find out that mismatch data type.
Desc table a, table b;
78. What are the degenerated Objects?
Objects created using SQL queries or stored procedures called Degenerated Objects.
79. What is input level context and output level context in webi?
The 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.
80. What is casual dimension?
Casual dimension is a dimension that should not change the fundamental grain of a fact
table.
Ex: sex- Male, Female.
81. What is the use of Surrogate Key in BO?
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.
82. Can we use detail object in generation of reports? If customer id is a
dimension in a report, what will happen if we define it as a detail?
a) Detail object means it should give detailed information for some dimension object.
You can use these objects in your report generation.
When we drag the detail object in query panel, It will automatically fetches it's
corresponding dimension object also.
b) Detail object:-
It gives extra information to the dimension object.
Eg:-customer id is a dimension object then detail object of customer id is customer name
i.e. first name, middle name, last name, Address, Phone number.
If we put customer id as detail the only problem is we can't perform drilling on it
83. What is maximum scope of analysis --> can we define more than 3
levels?
By default, you can do only up to 3 levels. But with custom, you can do more than 3
levels.
84. Difference between scope of analysis in Webi and in Deski?
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.
85. What is casual dimension?
One of the most interesting and valuable dimensions in a data warehouse is one that
explains why a fact table record exists. In most data warehouses, you build a fact table
record when something happens.
For example: When the cash register rings in a retail store, a fact table record is created
for each line item on the sales ticket. The obvious dimensions of this fact table record are
product, store, customer, sales ticket, and time.
At a bank ATM, a fact table record is created for every customer transaction. The
dimensions of this fact table record are financial service, ATM location, customer,
transaction type, and time. When the telephone rings, the phone company creates a fact
table record for each "hook event." A complete call-tracking data warehouse in a
telephone company records each completed call, busy signal, wrong number, and
partially dialed call.
In all three of these cases, a physical event takes place, and the data warehouse responds
by storing a fact table record. However, the physical events and the corresponding fact
table records are more interesting than simply storing a small piece of revenue. Each
event represents a conscious decision by the customer to use the product or the service.
A good marketing person is fascinated by these events. Why did the customer choose to
buy the product or use the service at that exact moment? If we only had a dimension
called "Why Did The Customer Buy My Product Just Now?" our data warehouses could
answer almost any marketing question. We call a dimension like this a "causal"
dimension, because it explains what caused the event.
86. How to overcome overflow of data in a report
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.
87. Is there any limit for rows and columns in cross tab?
No
88. When and where we use @variable function?
The @Variable function is used to call the value assigned to variables.
The variables are of two types:
1) Business Objects system variables
2) Personal text files variables
89. What is static filter and dynamic filter?
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.
90. What is report tracing in BO?
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.
91. How many micro cubes can a report have?
Only one
92. What is a local filter?
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.
93. Generally how do we get information for creating universes and reports?
94. What is the difference b/w b.o. 5.1 or 6.5 or Xir2?
BO 5.1.2 had no Infoview. BO 6.5.1 included Infoview, but no Crystal Report, CMC not
present. Instead supervisor (thick client) was used for giving Users rights.
BO XI includes integration with Crystal Reports, CMC (thin Client) for managing Users,
security and Profiles
2) Oracle 9i includes Bulk Inserts, Index Rename and Table Rename.
3) SQL is a 4 GL (Generation Language). Pl/SQL is a 3 GL.
95. What is a Prompt?
Prompts are used for asking the user for Dynamic Inputs while refreshing the Report.
96. Can we create reports without creating Universe?
Yes we can create reports without creating Universe.
97. What are ad-hoc 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.
98. How to link one location universe to other location universe
a) Click on File menu---> Parameter---> Links---->Add Link and then choose the
universe you want to link and give ok. Then the universe is added to the existing one.
b) In Designer, we can't join two universes, we can link two universes.
1. Click on the File menu; say Parameters then one dialogue box is displayed.
2. Click on the Links tab, and say Add Link then choose the universe u want to link and
say ok.
Then your universe is added to the existing one.
99. What is “maintaining universes”?
a) Maintenance of universe means adding new tables, refreshing the table structure after
adding new tables, create the joins between the new tables to existing tables identify
loops if any, examine the integrity checks after any changes, determining the cardinality
if any, resolving the loops. Adding the new objects and classes, exporting, restricting
access to users etc..
b) All the operations after the initial production phase are called maintenance of
universe.
We have to add some more tables to schema design as per client requirements and
finding any errors after adding the tables. If at all any resolving them and generating
reports.
10o. How to hide the tables in webi?
We can hide a table in webI when the table is empty.
From the properties tab, deselect 'Show when empty' check box.
101. How do u get requirement from the client?
Design Specification (.doc) - Shows the architecture of the Project.
Requirement Specification (.doc) - Security Requirements, Performance Requirements,
Non Functional Requirements, Functional Requirements
Project Plan (.mpp) - Project Duration
Report Specification Template (.xls) - Look and feel of the Reports
Data Element Matrix (.xls)- Tables and Columns involved in this Project.
102. How do u Receive requirements from the client?
Through web intelligence and through browser
103. What is Scope of Analysis?
a) Using this Scope of Analysis we know up to what extent we can drill the Report
b) Scope of Analysis determines the additional objects to be included in the query so that
the data will be available in drill mode. Before you can drill, you must use Scope of
Analysis to select the objects to be retrieved in addition to those that were placed in the
Result Objects.
c) Scope of analysis: it let's u add more data to the micro cube from hierarchies. This data
is used for multidimensional analysis. When you add the data to the micro cube, the
added data is not initially displayed in the report. When you drill the data it displays the
added data for the purpose of multidimensional analysis. The scope of analysis button is
located in the query panel.
Here we just specifying the path for objects to get the detailed or summarized
information using drill option for analyzing the data in different ways
104. HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
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.
105. WHAT ARE THE TYPES OF UNIVERSES? PLZ EXPLAIN IT?
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)
106. What are the types of Connections?
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
107. What is meant by slowly changing dimensions?
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)
108. What is meant by scorecards?
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.
109. Case1: A person buy a car, case2: rent a car which is context & which is
alias? Why?
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.
110. What is meant by Ad hoc reports? Can any body will explain with
examples.
Ad hoc reporting is a user friendly feature designed for all levels of users. Custom reports
are created using queries.
b) 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.
111. What is a Query?
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.
112. Explain about surrogate key?
a) A surrogate key is an automatic system generated unique key.
b) An artificial key which can be used to remove redundancy.
c) Surrogate key is a system generated key which is defined at database level to avoid the
duplication of records. it doesn’t maintain any relations b/w tables like as primary key
and it only allows unique data there is a command with sequence in oracle.
d) A surrogate key is a substitution for the natural primary key. It is just a unique
identifier for each row that can be used for the primary key to the table.
e) Surrogate Key is unique identifier Key in Production System, to avoid data duplication
and redundancy in DWH
f) In a current database, the surrogate key is the primary key, generated by the database
management system and not derived from any application data in the database. The only
significance of the surrogate key is to act as the primary key.
113. What is the difference between sub-query & co-related sub query?
a) A sub query is executed once for the parent statement whereas the correlated sub
query is executed once for each row of the parent query.
Example
Select deptno, ename, sal from emp a
where sal = (select max(sal) from emp
where deptno = a.deptno)
order by deptno
b) Nesting of queries, one within another is termed as a Sub-Query.
114. What is the necessity of oracle for business objects, why the interview
panel is concentrating on oracle very much? Just we need the commands
using select, joins? Why they r asking about cursors, triggers etc.
What ever we do in the BO it needs to connect to Oracle with the help of queries. As my
experience says, it’s some times necessary to have the derived tables to be created which
needs SQL knowledge, to do data validation we need SQL queries. Actually for any BO
Developer optimum level of SQL knowledge is necessary. Because In BO we are mostly
using oracle is as database. So what ever you are selecting in the query panel it is fired on
the database in the form of query. All of us know it is done by designer automatically. But
in some scenarios we have to implement freehand SQL queries, derived tables to get our
target results and some times we have to validate the background SQL generated by BO
to understand how results are coming in. And in creation of formulas and variables we
need SQL knowledge.
(to_char, to_date, trim, decode, sign, union, union all....). So SQL is must.
Coming to the PL/SQL in some situations when the data is in huge amounts, normal sql
not meet the required performance. So we have to use PL/SQL. So it is required in rare
cases where you are uploading the data in the report automatically by running the UNIX
batch or getting the huge amount of data in to the reports. As per my knowledge in real
time it is better to know about the writing the procedures, creating the views are more
enough. I think cursors, triggers etc are used depend upon data needs.
115. WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
The different table templates you can use to display information on reports are:
Vertical tables
Horizontal tables
Cross tabs
Forms
1) Vertical tables display header cells at the top of the table and the corresponding data
in columns.
2) Horizontal tables display header cells at the left of the table and the corresponding
data in rows.
3) Cross tabs display values for dimensions across the top axis and on the left axis. The
body displays the values of a measure that correspond to the cross section of the
dimensions.
4) Forms are useful in your report if you want to display detailed information
116. WHAT IS CARTESIAN PRODUCT?
a) It is a situation in which a Query includes two or more tables that r not linked by join.
If we execute that query, it will retrieve all the possible combinations b/w tables that are
not joined. In this situation condition is invalid or omitted completely, the result is
Cartesian.
c) A Cartesian product is defined as all possible combinations of rows in all tables.
d) A Cartesian product is a result set which contains all the possible combinations of
each row in each table included in a query. A Cartesian product is almost always an
incorrect result.
119. WHAT IS CARDINALITY?
a) Cardinality is a property of a join that describes how many rows in one table match
rows in another table. Cardinality is expressed as the minimum and maximum number
of rows in a column at one end of a join that have matching rows in the column at the
other end of the join.
b) Cardinality defines the numeric relationships between occurrences of the entities on
either end of the relationship line.
Eg:
1)1:1
2)1: M
3) M: 1
4) M: M
c) The minimum and the maximum number of row matches can be equal to 0, 1, or N.
d) Cardinality is mentioning the relation ship between the two columns participating in a
join...
Eg: if cardinality is 1 to n...for every column value in first table's field there exists many
column values for the field in second table.
Ex: For every customer there may exists more than one address
(Permanent and temporary)
120. HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
a) When ever we save universe it directly gets saved in local repository. If we want to
access these universe from deski or webi then we will have to save these universe to
central repository by EXPORTING it, it will directly be saved in default location in
central repository
b) By exporting the universes and documents, we can save them to the repository. We
can also publish them to the central repository.
c) If u are working in client system u must save ur universe and files in server system
repository.
Process: 1st save the Universe.
File-->export-->report conversation toolsok.
121. Can a Universe be linked to more than one data source?
a) The Various data source are:
Universe
Personal data files
Free hand SQL
VB procedures
Stored procedures
OLAP servers
b) Any number of data Source can be linked by linking common dimensions
Features of Dimension:
The dimension objects do not have to have the same name
(E.g. Person, Person Name)
Only dimension objects can be linked (e.g. Person Name, Encounter Type, etc.)
The dimension objects must have a common data format (e.g. character, numeric, etc.)
Common values must be in the same case etc.
c) Yes, we can link to more than one data source. We can have universe connection to
more than one data base. We can achieve this by creating the db link between two data
bases and then connecting it to the universe to any of the db.
d) You can have a single database connection to a universe.
e) Definitely it is not possible to use more than one database connection to a single
universe.
122. IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES
IN ONE DOCUMENT?
Yes, it is possible to use different universe to generate a single report....multiple data
providers.
123. TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
a) In BO XI R2, the row level and object level. Security can be done in the universe itself.
b) 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 particular user or user group.
124. What is 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.
125. HOW TO SPOT A HIERARCHY?
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.
126. WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE
DESIGNING UNIVERSES?
Some other function like Number, Character, Date functions &
@ functions like, @Aggregate_Aware, @prompt, @select, @where, @script and
@variable.
All the Universe Parameters (6 tabs) available in the universe parameters window are
very important functions to create any universe.
126. WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
Isolated joins, cross join, non equi join
127. WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
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.
129. WHAT KIND OF TOOL BO Is?
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)
130. HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?
#MULTIVALUE error can be resolved by putting the input context.
#COMPUTATION error can be resolved by puting the reset context in output context.
Create a new variable(ex:test) and copy the formula of the old variable to this new one
and assign the column to this new variable..is the solution for multivalue error.
Computation error: Use Max() function before the formula in the report to resolve a
computation error
131. HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW
DO YOU LINK THEM?
you can create different universe for different sources and link them in BO.
132. HOW DO YOU SCHEDULE THE REPORTS?
we schedule reports using broadcaste agent.
we have a simple procees to shedule thee reports.when u saved ur report in perticular
folder.
connect sever through browser tool go to ur folders and shedule
in 6.5 we can use broad cost agent but in the case of boxi we can use boe .net launch pad
In 6.x and previous versions, Broadcast Agent is used to schedule the reports.
In XI and XI Release 2, any user who is authorised to schedule documents can schedule
the reports.
Broadcast Agent lets any authorized user schedule documents to be refreshed on a
regular basis. Scheduled documents may then be automatically distributed to targeted
individuals or
groups or published for all users to access. Users can customize the information they
send by executing a standard report and then bursting it so that recipients receive only
the information they are entitled to by their security profile.
133. GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE
CREATING REPORTS?
THE MOST COMMON PROBLEM IS JOIN PATH PROBLEM
i.e,
LOOPS
CHASAM TRAPS
FAN TRAPS
134. GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH
PROJECTS?
It's depends on the project requirement.
There is no restriction on the creation of the universes.
It's all depends on the project
In general, One universe is sufficient for a project and if we need we can link other
universe from other projects...
this totally depend upon ur project requirement
135. i am using Business Objects 6.1(a) facing a problem. ie when we save
report in xls format then in xls sheet pictures are inserted into rep file are
not come. Is it a bug.
we can't save the report with chart in xls,text format. only save in html,.rep,pdf
While saveing the report we have to save in the form of save as
select this format:-
1)Microsoft Excel Sheet(.xls)
2)HTML format(.htm)
3).pdf
you can select any one of them it is possible.
136. Re: what is the diff between etl tool and olap tool
ETL tool is used to extract, Load and Transform the data from one system to another
system. OLAP tool is a reporting tool which will generates the reports that are useful for
dicison support for top level management
ETL tool are nothing but OLTP tool whereas OLAP tools are report net tools
ETL(OLTP) are extracters tranfers and loaders type OLAP tools are analysers
137. WHERE DO YOU USE GLOBAL FILTERS, EXPLAIN WITH EXAMPLE?
global filter acts on all fields in the report table
138. WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING
INTEGRITY CHECK?
We can't find traps i.e. chasm trap and fan trap. It can be identified only by visualization.
139. CAN A REPOSITORY CONTAINS REPORTS?
yes repository contains reports in bo 6.5 reports are stored as documents in repostory
in bo xi reports are stored as folders in cmc
Yes, Repository contains reports. In BOXI also reports are stored in repository (file
repository). Those reports in folders are also stored in repository only.
Yes, Repository contains reports.
In BOXI also reports are stored in repository (file repository).
Those reports in folders are also stored in repository only.
bo 6.5 rep contains 50 tables........
bo xir2 contains 8 tables.....
1 table is dedicated for documents(document domain).
these 8 tables r also called cms db(central management server)........
Repository Database will not store the actuall report file, it has the pointer of the report.
Yes, Repository contains reports. In BOXI also reports are stored in repository (file
repository). we can save our reports in folders(phsycal) and categories(logical)..these are
avilable only repository only
140. WHO ARE THE USERS OF THE REPOSITORY?
general supervisor creates repository and designer ,user(report devlepoer ) uses the
repository...the documents are stored in document domain...in fact the clients also uses
the repository while seeing the documents
General Supervisor, Supervisor are the users of therepository. Since they are the owners
of the repository theycan create the repository and modify it whenever they want.
who is having user as well as admin rights to access the
repository
141. IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS
2000 PROFESSIONAL SERVER, WHAT SHOULD BE THE SYSTEM
CONFIGURATION?
• P3 700MHz**
• 1 GB RAM
• 5 GB hard disk space for BusinessObjects Enterprise and
1.5 GB additional for Performance Management
• CD-ROM
** Windows support is limited strictly to the 32-bit versions of Windows operating on
either 32 or 64-bit (x86)
AMD/Intel chipsets. BusinessObjects Enterprise software for
Windows is not warranted or supported for use on other chipsets.
142. User name and password is saved by Business objects when we create
repository. and this username and password is saved in Table obj_m_actor
table in repository. The password in incrypted form. It is possible to Dycrypt
That Password.
Not possible.
143. Can we edit BOMain.Key file to connect with other repository with same
supervisor user name and password. But Database is different.
Yes
144. 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.
Clent first contacts the company's Business DevelopmentManager of the company, Then
Meeting and a chat happens in a clients place or client coming to company, Then gets the
requiement according to the deal
144. 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\multi,free\constrained)
it is nothing but a dialog box it can used for to take the values.
syntax:
@prompt('message',['type'],[lov],[mono/multi],[free/constraint])
Prompt: It is used to create an interactive object. and also it is dynamic filter.
General syntax:@prompt('message',['type'],[lov],[mono/multi],[free/constraint])
In designer we can write this way,@select(class\object )= @prompt
('message','type','{values1,values2...},class\object,mono\multi,free\constrained)).
Cascading Prompt: it is based on one prompt to another prompt. it is also refer to
hirerchy also & designed in uni level.
IN BOXIR2 wise:--
go tools --> click cascading lov --> edit lov window
open --> write conditions how many prompts u want. -->
click ok.
145. what is drill down?
Action of navagating thorough levels of data. by drill down youn can reach the more
refined or detailed information.
analysing the data in different angles and levels
Drill down is a one of the concept in Drill.
Drill is nothing but an action of navigating data thru levels of data. Drill down - with the
use of drill down you can reach more detailed information.
Navigating data to lower level in the hierarchy with in the cube move from summary
information to detailed data.Drilling the data into end level of hierarchy
146. 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.
The ability to move between different combinations of dimensions when viewing data
with an OLAP browser.
Multidimensional analysis tools organize the data in two primary ways: in multiple
dimensions and in hierarchies.
Slicing and dicing refers to the ability to combine and re-combine the dimensions to see
different slices of the information. Picture slicing a three-dimensional cube of
information, in order to see what values are contained in the middle layer. Slicing and
dicing a cube allows an end-user to do the same thing with multiple dimensions.
147. 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.
most of the reporting tool had same features but bO is more secure..can work with
remotely using web I,with out installing of BO s/w in ur local system
148. 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 decision by the managers.
The main aim of data warehouse is in analyzing the large volumes of data so that it can
be helpful in taking business decisions for reporting one day details also enough.but
analysis
means we need comparision means we need some old data is called historical data.the
data ware house saves historical data ,we con't to any data base manuplations.
where is in normal databases we arte able to maintain some extent of data .after that for
entering new data u need to delete the old data.
BUT in Data ware house u are able to stote years of records no need to delete the old data
149. what are the multidimensional analyses
multidimensional analyses that can be used to wide view varieties of data or information
Multidimensional analysis is the analysis of dimension objects organized in meaningful
hierarchies. A hierarchy is an ordered series of related dimensions.
Multidimensional analysis allows you to observe data from various viewpoints.
Multidimensional analysis means analysing the data by looking at various view points.
In BO,In 2 ways we can do this.1.Slice and Dice 2.Drilling.
Multidimensional analysis is analyzing the data in different ways. There are two options
are available in BO,
1.Slice and Dice, it allows us to view data differently i.e. we can change the position of the
rows to columns and columns to rows.
2.Drilling, using drilling option we can view data in different views i.e. we can know the
level details of any dimension. Suppose if we take Date dimension, we can use drill
option to view the next level of detail i.e. from year to quarter and from quarter to month
and from month to day.
150. What is data mart?
datamart is nothing but a database. it can be stored data about the particular
orginazation.
A data mart is a particular subject oriented block of data in the datawarehouse in the
business line like production, sales, marketing etc. they are two kinds of datamarts are
there one is independent & Dependent datamarts.
sub set of datawarehouse is called data mart.
A data mart is a subset of data warehouse that is designed for a particular line of
business such as sales, marketing, finance, etc.
Data mart is of two types:
1) Dependent data mart, in which data can be derived from an enterprise-wide data
warehouse.
2) Independent data mart, in which data can be collected directly from sources.
In the industry when a organisation goes for a enterprise wide Datawarehouse the cost
involved in setting up . its maintenance and other overheads are also associated with it.
So due to budget and time constraints some organisations initially set up a Data Mart to
facililtate there immediate needs . These Data Marts are generally set up at department
levels and in a future date if utility arises then datamarts across the organisation can be
integrated and a full fledged data warehouse can be formed. In a way Data Mart is a
subset of Data Warehouse.
151. .what is conformed dimension? R u used?
Confirmed Dimention is a dimention table which is connected to the multiple fact tables
A dimension that is used in more than one cube.
The use of conformed dimensions and shared measures is the primary way a set of data
marts can be united into one consolidated data warehouse.
conformed dimension table is once created that is not changed occutionally
A Confirmed Dimension (CD) is a dimension which is shared by different fact tables.
it is a dimention accept table join relation between two facts
152. 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.
LoV is list of values it displays the list that contains the data values associated with an
object.
A list of value can contain data from two types of data sources...
1. Database file
2. An External file.
LOV is nothing but listy of values.
as per require ment we can generate LOV for limited no of objects.we can save it in
repository server
we have cascadiding loV also we can generate lov s for multiple objects at a time
153. What is repository? Types
In XIR2 CMS Repository :Which consist of two database (System & Audit)
Input file repository: Template of the report
Output file repository: Instance of the report.
repository is the set of data structers that can be stored in the database.
repository is a oraganizing metadata or cenralizedmetadata storage place
reposirory is create new folder structure
types:
repository manager
repository admin console
repository is a central store area between group of users. repository is available under
cms
input and output repositories
154. what is alias?
one user prefrom different roles is called alias
eg
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.
Aliases are references to existing tables in a schema. An Alias is a table that is an exact
duplicate of the original table with a different name. The data in the table is exactly the
same as the original table. An alias breaks a loop by using the same table twice in the
same query for a
different purpose.
An alias is a logical pointer to an alternate table name.
Exact copy of the original table.Establish a one-one join between the original table and
the table which is aliased.The aggregatre results should be canned on to the aliased table
and not the original table.
alias is a logical table of existing look up table. using alias we can resolve loops
155. 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 canbe 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.
Loop can be resolved either alias/ context.
Loop is a Multiple paths between the tables selected in queries. Or you can say loop is a
closed path structure.
Loops can be resolved by…
ALIASES
•Alias - Same as the namesake in SQL.
•Exact duplicate of the original table.
.A different name “tricks” the SQL query to accept that you
are using 2 different tables.
CONTEXTS
•Rule which helps BO decide which of the 2 paths to choose in a loop.
•BO prompts the user to indicate the correct perspective (relevant path) for the query.
When to Alias
A loop with a single lookup table should be resolved by an alias
A lookup table can be identified by its cardinality
A lookup table only has the ‘one’ end of joins attached to it
If your universe is simple in terms of tables then go for alias.
If your universe is complex in terms of tables then go for Context.
Alias entails the propogation of the universe.
Contexts are not liked by the enduser because we are forcing the enduser to the database
which is the against to the universe basic rule ie to keep the endusers away from the
database.
loop is nothing but a continuous data flow .it is a pipe line. it is a close path end to end.
using alias table we can resolve loop s
A loop is a set of joins that defines a closed path through a set of tables in aschema.
Loops occur when joins form multiple paths between lookup tables.
156. 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 fact tables) then the loop can be resolved
by detecting context
tools-->insert context
then you can select the path.
157. How can we improve performance?
By making use of Aggregate tables.
1)using 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
158. What is the use of BO SDK?
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.
159. What are the general issues in migration process?
Alignment, performance.
Before Migration, one should have a thorough with
1. Import Wizard
2. Report Conversion Tool - for converting the DeskI Reports to WebI Reports
Issues can be:
1. What type of Migration u want to Usea)
Single Pass
b) Incremental Migration
2. Importing Security or not.
3. Repository Migartion- such as
a) Merging Multiple repository into one
b) Moving one to Multiple Repository (Depends on the requirement)
4. Need to take care of Versions and Platforms - Supported
databases,Web and Application Servers, Web Browsers and Operating Systems.
5. User/Group Migration
6. Setting up Folders/Groups Structures.
7. Document Migartion.
8. Taking Backups
9. Setting Up Servers etc.
There are lot other issues also.
1)Formatting issues
1)Linking Universes
1)hiding of variables you cant do it in xi r2
160. Why do we need metrics and sets?
Metrics are used for analysis and Sets are used for grouping.
161. what is the source for metrics?
measure objects.
162. What is the use of AFD? Where it can be stored?
used to create dashboards. It can be stored in repository, corporate or personal.
163. What is a Set?
Its nothing but grouping of users.
164. 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.
165. 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.
In Section(Master Detail) you can have two or more different crosstabs or
tables(hori/fin) eg. orders, customer, products etc
Where as In break one block is break into groups and subtotal is shown eg customer can
be broken into country/state/city
In Section(Master Detail) you can have charts for each section or detail. can have chart
and table combination as well.
Whereas in Breaks u cannot insert a chart for each of the groups formed out of break
166. 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.
Alterters are conditional tests.
Conditions restict the data at the database level.
Filters restrict the data at the report level.
Breaks can be used to remove redundat data and the data remains with in the cell
content.
167. 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.
Combining a data from multiple tables is called join.
There r 5 types of joins r there.
1)Simple join 2)Equi join 3)Outer join 4)Theta join 5)Short cut join
A join is a condition that links the data in seperate but related tables. The tables usually
have a parent-child relationship. If a query does not contain a join, the database returns
a result set that contains all possible combinations of the rows in the query tables.
Types of joins:
1) Equi-Joins
Link tables based on the equality between the values in the column of one table and the
values in the column of another.
2) Theta Joins
Link tables based on a relationship other than equality between two columns.
3) Outer Joins (Left Outer, Right Outer, Full Outer) Link two tables, one of which has
rows that do not match those in the common column of the other table.
4) Shortcut Joins
Join providing an alternative path between two tables, bypassing intermediate tables,
leading to the same result, regardless of direction. Optimizes query time by cutting long
join paths as short as possible.
5) Self restricting joins
Single table join used to set a restriction on the table.
join is very important concept in BO
relation between two tables is called joins.
we have 4 types of join relations 1:m,m:1,m:m,1:1
types of joins in BO
1)equi join
2)theta join
3)outer join(left/right)
4)isolated join
5)short cut join
168. What is a loop? How can we overcome?
loop is a closed path between end to end. Continuous flow 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.
169. What is the size of data base?
In general it will be anything between 4-8 Terabytes.
170. 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.
Object qualification is nothing but a property of an object determines how it can be used
in multidimensional analysis. For the purpose of multidimensional analysis objects can
be qualified as dimension, detailed and measure
171. What is a category?
we can store logical report here.in real time we can use categories only. we can't
manipulate the categories report
It is nothing but grouping of certain entities.
Categories tag objects in a meaningful way to provide an additional method of
classification, which makes searching for content easier for users. A Report in one Folder
may assigned to several Categories.
Types of Categories:
1)Corporate Categories – Created by admin or users who has admin rights.
2)Personal Categories – Created by each user to organize their own personal documents.
172. 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.
173. Can we have multiple domains?
Yes.
we have multiple domains,but security domain is not multiple,only document domain
and universe domain is multiple.
174. 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.
175. 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.
176. What is BO Main. Key?
BoMain.Key file contains the information about the repository site i.e it contains the
address of the repository security domain.
The General supervisor username n password is stored in bomain.key file
BOMain.key file contains the address of the repository's security domain. This key file
should be distributed to all the users of BO to work with BO or will access the bo
repository to share universes and documents. It is stored in BusinessObjects/LOCData
folder.
177. How to create Generic TIME CLASS, which includes Objects Year,Month
and Qtr?
year=to_date(to_char(timeclass,'yyyy'));
month-->to_date(to_char(timeclass,'month'));
178. How to link two different universes ?
go to universe parameters and select link tab and then select the universe.
Universes can be linked using Universe Parameters. You can link universes with any of
the following approaches:
1)Kernel approach
2)Master approach
3)Component approach
With the Kernel approach, one universe contains the core components. The derived
universes that you create from this kernel universe contain these core components as
well as their own specific components. Any changes you make to the kernel universe are
automatically reflected in the core components of all the derived universes.
The Master approach is another way of organizing the common components of linked
universes. The master universe holds all possible components. In the universes derived
from the master, certain components are hidden depending on their relevance to the
target users of the derived universe. The components visible in the derived universes are
always a subset of the master universe. There are no new components added specific to
the derived universe. Any changes you
make to the master universe are automatically reflected in the core components of all the
derived universes.
The Component approach is merging two or more universes into one universe.
we have a concept in BO linked universe there we can link multiple universes.
file--.parameters-->links
179. How to Implement the the Built-in Strategy Script in BO Designer?
strategy is used to extract structural information about the tables, joins ...
bo has 2 strategy
1. built-in -strategy
2. external- strategy
180. What are the security level used in BO?
There are four
1.hidden
2.disable
3.inhernt
4.enable
Security Levels in BO XI are:
1) Predefined
2) Advanced
Predifined:
1) No Access
2) View
3) Schedule
4) View on Demand
5) Full control
With Advanced you can explicitly define the security level.
181. What is slicing and dicing in business objects?
slice & dice is used to analyse the data in different views & perspectives
Slice and Dice can be applied to rotate a microcube in order to view it from different
perspectives.
A microcube is a conceptual way to present the data returned by a query before it is
projected onto a report.
You can choose all, or only some of the data held in the microcube to create a report.
slicing means it slices the cube based on a dimension dicing means rotates the cube with
independent of dimension
182. How will you know the version of Bo using designer?
in designer select the file tab, then click on parameter tab in that select summary tab
then we will get the information
While opening the designer, a BO patents page appear which shows the version of BO
183. Which command using Query Analyzer will give you the version of SQL
server and operating system ?
select @@version
184. How can we acheive Correlated sub-query in Designer?
A correlated subquery is a SELECT statement nested inside another T-SQL statement,
which contains a reference to one or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the outer query. This is the main
difference between a
correlated subquery and just a plain subquery. A plain subquery is not dependent on the
outer query, can be run independently of the outer query, and will return a result set. A
correlated subquery, since it is dependent on the outer query will return a syntax errors
if it is run by
itself.
185. Explain in Detail about Measure Objects? and what is the use of it? How
to create it?
It can be derived fro the Aggregate function. it convey the numeric information by
Dimension object can be measured.
Measure objects retrieve numeric data, or data that is the result of calculations on data in
the database.
For example: No. of students in the Students Universe.
Measure Object convey numeric information which is used to quantify a dimension
object. A measure object returns numeric information.
You can create a measure object by using aggregate functions such as,
1)Sum
2)Count
3)Average
4)Minimum
5)Maximum
186. What is the local filter and global filter in bo's?
To hide & display the data.
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
a report can contain more than one block...same way a document can contain more than
one report.....
so if we see one report we have some blocks....
applying a report filter to only one block is local filter..
applying a report filter to all blocks is global filter...
in any report.
Global Filter will affect whole Report But local filter will affect selected both only.
187. What are the steps to taken care to improve the Report performance?
The Report Performance can be improved by the following
performance Requirements :
1- The Report should open within 10-15 Minutes
2- The data should be available within 24 hours For
Example - If there is some data error , it has to be taken in ETL ( Extraction ,
Transformation , Loading ). When the mapping got refreshed , the data should be
fetched into the Reports within 24 hours
As part of universe parameters increase the array fetch size and try to use aggregate
awareness.
188. How to connect one to one report?
You can link thru Hyperlink option
By using drill down functionality additional components will be added in HTML Tag.
189. What is the drill up , drill down, drill by , drill trough ?
drill-down means analysing the in different levels going to the down let us eg as year---
>quarter,quarte---> month and so on
190. How to create Universe using Flat file in BO6.0
If i am not wrong u can't create universe from a flat file but u can generate a report from
a flat file. choose "personal data files" in the new report wizard instead of univese and
input the file information.
191. What is the test methodology for testing BO Universes?
Integrity Check is the option through which one can test the universse in BO.
192. How can you access your repository with different user profiles?
first thing we are under the member(user) of the repository.and we need to rights to
access repository.
we also need to create particular user name and pass
193. 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
194. Can we take report on Excel in Business Objects?
yes. The businessobjects separately provided the option of get the report data from
universe or others(personal data option)in the business objects entered wizard. Click or
Select the others option and it will let u different files or extension files. here select .xls
file and follow normal
report style.
Yes, When u get the output of report then use save as .XLS option.
s sure,when we save the perticular report we have a option to save in .XLs
Yes, We can take a report on excel in Business Objects,
Process ....
In Desktop Intelligence -> File -> New - Generate a standard report -> Begin -> Other ->
Personal Data Files -> Finish -> format -> xls & select excel file from browse option -> If
excel file first row contains column name then select the check box -> First row contains
column names -> Run.
------------------------------------------------------------
If you want to save a BO report in excel format then,
After generating a report file -> save -> File name -> ....... & save as type -> xls -> Save
195. What is batch processing in Business Objects?
batch processing means scheduling the reports
196. What are different types of saving options in web intelligence?
we can save as excel, RTF and .rep PDF and html also
The saving formats with web intelligence are excel, pdf, csv and csv with options. Not
possible with rtf, rep and html.
The saving options with webi are:
1) excel
2) pdf
3) csv
4) csv with options
(Not possible with rtf, rep and html)
we can see save the report as excel...webi....adobe acrobat....thats all ...no rep... rtf...etc.
we can save webintelligence documents in two ways
1.excel
2.pdf only
197. What are alertors in Business Objects?
Alerts are set of instructions and rules to highlight output of reports.
Alerters are conditional tests which can be used to highlight the critical data.
we can apply a maximum of 10 alerters on a single dimension/column and a max of 30
alerters on a report.
198. What services the broadcast agent offers on the server side?
We can monitor the Scheduled Reports are controlled in the server side.
We can resume or cancel the reports running in the Broad cast Agent.
199. In Business Objects 4.1 version what is the alternative name for
broadcast agent?
Document agent server
200. What are steps to be taken care to create a good Universe?
A Universe is a business-oriented mapping of the data structure found in databases:
tables, columns, joins, etc.
A Universe is a semantic layer between Database and end users.
A Universe 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.
A Universe can also pertain to a section within a department or just about any set of
organized procedures such as a payroll or inventory system.
A Universe consists of a set of objects, grouped by classes.
Steps to be taken care to create :
Prepare : Know the data source
Analyze :Identify the needs of the end user population
Plan : Design the universe(s)
Implement : Create the universe(s)
Test : Using a test team (including end users)
Deploy : Distribute the universe to end users
Evolve : Adapt and extend universe over time
201. What is broad cast agent?
Broad Cast Agent used to shedule or refresh the document on particular period of
time(day, weak, month , etc) and also send those documents to the users.
BCA is used to publish or refresh the documents in regular intervals i.e Broadly speaking
BCA is used to schedule the documents.
BCA is used to schedule the documents and also used to send the documents to users in
pdf & excel format.
BCA is used to schedule the documents.
Using BCA we can send the documents to users in pdf & excel format.
bca is avilable only in 6.5 when we work with XI R2 we have publishing wizard .through
this we can publish our reports unders repository
202. Where will you find the address of repository in Business Objects?
You can find if from .key file
BOMain.Key
BOMAIN.KEY it is located in LOCDATA folder
203. What is security domain in Business Objects?
Security domain checks the users & their previlages
There are there domains in BO,
1. Security Domain
2. Universe Domain
3. Document Domain
Security Domain : It contains all user name & Password.Like
it ll hold all the User credential informayion
Universe Domain: It hold all the Universe Information
Document Domain: Nothins but Report Information
to check the user previlages ,means authentications
Security domain is created with 25 metadata tables, which contains the user name and
password of all the users,who enable the repository access.
Business object supervisor product performs a database authentication in business
object.
With in the business object repository we can have only one security domain.
204. Types of universes in business objects?
universe types in BO is
secured
shared
personal
This is not Universe types.
Personal,Shared, Secured are Universe connections.
most preferred Secured , we can export all changes made in universe. Where as other
connection does not allow.
two types of universe are there
1) Simple
2) Complex
There are two types of Universes
1. Ad_hoc Universe.
2. Non Ad_hoc Universe.
There are two types of categories personal (Non Ad_hoc) &
Corporate(Ad_hoc),
The two types of universes are kernel universe and another is derived universe.
I think this is the correct answer.
these question is not specific ....there may be many situations in bo where we can classify
the universes..
i'll tell some.....
1.depending on type of data universe objects mapping
Ad_hoc (corporate data)
non Ad_hoc(personal data)
2. in linking universes scenario
Core universe (called kernel or master universe) and derived
Universe
3.depending on universe parameters.
secured universe..personal universe...shared universe..
simple and linked
205. What are universe parameters?
universe parameters are universe name which is given by the designer and connection to
database source.
so they are universe name
database source.
Universe Parameters
Definition
Name: Enrollment - Registrar only
Description: Views of student enrollment data. Includes
course information since 1995 a
nd is retained for up to 5 years. Updated nightly.
Connection: DB2 Secured
General information
Created: 8/27/1999 by FSIS69
Modified: 4/30/2002 by FSIS69
Comments:
Statistics: 35 Classes
513 Objects
49 Tables
10 Aliases
55 Joins
0 Contexts
0 Hierarchies
26 Conditions
Strategies
Join strategy: Edit Manually (none)
Table strategy: (Built-in) Standard
Object strategy: (Built-in) Standard Renaming
Controls
Limit size of result set to: 500000 rows
Limit size of long text objects to: 1000 characters
Limit execution time to: 10 minutes
Warn if cost estimate exceeds: unchecked
SQL parameters
Query
Allow use of subqueries: yes
Allow use of union, intersect and minus operators: yes
Allow complex conditions in Query Panel: yes
Cartesian products: prevent
Multiple paths
Generate several SQL statements for each context: yes
Generate several SQL statements for each measure: yes
Allow selection of multiple contexts: no
Links
University Space Management System
Curriculum Master
Definition Tab: name, description and connection to the
database
Summary Tab: author and statistics about the universe
Strategies Tab: internal or personal wizards to make
creating a universe easier
Controls Tab: manages access and control of resources
SQL Tab: queries and SQL parameters
Links Tab: enables dynamic links with other universes
206. Who launches the supervisor product in Business Objects for first time?
general supervisor
207. Analysis in business objects?
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
208. can BO generate reports with out CUBICAL data to repository?
In BO the cubic structre cannot be perfomed it's not supported for building the
cubicstructure where as the cognos will support.
i hope this is the usefull answere..
No!!
Business Objects can create the reports without Cubical data also.
Ex: In the Fullclient application of BO we can create the report based on the excel sheet.
Just create the excel sheet having two rows and select the dataprovider as the Excel sheet
and Run it, You will get the BO report.
That means you are not having the CUBICAL DATA at the souce, even though you can
generate BO reports.
209. what is main functional differences between BO and COGNOs?
BO : Business objects, objects in object-oriented programming meant to represent
business entities.
Business Objects, a company that creates and markets business intelligence applications
analyzing internal and external data.
COGNOS : which makes business intelligence (BI) and performance planning software.
Business Objects
1.BO -- ROLAP Reporting Tool.
2. It does not support MOLAP cubes.
Cognos :
1. MOLAP Reporting Tool.
2. u can create CUBE based on Business Req
3. Develop reports both ROLAP and MOLAP
BO->for management users adhoc reporting
cognose-->for production users-.standered reporting
210. how to test reports in businessobjects?
if we are using oracle as a data source we can use TODD (fornt end for oracle) to test the
report . Take the SQL statement from the SQL editor of Query panel and run the query in
the Todd .
In BO intially to check the report, we go for Integrity check . One button is there to check
the integrity,parse error, joins,loops and soon.
The second stage of testing involves testing the SQL query of the report if it uses free
hand SQL else we need to test the universe which the report is using.
If we use the query of the report in the TOAD it would show the same result. And the
integrity check is only for testing the universe and not for the report.
We would check the report by manually. As the report having n number of rows we
would not check for all and check it randomly. This is the way to test the report.
To test the report the simply write the SQL query and testit in the database, if copy and
paste the SQL generated by the BO in Report Panel and fires it in TODD then it gives the
same result. So to test report we need to manually write the SQL and then test it in the
database and compare whether the result is correct or not.
For your kind information, Integrity Check is not used for Universe testing and not for
Report testing.
211. What is a Universe?
Universe is semantic layer between data base and query panel.
A universe is a file that contains the following:
• Connection parameters for one or more database middleware.
• SQL structures called objects that map to actual SQL
structures in the database such as columns, tables, and database functions.
Objects are grouped into classes. Objects and classes are both visible to Web Intelligence
users.
• A schema of the tables and joins used in the database.
Objects are built from the database structures that you include in your schema. The
schema is only available to Designer users. It is not visible to Web Intelligence and
Desktop Intelligence users.
A Universe is a business-oriented mapping of the data structure found in databases:
tables, columns, joins, etc.
A Universe is a semantic layer between Database and end users.
A Universe 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.
A Universe can also pertain to a section within a department or just about any set of
organized procedures such as a payroll or inventory system.
A Universe consists of a set of objects, grouped by classes
A universe is a semantic layer which isolates the end user from technical issues of
database structure.
Actually it is a file which contains the connection parameters to database middleware.
It contains the structures that map to actual SQL structures in the database like columns,
tables.
A schema of tables and joins used inthe database.
Universe is a semantic layer that maps the data structure found
databases(tables,columns,etc)in business terms.
A universe is a file that contains the following:
1.Connection parameters for one or more database middleware.
2.SQL structures called objects that map to actual SQL structures in the database such as
columns, tables, and database functions. Objects are grouped into classes.
Objects and classes are both visible to Web Intelligence users.
3.A schema of the tables and joins used in the database. Objects are built from the
database structures that you include in your schema. The schema is only available to
Designer users. It is not visible to Web Intelligence and Desktop Intelligence users.
212. how will u create a report using oracle stored procedure?
u need to create a stored procedure using in/out parameter of a ref cursor. the parameter
of the proc should be in only. then create a connection to the database using middleware.
suppose u have created a proc on oracle 9i, then make the connection using oracle
client.mention the user name/password and the data base name in the connection.
then in the report section use the stored procedure as data provider and select the proc
using which you want data and generate the report.
this is a sample one
create or replace procedure proc_name(proc_cur in out
sys_refcursor)
as
begin
open proc_cur for select * from tab;
end;
follow his steps for Creating report using SP:
1-Select Data---New Data Provider--Stored Procedure
2-Select or define the db connection
3-Choose the stored procedure
4-Specify stored procedure as the data source
5-Define parameters
Use REF CURSOR with IN/OUT parameter.
Ref cursor is a cursor variable that points to any cursor,
mainly used for returning the CURSOR OUTPUT.
Eg:
CREATE OR REPLACE PROCEDURE BO_proc(proc_cur IN OUT
sys_refcursor)
AS
BEGIN
OPEN proc_cur FOR SELECT * FROM EMP;
END;
213. In BO module, you forgot all password even all user in business object,
designer, supervisor, general supervisor everything, how to you recover
your details?
You can change supervisor password first using below steps and then change all the
users passwords using supervisor.
Warning: Direct manipulation of the repository tables can cause damage to your
repository and will void your support contract. Do so at your own risk.
If you don't have a second general supervisor, you could try the following SQL run
against the security domain database:
Code:
Update OBJ_M_ACTOR
Set M_ACTOR_C_PASSWORD = NULL
Where M_ACTOR_C_NAME = <username of general supervisor>;
This will set the password for the general supervisor to null, and therefore the next time
you login, you will not need to enter a password. It is recommended that a password is
given as soon as possible via the supervisor module.
You will also have to set the status of the user login; otherwise even with a null password
Bo will not let you log in.
The status column is in OBJ_M_ACTOR and is called M_ACTOR_N_STATUS. If you
set this flag to 1 along with setting the password to null then you should be okay. If this
still doesn't work, make sure you have committed the database update
214. How to create derived Tables in BO 6.5 with columns from different
tables in the universe and how it has to be joined in the universe?
I have no idea about BO6.5 however I feel that creating Derived table must be similar in
both XIR2 and BO6.5.
-right click any where in Designer.
-select Derived table from Popup menu.
-A window will open up. Give the name of the derived table,
You can specify the SQL stmt here as you do in oracle(if you are using oracle DB).
Example:
Select BONUS.ENAME Ename, DEPT.DEPTNO, EMP.EMPNO from Bonus, dept, emp
where EMP.DEPTNO=DEPT.DEPTNO
You can specify the join in SQL stmt if necessary.
However joining the Derived table indeed is similar as joining a normal table.
215. How do u implement dense rank in bo reports?
Dense Rank is used for assigning a precedence or rank to each row in the result set
relative to other rows in the result set.
The DENSE_RANK function computes the rank of a row in an ordered group of rows.
Rows with equal values for the ranking criteria receive the same rank.
Eg :-To Show the set of sales people who make the top 3 salaries - that is, find the set of
distinct salary amounts, sort them, take the largest three, and give me everyone who
makes one of those values.
SELECT * FROM (
SELECT deptno, ename, sal,
DENSE_RANK()
OVER (
PARTITION BY deptno ORDER BY sal desc
) TopN FROM emp
)
WHERE TopN <= 3
ORDER BY deptno, sal DESC
/
DEPTNO ENAME SAL TOPN
---------- ---------- ---------- ----------
10 KING 5000 1
CLARK 2450 2
MILLER 1300 3
TT 3000 1 <--- ! (in
case of rank
JONES will have
3 and dense
rank will have 2)
FORD 3000 1 <--- !
JONES 2975 2
ADAMS 1100 3
30 BLAKE 2850 1
ALLEN 1600 2
30 TURNER 1500 3
216. What is aggregate navigation?
Aggregate Navigation is used to specify the incompatible objects.
Whenever we use Aggregate Aware we need to set up in compatibilities to work it
properly (so Business Objects knows what SQL to generate)
For example, there are 2 aggregate tables fact table by week and by day. If you set up a
measure as aggregate aware from both tables - total quantity for example, the select
might be something like: - Aggregate_Aware(sum(week_agg.qty),sum(day_agg.qty))
The week table listed first as this would be the preference. But as Business Objects needs
a reason to not go to the week_agg table, this is done using incompatibilities. For
example the Week Number dimension object would be compatible with the week_agg
table as it will link to it and the data is held at an appropriate level to report against it.
However the Date dimension object would be set as incompatible with the week_agg
table, such that when it is selected alongside the Quantity object, BusinessObjects knows
to jump to the next option in its select definition.
217. What are cascading prompts, explain with steps?
Cascading Prompts allows you to use values selected from one prompt to filter values in
another prompt. Series of prompts which will narrow the end user selection, select an
hierarchy and apply prompts.
Time hierarchy: year/quarter/month/week.
Take dimension objects year/quarter/week and apply a prompt on month.
Follow the same steps.
Cascading prompt means it is nested. It means we can apply the prompt like this.
region to country, country to state, state to city.
step1: select objects and double click. Then draw the region to query panel then select
operator and operand as select
new prompt.after type and drag the country to query panel
then select operator then operand as select new prompt. like
that we can create.then finally run query.then asks to enter
values
for region after enter the values for country.
WHAT IS A BO REPOSITORY
Repository means set of database tables, Business object store security information e.g
user, group, access permission, user type etc. , universe information e.g. objects,
classes, table name, column name, relation ship etc.and document information
ITS A SEMANTIC LAYER WHICH STORES THE BO USERS N THEIR PRIVILEGES
Repository means set of database tables, Business object store security information e.g
user, group, access permission, user type etc. , universe information e.g. objects,
classes, table name, column name, relation ship etc.and document information.
BO repository is an set of db tables which holds the metadata information. This bo
repository is divided in to 3 domains Security, universe, document domain. This
metadata holds all the information related to users groups their privileges...........except
the "supervisor" this is the super user of bo rep.the supervisor info is stored BOMain.key
which is stored in default home dir of bo.
Generally Repository is the Metadata
BO 5.0 Repository create/maintain 50 tables, they are distributed as follows
25 tables for Security domain
24 Table for Universe domain
1 Table for Document Domain
in 6.5.1 repository
25 tables in sec. domain
1 table in doc domain
31 tables in uni domain
it is a metadata
In BOXI R2, there are no separate domains like in BO 5x and 6x.
There is a single repository which stores the entire information about the users , objects,
repotrs etc.
Bottomline: There are NO separate domains for Security, Document and Universe like in
classic BO.
In BO Xi R2 here also we use the same domains. At the time of repository creation 8
tables will be generated.
Scheduling
This is documented in the help file.
To schedule an object
Navigate to the object you want to schedule.
Click the Schedule link for the object.
The Schedule page appears.
Select and specify the scheduling options you want to use.
To see the fields for each option, click the plus icon beside the option to expand the
options. For detailed information, see the following sections:
When to run a scheduled object
Database logon information
Filters
Destination locations
Format
Print settings
Server group settings
Parameters
Click Schedule.
1. COULD YOU PLEASE GIVE ME THE DIAGRAM OF BO 6.5
ARCHITECTURE OR EXPLAIN ABOUT THE TIRES?
BO xi r2 follows three tier architects.
1. Client (DI/Web I Crystal reports)
2. Application tier (Java / .net)
3. Database tier
2. EXAMPLE COUNTRY NAME IS LIKE INDIA/UK OR ALL IN PARAMETER
I SELECTED INDIA OR UK IT SHOULD SHOW ONLY PARTICULAR
COUNTRY DETAILS IN BO. IF I SELECT ALL IN PARAMETER. IT SHOULD
SHOW BOTH COUNTRY DATA IN DIFFERENT TABLES
use matches pattern option to solve your problem.in matches pattern ( select country
name or % for all). now if u select particular country name then corresponding data is
displayed else use % to show all data for country prompt
3. I have one report. Now i want to display that report as one row as one
color and another row as another color. The entire report i need like that
Alternating row shading can be done in deski. To show the different color in different
row
Create a New variable. put the formula =Mod(Rowindex(),2) in new variable.
click ok.
add this variable in to report Now create a Alerter and put 1 or 0 and color. Now you can
get the different color in different row.
4. can any body tell me how to create Hyperlinks in BO XI R2
1. Create a new Variable to be created as hyperlink,
2. Make it as Dimension.
3. Write the link where you want this to move after
clicking on it.
4. Save it.
5. USe this object in the report
6. Goto the properties of the object.
7. Click DISPLAY -> Read the cell Content as -> Select HYPERLINK.
8. Save the report close it and open it again, the variable will work as hyperlink in the
report.
5. I am trying to save the XI report to CSV format. the csv file not displaying
columns inorder. all the columns are misplaced. the report size is 12MB Can
any one tell me why the columns are incorrect position when XI report
converted into CSV format?
1. Make sure all the report headers, details section don't have any formula that may have
invalid expressions.
2. Try to position all the report headers and detail elements with similar size
andalignment
3. Check if you have any extra/hidden Textbox objects within the detail section.
4. I had similar problem, and had this problem only when the report is redered to CSV,
later i found that one of the formula i have which displays.." NO DATA FOUND" when
returns null or empty rows and this caused to misplace the column..
A::; While saving use the options in the CSV(options)like Text qualifier and column
delimiter
'Add objects to the folder' (id - 1) for 'Auto Loans' (id -2626). Please contact your
system or permissions administrator if you require this right
Ans:
The user donot have the right to "add the objects to the folder". please give the rights to
this user and try to save the report
6.what are the documentations u r created
We create many docs while creating the reports/ while designing the universe. We craete
LDD (low level design document) based on the HDD while designing/developing phase.
and also, UAT/Test plan/Regression test plan docs also should be prepare before
sending
the report/universe to the customer.
7. What are the errors u have faced in creating reports in business objects
and explain
some?
While creating the Reports mainly we face syntax/Computation/multivalue/Objects are
not compatible related errors.
8. Can any one tell me for business objects what we need to study means
some body told me that we need DW,ETL,SQL.... is this is necessary..?
If one must be an expert in Business Objects he need to have the skills mentioned below
- Oralce (sql)
- Datawarehouse Concepts
- Business Objects tools :
- Designer
- Desktop Intelligence
- Web Intelligence
- CMC
- Migration
- Report conversition tools
- Infoview
All these Business Object tools are the products of the Business Objects which come with
the product.
9. What is thin client And thick client..?
In BO, Thin client is WebIntelligence, where you just need the server path or the url to
access reports, whereas Thick Client is Desktop Intelligence, where u need to install BO
Full Client on your pc to access/create reports.
Ans
Thin Client means : exam - the user can access the detail form database directly it is call
as thin client
Thick Client means : exam the user can access the details from database thru third layer
10. How to check for a particular value from one column with the list of
values present in another column in Webi reports?
Easy one, save the webi report to PDF and search for the value in PDF. If it is duplicate it
will show otherwise not.
11. what is a filter?
A filter, as the name suggests, is used to apply a condition to get specific or "filtered"
data in the report.
a filter can be applied either at the universe level or at the report level.
A::::: Filter at the report level is nothing but "hiding the data".
Filter at Query panel is nothing but " filtering the data at DB/DW level"
12. When any new universe changes are deployed how does the end user get
the view of the new classes/objects added(apart from specs doc)?
when universe get changed, we do export the changed universe to enterprise server.
user gets the view of changed classes objects what ever we done at universe and
already existed objects which are not changed are viewed as same like before.
13. When N reports are scheduled for N users, How does the BCA process
/know to which user the report needs to be sent?
There is an option in business object scheduler in which we need to give the email id's of
the user who wants the reminder when the report has been refreshed...This is the way
the BCA will get to know about which users wants which report...hope this'll help..
14. 1. what is import wizard and its purpose ?
2. what is publishing wizard and its purpose ?
Import wizard is a tool that helps in migrating the reports from older version of BO to a
newer one. Generally, BO 6.5 reports are migrated to DeskI or BO XI R2. Though
migration of reports could be done manually. Publishing wizard is used to publish or
export a report into desired repository.
A:::::
Import wizard has many uses For converting older version reports to new version For
creating the BIAR file For sending or exporting the reports with in the organization by
using the cms name,user,pass word
Publishing wizard is used to publish or export the agnostic documents like pdf, ppts to
the infoview.
A::::
Import wizard used to move one environment another environment i.e., development to
production
suppose u have develop universe, report then u have compress these BIAR file after the
BIAR file sent production users then can convert to BIAR to actual files (universe,
reports) so that we can also use import wizard method.
2. Publishing wizard we can export locally reports to public folders in CMC.
15. I have 2 universes. that is u1 and u2. From u1,i created one report that is
r1. Now I want to give the connection r1 to u2 and at the same time delete the
connection from u1 to r1 ? How is it possible explain?2.How can i schedule
the reports in BOXIR2?
Ans:
can change the connection for the report r1.For webI reports in query panel on left side
we have query properties there we can change the connection of the universe to u2.then
it will map to the u2.
A:;
Suppose you have development universe(U1) and production universe(U2) then u have
develop first sample report based on U1 universe after you have move this report in
production system using import wizard then change universe connection U2 after it
works fine. if any changes objects in any of universe then you get error.
2.suppose you have admin right then u can schedule in cmc other wise u have schedule
right then schedule the reports.
A::
we can change the connection of a particular report in the report level option tools-
>view data->Browse of universe option, here we can change the connection of the
report and we connect to any valid universe.
16. Prompt is a function in BO, that is used to get report containing specific
data. Specific to what prompt values have the user entered. A prompt could
be given in the query panel while editing the data provider for the report. for
ex, if a prompt has been added in a column say "balance" ,and the prompt
asks for which date the user wants to see the balance, then the user can
either on its own put a value or he can also select value/values from the list
of values.
Ans:
prompts are the user interactive objects which will allow the user to enter the value
based on the value the query will be executed and the results will be displayed in the
report based on the prompt value, for eg:@prompt('enter the value for the
year','Á','class/object',mono,free)
By using this the BO will ask the user to enter the year based on the value of year the
query will be executed.
If he selects the 2001 then the year will be equal to 2001
17.Explain about derived tables?
Ans:
derived tables are logical tables in the universe. To reduce the query complexity and
better query performance or complex query we write in derived tables. derived tables are
nothing but sql queries. these tables can be used in prompts.
18. what is crosstab reporting, slice and dice and drill mode??
Ans:
Tabular reports is a 2D format and most of the operational/formatted reports will be
created in tabular form. Cross tab reports is a 3D format and most of the analytical
reports are created in the cross tab report form.
Slice and dice allows us to show and hide the objects, whereas drill allows us to drill the
data like drill up, drill down, drill through depending upon the user requirements. With
slice and dice, you change the position of the data like moving the data from rows to
columns. Drill mode allows you to analyze the data in different angles and different
levels of details.
19.what is the difference b/w star and snowflake schema in data ware
house?
Ans:
Star Schema : Star Schema is a relational database schema for representing
multidimensional data. It is the simplest form of data warehouse schema that contains
one or more dimensions and fact tables. It is called a star schema because the entity
relationship diagram between dimensions and fact tables resembles a star where one fact
table is connected to multiple dimensions. The center of the star schema consists of a
large fact table and it points towards the dimension tables. The advantage of star schema
are slicing down, performance increase and easy understanding of data.
Snowflake Schema :
A snowflake schema is a term that describes a star schema structure normalized through
the use of outrigger tables. i.e., dimension table hierarchies are broken into simpler
tables.
In a star schema every dimension will have a primary key.
# In a star schema, a dimension table will not have any parent table.
# Whereas in a snow flake schema, a dimension table will have one or more parent
tables.
# Hierarchies for the dimensions are stored in the dimensional table itself in star
schema.
# Whereas hierarchies are broken into separate tables in snow flake schema.
These hierarchies helps to drill down the data from topmost hierarchies to the lowermost
hierarchies.
20.why you create universe and creating reports based on that? why don’t
we go for crystalreports and generate reports directly? tell me the
advantages? please answer to this question.
Main difference is ROLAP (Relational OLAP) supported by BO and not by Crystal
Reports.
ROLAP meaning is you can try to generate the universe using SQL's from several data
Sources (whatever you call like SQL Server, ORACLE etc;).In Crystal Reports if you try to
add
more that one data source that's it!! the verify database option will be disabled(which
means it does not support)
A:The biggest difference is that Crystal reports are used for "canned" reporting while BO
is
used for adhoc reporting.
21. BO 6.5 is a 3 tier architecture. Tell me the names of the tiers?
1.Client Tier / Presentation Tier(User Interface)
2.Application Tier
3.Data Tier
22.What is the Drill filter and it's usage?
to use the drill filter by default to generate your report after to select on toolbar click >
tools menu > options >select Drill filter in drill toolbar by using in drill through section
>automatically u select one column given the right click > drill filter option will
available.
for Ex to take objects year,Q,M,City,customer,revenue i want only the year value to have
2008 only.u select Drill filter option automatically u will get your filtered data.
Ans:
Drill filter is a mode that allows you to break down the data and view it from different
angles and different levels of detail to discover what the driving factor is behind a good
or bad result
23. what is slowly changing dimension
Ans:
Slowly changing dimension applies to some cases where attribute for a record varies over
time.
For example a person called narmatha lived in one place (india). So the original entry in
the customer lookup tablelike : customer id :100 name: narmatha , country:India
At a later the person moved to UK
How should XYZ Inc. now modify its customer table to reflect this change? This is the
"Slowly Changing Dimension" problem.Slowly changing dimensions(SCD) is the type of
dimensions
which changes with respect to time or period.
Fo s ex: there is an table which has objects like Country City Employee id address .
Here for example the say the employee of employee id say e23321 is presently in
Hyderabad after a month he is relocated in Bangalore than we can say the address
dimension
is SCD w.r.t. time
We have 3 types of SCDs:
SCD-1
SCD-2
SCD-3
SCD-1:where no historical data is not maintained only present data is maintained
SCD-2:Where complete historic + present data is maintained
SCD-3:Where one time historic(say previous) data+ current data is maintained
24.what is aggregate awareness ? how do we use ? where do we use ?
Aggregate awareness: is the ability of a universe to make use of aggregate the tables in
a database. These tables have pre calculated data
USE:
you can use a function @aggregate_Aware in the select statement for an object that
directs a query to be run against aggregated tables This function can be used to speedup
the execution of the query and to improve the performance of sql transaction
25. 1. how do u connect one report with another ?
2. how do u generate reports from different data sources(ex: oracle, sql
server)?
3.how do u give the security to universe ?
In Business Objects web intelligence we can not connect one report with another .this is
possible with Crystal reports 'SUREPORTS' functionality.
In bo xi r2 Universe can be created using single data source.But while on creating
reports we can generate single report from different Universes which has different data
base connections by using 'MERGING DIMENSION' functionality.
In BO xi r2 we can not create reports using data base directly (eg:oracle,querys,xml)
because Universe is the ultimate data source to the web intelligence reports.
But using desk top intelligence we can generate reports using different data sources .and
also using Crystel we can do this.
Cooming to security of the Universe,security can be done universe level that is row level
security,universe parameters restrictions,object level security.
We give security to Universe by using Designer or cmc.
26. I am starter in BOXIR2.CAn anyone plz tell me the user identification
details to be entered at the time of login to designer/deski
while Login to designer you need to fill three user
identicative fields
1.User Name
2.Pass Word
3.Security Domain
User name and password can we created by the admins in General supervisor with
designer privileges. And in the security domain you need to specify the database to
which you need to connect it can be repository database
also.
27.Difference between drill by and drill across with example?
Drilling across: display different data by choosing other values from the drop down
menu. Drilling across shows totals for another value on the same level in the current
hierarchy.
28. can i use stored procedure in webi?
That was true in XIR2. As of XI 3.0, you can connect to a stored procedure with WebI
through universes. Simply create a universe on top of your stored proc with the new
data connector provided in this release.
29. Instead of cms which server you have to use?
BCA servers (Broad cast agent)
30. Tell me the difference between cmc and cms?
The Central Management Console (CMC) is included for full control over the BI
platform. In addition, specialized administration interfaces are provided when you
require administration of specific-user access, document creation, and server
configuration. This is particularly important in decentralized system management
environments where different people are responsible for different aspects of the
deployment. The result is a powerful, open, and complete BI platform that meets the
needs of end users while providing IT with full control over the deployment.
The Central Management Server (CMS) is the central platform service and is
responsible for maintaining a database of information about your Business Objects
Enterprise XI system. All the platform services are managed and controlled by the CMS.
The CMS also manages access to the system file store where the physical documents are
actually managed. The system repository database is maintained using the provided
MySQL database, or by using your preferred IBM DB2, Microsoft SQL Server, Oracle
database, or Sybase ASE . The database structure is automatically created when you set
up your Business Objects Enterprise XI
system or it can be configured on a different database if you want to move your
implementation to another environment. All access to the repository is managed directly
by the platform and management interfaces and by the SDKs. The CMS data includes
information about users and groups, security levels, Business Objects Enterprise
content, and services. The CMS also maintains the Business Objects Enterprise
repository, and a separate audit database of information about user actions.
31.How to create universe in business objects enterprise 11.5
in boxir2 to create the universe by using business view or Designer.
32. Difference between Decode and Case?
Decode: using for reporting purpose. and it is implemented by if stmt.
Ex: select decode(job,'CLERK','executive',job) from emp;
Case : implemented by if & else if condition. it is using pl/sql equality conditionality.
Ex : select case job='CLERK' then 'executive' else 'no' end a from emp;
it is also used for multiple columns & multi conditions.
33. Explain about MTD(Month To Date) and YTD(Year To Date) with one
example and where you use this in your project?
mtd means report from the starting date of the month and current date
ex:i want a report for the mtd august means
the report start date must be august 1st to today date(4 aug).same for the ytd.
where we can use means we can use sales and inventory its depends upon u r
requirement
A::;
Eg for the MTD report is select sal from emp where hiredate between
trunc(sysdate,'mm') and sysdate;
same for the ytd,qtd place yy or q respectively
34. how to hide the prompts?
i think show/hide object will select in designer or report level. i think in report level
show/hide object by using pivot tab, format table dialog box.
in designer level directly select right click object select show/hide option. selected
prompt object automatically done.
35.without creating the business view is there possible to create & generate
the Crystal reports?
yes we can create and generate reports by connecting to either universe or other data
sources like ms access etc.
36. how to connect one to one report? Explain with example?
Yes we can connect one report with another.......
By using merged dimension option available in reporting toolbar....
37.what is the use of merge option in webi reports? Explain with example?
we can use merge option in webi, as like synchronization in 6.5
EX: if u open one Dp & generates the report after u select another Dp u can link with in
2Dps same contains objects like In 1st
DP(Year,Q,Country,revenue),In 2nd
DP(Year,Q,quantity sold). --> Click Merge Option -->
automatically merge same type of dia objects. It is generated in one report.
38. how to connect the hyperlink in webi reports?
there are two ways to create a hyperlinks in a report
1. u create a new Hyperlink, open the webi & go for new tab, select Hyperlink option.
Hyperlink window will appear, in this window give name, Mainly u select URL path i
think
this is source location. this source location will be transferred into target locations(select
Folders or Categories).click ok
Then automatically Hyperlink will connected.
2. Create a cell in the report and then right click on it insert the url there and get the
hyperlink with the report.
39. How would I achieve Traffic Lighting in Business Objects
insert the pictures & colors automatically achieve traffic lighting in Bo
40. What is the purpose of @aggregate aware function? please draw, how
you use the @aggregate aware function
An aggregate table is summary table that dba build to execute querys faster.@aggregate
_aware is an function in bo which takes advantage of aggregate table when ever possible
else it redirects to original fact table.
syntax:
@aggregate_aware(sum(smallest_table),sum(medium
table),sum(biggest_table));
here smallest table is aggregate table because data is aggregated by various
dimensions. and big table is fact table.
41. What are the different types of Filters available in BUSINESS OBJECTS?
Filters Are Two Types
Report filter
Query filter.
Report filter:
Report filter Hides the data In report.
Its works on Microcube. (Its contain in Repository)
Query Filter:
Query filter Restrict the data from data base.
Its works on database.
42. What are the Different Data Providers support in Web Intelligence and
Desk TopIntelligence?
Web Intelligence support only Universe.
Desk top Intelligence supports different type of data providers.
1:Free hand SQL
2:Stored procedures
3.universe
43. What is Complex Reports?
Complex reports are the reports which pull up data from different sources. Complexity
also depends on the data model and the critical way the report data is going to be
generated.
44. There are two options to set "max number of rows fetched" from
designer,
1. Tools> Options
2. From universe parameters
What is the different between these two and why their values are different?
Ans:
In Designer
This is a useful feature to show you a sample of the data in your tables as you build
objects in the universe. As a default, Designer will present you with the first 100 values
in your database
45. while migrate bo 5.1 report into boxir2 ,what are the problems faced
1)5.1 stored data from repository level boxi u stored in folder type of options
2) provide RLS level in 5.1 supervisor will provide in boxi developer provided
46.how to create a derived table in designer? i need steps regarding derived
table
in universe designer right click -create derived table -give name for derived table.
it's displayed in the universe designer pannel.
mainly derived table used for we can create our own query.
like we can select only the particular tables in the deski while tracking the derived
table(it's based on the our query)
47.when will use compatible and incompatible objects?
compatible and incompatible objects will be defined when you create aggregate
awareness. This is one of the performance improvement technique at the universe level.
48. What is the difference between derived table and views? which one gives
better
performance?
a derived table is dynamic, virtual table that you create within universe structure. It
consists of set of sql statements that you create in designer and you can use it as a logical
table to create objects.
in the derived table sql set, you can put a select statement in place of table name in the
from clause. sql set can also contain embedded prompts and you can create joins
between embedded physical tables ,just as you can with other tables.
derived tables can be used in place of database views, aggregate tables, lookup tables.
by using derived table we are processing load from the report server to the database.
views are also virtual tables which are created in database level and can make use in
universe. but we can not create them in universe structure.
49. How to create predefined filters in B.O.
Pre-defined filters are created in Business Objects Designer where we
create/edit/append Universe. In the universe window, in the right hand pane is classes
and objects, by default the view selected is of dimensions, measures and details, to create
filters, the view must be changed to filters and use add object and select the required
where clause.
50. WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ?
In general the same index theory applies to DW as it is for any RDBMS. So we can have
one clustered index and several non-clustered indexes on a table. defining the index
depends on the need for the particular SQL. We usually define them on the columns
used in the join clause and in the where clause to facilitate the faster fetch.
51. i Have created the universe in which i have one table and different
derived tables from the same table i am supposed to create report from the
same universe which should display the duplicates rows, but all the time i
run the report i am not getting the duplicate rows i have checked the
duplicate report option too in report.. is there problem with universe or
report,..
This can be solved in a simple manner.. In Report just double click your table or right
click for Table properties.. In the General Tab just uncheck the option "Avoid duplicate
rows Aggregation". Hope you will get the desired results..
52. how to do Ad-hoc reporting ?
Adhoc report is nothing but an user friendly report. The end user can create their own
report like drag and drop the objects what they wants in report based on the business
perspective.
53 What is security level in BO ?
In BO 6.5 windows level, command level and row level these are securities and XIr2
Folder level and user level create in central management console
54 what is row level security in bo?
in bo 6.5 row level security restrict the rows in the table In supervisor level, click on
resource pane, select universe right click, on properties on, select row level how many
rows u want select that rows and apply ok
56 what are the disadvantages of alias?
alias is an duplicate of table name and it is closed path circuit, it may causes duplicate
reports on table by causing this type of error we can use alias, context in bos Aliases will
create complex in structure of the Universe
57 can we create aliases for every table beforehand? if yes what are the
disadvantages?
In the Designer you can create alias for the table. U had that option in menu bar.You
just select the table and type the alias name. This is used to avoid some looping and
trap problem.
u can create alias for very table but its better not create alias for fact tables. If
unnecessarily alias are created for every table the universe structure will be complex. so
more number of tables will be present in your schema.
58 I have a column contains a data like A,A+,A++,B,B++how u going to sort
their data?
using custom sort in report, where one can define the sort sequence.
59 who r the users in B.O.XIR2?
In BoXIr2 there are no standard or specific users. Once you install the product you will
get two default grous ie., every one and administrator. And one default user as
administrator. We can create our own users and groups. But all the users we create
should be in the everyone group including the administrator.
60 What is meant by ZABO and FC(full-client)?
This module of the application is hybrid of the thin client and the Full Client Modules of
Business Objects Reporting Module. ZABO stands for Zero Administration
BusinessObjects. This application uses the hardware resources of the client machine
for application level processing and communicates through the protocol defined for the
browser to use the server resources for processing External requests (like running a
database Query, creating a data provider to
access data.)
A:;;;
ZABO means Zero Administration Business Objects and this is 3-tier level architecture.
No need to install any BO software.
Full Client means 2 -tier level architecture we can directly connect to repository only we
defines key file and this Fullclient we need BO tools our local system also.
61. What is diff b/w Alias and Contexts in which situation we are using
contexts instead of Alias?
The main difference between them is if the loop is formed between 1 fact table and 2(0r)
more dimensions tables, then create an alias for existing dimension tables. if loop
constitute more than one fact table then in this case go for contexting.
A::;
Contexts and Aliases are means to resolve loops/traps in universe designs. Contexts are
used to specify which of the paths should be used when more than one path is possible
from one table to another in a loop. Contexts are used in the scenarios where two or
more many-to-one joins converge on a single table. Whereas Aliases are used to resolve
the loops by duplicating the table and defining separate paths when one-to-many join
links to a table which is again linked to another one-to-many join.
62 what is crystal reports? how to migrate them?
Mainly the source of crystal report is Businessview.it is generate the reports daily basis.
63 what happens if cardinalities are not resolved?
If Cardinalities are not specified between the tables i.e the relationship between the
tables
( 1-1,1-MANY,MANY-MANY)
We get more results at report level more than the actual result,like a Cartesian product.
We can't detect the Loops & Traps (Chasam & Fan) Which are mainly detected by the
CARDINALITIES option so it should be Identified.
A::::
cardinalities are called relationship, u given the tables relationship 1-1,1-many,many-
1,many-many relationship (which is suitable for that area) give the correct once check
the check integrity button
64 What is the difference between Thin client & thick client?
Thin client we can also called as Web Intelligence where as thick client also called as
desktop intelligence. The main diff b/w thin & thick client, in webI, we an create reports
using only universe but using DeskI we can create reports by using data providers are
XML data provider, VB application, universe, stored procedure, database, sap r/3 etc
A:::::
Thin Client is a browser based version, whereas thick client is a desktop based version.
In thick client, you have lot of functions and formatting options.
65 Can anybody tell How a report will burst into .pdf files?
Give File -> Save-As in PDF format.
66. Is import wizard, report conversion tool, report comparison tool,
security viewer ---- all r migrating tools. whether all the tools are available in
BOXIR2? ..
In BOXIR2
We have below tools only
Import Wizard
Report Conversion Tool
Repository Migration Wizard
A:::
Import Wizard used to migrate the reports/ users/ universe connection etc etc.
Report Conversion Tool(RCT) is used to convert the DeskI reports to WebI Reports
there is no Report Comparison tool, n Security Viewer present in XIR2
67.1.what is the use of migration.(converting one version to another)
2. what r the migration issues faced while migrating from Bo5.x to BOXIR2
n how 2 resolve it.
1) Each version have some license period and License for 5x end by 2007 december I
guess. Also some enhanced features available in the latest versions.
2) If u want to convert 5.x Deski to XI Deski just open the report in XI. Nothing to be
done extra. But its safe to have a backup of 5 separately. Then you can check the data by
running the reports in Both Versions. If u want to covert to Webi use migration tool
provided in XI. Here you might
face some alignment and formatting problem will arise.
68 what do u mean by variable functions ?
varible is reusable function, once create the varible,we can use n no of times
69 what is the difference between olap and oltp?
OLAP - Online Analytical Processing, which deals with analysis of data. It has to deal
with historical data too( for analysis purpose) Not updated frequently. If required bulk
update is allowed.
OLTP - Online Transactional Processing, which deals with transactions. For e.g.
withdrawals at ATM machines. It involves many transactions. The databases have to be
updated more frequently after the successful completion of a transaction.
A::
OLTP
* Is the E-R modleling,there are more concurrent users,
* It contains normalized tables so there is no redundancy.
* More tables,Joins and less Indexes,
* It stores daily transactional data
* It stores very less data
* It contains mainly current data
* INSERT,UPDATE,MODIFY can be applied on OLTP.
* Performace will be high
OLAP
* It is the Dimensional Modeling
* It contains Denormalised tables there will be redundancy.
* Less tables,Joins and more Indexes
* It stores operational data
* It contains Historical and Present data
* only SELECT clause is applied on OLAP
* It stores very Huge data
* Performance will be low compared with OLTP
70 what are the types of universes?
what is the difference between metric universe and simple universe? in what
context we use metric universe?
There is only one universe in terminology of BO, but there may be many situations
based on the usage, where we can classify the universes as-
1. Depending on type of data universe objects mapping
a.Ad-hoc (personal data) – The Universe created for a personal usage is called Adhoc
Universe and these are not shared with anybody else.The reports created using these
universes are called Ad-hoc Reports and generally users have the rights to store the
reports in the Inbox. Ad-hoc reporting is a user friendly
feature designed for all levels of users. Custom reports are created using queries.
b. Non Ad-hoc (corporate data) – The universe created for a corporate usage is
known as Non ad-hoc Universe these are sharable Universes and reports created from
these can be viewed by all the users.
2. In linking universes scenario
a. Core universe (Kernel or Master universe) – The Universe created and used
with another universes for the reusability of the components.
b. Derived universe – The Universe created using Core
universe and there own required components.
3. Depending on universe parameters.
a. Secured universe.
b. Personal universe.
c. Shared universe.
71 in universe perameter u dont give the option multiple contexts ,what is
the impact in report level
By having multiple contexts you can utilize the 'multipass' sql feature. 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
synchronized in the report.
72 in report level u find from which context u use, why it appears, what is
the reason, how u resolve in report level
When a query is ambiguous, BusinessObjects or WebIntelligence displays a dialog box
that prompts the user to select one of two contexts. When the user selects a context, the
corresponding tables and joins are inserted into the SQL query.
This should be resolved at universe level by selecting proper options in universe
parameters>SQL>Multiple Paths
73 main purpose of aggregate awareness(not include make possible of use
of aggregate tables)
Aggregate tables are used in the schema in order to improve the query performance. It is
implemented by using @aggregate_aware()function. these tables carries precalculated
aggregates(measures).it will improve query performance, so we will get data fastly.
http://www.dwoptimize.com/2007/09/aggregate-awareness.html
Aggregate Awareness is used to avoid having an object multiple times, in different
classes, for the fact table and the aggregated table.
74 what is isolated joins in check integrity
Isolated join is the join which is not included in any of your contexts, so you are getting
that error.
Solution :
First of all find what are all the joins you left with out including in any of your contexts
and join them to any of the context which you think appropriate. Then go for Integrity
check.
75 what r the disadvantages in boxir2
group values function,available in 6.5 but XIR2 is not available.
76 How to execute the MACRO through Infoview?
running the VB macro as full client report by invoking DeskI using a batch file. This
batch file can then be scheduled in Infoview too.The batch file looks like this Code:
"C:\Program Files\Business
Objects\BusinessObjects Enterprise11.5\win32_x86\busobj.exe" -user "administrator"
-pass "passwd" -system "servername" -auth "enterprise"
-nologo -blind -document "C:\temp\VB_BOXI.rep"
This will invoke the DEskI application and run the .rep file containing the macro. And it
can be scheduled as program object in CMC/Infoview.
77 Is it possible to generate reports without having knowledge of the
Universe structure?
yes, we can run the report without any knowledge of universe structure.
78 As im new to BO, tell me
1.How to do migration from BO6.5 to BOXIR2?
2.whats the difference b/w BO6.5 to BOXIR2.
3. what is the way both BO 6.5 n BOXIR2 file storage varies.
1) To migrate the bo 6.5 to XIR2:--
a) open the migration wizard
b) select ur source location(Here give ur BO 6.5 doc)
c) click next
d) select ur destination location (ur BoXIR2 environment)
e) select the users or admin or specific users
f)click next
f) click ok
the above conditions will applied ur 6.5 document will
migrated into ur boxir2 environment.
A::;;
2.....i think so many differences are there
1. 6.5 is three tier Architecture and XIR2 is multi tier/Five tier architecture
2. 6.5 is database concept/xir2 is file repository concept
3. this is corba architecture / xir2 service orient arch.
and etc..
1... entirely different from xir2
6.5 profiles are general supervisor supervisor, designer, supervisor-designer, user,
versatile user xir2 in everything manage by CMC
3..... 6.5 we can create repository that file stored by *.sdlc folder xir2 when u r installed
by default create by repository
79 What is the diff between break and section
break removes duplicates and section appears outside the grid.
80 what is master-detail report
Master-Detail report allows us to display the result in Section wise. It splits large blocks
of data into sections. It minimizes the repeating values. We can have subtotals also.
A::::
Yes. It displays the data section wise. If you have the following in a report, for
e.g.Country, Store, Sales, you can change it into a master detail report country wise by
dragging and dropping Country as a section when the cursor shows the text 'Drop here to
create a section' you can see the data country wise.
81 wat is the difference between full client report and thin client report? wat
is the difference between desktop intelligence and web intelligence?
Full Client reports are created using BO reporter which use BO two tier architecture
however Thin Client reports are webi reports which are created using web intelligence
and use BO 3 tier architecture to process.
82 can anybody tell me how many classes where there and objects in each
class
That depends on your Business needs. class is nothing but a views from the database. so
your object count will depend on that only. so we cannot say aout the classes and object
count
83 how many user were there
what exactly is your questions, like in my environment their are 1500 Business End
Users and 4 report Developers and Two Universe Designer and one Administrator.
84 Can anybody tell me about issues faced while creating universe.
loops, connections to the data base, all these i faced while creating the universe
85 Is it possible to develop reports without Universe access?
This is possible only in deski reports not in webi.
to create reports data source can be personal data file or free hand sql or universe in
desktop intelligent.
in web intelligent data source to create reports is universe.
in crystal reports we can create reports using different data sources other than universe.
86 Can We customize the Business Object infoview in BO?
Yes. Through the CSS files located under
programfiles\businessobjects\Tomcat55\webapps\InfoViewApp\res, if you were editing
the look and feel of InfoView, for example.
87 how to solve #multivalue, #syntax, #error. iwant complete solution
process in practical wise?
practical wise:
#Multivalue :- this error will occur in 3ways
1) #multivalue in aggregation
2) #multivalue in breaks header or footer
3) #multivalue in section level.
1:-- the o/p context not include i/p context its situation this error occurs.
Ex: in a report i have year,city dia's & Revenue measure is there.
=<revenue> In <year>
The above condition will to run the query getting revenue column #multivalue error
occurs.
solution: cilck the formulabar in view menu select the error containg cell, edit the
formula to write below condition.
= <revenue> In(<city>,<year>) In <year>
The above formula will run correct data will appear in the report.
Note: the above condition by default it will take agg "sum" function.
#syntax:--
the variable in the formula no longer exist in the condition.
Ex:- <product price> * <quantity sold>
The above condition will run this error will occur.
Solution:- Click edit dataprovider--> new object will be need --> select error cell -->
edit formula --> click ok.
#error:--
the variable in the formula is incorrect. This error will occur.
solution : go for data menu --> click variable
select the error containing a cell --> copy the formula in edit menu --> paste it in new
cell --> go for formula bar in view menu --> --> take the first error containing cell --
>edit the formula --> repeat the above steps.
88 how to optimize the query performance in b.o?
select the limit size of execution is increase button in universe parameters
89 i want to hide a chart in reporting level? i want to hide a prompt in
designer level?
Chart can be hidden in Desktop-Intelligence as below.
Select the chart -> Format -> Chart -> Appearance -> Check the Hide block check box
and your chart is gone. You can also conditionally hide your chart by just typing the
condition in the text box provided below this check box.
90 can anybody explain me in detail what is the difference between desktop
intelligence and web intelligence in detail?
Desktop Intelligence is full client. It is 2 tier architecture, where Web-I is 3 tier with
Enterprise server in between. Desktop-I and Web-I differs in some syntaxes.
E.g: []in Web-I replaces <> in Deski.
Also scheduling can be done directly in Web-I (Xi R2), where as we need additional
softwares to schedule Deski reports.
You can view the Deski reports in Web-I, but not Web-I reports in Deski.
91 What is the difference B/W Variable & Formula? what is meant by
incompatible object error in the report level?
1.Whenever we execute the formula , the result will be stored in the variable.
2.When the contexts are not properly defined we will get the error as incompatible
combination of objects.
92 In a report i want to fetch teh data from 2 data Providers.
which condition will satisfy to link the 2 data providers.
ex: Q1 have columns A,B,C Q2 has a X,Y,Z columns.
requirement is like i want to get all the columns from those 2 tables in
report level..like A,B,C,X,Y,Z in a single report.
in BOxir2 wise it is possible. would u have base uni & dervied uni's. i think ur
requirement is solve by go for deski, select "datamanager" --> click "link to" Option it is
possible.after use using "combining query" option & just select "union" operator wise ur
query is solve.
anotherwise u go for webi, select "MERGE" option it is possible.
otherwise, ur requirement is not possible. because ur columns names are not maching.
A::::
in BOxir2 wise it is possible. would u have base uni & dervied uni's. i
think urrequirement is solve by using "combining query" option & just select "union"
operator wise ur query is solve.
anotherwise u go for webi, select "MERGE" option it is possible.
otherwise, ur requirement is not possible. because ur columns names are not maching.
u go for deski, select "datamanager" --> click "link to" Option it is possible.
A:::;
You can do a trick. Suppose u have different objects in two data providers (lets say dpA
and dpB),dpA have product related objects for example product code, product name etc
and dpB have customer related objects.U drag a object from a dp, lets take dpA.Now
when u try to drag a object from dpB u will not be able to do that. For this , go to the
tool bar->view data->definitions-> link the object u want to drag(say customer name
from dpB) with any object from dpA ->select Ok.Now u will be able to drag the customer
name from dpB. U will see that data displayed in the report is not correct.Now again go
to view data and unlink the objects->select Ok.Now u will get the correct data in the
report.
93 What is meant by For each For all function. In which case we use the
option in BO?
FOR EACH-add all objects to the contex for all-delete all objects from the context we use
FORALL for summary purpose and FOREACH for detail purpose
A::;;
forall : -- while using measure objects will inserted(o/p context)
foreach:- while using diamension object will inserted (I/p context)
these above 2 conditions are using in calculation context.
= sum(<revenue> foreach(<year>,<city>)) forall(<year>)
94 i want to take a report 10 records per page. How to take it? is there any
paging option in BO?
i think u go for "format tables" option.
95 in xir2 how to send reports to end user
You can send reports to any user via the scheduling options for a report. The report will
then run as per the scheduled options and when successfull, it will send a copy to the
user's email address or inbox (in BO), depending on the options selected.
96 how we send repotrts/documents to end user
You can send reports to any user via the scheduling options for a report. The report will
then run as per the scheduled options and when successful, it will send a copy to the
user's email address or inbox (in BO), depending on the options selected.
97 what is diff between webi,deski,infoview
difference between web intelligence, crystal reports and desktop intelligent
the main difference is that:
when we working with the desk I. we need BO software in our local system. there is a
possibility to work with flat files using free hand SQL.
in web I. not needed. we can connect to server system through web address of BO. u
should work with only existing universes.
98 can i link two Universes having with different connection
I do not know about the linking of universes with two different connections. But the
linking can be done at reporter level by linking of data providers. We can link the
dimensions and measures of two different universes with 2 different connections by
linking the data providers built upon them.
99 what r the types of joins universe supports
Universe supports these joins mainly:
1.Equijoin
2.Non-equi join
3.Theta join
4.self join
5.s/c join
6.Outer join
7.Inner join
100 what r the universe connection types?
Shared connection
secured connection
Personal connection - used only stand alone system.
101. what r the advantages of creating the universe?
The main fact behind creating universes is "Business users need not have strong SQL
back ground. But sometimes they need to develop reports". In such case the
importanceof universe comes. The universe designer needs to have a strong SQL back
ground and he/she will create universe which in turn has objects like dimensions,
measures, etc,
The business user then uses these objects just by dragging and dropping in the query
editor pane. Dragging, dropping and running is more easy for him rather than writing
SQLs by his own.
102. when and where alias and context are used in resolving a loop.
when a schema contains a loop u should create alias table. alias concept not only for
loops. we can also use in fantraps.
coming to context :when u run two sql statements as a single statement we will go for
context detection process.
in traps we can choose contexts. traps are two types chasam trap and fan trap.
these traps are situation oriented relation between multiple tables like this:
--------------------------------------0-
chasam trap :1:M:1
fan trap :1:M 1:M
really if u want o see the context how to look tools->automatic detection----.detect
contexts in BO XIr2
103 u drag 2 sources from 2 diff data providers, how we take these 2 sources
into 1 singlereport, how we give the link these 2 sources
You can do a trick. Suppose u have different objects in two data providers (lets dpA and
dpB),dpA have product related objects for example product code, product name and dpB
have customer related objects. U drag a object from a
dp, lets take dpA. Now when u try to drag a object from dpB u will not be able.
For this , go to the tool bar->view data->definitions-> link the object u want to drag(say
customer name from dpB) with any object from dpA ->select Ok. Now u will be able to
drag the customer name from dpB. U will see that data
displayed in the report is not correct. Now again go to view data and unlink the objects-
>select Ok. Now u will get the correct data in the report.
104 draw the architecture of bo
105 why we use aggregation in lower level
106 what is merged dimension in 6.5 and webi
in 6.5 there is no concept of merged dimension. in xi r2 they introduced...ie to
synchronize the multiple data providers in webi by merging them on common
dimension...
107 If any one Deleted the BOMain key by accidently,is any possible to get
back that Bomain key. if possible please send some steps.
for first time we launch supervisor we have to choose set up configuration n that we must
choose between default or custom installations. we have another option is there that is
run a safe recovery we have to choose this option for 1)the location of the security
domain has been changed 2)the key file has inadvertentlybeen removed, renamed or
damaged
108 aggregate awareness in detail?
Aggregate awareness is a term that describes the ability of a universe to make use of
aggregate tables in a database. These are tables that contain pre-calculated data. You can
use a function called @Aggregate_Aware in the Select statement for an object that
directs a query to be run against aggregate tables rather than a table containing non
aggregated data.Using aggregate tables speeds up the execution of queries, improving
the performance of SQL transactions. The reliability and usefulness of aggregate
awareness in a universe depends on the accuracy of the aggregate tables. They must be
refreshed at the sametime as all fact tables. A universe that has one or more objects with
alternative definitions based on aggregate tables is said to be “aggregate aware”. These
definitions correspond to levels of aggregation. For example, an object calledProfit can
be aggregated by month, by quarter, or by year. These objects are called aggregate
objects. Queries built from a universe using aggregate objects return information
aggregated to the appropriate level at optimal speed.
109 plz tell me about BOmain key in detail?
BO Main key will store the address for repository of the security domain.
General path for BOMainKey
C:\Program Files\Business Objects\BusinessObjects Enterprise 6\LocData
110 how we transport universes from business objects 6.5 to BOXI R2?
BO XI R2 provides one Migration tool along with its Reporting tool kit. Using this tool
we can migrate universes from a lower version to a higher version.
A:;
BOXI is later version than BO 6.5, so all features available in BO 6.5 are already available
in BOXI along with few extra features. Universe developed in BO 6.5 will work with no
problem in BOXI. The simplest way to transport the universe is save the universe in BO
6.5, and open the universe in BOXI and save again in BOXI.
A:;
It is better to say upgrade or migrate other than transfort. We can do this by using
BOXIR2 of IMPORT WIZARD Module.By using Import wizard,we can upgrade universes
and reports and connections from BO5.x ,BO6.x versions to BOXIR2
111 how to link 3 fact tables
Fact tables are tables with lots of measure values and are uniquly identified by a key, also
a fact table can have a foreign key. For Example custumer fact table is connected to loan
fact table via customer_id, and each record in loan fact table is uniquely identified by a
primary key on cod_acct_no. Similarly customer table can be connected to Savings fact
table through customer id.
112 if there are 2 hierarchies 1 is a-b-c and another one is a-c which
hierarchy b.o takes while we use drill mode
Hierarchies will be used in drill reports. We will select Drilling levels in Query panel.
There are 4 types of levels are there.
1.level
2.level
3.level3
4.custom level
drill down --->navigation of levels, like one by one
drill through--->selecting new level of hierarchy at the time drilling
drill by--->directly selecting required drilling level
so, from your point a-b-c is drill down a-->c is drill by
113 rows are hide in deski, what is process, i know hide the column it is
fulldown menu,format>table format > pivote> hide button
Rows can be hide only when the break is applied on a particular column using...
Format-->Breaks-->Fold
114 what do u mean by merged dimensions in Business Objects
merged dimension is nothing but to synchronize the data from different data sources
with a common dimension
A::
Web Intelligence allows you to synchronize multiple data providers in the same
document. This allows you to build reports which synchronize data from multiple
sources. When you synchronize queries through merging, you can include report objects
from different queries in the same report block.
115 if we run a report it is taking so much time to display the report, what to
do to increase the performance of the report
if we run a report it is taking so much time to display the result to be followed as :
1)use aggregate tables(contains pre calculated data)
2)pre defined conditions, LOV's
3)in a real time scenario query contains a large if statements. some times we need to wait
max of 30 min to run particular statement...not all
A:;;
If the question is not pertaining to query optimization, I would prefer not to use much of
formatting on the page. One can keep the report without any page formatting as this
would take a very long time. Try not to use the slice & dice panel as this would also take
considerably long time
116 how to improve the performance of the report
to improve the performance of the reports we have multiple ways in my view. for
example
1)generate LOV for required objects
2)use aggregate tables in universe design
3)use pre defined conditions and formulas.
4)check context (if there resolve it)
5)check loops (if there resolve it through alias table)
if u did u all these at universe level, when u generate the report at query panel level
automatically performance will increase.
117 What is meaning of fullpath client in business objects?
Ans:
full path client is nothing but a info-view
118 how to sort on a particular object, that object is not picked up while
creating the cross tab but we need to sort on the object that is not in the
cross tab????
Select the object in the cross-tab, sort the object and then hide the object.
A::
Go to Format--Sorts then click on Add we will get all the objects select the object and
apply it which is not in the Crosstab report
119 how can we retrieve particular number of rows from data warehouse?
for EX: my report want to displayed with 10 records in a report?? how
While creating the report you have an "OPTIONS" tab at left hand side bottom. Please
open that and set the number of columns you need to display in the report.
A:;
We can do this in 2 levels in BO.
1.In Universe parameters, set the no of records for your requirements. But I will apply to
all reports.
2.We can do this to a particular report in the query panel. Select OPTION button(Left
side down placed) and set the no of records how many you want.
120 what is custom sorting? how we can do this explain with procedure???
hi,custom sorting is nothing but sorting as per our requirement suppose months like
jan
feb
mar
apr
may
jun
jul
we can display first jan next mar next jun for these purpose we can use custom sort
121 how can we overcome by loops? and also is it possible ,one user can
different universe
By using Alias and context
Alias- loop contains one look up table
Context-loop contains more than one lookup table
122 how do we apply sql query on selected variables?
if u drag the variable, automatically sql query will be added.
or
if u select new variable, one window will appear. in this window u select the
qualification(dia or detail or measure) in definition window. go for formula tab, window
will appear here write a formula by using objects & operators.
if u have any errors or not , check once parse condition. Click apply > click ok.
A::::
first of all u have to know your requirement as per requ. u can drag and drop the
variables in your objects results and conditions panel in deskI. on top we have icon with
Sql named .simply click on that u will get a whole sql query .
A:::;
If we drag the variables automatically SQL query will added and if you want to modify
that query go to query panel-> click sql at the top and there is one options Do not
generate the sql query before running just click that option
and modify the query whatever you want.
123 what are the differences between web intelligence reports and crystal
reports ?
bo reporting is preferred for dwh, where as crystal is preferred for transaction database
which involves lots of queries and joins
A::
webI : it is ad-hock reporting.
we can change the report as per requirement
for management quick decisions. for management
Crystal Reports:
it is standard reporting
daily transactions(example bank ,shopping malls)
for production users.
124 when to go for alias and when to go for contexts
When you have multiple fact tables then we have to go for Contexts, there is no other
go. In the other situations we can use aliases.
A:;;
We use alias or context when ever we encounter a loop .If there are more than one fact
table use a context or if only one fact table use alias
125 what is fantrap?
Actually FAN TRAP is a problem that occurs in Universe Level. Loop occurs while we
design the universe.
Two Types of Loop Problem:
1) FANTRAP PROBLEM solved by ALIAS METHOD:
Definition: Two One-to-many table link eachother is in turn linked another one-to-many
table.
2) CHASM TRAP PROBLEM solved by CONTEXT METHOD:
Definition: Two Many-to-one table converges on one single lookup table.
Loop can be detected while INTEGRITY CHECK is done. An option is there as "Check for
LOOPS" available. By "Detect Loop" we can choose what to be applied for solving the
loop.
A:::
fantrap is the one of the concept to solve join problems. the table contains 1:m
relationship parallel it is fan trap.it is coming up by situation
what is fantrap and chasmtrap ?
Fantrap means one-to-many joins of the tables it is detected by visual analysis. By using
fantrap problem is many rows than expected. Through aliases, context and check
multiple sql statements for each measures option we can solve this problem.
chasm trap means two or more many to one joins converge on to a single lookup table
chasm trap means many-to-one and one-to-many join relation converge on to a single
lookup table, because of this we get incorrect results i.e., Cartesian product, We will
resolved by using some times alias, some times context,
some times shortcut join and check multiple context for each measures option.
Fan Trap:
Fantrap means one-to-many and one-to-many join relation of the tables it is detected by
visual analysis, because of this we get incorrect results i.e., Cartesian product, We will
resolved by using some times alias, some times
shortcut join and check multiple sql statements for each measures option.
126 how do u migrate BO 6.x to XI ?
migration is done with the help of import wizard in xir2. other wise u can manually
migrate universe or report. when u try to open a 6.5 or 5x version report or universe they
will automatically updated to xi and they cannot open again in the previous version once
they converted to xi. that is why it is better to take a back up before migration.
A::
when u work in latest version of BO .old files automatically migrate to new version.
example: while u open 6.5 version reported in Xi r2 first of all u have to import it.may at
the same time it will ask u a msg like (override the current version of BO)
127 what is dashboards? what is metrics?
Ans:
dashboards is nothing but collection of information
metrics are system of parameters or ways of quantitative and periodic assessment
process that is to be measured these are used to track trends and productivity
metrics are mainly used for analysis purposes
A::
my infoview is a dash board or portal page that allows you to display the documents or
web sites you most frequently access.
we can select info view option and select frames templates and save the content inframes
as your interest. it can be web address or report .once you save dash board settings. you
can view it by clicking info view button.
128 IN BOXIR2 creating universe by using Designer and Business View.
What is the difference b/t two?
Business view is used to create a lovs in crystal reports this can be schedule to refresh to
daily. business view can be used by only in crystal reports a universe can also be a source
for crystal reports as well as webintelligence in business view we can connect to multiple
database and create a business view, it is not there in universe
A:::
In business views we can create universe by connecting more than one database at a time
and generate repots. In designer we can create universe by connecting to only one
database at a time and generate reports.
129 why do we use crystal reports rather than webintelligence reports ?
crystal reports :we use most of the times daily basis. we have to know the day to day
status. example daily transaction of the persons in a bank. end of the day whole sales
reports of the same branch. is for production .it is a predefined template
web I: it is only for management users. they want to take own decisions for their own
like take a sales mall giving offers like end of season sale and clearance sales occasional
offers
A::;
Webi report- it is ad-hoc report, we can modified as per request and analysis the
reports.
but in Crystal reports--> we cant not modify the reports and it contains daily bases i.e.,
day to day information .example: shopping mall and customer details in bank
A:::
Crystal Reports can be when more customization of the report is required. The
complexity in creating Crystal Reports is more than the Complexity of WEBI.
Crystal Reports formatting requires more effort and the look and feel of export may
require some modifications to fit users requirements.
WEBI can be used for Power Users who can design their own reports. However The
flexibility on customization of the reports is limited. Since WEBI is in Columns and
Tabular format, there is not much formatting effort required.
130 How many universe dfi you create if you have 2 years of experience in
BO
There's absolutely no correlation between the two, meaning professionals with same two
yr exp might have created different no of universes, few might have just maintained old
universes whereas created lots of reports on those old universes.
131 I am having an report there four columns and n number of rows if i click
any one cell the report want to go to another report page which gives the
detail of the cell which i click
This is hyper linking. The cell can be defined as a hyperlink and parameters can be
passed to the destination report to open.
132 What are the join problems comes appart from loop,chasm & fan Traps
133 What are the Errors in BO Pls Explain with Examples
Errors:
1) # Multivalue
2) # Errors
Errors in BO
#Multivalue: When any variable yield more than on result
#Syntax: Occurs when we remove any object from report that is used in the formula of
any variable.
#Error: Generic Error
#Incompatible, Context Error: Generally occurred when we context is not properly
defined for calculation and when we try to place two incompatible objects in one table.
#Div: Divide by Zero
134 How to Schedule the reports in Xi R2
You could see the option of scheduling in infoview, right below your report. otherwise u
cud schedule it from Central management Console
A:;
Using Central Mgt Console.
A::
in web intelligence we can schedule report as well in cmc. once you have written the
query and run it. and save it to folders. and open that folder to schedule the report. In
cmc you have an option to schedule the report.
135 Pls Explain about the different between 6.5 & Xi R2
B.O 6.5:-- > 3tier architecture
> Rep created after the installation
> In Webi wise :-- > There is no alerter & There is no merge option
>
In 6.5 Contains 57 tables are there
> In security level wise also some changes are there :
> in supervisor access security services option is there.
>In 6.5 There is no Cascading prompt.
> Here separate Supervior & B.C.A
BOXIR2 : Designer wise-- > directly to restrict data in
designer level. > New feature is Cascading prompt
Webi wise : > here alerter & sub alerter also possible
> Merge Option is also possible
> BCA + Supervisor combined in CMC.
>doc domain & uni domains are located in form of folders
> here secured & Saved in folders & categories.
> Scheduled directly in Webi.
136 Hi any done business objects certification. I am expecting some help
from them.There are three levels in Business Objects Certified
Professional(BOCP)
1.SA 210
2.SA 310
3.SA 410
137 how to restrict null values in webi report?
I believe you can define a formula like below Not IsNull(object). This formula should
bypass all records that has null values. There might be some other ways too..
138 any body can give hierarchy of business object...i mean who will see
reports after reports developing is finished...then next....
designer we design the universe and on the top of this table's data we generate reports in
WEB INTELLIGENCE. any non technical person can just see the reports to analyze the
data.
139 I have 2 structures in universe, but i can't link the structures b'cos no
related columns,so what i have 2 do to link dat and if don't link them can i
get data of 2 structures in the report that i run?
YES,YOU CAN RUN THE BOTH STRUCTURES IN A UNIVERSE WITHOUT LINKING
THEM.
A:::
yes we can link both the universes no common columns are required.
140 what are the debuggings in the business objects?
141 how to do scheduling in desktop intelligence in BO XI R2
To schedule a Report first you to export the report to the Administrator and select the
Folder then select the object and select schedule and you will get the choice to select like
once, on demand , weekly, monthly so on.
A:::
Once the Report is saved, then click on file, go to Export, and export the export which
you want. Once the report is exported then a small dialog box appears which shows that
Exporting is done successfully, then save ok. Now go to Crystal Enterprise (Infoview) and
open the report which you exported earlier in Desktop Intelligence. Click on that folder
and you can see the Report over there. Then from there we can schedule the report like,
daily, hourly, monthly, qtrly, yearly etc.
142 what is difference between folders and category ?
folders: folders and subfolders are used to organize documents
categories: categories are a way to classify your information
for example, you could place your financial reports and documents into a folder name
finance and you could classify or tag your reports that deal with specific financial matters
as payroll, accounts, payable and accounts receivable
A::
Folders : ->are used as containers for documents to store and organize information
within the system.
->folder Can hold many documents. A document can only belongs to one folder.
However you can create shortcuts to documents and place the shortcuts in other folders.
Categories:->Are used to tag documents in a meaningful way to classify them for
organizational purposes.
->Allows users to view documents across the system because a category is not
constrained by the document's storage location.
143 linked universe ?
Concept of linked universes is based on inheritance. You can specify your common
classed and objects in Parent universe (Kernal) and then link this universe in child
universe (Derived Universe) to make use of these classes and objects. In Derived
universe one can add their own tables, classes and objects. However linking universe
does not link following...
->Parameters->contexts->Aggregation
A::
in real time scenario we will work with linked universe. here same data source and diff
data source is not a issue. we need to fetch max 15 to 17 tables in single universe. more
than that u will create another universe and link it.
file-->parameters –links
144 where are objects are stored ?
objects are created by universe they are categorized by class. but these objects are stored
in the universe .when we export universe to repository universe is exported with all
objects and join every thing. but objects are in universe and universes are in repository to
share with other users.
145 how do you share the universe ?
Export a universe in a Folder and then give rights to the users to the folder whom you
want to share the universe
147 how do you give security to universe ?
We can secure the universe by applying security restrictions through Universe Designer.
We can apply following types of security restrictions on Different users:
1.Object Restriction
2.Row Level Restriction.
3.Table Mapping.
4.Connection Restriction
148 what is zero client and thin client ?
Ans:
Zero-client viewers do not require client-side software to be installed or downloaded.
Instead these viewers display the reports as DHTML.
Thin Client Viewers require components to be downloaded and installed on the clients
computers. These client viewers offer better report fidelity but can require more
administrative overhead.
149 what is variable ?
Variables are used to prevent the same computation being performed several times as
the variable allows you to store the values so that they can be used later. A variable
represents specific data or a value, and acts as a placeholder for that value. Unlike a
constant value, which is fixed and unchanging, a variable can be repeatedly assigned
different values. You assign a value to a variable and the variable maintains the value
until you later assign a new value. Because of this flexibility, it is necessary for you to
declare variables before you use them. Variables can be treated as a normal attribute,
that is, it can be a source or target of a transform
150 what is fantrap ?
A fan trap is a type of join path between three tables when a “one-to-many” join links a
table which is in turn linked by another “one- to-many” join. The fanning out effect of
“one-to-many” joins can cause incorrect results to be returned when a query includes
objects based on both tables.
151@prompt('message',['type'],[lov],[mono/multi],[free/constraint])
what is Constraint?
free refers to free input as opposed to constrained, which means that the end user must
choose a value suggested by the prompt
A:::
Free Means, User can either enter value or select value from LOv. Constraint Means,
User can n’t enter their value, they should select value from LOV
152 what is a Micro cube?
A cube contains data in multi dimensional analyzed format. And it's components are :
1) Measure / Fact :- It's an object which is been analyzed.
2) Dimension :- It's an object with respect to which we perform Analysis.
3) Detailed :- It's an object which provide extra information about a dimension. in
BOXI A cube is called Micro Cube.
A::;
Micro Cube is a processing Unit. It Composed facts & Dimensions & measures.
Micro Cube is cleared by using "Purge" Option.
153 How to Analyze 'Join' problem and which method is the best to resolve
that
join problems can be analyzed by doing check integrity& "Detect joins " option also.
To solve the join path problems using cardinalities also
154 how will u create a report using oracle stored procedure?
Creating report using SP:
1-Select Data---New Data Provider--Stored Procedure
2-Select or define the db connection
3-Choose the stored procedure
4-Specify stored procedure as the data source
5-Define parameters
Use REF CURSOR with IN/OUT parameter.
Ref cursor is a cursor variable that points to any cursor,mainly used for returning the
CURSOR OUTPUT.
Eg:
CREATE OR REPLACE PROCEDURE BO_proc(proc_cur IN OUT sys_refcursor)
AS
BEGIN
OPEN proc_cur FOR SELECT * FROM EMP;
END;
/
155 Say, the query gets executed and we got the results. In case if we have a
large number of rows, how can we know the exact no of rows returned?
click on any column in result set, right click and select countall. this will display the total
number of columns in the result set.
156 is there any way to know how long the report executes and how many
records will be returned before hitting the "run" option?
simple! take the report query and modify to take the count in the query and execute it at
the back end.
A:
go to Definition tab in the data manager there u find these query options.
A:
before run a report just click on view button u can see the report
157 There are 2 types of strategies are there?
1. Built-in Strategy
2. External Strategy
can you please explain them in complete that what are these?
Ans:
Built-in Strategies: Designer provides a number of default strategies which we can use.
These are strategies for extracting joins, detecting cardinalities, and creating default
classes and objects. Options for indicating default strategies are located in the Database
tab of the Options dialog box.
External Strategies: We can also create our own strategies. Such strategies are referred
to as external strategies. With an external strategy, we can specify the exact way that
objects and joins are to be extracted from the database structure. The strategy we use,
for example, can be a script generated from a CASE Access tool. An external strategy is
specific to one RDBMS.
158 difference between xir2 and 6.5 version
1. XI R2 has a 5 tier architecture, where as 6.5 has 3 tier
2. In XI R2 we have some new tools like Import wizard, conversion tool etc.
3. In 6.5 we have a product called Business objects but now its been renamed as
Desktop intelligence.
4.In 6.5 we have supervisor, but there is no supervisor in XI and they have introduced
the new concept of CMC which is used to created users, user groups etc.
5.In 6.5 reports are being stored in document domain of repository, now they have
introduced the concept of folders and categories.
6.In 6.5 we have BCA(broad cast agent)to schedule the repots but in XI there is no BCA,
u can schedule the reports using "Scheduler" in CMC
7. not only these even in designer, deski& webi, u have some new enhancements
159 how to connect to a server in a business objects
there are some third party software’s are there to connect like "CITRIX"
160 what are slowly changing dimensions, confirm dimensions?
Slowly Changing Dimensions are basically those dimensions whose key value will remain
static but description might change over the period of time. For example, the product id
in a companies, product line might remain the same, but the description might change
from time to time, hence, product dimension is calledslowly changing dimension.
Where as Confirmed dimensions is some thing, which can be shared by multiple Fact
Tables or multiple Data Marts.
Conformed Dimensions (CD): These dimensions are something that is built once in your
model and can be reused multiple times with different fact tables.
For example, consider a model containing multiple fact tables, representing different
data marts. Now look for a dimension that is common to these facts tables. In this
example, let us consider that the product dimension is
common and hence can be reused by creating short cuts and joining the different fact
tables. Some of the examples are time dimension, customer dimensions, product
dimension.
161 how do u resolve contexts ?
go to tool -->automate detection-->detect contexts
162 Draw the architecture of traps?
chasm trap::
sale
client< rental
chasm trap is a type is a type of join path between 3 tables when 2 many to one joins
converge on single table.
fan trap::
when one table has one -to-many join that "fans out" into other "one-to-many" join for
other table.is fan trap.
a--->b--->
A:::;;
Chasm Trap:-
Orders
customers <
Loans
Fantrap:-
customers----->orders---->orderliness
163 what is the syntax for aggregate awareness?
Aggregate awareness is a feature that makes use of predefined aggregate tables to
enhance the performance of SQL transactions. It is used to improve the speed by which
aggregates are calculated in the database. To set up aggregate awareness in a universe,
you define or more objects using the @Aggregate_Aware function. The syntax for this
function is as follows:
@Aggregate_Aware(aggregate_table_1, ... aggregate_table_n)
The arguments of this function are all the names of alternative aggregate tables. When
you formulate the syntax, you should be aware of the order of the arguments. The
precedence is from left to right; this means that BusinessObjects determines the
aggregate to use beginning from the leftmost argument.
A:::;
@Aggregate_Aware(sum(agg_table_1), ... sum(agg_table_n))
164 Ranking feature was not available in WEBI 6.5 version, So how can we
get ranking in WEBI 6.5 version?
no we cannot perform ranking in webi6.5
165 What is the Computation error? how to solv it?
166 can anyone help me ? an index has been done on the primary key of a
table. an update operation was performed on that table. now my question is
1> what abt the
performance ?means faster or slower due to indexing ? 2> does the
operation affect to the primary key constraint ? normally database take to
refresh time 2 hours. but client asked iwant to refresh with in 5 min that
same database. do
you have any option in BO and Oracle? explain me briefly
when we use an INDEX.. performance will increases.........Infact the main purpose of
index is to increase the performance only...(very fast).
2.the index ,generally works based on primary key or unique key.
when we use index..refreshing time will reduces.. ITS a database question...its no way
related to BO.
167 you are a universe designer and report developer in BO, what type of
information you gather from client? Briefly explain plz
we can gather information by asking QUESTION TO THE CLIENT like
WHAT,WHY,WHEN and HOW.
Role of BO Developer is,
--->Firstly we have to understand the Business Process and user requirement of the
client.
--->Based on that we have to design and develop Universe.
--->test the universe.
--->Design and develop Reports.
--->Finally view and share reports between end-users.
168 2 table is there , thats column is different name but data type is same, 2
tables values are same. how to you findout both values are same?
In Designer,
in the file tab-->parameter-->Strategy
we join ---- in the join we have lot option to join .
option are match by column names,match by values etc..
169 Table A, Table B is there, that colums are different like tabl A contian (A
varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2),
F date) , i want 2 compare mismath datatype length in both table, how? do
you know any in built function?
using describe function v can find out that mis math datatype.
desc tabl a, table b;
172 What is the degenerated Objects?
Objects created using SQL queries or stored procedures called Degenerated Objects.
173 1.what is input level context and output level context in webI?
2.what is a cascading prompt? Where will you give this and how?
3. What is External Strategy?
The input context determines what dimension to go into the calculations to produce the
values. Where as the out put context determines how the values are combined. It is
generated by the cell location with the report.
External Strategies are script files used how to read the data dictionary of source
database. Data dictionary of source database having meta data information of tables,
columns, views, synonyms, stored procedures. .etc.
175 How to create Derived Tables in BO 6.5.4 with columns from different
tables in the universe and how it has to be joined in the universe?
I have no idea about BO6.5 however I feel that creating Derived table must be similar in
both XIR2 and BO6.5.
-right click any where in Designer.
-select Derived table from Popup menu.
-A window will open up. Give the name of the derived table,
You can specify the SQL stmt here as you do for example in oracle(if you are using
oracle DB).
Example:
select BONUS.ENAME Ename, DEPT.DEPTNO,EMP.EMPNO from Bonus, dept, emp
where
EMP.DEPTNO=DEPT.DEPTNO
You can specify the join in SQL stmt if necessary.
However joining the Derived table indeed is similar as joining a normal table.
176 What is casual dimension?
Casual dimension is should not change the fundamental grain of a fact table.
Ex: sex- Male,Female.
177 What is the use of Surrogate Key in BO?
It is used for duplicate values in a data base 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
A:::
Surrogate key is the dummy key which is used to allow the duplicate values
A:::
Surrogate key is contiguous numbers generated by DB in a table which acts as a primary
key since surrogate key has unique values.
for eg :
101,102,103,104,105............ so on
A:::
When we transfer the data from the source to the target tables i.e dimension tables, we
will be having one primary key for the dimension table, but in the SCD type 2 will be
having the repetitive data i.e history +current data, so we will be using the surrogate
key for the dimension tables for identifying the rows uniquely this surrogate is
implemented in the ETL process by using the "Sequence Generator Transformation".
The surrogate key will be act as primary key in the SCD type 2 and primary of
dimension table will be the natural key.
178 WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI
BO 6.5 is three tier architecture like, Universe Domain, Document Domain, Security
Domain whereas BO XI is 5 tier architecture like Client, Application, Intelligence,
Processing and Data
179 can we use detail in generation of reports? if customer id is a dimension
in a report,what will happen if we define it as a detail?
Detail object means, It should give detailed information for some dimension object. You
can use these objects in your report generation. When we drag the object in query
panel, It'll automatically fetches it's corresponding dimension object also.
Detail object:-
It gives extra information to the dimension object.
Eg:-
customer id is a dimension object Detail object of customer id is customer name ie..first
name, middle name, lastname, Address,Phone number.
180 how do u implement dense rank in bo reports?
The DENSE_RANK function computes the rank of a row in an ordered group of
rows.Rows with equal values for the ranking criteria receive the same rank.
For eg.
To Show the set of sales people who make the top 3 salaries - that is, find the set of
distinct salary amounts, sort them, take the largest three, and give me everyone who
makes one of those values.
SELECT * FROM (
SELECT deptno, ename, sal,
DENSE_RANK()
OVER (
PARTITION BY deptno ORDER BY sal desc
) TopN FROM emp
)
WHERE TopN <= 3
ORDER BY deptno, sal DESC
/
DEPTNO ENAME SAL TOPN
---------- ---------- ---------- ----------
10 KING 5000 1
58
CLARK 2450 2
MILLER 1300 3
20 SCOTT 3000 1 <--- ! (in
case of rank
JONES will have
3 and dense
rank will have 2)
FORD 3000 1 <--- !
JONES 2975 2
ADAMS 1100 3
30 BLAKE 2850 1
ALLEN 1600 2
30 TURNER 1500 3
181what is maximum scope of analysis --> can we define more than 3 levels?
By default, you can do only upto 3 levels.But with custom, you can do more than 3
levels.
182 Difference between scope of analysis in webi and in deski?
In Deski: all the data for all objects will be retrieved from the database.and that is
stored in microcube. whenever you want to drill down for next level dimension it doesnot
need to connect to database
In Webi : all values for all objects that are dragged into the query panel will be
retrieved. hierarchical objects values wont be retrieved like deski.
whenever you drill down the report, to display the values this report is meet ot database
again. and retrieves the data.
184 what is casual dimension?
One of the most interesting and valuable dimensions in a data warehouse is one that
explains why a fact table record exists. In most data warehouses, you build a fact table
record when something happens.
For example:
When the cash register rings in a retail store, a fact table record is created for each line
item on the sales ticket. The obvious dimensions of this fact table record are
product,store, customer, sales ticket, and time.
At a bank ATM, a fact table record is created for every customer transaction. The
dimensions of this fact table record are financial service, ATM location,
customer,transaction type, and time.
When the telephone rings, the phone company creates a fact table record for each "hook
event." A complete call-tracking data warehouse in a telephone company records each
completed call, busy signal, wrong number, and partially dialed call.
In all three of these cases, a physical event takes place, and the data warehouse
responds by storing a fact table record. However, the physical events and the
corresponding fact table records are more interesting than simply storing a small piece
of revenue.
Each event represents a conscious decision by the customer to use the product or the
service. A good marketing person is fascinated by these
events. Why did the customer choose to buy the product or use the service at that exact
moment? If we only had a dimension called "Why Did The Customer Buy My Product
Just
Now?" our data warehouses could answer almost any marketing question. We call a
dimension like this a "causal"
dimension, because it explains what caused the event.
185 what is aggregate navigation?
Aggregate Navigation is used to specify the incompatible objects.
A:::
Whenever we use Aggregate Aware we need to set up incompatilibities to work it
properly (so BusinessObjects knows what SQL to generate) For example, There are 2
aggregate tables fact table by week and by day.If you set up a measure as aggregate aware
from both tables - total quantity for example, the select might be something like: -
@Aggregate_Aware(sum(week_agg.qty),sum(day_agg.qty))
The week table listed first as this would be the preference. But as BusinessObjects needs
a reason to not go to the week_agg table, this is done using incompatibilities. For
example the Week Number dimension
object would be compatible with the week_agg table as it will link to it and the data is
held at an appropriate level to report against it. However the Date dimension object
would be set as incompatible with the week_agg
table, such that when it is selected alongside the Quantity object, BusinessObjects
knows to jump to the next option in its select definition.
186 how to overcome overflow of data in a report
When u have huge number of rows in report then u will get partial results in that report.
for that u have to increase the (Limit Size of the Results) chek box button in
UniverseParameters. then ur report will not overflows.
187 is there any limit for rows and columns in cross tab
You can have any number of rows and columns in a cross tab.
188 when and where we use @varialble function
The @Variable function is used to call the value assigned to variables.
The variables are of two types:
1) BusinessObjects system variables
2) Personal text file variables
189 what is static filter and dynamic filter
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.
190 what are cascading prompts explain with steps
Ans:
cascading prompt means it is nested. means we can apply the prompt like this. region to
country, country to state, state to city.
step1;select objects and double click. then draw the region to query panel then select
operator and operand as select new prompt. after type and drag the country to query
panel then select operator then operand as select new prompt. Like that we can create.
then finally run query. then asks to enter values for region after enter the values for
country.
A:::
Cascading Prompts allows you to use values selected from one prompt to filter values in
another prompt.
A:;;
series of prompts which will narrow the enduser selection.select an hierarchy and apply
prompts. Time hierarchy:year/quarter/month/week.
take dimension objects year/quarter/week and apply a prompt on month.follow the
same steps.
191 what is report tracing in bo
report tracing is nothing but tracing the report for its performance by using audit we can
trace report like how many users seen it. and users details ,its performance etc
192 generally how do we get information for creating universes and reports
193 how many micro cubes can a report can have
Only one
194 how to find the size of the report
Go to CMC and click on Objects
# search for the report name
# select the report properties and / File name : exp ("cdze0466c24fac6c.wid") search for
this on the client server machine where the repository is hosted an you can set the size of
the file there
195 what is local filter
Generally local filter would apply on a particular block. (table, crosstab, )
A::;
A local filter is applicable only to a particular block i.e. the block on which it is created
like table or cross tab.
196 What are all the points to keep in consideration, while we are migrating
the Universes,Reports from BO5.1.6 to BO 6.5?Is is compatible to migrate
like this? Does it effect the filters in Reports and Join in the Universe
1971)Difference between BO 5.1.2 and BO 6.5.1 and also BO XI(R2)??
2)Difference between oracle 8i amd oracle 9i?
3)Difference between SQL and PL/SQL?
4)what is Broad cast Agent?
5)what is prompts?
6)master detail format means?
7)performance tuning of reports means?
8)ad-hoc reports means?
9)can't we generate reports without creating universe?
Ans:
1)
BO 5.1.2 had no Infoview.
BO 6.5.1 included Infoview, but no Crystal Report, CMC not present, instead
Supervisor(thick client) was used for giving Users rights.
BO XI includes integration with Crystal Reports, CMC (THin Client) for managing Users,
security and Profiles
2)
Oracle 9i includes Bulk InsertsIndex Rename and Table Rename.
3) SQL is a 4 GL(Generation Language)
Pl/SQL is a 3 GL
5) Prompts are used for asking the user for Dynamic Inputs while refreshing the Report.
9) Yes we can create reports without creating Universe.
A::
4) Broad cast agent is used schedule the reports through web intelligences
63
8) 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
A::::
5)prompt is an enduser object, which allows the values or entering the values to restrict
the data displayed in document.
4)Broad cast agent is refresh data and schedule the data in report level.
6)master detail format means section, section means eliminate the duplicates and
display data in separate block in the form of master detail relationship.
7)you can reduce the calculation and conditions in the report
2) you can limit the cut copy paste operations for user's
3) you can limit access no of report's at peek time you can improve performance at
report level
in model:
1)you can remove loop's at that time you can improve performance at model level
2)use indexes you can improve performance
198 How to link one location universe to other location universe
In Designer,
1.Click on the File menu, say Parameters then one dialogue box is displayed.
2. Click on the Links tab, and say Add Link then choose the universe u want to link and
say ok. Then your universe is added to the existing one.
A:::
Click on File menu---> Parameter---> Links---->Add Link and then choose the universe
you want to link and give ok. Then the universe is added to the existing one
199 Can any one say me what does"maintanence of universe" means
Maintenance of universe means adding new tables, refreshing the table structure after
adding new tables, create the joins between the new tables to existing tables, identify
loops if any, examine the integrity checks after any changes, determining the cardinality
if any, resolving the loops, adding the new objects and classes , exporting , restricting
access to users, etc..
all the operations after the initial production phase are maintenance
200 How to hide the table s in webi?
There is no hide option available in webI but you can use the alerter trick to accomplish
this.
A:
To hide a column in webi just select the desired column and change its border color to
the background color.
A:;
use the pivot function available
201 Is it possible to join more than one universe in Business Objects? If its
so how is that possible ?
yes it is possible we can link the two universes by using add link option which is available
in parameters (option seen in tool bar file menu)
A:;
wer con't join two universes, we can link two universes. file-->parameters-->links
A:::
universes can be joined .one universe is having one data source. if you want to link one
universe with a universe having different data source it is not possible. for linking two
universes data sources must be same.
204 HOw do u migrate from old version to the new version?
Business Objects recommends you to go through Four key phases to migrate an existing
deployment to higher one.
The phases are :-
1. Assessment & Planning. The assessment phase consists of auditing a particular
deployment to determine the tools involved and project phases.
2. Installation of destination environment. During this phase, a working instance of
higher version will be installed to provide access to the migration capabilities and allow
staff to become familiar with its operation.
3. Importing contect to the destination system. This phase corresponds to the actual
migration implementation using the appropriate tools to move content from the legacy
system to the higher version.
4. Testing and validation. This phase involves any checking and post implementation
tuning required in order for the customer To put the BI system into Production
205 what is Scope of Analysis
Using this Scope of Analysis we know upto what extent we can drill the Report
A::
Scope of Analysis determines the additional objects to be included in the query so that
the data will be available in drill mode. Before you can drill, you must use Scope of
Analysis to select the objects to be retrieved in addition to those that were placed in the
Result Objects.
A::;
scope of analysis: it let's u add more data to the microcube from hierarchies. this data is
used for multidimensional analysis. when u add the data to the microcube, the added
data is not initially displayed in the report. when u drill the data it displays the added
data for the purpose of multidimensional analysis. The scope of analysis button is
located in the query panel.
206 HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
Short cut Join providing an alternative path between two tables, bypassing 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
207 WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
208 WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT
Types of Universes:
1) Simple
2) Complex
Shared, Personal and Secured are not universe types.
They are universe connection types.
209 what is meant by slowly changing dimensions?
Master data occur in the OLTP system and that can't change regularly, When the
changes are occured in the OLTP system,that changes can be handle 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 historic data)
A:::
Dimensions that change over time are called Slowly Changing Dimensions. There are
three types namely,
1) Overwriting the old values
2) Creating an another additional record
3) Creating new fields
210 what is meant by scorecards?
Provide fast and effective way of monitoring key measures
A::;
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.
211 suppose case1:a person buy a car
case2: rent a car which is context & which is alias? why?
buy a car is context & rent a car is alias
becoz buy a car is a fact & rent a car is a look up, alias is created on look up tables.
212 What is meant by Adhoc reports? Can any body will explain with
examples
Ad hoc reporting is a user friendly feature designed for all levels of users. Custom reports
are created using queries. 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:::
Adhoc meant for management users .example BO is adhoc reporting tool. to make quick
decisions.
example :if u 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 water u need to Clarence of stock. when u
enter into the "big bazar" they put offers every 15 min and changed..
213 Can any body will explain about surrogate key?
Surrogate key: Also known as Sequence id in ORACLE or Identity column in SQL
SERVER
(whatever you call to your convenience).Auto generated keys by the system.
DWH: Used here as a substitute of existing primary key to encourage duplicates and
thereby misleading the rule of third normal form. Thus maintaining the history of
records
which supports SCD(slowly Changing Dimension III)
3NF: Each table should have one primary key
214 What is the difference between sub-query & co-related sub query?
Nesting of queries, one within another, is termed as a Sub-Query.
A sub query is executed once for the parent statement whereas the correlated sub query
is executed once for each row of the parent query.
Example
Select deptno, ename, sal from emp a where sal = (select max(sal) from emp
where deptno = a.deptno) order by deptno
215 what is the necessity of oracle for business objects, why the interview
panel is
concentrating on oracle very much? Just we need the commands using
select,joins? Why they r asking about cursors, triggers
Actually for any BO Developer optimum level of SQL knowledge is necessary. Because In
BO we are mostly using oracle is as database. so what ever you are selecting in the query
panel it is fired on the database in the form of query. All of us know it is done by designer
automatically. But in some Scenarios we have to implement freehand SQL queries,
derived tables to get our target results and some times we have to validate the
background SQL generated by BO to understand how results are coming in. And in
creation of formulas and variables we need SQL knowledge.
(to_char, to_date,trim,decode,sign,union,union all....)so SQL is must. Coming to the
PL/SQL in some situations when the data is in huge amounts, normal sql not meet the
requireperformance. So we have to use PL/SQL.So it is required in rare cases where you
are uploading the data in the report automatically by running the Unix batch or getting
the huge amount of data in to the reports.
216 WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
The different table templates you can use to display information on reports are:
? vertical tables
? horizontal tables
? crosstabs
? forms
1)Vertical tables display header cells at the top of the table and the corresponding data
in columns.
2)Horizontal tables display header cells at the left of the table and the corresponding
data in rows.
3)Crosstabs display values for dimensions across the top axis and on the left axis. The
body displays the values of a measure that correspond to the cross section of the
dimensions.
4)Forms are useful in your report if you want to display detailed information
217 WHAT IS CARTESIAN PRODUCT?
A Cartesian product is a result set which contains all the possible combinations of each
row in each table included in a query. A Cartesian product is almost always an incorrect
result.
A::
A Cartesian product is defined as all possible combinations of rows in all tables.
218 WHAT IS CARDINALITY?
cardinality defines how many instances there for each unique record in the related
table.the sole purpose of cardinality detection is to warn you of possible loops
A::
Cardinality is a property of a join that describes how many rows in one table match rows
in another table. Cardinality is expressed as the minimum and maximum number of
rows in a column at one end of a join, that have matching rows in the column at the other
end of the join.
The minimum and the maximum number of row matches can be equal to 0, 1, or N.
219 HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
When ever we save universe it directly gets saved in local repository. If we want to access
these universe from deski or webi then we will have to save these universe to central
repository by EXPORTING it, it will directly be saved in default location in central
repository.
A:;
By exporting the universes and documents, we can save them to the repository. We
canalso publish them to the central repository.
220 WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
there r many diff options. 1)In xir2 scheduling option is available. in 6.5 to schedule the
reports by using BCA.
2) alerts & Sub alerts are available.
3) Rank option is also available .
221 CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
The Various data source are:
Universe
Free-Hand SQL/
Stored procedures
OLAP servers
Personal data files
VB procedures
Any number of data Source can be linked by common dimensions
Features of Dimension:
The dimension objects do not have to have the same name
(e.g. Person, Person Name)
Only dimension objects can be linked (e.g. Person
Name,Encounter Type,etc..)
The dimension objects must have a common data format (e.g.
character, numeric, etc.)
Common values must be in the same case etc..
222 is it possible to create reports from different universes in one
document?
Yes it is possible
223 TILL WHAT LEVEL OF SECURITY BO SUPPORTS?
I 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 roe level or column level in case of particular user or user
group.
Row level Security ?
The measure of specifying which rows a user can retrieve based on a column of data or
combination of columns is called row level security.
224 How to spot a hierarchy?
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.
225 what all different kind of functions available while designing universes?
Ans:
Some other function like Number,Character,Date and @functions. (Pronounce as at)@
fuctions like, @aggregate_aware(very important)@prompt,@select,@where,@script and
@variable.
226 what type of joins returns incorrect results?
Non Equi jpins and cross joins
227 What is the purpose OF TESTING INTEGRITY OF THE UNIVERSE?
Ingegrity checks detects:
1. Invalid syntax
2. Loops
3. Isolated tables
4. Isolated joins
5. Loops with in contexts
6. Missing and Invalid cardinalities.
228 What is cordinalities of join
Cardinality is a property of a join that describes how many rows in one table match rows
in another table. Cardinality is expressed as the minimum and maximum number of
rows in a column at one end of a join, that have matching rows in the column at the other
end of the join. The minimum and the maximum number of row matches can be equal to
0, 1, or N.
229 What kind of tool BO is
business objects is ROLAP TOOL
A:;;
BO is a query, reporting and analysis tool that allows users to access, present and analyze
data from a corporate database. Typically used to analyze data stored in a Data
Warehouse.
230 how do you resolve multivalue and computation erros?
Create a new variable(ex:test) and copy the formula of the old variable to this new one
and assign the column to this new variable.. is the solution for multivalue error.
Computation error: Use Max() function before the formula in the report to resolve a
computation error
A:::
#MULTIVALUE error can be resolved by putting the input context.
#COMPUTATION error can be resolved by putting the reset context in output context.
231 how you worked with multiple data sources?if yes ?how do you link
them?
When you pull data from different data sources, if the dimension name is same then they
get linked automatically.
Ex. You have "Month" in one DP1 and Month in another DP2 they get linked
automatically.
i.e. a Join is created between the two. If the name is not same then we need to link them
in Data Manager.
232 How do u schedule reports..
we have a simple proceeds to schedule thee reports. when u saved ur report in particular
folder.
Connect sever through browser tool go to ur folders and schedule
A:::;
in 6.5 we can use broad cost agent but in the case of boxi we can use boe .net launch pad
A:::
In 6.x and previous versions, Broadcast Agent is used to schedule the reports.
In XI and XI Release 2, any user who is authorized to schedule documents can schedule
the reports.
A:::
Broadcast Agent lets any authorized user schedule documents to be refreshed on a
regular basis. Scheduled documents may then be automatically distributed to targeted
individuals or groups or published for all users to access. Users can customize the
information they send by executing a standard report and then bursting it so that
recipients receive only the information they are entitled to by their security profile.
233 genarally what are the problems are facing while creating reports?
THE MOST COMMON PROBLEM IS JOIN PATH PROBLEM
i.e,
LOOPS
CHASAM TRAPS
FAN TRAPS
234 genarally how many universes are create for each projects?
Its depends upon the project
235 i am using Business Objects 6.1(a) facing a problem. i.e., when we save
report in xls format then in xls sheet pictures are inserted into rep file are
not come. Is it a bug.
Ans::
While saving the report we have to save in the form of save as
select this format:-
1)Microsoft Excel Sheet(.xls)
2)HTML format(.htm)
3).pdf
you can select any one of them it is possible.
236 In source system we have os - windows
BO - 5.1.5. with webi 2.7.1
Repository database - oracle
Reports database - Oracle and DB2
Nearly we have 1200 reports in present system , i want to
move as it is to new hardware
os- windows
bo- 5.1.5 with webi2.7.1
repository - oracle
reports - oracle and db2
237 Migration of Reports from business objects 5.1.5 to same version in
different hardware?
238 what is the diff between etl tool and olap tool
ETL tool is used to extract, Load and Transform the data from one system to another
system. OLAP tool is a reporting tool which will generates the reports that are useful for
decision support for top level management
239 where do you use global filters ,explain with example?
global filter acts on all fields in the report table
240 what problems are not known while performing integrity check?
We can't find traps i.e. chasm trap and fan trap. It can be identified only by visualization.
241 can a repository contains reports?
Yes, Repository contains reports. In BOXI also reports are stored in repository (file
repository). Those reports in folders are also stored in repository only.
A::;
Yes, Repository contains reports. In BOXI also reports are stored in repository (file
repository). we can save our reports in folders(physical) and categories(logical)..these
are available only repository only
242 OLTP = Online Transaction Processing - Typically transaction intensive
(INSERT/UPDATE/DELTE) systems, heavilly normalized
OLAP - Online Analytical Processing - Typically query intensive systems, demoralized to
avoid
unnecessary joins and storing pre-aggregated values eg. Day/Month/Quarter/Year totals
OLTP : Involves transaction processing operation and used in day today operation
.Frequent
update and insert statement occurs .Database should have very less Fillfactor value
OLAP : Involves Analysis operation, meant for future prediction. Datas get stored into it
with
less number of updates Database should have very high Fillfactor value
243 How are the user s of repository
general supervisor creates repository and designer ,user(report developer) uses the
repository...the documents are stored in document domain...in fact the clients also uses
the repository while seeing the documents
A:;;
Supervisor, General supervisor, users, usergroups.
244 if i want to install bo enterprise products in windows 2000 professional
server ,what should be the system configuration?
• P3 700MHz**
• 1 GB RAM
77
• 5 GB hard disk space for BusinessObjects Enterprise and
1.5 GB additional for Performance Management
• CD-ROM
** Windows support is limited strictly to the 32-bit versions of Windows operating on
either 32 or 64-bit (x86) AMD/Intel chipsets. BusinessObjects Enterprise software for
Windows is not warranted or supported for use on other chipsets.
245 Can we edit BOMain.Key file to connect with other repository with same
supervisor user name and password. But Database is different.
Ans:::
246 How do you get the requirements from the client
Client first contacts the company's Business Development Manager of the company,Then
Meeting and a chat happens in a clients place or client coming to company, Then gets the
requirement according to the deal
247what is prompt? Cascading prompt? Syntax
Ans:;
Prompt: It is used to create an interactive object. and also it is dynamic filter.
General syntax:@prompt('message',['type'],[lov],[mono/multi],[free/constraint])
In designer we can write this way,@select(class\object )= @prompt
('message','type','{values1,values2...},class\object,mono\multi,free\constrained)).
Cascading Prompt: it is based on one prompt to another prompt. it is also refer to
hierarchy also & designed in uni level.
IN BOXIR2 wise:--
go tools --> click cascading lov --> edit lov window open --> write conditions how
many prompts u want. --> click ok.
248 What is drill down
Navigating data to lower level in the hierarchy with in the Cube.
249 What is Slice and dice
The ability to move between different combinations of dimensions when viewing data
with an OLAP browser.
Multidimensional analysis tools organize the data in two primary ways: in multiple
dimensions and in hierarchies.
Slicing and dicing refers to the ability to combine and re-combine the dimensions to see
different slices of the information. Picture slicing a three-dimensional cube of
information, in order to see what values are contained in the middle layer. Slicing and
dicing a cube allows an enduser to do the same thing with multiple dimensions.
250 What are the features in BO
define scope of analysis.
define conditions.
create master and detail reports.
add formulas, local variables and functions
breakeup tables and display the calculations.
create charts.
analyze the data in drill mode.
use slice and dice.
formate reports.
export reports.
251 Why we go for dataware housing
for reporting one day details also enough. but analysis means we need comparison
means we need some old data is called historical data.the data ware house saves
historical data ,we con't do any data base manipulations. where is in normal databases
we arte able to maintain some extent of data .after that for entering new data u need to
delete the old data.
BUT in Data ware house u are able to store years of records no need to delete the old data
252 Multi Dimensional Analysis..
Multidimensional analysis is analyzing the data in different ways. There are two options
are available in BO,
1.Slice and Dice, it allows us to view data differently i.e.we can change the position of
the rows to columns and columns to rows.
2.Drilling, using drilling option we can view data in different views i.e. we can know the
level details of any dimension. Suppose if we take Date dimension, we can use drill
option to view the next level of detail i.e. from year to quarter and from quarter to
month and from month to day.
253 what is data mart?
A data mart is a subset of data warehouse that is designed for a particular line of
business such as sales, marketing,finance, etc.
Data mart is of two types:
1) Dependent data mart, in which data can be derived from an enterprise-wide data
warehouse.
2) Independent data mart, in which data can be collected directly from sources.
A:::;
Data Marts is used on a business division/department level. A data mart only contains
the required subject specific data for local analysis.
A database, or collection of databases, designed to help managers make strategic
decisions about their business. data marts are usually smaller and focus on a particular
subject or department. Some data marts, called dependent data marts, are subsets of
larger data warehouses. A data
mart is a simpler form of a data warehouse focused on a single subject (or functional
area) such as sales, finance, marketing, HR etc. Data Mart represents data from single
business process.
254 what is conformed dimension?
Confirmed Dimension is a dimension table which is connected to the multiple fact tables
255 what is LOV? where it is stored?
LOV is the list of values. it can retrieve the data values associated with the particular
object. this can be stored in sub folder of USERDOCS with .lov extension.
A::::
LOV is list of values it displays the list that contains the data values associated with an
object.
A list of value can contain data from two types of data sources...
1. Database file
2. An External file.
256 what is repository? Types
In XIR2
CMS Repository :Which consist of two database (System & Audit)
Input file repository: Template of the report
Output file repository: Instance of the report
A:::
repository is a organizing metadata or centralized metadatastorage place repository is
create new folder structure
types:
repository manager
repository admin console
257 what is alias?
Aliases are references to existing tables in a schema. An Alias is a table that is an exact
duplicate of the original table with a different name. The data in the table is exactly the
same as the original table. An alias breaks a loop by using the same table twice in the
same query for a
different purpose.
258 What is loop? How resolve the loop? explain it?
Loop is a Multiple paths between the tables selected in queries. Or you can say loop is a
closed path structure.
Loops can be resolved by…
ALIASES
•Alias - Same as the namesake in SQL.
•Exact duplicate of the original table.
.A different name “tricks” the SQL query to accept that you are using 2 different tables.
CONTEXTS
•Rule which helps BO decide which of the 2 paths to choose in a loop.
•BO prompts the user to indicate the correct perspective (relevant path) for the query.
When to Alias
A loop with a single lookup table should be resolved by an alias
A lookup table can be identified by its cardinality
A lookup table only has the ‘one’ end of joins attached to it
A:::;
a situation occurs more than one path exists from one table to another table. to resolve
the loops we can use the alias and 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.
259 what is context? How u create? With example
it is a set of joins that specifies 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.
260 How can we improve performance
1)using 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
261 What is the use of BO SDK?
The BusinessObjects Enterprise SDK allows you to build web applications that interface
directly with your BusinessObjects Enterprise system.
A::
BO SDK 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.
262 What are the general issues in migration process?
Before Migration, one should have a thorough with
1. Import Wizard
2. Report Conversion Tool - for converting the DeskI Reports to WebI Reports Issues can
be:
1. What type of Migration u want to Usea)
Single Pass
b) Incremental Migration
2. Importing Security or not.
3. Repository Migration- such as
a) Merging Multiple repository into one
b) Moving one to Multiple Repository (Depends on the requirement)
4. Need to take care of Versions and Platforms - Supported databases, Web and
Application Servers, Web Browsers and Operating Systems.
5. User/Group Migration
6. Setting up Folders/Groups Structures.
7. Document Migration.
8. Taking Backups
9. Setting Up Servers etc.
263 Why do we need metrics and sets
Metrics are used for analysis and Sets are used for grouping.
264 What is the source of metrics?
Measure objects.
265 What is the use of AFD. Where it can be stored?
used to create dashboards. It can be stored in repository, corporate or personal.
266 Set:::: Grouping of Users
267 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.
268 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.
A::::
In Section(Master Detail) you can have two or more different crosstabs or
tables(hori/fin) eg. orders,customer, products etc
Where as In break one block is break into groups and subtotal is shown eg customer can
be broken intocountry/state/city
In Section(Master Detail) you can have charts for each section or detail. can have chart
and table combination as well.
Whereas in Breaks u cannot insert a chart for each of the groups formed out of break
269 What are Alerter, Filters, Breaks and Conditions?
Alerter is conditional tests.
Conditions restrict the data at the database level.
Filters restrict the data at the report level.
Breaks can be used to remove redundant data and the data remains with in the cell
content.
A::::
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.
270 What is a join? Explain different types of joins?
A join is a condition that links the data in seperate butrelated tables. The tables usually
have a parent-child relationship. If a query does not contain a join, the database returns
a result set that contains all possible combinations of the rows in the query tables.
Types of joins:
1) Equi-Joins
Link tables based on the equality between the values in the column of one table and the
values in the column of another.
2) Theta Joins
Link tables based on a relationship other than equality between two columns.
3) Outer Joins (Left Outer, Right Outer, Full Outer)Link two tables, one of which has
rows that do not match those in the common column of the other table.
4) Shortcut Joins
Join providing an alternative path between two tables, bypassing intermediate
tables,leading to the same result, regardless of direction. Optimizes query time by cutting
long join paths as short as possible.
5) Self restricting joins Single table join used to set a restriction on the table.
271 What is the size of database
In general it will be anything between 4-8 Terabytes.
273 What is category
Categories tag objects in a meaningful way to provide an additional method of
classification, which makes searching for content easier for users. A Report in one Folder
may assigned to several Categories.
Types of Categories:
1)Corporate Categories – Created by admin or users who has admin rights.
2)Personal Categories – Created by each user to organize their own personal documents.
274 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.
275 Can we have multiple domains?
we have multiple domains, but security domain is not multiple, only document domain
and universe domain is multiple.
276 When does the repository is created
In 5i/6i versions after installing the software, whereas in Xi version repository is created
at the time of installation.
277 What is meant by Domain? How many domains are there in basic set up
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.
279
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
Ans::
year=to_date(to_char(timeclass,'yyyy'));\
month-->to_date(to_char(timeclass,'month'));
281 How to Implement the Built-in Strategy Script in BO Designer?
strategy is used to extract structural information about the tables, joins ...
bo has 2 strategy
1. built-in -strategy
2. external- strategy
282 What are the security level used in BO?
Security Levels in BO XI are:
1) Predefined
2) Advanced
Predefined:
1) No Access
2) View
3) Schedule
4) View on Demand
5) Full control
With Advanced you can explicitly define the security level.
282 in 5.1 there is no infoview but in 6.5 having infoview
283 What is slicing and dicing in business objects?
Slice and Dice can be applied to rotate a microcube in order to view it from different
perspectives.
A microcube is a conceptual way to present the data returned by a query before it is
projected onto a report.
You can choose all, or only some of the data held in the microcube to create a report.
284 Can we take report on Excel in Business Objects?
yes. The business objects separately provided the option of get the report data from
universe or others(personal data option)in the business objects entered wizard. Click or
Select the others option and it will let u different files or extension files. here select .xls
file and follow normal report style.
A:::
Yes, We can take a report on excel in Business Objects,Process ....
In Desktop Intelligence -> File -> New - Generate a standard report -> Begin -> Other
-> Personal Data Files -> Finish -> format -> xls & select excel file from browse option
-> If excel file first row contains column name then select the check box -> First row
contains column names ->Run.
------------------------------------------------------------
If you want to save a BO report in excel format then,
After generating a report file -> save -> File name -> ....... & save as type -> xls ->
Save
285 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.
286 What are steps to be taken care to create a good Universe?
A Universe is a business-oriented mapping of the data structure found in databases:
tables, columns, joins, etc.
A Universe is a semantic layer between Database and end users.
A Universe 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.
A Universe can also pertain to a section within a department or just about any set of
organized procedures such as a payroll or inventory system.
A Universe consists of a set of objects, grouped by classes.
Steps to be taken care to create :
Prepare : Know the data source
Analyze :Identify the needs of the end user population
Plan : Design the universe(s)
Implement : Create the universe(s)
Test : Using a test team (including end users)
Deploy : Distribute the universe to end users
Evolve : Adapt and extend universe over time
288 What is the test methodology for testing BO Universes?
we test universes by using integrity check .or we can individually test loops, contexts,
aliases.
289 How to create Universe using Flat file in BO6.0
but u can generate a report from a flat file. choose "personal data files" in the new report
wizard instead of universe and input the file information.
290 What is the drill up , drill down, drill by , drill trough ?
drill-down means analyzing the in different levels going to the down let us eg as year---
>quarter, quarter---> month and so on
drill-up means analyzing the in different levels going to the up let us eg as month---
>quarter, quarter---> year and so on
292How to connect one to one report?
You can link thru Hyperlink option
293 What are the steps to taken care to improve the Report performance?
The Report Performance can be improved by the following performance Requirements :
1- The Report should open within 10-15 Minutes
2- The data should be available within 24 hours For
Example - If there is some data error , it has to be taken in ETL ( Extraction
,Transformation , Loading ). When the mapping got refreshed , the data should be
fetched into the Reports within 24 hours
A::
As part of universe parameters increase the array fetch size and try to use aggregate
awareness.
294 What is the local filter and global filter in bo's?
a report can contain more than one block...same way a document can contain more than
one report.....
so if we see one report we have some blocks....applying a report filter to only one block is
local filter. applying a report filter to all blocks is global filter...in any report.
A:::
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
295 Explain in Detail about Measure Objects? and what is the use of it? How
to create it?
Measure Object convey numeric information which is used to quantify a dimension
object. A measure object returns numeric information.
You can create a measure object by using aggregate functions such as,
1)Sum
2)Count
3)Average
4)Minimum
5)Maximum
296 How can we achieve Correlated sub-query in Designer?
A correlated subquery is a SELECT statement nested inside another T-SQL
statement,which contains a reference to one or more columns in the outer query.
Therefore, the correlated subquery can be said to be dependent on the outer query. This
is the main difference between a correlated subquery and just a plain subquery. A plain
subquery is not dependent on the outer query, can be run independently of the outer
query, and will return a result set. A correlated subquery, since it is dependent on the
outer query will return a syntax errors if it is run by itself.
297 Which command using Query Analyzer will give you the version of SQL
server and operating system ?
Select@version
298 How will you know the version of Bo using designer?
in designer select the file tab, then click on parameter tab in that select summary tab
then we will get the information
300 What is batch processing in Business Objects?
Nothing but Scheduling the reports
301 What are different types of saving options in web intelligence?
The saving options with webi are:
1) excel
2) pdf
3) csv
4) csv with options
302 What are alerter in Business Objects?
Time Scale
· OLTP: This stores current data
· OLAP: This stores History data for analysis
· OLTP: Optimizes update performance by minimizing the number of indexes
· OLAP: Optimizes adhoc queries by including lots of indexesNormalization
· OLTP: This is fully normalized
· OLAP: Possibly partially denormalized for performance reasons. As this is used for
reporting.
Organization
· OLTP: Data stored revolves around business functions
· OLAP: Data stored revolves around information topics.
Stored Values
· OLTP: Stores typically coded data.
· OLAP: Stores descriptive data
Homegenity
· OLTP: Scattered among different databases or DBMS and using different value coding
schemes
· OLAP: Centralized in data warehouse. Or in a collection of subject oriented data marts