1. List the steps to do to use Alerts in BO?

Alerts are used to alert some part of the data if any change occurs.

select the part of the data in the report where u want to keep alerts n just click on alerts in the tool bar which is present in the third line from menu bar besides rank
then a window pops up n we ca n give some condition where in if it crosses that an alert is sent.

Alerts means highlights the data.
1. select the cloumn/row
2. apply the alert that is available in tool bar
3. provide the necessary condition
4. Apply it
Tx

2. Can we do load testing for Webi Reports? (Example if I have have to test one webi report for Concurrent users refreshing report at one time)?

You can do Load testing for Webi Reports using Load runner tool.
1) Install loadrunner in your system. ( to use loadrunner you need admin rights).
2) Generate loadrunner scripts.
3) Use controller(which is present in loadrunner) to get the results.

Using loadrunner tool you will get these results:
a) Maximum Running Vusers: 50 ( Given by the testing person, you can increase virtual users if you want)
b) hits per second.
c)Average response time for every transaction like login,click on the particular link,logout etc.,
d) Errors per second.
e) Connections per second.

3. Explain difference between union and group?

The difference between union and group is as follows:
★ Take two tables t1 and t2.
★ In t1 we have columns like a,b,c,d. and t2 has a,d,e,f.
★ Ao union means t1 union t2 i.e getting result from both tables i.e a,b,c,d,e.,f
★ Where as group performs on a individual column in a particular table.

4. Explain 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

it is centralized and set of data structure that can be stored in databases.basically repository can be made up by 3 domains.

5. Described about report template in B.O?

Report Template is a specimen for your future reports.

You create a report from scratch, say make it Master-Detail Report with charts, put your company logo, add some default colors(something like same colors your company uses for its documents, webpages etc.) & then save it as BO Report Template file.

Next time when you are creating new reports, & select use Templates option, your report saved as template will be listed in the box. If you select it, your new report will automatically use all color formats, & table-chart structures, logo....whatever you used in your template report file.

Advantage : 1 time devaelopment of display & structure format, for multiple reports use. i.e. Time Saving. No need of formatting for all standard reports.

6. Explain the difference between ZABO and webi?

ZABO is zero administrator businessobjects , which will be installed on your local m/c when any full client report in opened/edited from infoview . For this you don't require any BO mainkey , key will be installed from BO server.Webi is also called as thin client , where -in you are create BO reports on web browser . Reports are only based on Universe.

7. Suppose if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

Cartesian product is getting incorrect results.
for instance if we have a cham trap or a fan trap n we din't solve them after checking the integrity also we get duplicate results of the same record ie nothing but cartesian product.

ex:-
we have customer,orders,loans classes
orders for one product if the product_price is 150$ it will appear twice in the report due to traps bcoz of the cartesian product thats why to solve the cham trap we create context and in order to solve fan trap we create alias table.

8. Tell me if I have three predefined prompts.In a report it will come randomly.How they will come in a specified format?

We can do this in three ways:
1.alphabetical order-prompts will appear in alphabetical order
2.numeric order-prefix number and they will appear in numeric order
3.date order-prompts will appear date wise
it depends on the type we choose in prompt syntax

9. Which versions are used in the BO dashboard work?

Bo XI R2 versions is used in the BO dashboard work.

10. Which steps to taken to schedule the report?

As far as i know we schedule the reports through broadcast agent.

Download Interview PDF