Oracle Communities

Oracle Analytics and AI

Child Item

How to use parameter created using derived dates [New feature in Sept 2024 updates]

Rajakumar Burra

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.

Find more posts tagged with

Accepted answers

Rajakumar Burra

I have played around it. After reviewing Logical SQL i found answer.

Solution is

All comments

Steve F-2

Hi @Rajakumar Burra

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.

Rajakumar Burra

I have played around it. After reviewing Logical SQL i found answer.

Solution is

Steve F-2

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.

Benjamin Arnulf-Oracle

Thank you for sharing the solution!