Real time situations in OBIEE

OBIEE, is really every table is set to cacheable by default?

No ,By default some of the physical tables are not set cacheable because those tables are maintained with large volume of data, so it may lead to performance issues.

We can Observe the cacheable option : table->properties

I have a report, built with columns like order_no, order_date, order_loc etc..In the report i can able to see the data perfectly but when i download the report to excel the data column is showing the unexpected result. Is it a expected scenario? If yes, how can i resolve this?

Yes, this is an expected behavior, so we have to externally tell the BI serer to follow a specific format when download the report.

Steps:

Analysis->column properties-> Custom CSS style format->specify the date  format ->mso-number-format:"\@"

I have a dashboard prompt ,which is a edit box. I want to use the edit box as case in-sensitive filter in my dashboard page. Is it possible?

Yes, It is possible you can achieve this required my changing the configuration setting in the NQSconfig.INI file.

CASE_SENSITIVE_CHARACTER_COMPARISON = OFF;//by default 'ON' enabled

Restart the services and observe the behavior of the Edit box.

More Questions on OBIEE