I have a table like below.
I want show only upcoming milestone based on current date.
For example, My canvas should show only RC2 Content Complete Oct/25/2024
Any ideas?
Hi @Rajakumar Burra ,
I would create a parameter and initialize it with the date of the upcoming milestone using a logical SQL query: select MIN(Date) from <Dataset/Subject area> where Date >= CURRENT_DATE and Milestones IS NOT NULL
select MIN(Date) from
<Dataset/Subject area>
where Date >= CURRENT_DATE and Milestones IS NOT NULL
Then you can add an expression filter to your table (or to your canvas): Date = @parameter(<NAME>)(<DEFAULT>)
Date = @parameter(
<NAME>
)(
<DEFAULT>
)
Thanks @Federico Venturin It works.
In
I have not used Logical SQL parameter select MIN(Date) from <Dataset/Subject area> where Date >= CURRENT_DATE
where Date >= CURRENT_DATE
and used Initial Value as "First Available" and bind to table filters.
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.
