OBIEE Analysis Interview Questions

ANALYSIS

1.       What are the column properties?

Style, column format, data format, conditional format, interaction, write back

 

2.       What is the use of hide column option?

It is useful to hide unnecessary columns

 

3.       Can we sort month column as per calendar ascending order ?

Yes. By using the month code column we can sort as per calendar ascending order and we can hide the month code column if we don't want it in the report

 

4.       Can we format part of the column title?

Yes. in OBIEE 11G by using HTML tags we can do it

for ex:- cal year is the column name. we want to make only year bold we can make it as cal<B>year</B>

 

5.       What is suppress option?

It is useful to hide duplicate values in report

 

6.       What is data format?

It is useful to convert one format of data into another format

ex:- if we want convert the rupees into dollars or to any other currency we can do it.

 

7.       What is Conditional Formatting?

It is useful to format data based on some condition

ex:- if we want to divide the business based on sales then

dollars-->column properties-->conditional formatting

dollar's value is less than 100000-->select color as Red

dollar's value is between 100000, 200000-->select color as Yellow

dollar's value is greater than 200000-->select color as Green

we can see the data of dollar values with colors

 

8.       What is Interaction?

It is useful to apply action links, drill options on column headings and column values

 

9.       What is Write back?

In Reports of Answer you can give a column as updateable and then view the reports, this option is called write back.

 

10.   What is BIN?

Bins are useful to combine the values for the column into sets and also useful to group the data