Business Objects

  Home  Data Warehouse  Business Objects


“Business Objects guideline for job interview preparation. Explore list of Business Objects frequently asked questions(FAQs) asked in number of Business Objects interviews. Post your comments as your suggestions, questions and answers on any Business Objects Interview Question or answer. Ask Business Objects Question, your question will be answered by our fellow friends.”



42 Business Objects Questions And Answers

22⟩ How to generate the report from excel sheet?

Start BO,

Select "Others" on Data Providers wizard page,

from drop down menu, select "ersonal data files",

specify file location & check the box "First Row contains Column names" this will help you in creating Objects.

click Ok.

Start building your reports.......

 113 views

23⟩ Explain How we drill up week to Month?

In data Warehouse when u change + symbol to - , u would c all the aggregation level in that + this is called rolling down.

So if u again click over that - it would again compressed back to +. This is call drill up.

your Aggregation levels woudl b like

Year>Month>Week>Day>Hour>Minutes>Seconds.

So by changing the symbol from - to + at month aggregation level u can drill up.

 122 views

24⟩ What is the difference between condition & filter?

Conditions: these retrievals the data based on the condition (universe level)Filter: it brings the data and filter; performance will be slow (report level)

Filters - are used to restrict the number of rows in the output.

Conditions - It wont reduce the Number of Rows, but you can show up data based on some validations.

For Eg: select cust_id from customer where cust_name like 'A%'

Filter is Cust_name like 'A%'.

Condition is also applied at report level.

If (cnt(cust_id) > 1 ;"Valid";"NotValid")

 159 views

25⟩ Explain What are 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

 131 views

26⟩ What are the steps to be taken to schedule the report?

You can schedule any report using Business Objects (reporter) .1) Open report in BO2) Select option " File->Send To- BCA"3) Select the BCA name to which report has to be scheduled4) Set other options for report scheduling like time , any macro , user etc.

 134 views

29⟩ What is 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.

 138 views

30⟩ What is thumbnail?

BusinessObjects Enterprise lets you preview a report using thumbnails. You can request the server to take a snapshot of the first page of the report and return it to the browser as an image file. This image can then be displayed as part of the Report Details page.

To retrieve a thumbnail, a separate page needs to be created because the code that writes an image to the screen erases any text that may have previously been there.

 131 views

34⟩ Explain 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 .

 146 views

40⟩ Explain What 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.

 131 views