Real TimeOBIEE Questions sample

Date format issue while export to excel format 

Answers-->column propeties-->custom CSS style options(bottom of the window)-->check the custom css style -->Give the following date format
----mso-number-format:"mm\/dd\/yyyy\ hh\:mm\:ss AM\/PM" or " mso-number-format:\@"
Change the format based on you requirement.

When i logged into the analytics not able to see all the options available for administrator?
First logged in as a administrator into Em, manage the privileges which is required for the user.

I want to display the 4 narrative views in a single compound layout,but first narrative view width is 1000 and the other 3 views width should  be 500.Is it possible?
No,With a single compound view we can't achieve.

How can i sort values of column in subject area not in report ?
We can sort the column in 3 ways
1.Ascending order
2.Descending order
3.Based on another column
In Rpd we can sort the column based on the another column
BMM layer--->properties of the column_sort-->General--->Sort order column ---->select the column_base(column_sort will be sorted based on the column_base).

Can we call multiple action from a single actionlink?
Yes,We can call the multiple action links from a single action link based on the conditions.

What is the difference between joins in physical layer and BMM layer?
Both are same,but can give the complex conditions in BMM layer.The Query always fire from physical layer only.