Latest SAP BO Interview Questions and Answers
1 :: What is mean by aggregate aware?
How we are using this function?
Aggregate awareness is a term that describes the ability of a universe to make use of aggregate tables in a database. These are tables that contain precalculated data. You can use a function called @Aggregate_Aware in the Select statement for an object that directs a quely to be run against aggregate tables rather than a table containing non aggregated data.
Pros:
Speed up the execution of query and Improve the performance of Sql transaction.
If you are using the aggregate tables then you must refresh the aggregate table with all fact tables to have the consistency in your result.
2 :: what are templates in which way it is help full?
what is data provider?
what is freehand sql?
difference between b.o 5.1 and 6.Ib?
I instead of selecting standard report format we can select the template in which we wish to fgenerate a report.
for ex:-if we want our report to be in cross-tab format we can select that template.
templates are very helpful bcoz we can select the template in which we want to generate the reports accpording to our choice.
2.data providers are the sourse data to generate the reports
some of the data providers are
ex:-universes,excel sheets,text documents n blah blah
