Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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
