BO Designer Interview Preparation Guide

Download PDF

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

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

Restrict Top 26 Rows: Depends on how you want to do it.

In a report: Drag the Dimention and measures into report. Click on the Dimention object and use the RANK button on the tool bar. you can specify the the Top 26 or Bottom(Depending on the requirement) values of a measure. It also provides some calculation like Sum/Percentage

If you want to restrict the Top 26 in the query itself, you might have to create an object in the universe. May have to use the analytical functions based on which you need to Rank the Data.

1.each n every object n class must be given description so that it is very clear to non technical users also n each n every object must me given a understandable clear name so that by just looking at that one can be able to find out whether it is a measure object or dimension object.

2.there must no loops,fan traps or cham traps while designing the universe.

3.we must check the integrity of the universe.

Right click on any object,go to the properties.specify the query in select and put the next query in where clause,

like select COLNAME from TABNAME1 where COLNAME IN(select colname2 from tab2)

Index awareness is the ability to take advantage of the indexes on key columns to speed data retrieval.

In DESIGNER Level
1)eliminate the unnecessory joins
2)use conditions as much as at the database level
3)edit the SQL query in the Query Panel as per requirment

In REPORTER level

1)eliminate the filters as much as possible
2)try to reduce the user variables

Select the component business object Designer
Now it will prompt for userid/password/security domain
You will find a Help button, click that and find out what ever you want

Functional Differences :

1.BusinessObjects client needs to be installed on every PC from where you want to build / access reports. WebI needs just a browser & URL(of the server from where it will access BO).

2.BOMAIN.Key file needs to be copied on every individual PC that uses BO client. WebI doesn't need it.

3.You need to stick to those PCs which have BO client installed, WebI can let you access even when you are roaming anywhere in the world(provided the access conditions i.e. internet/VPN enabled WebI web server)

Architectural Differences :

1.BO Client : client machine calls BOMAIN.key on it's local drive, that sends info to BO Server's BOMAIN.key, validates it, then checks it into Repository, after repository validation user can access the BO services.

2.WebI : user logs into WebI using InfoView from web-browser, it talks to the WebI Web server, web server's BOMAIN.key checks the privilages of that user, send info to BO server's BOMAIN.key, that validates the info & forwards to Repository, if it validates the info, gives access to the universe & underlying dabase.

elect @@version is the command that will give the said details