Business Objects Frequently Asked Questions and Answers

2/15/2010 No Comment

Business Objects Frequently Asked Questions with Answers.

Name the data providers Business Objects supports?Answer : The data providers that BO supports are cited below.
  • Queries on Universes
  • Stored Procedures
  • Free-Hand SQL
  • Personal Data files
  • VBA Servers
  • OLAP Servers
  • SAP
Differentiate between Filter and Global filter in BO?Answer : Filter: is applied on particular block.
Global filter: Filter is applied on the whole report.

What do you mean by fold in BO?Answer : Fold option is used to display only the break headers and footers in a table.

What do you mean by outline view? (View?Outline)Answer : Outline view folds up the sections in the report to display only the high level information that you’ve included at the top of each section.

Define template in Business Objects?Answer : You can use a template in the following situations:
•When creating a report.

Name the different ways of refreshing documents?Answer : 

  • Manually (Click Refresh Data icon)
  • Every time you open a document. (Tools -> Options ->Save Tab->Check Refresh document when Opening)
  • Automatically at specific times or intervals
  • Refresh a data provider once at a set time: Data->View Data->Select Data Provider ->Select Definition tab->Check Automatic Refresh->Choose Once Radio button->From
Date & Time
Regularly refresh a data provider: Data->View Data->Select Data Provider ->Select Definition tab->Check Automatic Refresh->Choose Every Radio button->Specify in

Minutes or Hours•By sending the document to Broadcast Agent, the BUSINESSOBJECTS product that manages the scheduled processing of documents.

Why do you create variables in the report in Business Objects?Answer : Variables are two types derived variable and calculated variable.

  • Grouping a set of dimensions creates derived variable.
  • Calculated variable is created by performing certain calculations on fields.
The New Report Wizard includes a dialog box that enables you to view and select the template you want to use. The styles and structure of the template are applied to the new report.
  • When formatting an existing report. When you apply a template you can choose to apply the template styles only, or to apply the styles and the structure.
What do you mean by Alerter in BO?Answer : Alerter is used to highlight data and writing some text if a condition is satisfied in Business Objects report.

How many breaks I can use on the report?Answer : One group can have a maximum of 9 breaks.

What’s the difference between Count and Count All?Answer : Count: function counts values of a dimension object that are the same only one time.
Count All: function counts all rows including empty and duplicate rows.

Explain what do you mean by Slice-and-Dice Mode?Answer : Slice-and-dice mode enables:
  • To switch the position of data in a report.
  • move data from columns to rows
  • Work with master/detail reports
  • Display and remove data
  • Rename, reset and delete blocks
  • Turn tables and crosstabs into charts, and vice versa
  • Apply, edit and delete breaks, filters, sorts, rankings and calculations.
Why do you get partial results and how to get around this problem?Answer : 

  • In the Query Panel\Options if we restrict the number of rows to a specific count we get partial results.
  • In the Universe parameters, Controls tab if we limit the result set size to a specific number, which is less than the resultset we get a partial results.
  • If we have a report containing two data providers which are linked to each other and if one data provider is deleted we get a partial results.
Explain what do you mean by UserResponse function?Answer : Returns the response to the specified prompt. This prompt is written when the data provider (query or free-hand SQL script) is set up. It appears when you run the query or SQL script. The response to the prompt is the value returned by the UserResponse function.
UserResponse ("Data Provider Name", "character string")

What is drill down and give all the concepts related to it?Answer : Drill down is a functionality used to view the data from different levels from higher level of detail to lower level of detail. We have to declare a hierarchy to do so. Drill thruough is an additional functionality provided to the user where he can drill on a field not there in that hierarchy. Business Objects internally generates a query and retrieves a result according to the selection. Scope of analysis gives the details of what level of detail data the user is looking.
Related Posts

No comments :


Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer