BO Technical Interview Questions Answers
What is the console mode? What you can do there?
Console mode provides the task information of the scheduled BCA tasks, processed/non-processed tasks.
What is an extended syntax in Business Objects?
Extended syntax allows users to perform calculations on a particular block, report, or body as per the requirement.
Where do you get information about Rows retrieved, Duration & Timestamp for execution? Data ? View Data ? Definition tab
How do you get 24 hr clock rather than 12 hr clock?
Format the date time to HH:MM:SS. This should make the clock 24 hr. If this does not work we need to change the clock settings in the Regional Settings of Control Panel to show a 24hr clock and select the 24hr clock in format panel of a field.
Can you perform/ put sort on hidden objects? How many ways of hiding are there?
Yes. There are two ways of hiding 1. Normal Hiding 2. Conditional Hiding.
What is conditional hiding?
Conditional Hiding is a process of hiding a field or a block if a particular condition is satisfied.
Why Business Objects generates two separate SQL?
When we query on objects, which do not have a join, they are executed as two different SQL and then synchronized.
You are unable to write combine queries, what you need to do?
In the Universe Parameters, SQL tab check the option Allow use of UNION, INTERSECT and MINUS operators.
How do you run the same report against another universe, without creating all again?
Changing the Universe name in the Definition tab of Data Manager
What is custom sorting and how do you do it?
Sorting of the variables in the order set by the user.
Can you create a report with more than one data provider?
Yes. Create two data providers and then create a virtual cardinality on the two micro cubes based on a particular field.
How does Business Objects generate a query?
Business Objects is a query builder, which builds the query, based on the selected fields and selected conditions. This generates an SQL, which is executed on the database through a middleware either through ODBC or through some other connection. The database creates a resultset and provides the same to ODBC and which the Business Objects converts to Microcube.
Why do you use VBA in Business Objects?
To provide additional programming ability to Business Objects
How do you make a report read only or refresh only?
While saving a report in the Save window, click Options give a password for reading & writing.
What is vertical break and where do you use it?
It is similar to horizontal break which break on a particular value but typically used in a cross tab
How do you configure different modules of Business Objects for the users?
Supervisor decides which user needs to be provided access to different modules
What is the console mode? What you can do there?
Console mode provides the task information of the scheduled BCA tasks, processed/non-processed tasks.
What is an extended syntax in Business Objects?
Extended syntax allows users to perform calculations on a particular block, report, or body as per the requirement.
Where do you get information about Rows retrieved, Duration & Timestamp for execution? Data ? View Data ? Definition tab
How do you get 24 hr clock rather than 12 hr clock?
Format the date time to HH:MM:SS. This should make the clock 24 hr. If this does not work we need to change the clock settings in the Regional Settings of Control Panel to show a 24hr clock and select the 24hr clock in format panel of a field.
Can you perform/ put sort on hidden objects? How many ways of hiding are there?
Yes. There are two ways of hiding 1. Normal Hiding 2. Conditional Hiding.
What is conditional hiding?
Conditional Hiding is a process of hiding a field or a block if a particular condition is satisfied.
Why Business Objects generates two separate SQL?
When we query on objects, which do not have a join, they are executed as two different SQL and then synchronized.
You are unable to write combine queries, what you need to do?
In the Universe Parameters, SQL tab check the option Allow use of UNION, INTERSECT and MINUS operators.
How do you run the same report against another universe, without creating all again?
Changing the Universe name in the Definition tab of Data Manager
What is custom sorting and how do you do it?
Sorting of the variables in the order set by the user.
Can you create a report with more than one data provider?
Yes. Create two data providers and then create a virtual cardinality on the two micro cubes based on a particular field.
How does Business Objects generate a query?
Business Objects is a query builder, which builds the query, based on the selected fields and selected conditions. This generates an SQL, which is executed on the database through a middleware either through ODBC or through some other connection. The database creates a resultset and provides the same to ODBC and which the Business Objects converts to Microcube.
Why do you use VBA in Business Objects?
To provide additional programming ability to Business Objects
How do you make a report read only or refresh only?
While saving a report in the Save window, click Options give a password for reading & writing.
What is vertical break and where do you use it?
It is similar to horizontal break which break on a particular value but typically used in a cross tab
How do you configure different modules of Business Objects for the users?
Supervisor decides which user needs to be provided access to different modules
