Sep 2024 update came with parameter creation and binding for derived dates.
Created below parameter.
I want to use above parameter in expression filter. I am unable to use it calculation or expression filter.
Help is appreciated.
I have played around it. After reviewing Logical SQL i found answer.
Solution is
Hi @Rajakumar Burra
You may need to CAST it to a matching data type.
Create a Date Part Parameter in Oracle Analytics
[EDIT UPDATE: I was doing a little testing (November 2024) and even with simple text parameters, the syntax validation was failing]
@Avinash Krishnaram-Oracle - Any known issues you are aware of, I did not spot any.
Hi @Rajakumar Burra I too observed EXTRACTMONTH in the LSQL, but I would not have guessed to add 'timestamp' prior to the default. Thanks for sharing your solution with the community.
Thank you for sharing the solution!
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.
