Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 49 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 286 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How to use parameter created using derived dates [New feature in Sept 2024 updates]
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.
Best Answer
-
I have played around it. After reviewing Logical SQL i found answer.
Solution is
3
Answers
-
- Syntax for Referencing Parameters
Out of curiosity, did you test with DATE and including the default value?
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.
0 - Syntax for Referencing Parameters
-
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.0 -
Thank you for sharing the solution!
0
