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
