nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

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!

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…

Top Leaders

Mallikarjuna Kuppauru-Oracle 80