May I know if any suggestions on this.

Hi All, Thank you for your replies. The below link resolved my issue. http://adventuresinobiee.blogspot.com/2013/05/missing-treat-text-as-options-in-obiee.html

We can observe that in the screenshot, 'Custom Text Format' is disabled. And only two options are available for me as shown below. There is no HTML option etc.

Yes Christian. In DB its coming Line Breaks, Bullet Points etc. I want to maintain the same in OBIEE, but its not happening (Coming in a straight line). I can't put you the screenshot. Else I would have.

I think you should duplicate the fact. Remove all the measure columns in the duplicated (Now this will be treated as Dimension in BMM Layer). Keep only the dimensional columns like the date logical column which you created etc. In the actual fact, keep only the measure columns. Join the Fact and the duplicated fact. And…

Hi Experts, Can anybody suggest me on this. The comparison between 11.1.1.6 and 11.1.1.9 has been very confusing. We are not able to identify is it an issue while upgrading or a feature in 11.1.1.9. Thanks & Regards, Karthik R