Business Objects Interview Questions

Dashboard is basically a Plate form where all the component represent the Progress. ScoreCard is a component which shows KPIs of the Company and give them better look in order to have good decision. l...

When Query fired very first time it hits directly against the Database and then its fetch all data and store into one MICROCUBE. MicroCube basically a temp place holder where all the Possible dimensio...

Micro cube is the one which stores the results of the query. each data provider stores it results as/ in the micro cube when we create the query in the query panel. you can access the micro cube in ...

To my Understanding Crystal Report is older then Webi and it has more user friendly Connection available compare than webi. Custom formatting, Wide range of Variable, Predefined Filter, Printer and etc.... It usually use for Transitional data.

In WEBI we don't have add command option ,in crystal report we have add command option.

There are major Three Context Operator use in the calculation.
ForAll : Operator Remove the Dimension form the Calculation context.
ForEach : Operator Add the Dimension From the Calculation Context.
In : Operator give you calculation from the scratch.

Both ForEach and ForAll Operatators are context operators.
ForEach allows us to define groups within the data context for our calculations.
Whereas ForAll allows us to instruct Business Objects which dimensions in the report context will not affect our calculations.

Query Performance: I would say you should check first SQL and run against directly to the database and note that it is taking the same time to fetching the data. 2) Try to avoid extra prompt in your r...

Check your Sql Query for all Data providers in your report

In Groupby is there any measure you have.

If you have measure objects in groupby then it will take too much time run the report.

Linking the data base in the universe levels

according to your question you want data synchronization from two different database..(it means they r not relational data so cant get synchronized anyway)...now if u have one database(relational) b...

actually bca is used to schedule and deliver reports not for securities. securities are handled by supervisor tool in older versions of bobj. supervisor is the old cmc. please rectify the answer.

BCA is similar to CMC, this is not available in BOXI. BCA does all the security level actions similar to CMC in BO 6.5.

Context is set of joins through the tables which has a some functionality served.These are used to resolve loops. If the same join is used in two contexts ,then any dimension or measure using the co...

Context is a mechanism used in Business Objects.We come across this word in Universe design.It is mostly used to resolve the loop problem.Basically, Loops can be solved by the alias concept.Some loops...

Info BURST is used to schedule and/or run BO and Crystal reports, and send the output in different formats (eg. BO report, Excel, PDF, Word, ...) to one or more users, to a file directory, ...

Incremental aggregation concept is required in incremental loading. For example, lets say we receive sales data weekly and the same data is stored in some fact table with monthly granularity. We might...

Ill answer the first three. An incremental aggregation (I think because I have not exactly used the term) is an aggregate in which the new aggregate rows are appended (added to the back of) previous a...

When ever we work with DESKI/WEBI rich client, we have option to save the report in the local m/c or in the repository.Select File->export, report gets saved in the repository.

Whenever you are releasing the report in any domain it directly goes to Repository and it always shows to corporate documents and can export from there.
If you want to delete any file then you will have to delete from repository there is nothing second medium to delete it.

Dashboard is contain summarized data and its can view good quality of presentation.

Dashboards give dynamic interactivity and easier way of representation and summarized level of values

In BOxi3.1 we have freestanding cells ,in that current date function one cell is there u can drag and drop into report header it will display current date,or u can create a variable like current date(object)

By Using CurrentDate function

you can combine two universes by using link parameter, but at that time two is same database,suppose one is local repository another one is server repositories you combine to both universe to server repository or local repository

We cannot link universes which are built on top of different data sources, but we can built reports from them in webi through multiple universe option. Another way is by creating schema using DATA FE...

In Oracle to_date(to_char(datecol, mm/dd/yyyy), mm/dd/yyyy)

FormatDate(DATE;DD/mm/YYYY)

When an object is deleted, the designer must remove all objects that relate to that object or alter them so that they didn't refer to it.

It is a common dimension there in two queries. The basic use of merge dimension is to create a common block with the help of two or more data providers. steps: 1. Create a report with two queries. 2. ...

If you are using same dimension from different table like Year dimension will use in all the rate tables.

At that time will Combine(merge) all the dimensions in to one dimension.

Yes the 2nd one is possible only if it is R3(i.e external source).

as mentioned above... use webi rich client for flat file as one of the data source.

Major difference b/w XIR2 and XI3.1 from the server part

1. we have a centralized server SIA which manages all the other servers in XI3.1.

2. In XI3.1 webi rich client has been introduced.

3. Security model is different regarding inheritance in XI3.1

etc

XI r2----we used to do the webI reports in Infoview that is in the web. XI r3----we can do the webi in both infoview and rich clint that is we can do the reporting in online and offline modes. 1. W...

Condition is applicable on the table set. It works same as where clause in SQL. Where as filter works on the result set, just like having clause in SQL.

Conditions should be applied at the designer level. where as the Filters are mostly used in reporting tools.

Condition fetches the data directly from database while filter just hides the data without interacting with the database.Condition works on query level while filter works on report level.Condition is used for better performance while filter is used only when we are unable to apply conditions.