I am unable to find the ARsqls27.so file in any of the ORACLE_HOME or anywhere in the server. So apparently, it didn't ship with my Oracle 12c. What should be my next step ?

Great Question. Answer is Ad-Hoc reporting. I don't want to expose a whole bunch of presentation service layer tables and columns to the users to build their customer reports via drag and drop. I only want to give a selected filter capability to build OBIEE reports. Does that make sense '?

I am not sure how to explain: 1. I am an OBIEE certified developer and I know how to create a prompt. 2. My post is regarding creating customer OBIEE dashboards using ADF objects in JDeveloper. Does that make sense ? Thanks Rohit

Thanks for replying Gianni, i replied to Joel with the answer.

Yes @Joel I am looking for something OOTB in OBIEE wherein i can create my own filters and want to user to selected the filters one after the other. Does that make sense ? Thanks Rohit

It was helpful, but the accurate answer is: EVALUATE('regexp_replace(%1,%2,%3)' AS CHAR,<OBIEE Column Name>,'[[:punct:][:space:]]+',' ')

This answer was not helpful as while implementing it, it gave errors. I would like to hear from someone who has actually implemented the hostname (computer name) change on a windows environment. Thanks

Thanks. I was able to crack it. Here is the code: SUBSTRING("Input String" FROM 1 FOR length("Input String") - LENGTH(TRIM(RIGHT(REPLACE("Input String", ' ', REPEAT(' ', 100)), 100))) ) || case when TRIM(RIGHT(REPLACE("Input String", ' ', REPEAT(' ', 100)), 100)) = 'RD' then 'ROAD' when TRIM(RIGHT(REPLACE("Input String", '…

Let me try this Gianni !

In an ideal world everything should be pushed to ETL, but in a practical world you have to deal with it based on case by case.

Thanks for all the help !

Here is the solution: 1. Create an additional column with the formula: case when "FACT.measure1" = "FACT.measure2" then 1 else 0 end 2. Lets call the column 'dummy' and Hide the column 3. Go to the conditional formatting for "FACT.measure1" and select 'dummy' =1 then 'Green' 4. Go to the conditional formatting for…

Hi Christian, Let me try it OBIEE and if it works, will mark your answer as correct. Also need to find the corresponding string functions in OBIEE. Thanks Rohit