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
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
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.
- 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.
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.
- 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.
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 :