How can I replicate the CONTAINS function from Tableau in OAC for text field searches?
CONTAINS
To check if data in a field(column) contains the text that we are trying to find?
@Lokesh Obhilineni-Oracle Hi Lokesh, Please pull calculated column and use case when statements along with like operator.
example: case when New to clinic indicator like '%use your text keyword%' then <yes>
else <No> End
please see if it helps.
Please you may refer for case when statements usage https://docs.oracle.com/en/middleware/bi/analytics-desktop/bidvd/conditional-expressions.html#GUID-17D67DA8-DE8E-4C05-9B9F-4D0244B263CA
There are case(if) ,case(switch) statements which you may explore
That worked perfectly
Thank you!
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher
How can you put a total number of records in your oracle OAC table footer
we have two seperate environments in air gap… 1- oas 2024 2- oas 2026 developers in both env, required extensions like push button, racing bar, guage…. where to download.
