Q: How will you do sort in Reports in OBIEE Answers.

 Q: How will you do sort in Reports in OBIEE Answers.
A: Click modify and then click sort (order by icon) on the relevant column in the criteria  pane.

How to get sql from obiee for reports? What is write-back in obiee ?

Q     How to get sql from obiee for reports?
A :-  There are many ways to get the sql
•      Modify the request and click Advanced in that you get xml code and also the actual sql.
•      In the catalog Manager click Tools –>Create Report .In the Create Report 

Q:    What is write-back in obiee ?
A:-    In Reports of Answer you can give a column as updatebale and then view the reports,this option is called write back.By clcking Administration->Manage sessions-> view sql.

What is single LTS and multiple LTS

Q:    What is single LTS and multiple LTS?

 A:    The logical table created at the BMM layer can be based on the data from a single physical  layer table, when it is called single Logical Table source. When the specific logical layer table is dependent on the columns of different physical layer tables, it is called Multiple LTS. Most of the time we will be dealing with Multiple LTS.