Need to populate 60 dates in second prompt based on the date in first prompt — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need to populate 60 dates in second prompt based on the date in first prompt

Received Response
1
Views
2
Comments
yaseennawaz
yaseennawaz Rank 4 - Community Specialist
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

Hi,

I have two prompts in the prompts section.One is a Forecast Effective Date and the other Transaction date.If I give a date in the first prompt ( Forecast Effective Date) then I should get list of next 60 dates(all the dates)  including the forecast effective date in the second prompt(Transaction date).Please let me know how this can be achieved.

Regards,

Yaseen

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Create a prompt for your forecast date , make it auto apply ( uncheck the apply button from properties of prompt) and keep a presentation variable.

    Create a second prompt and make the results as SQL Results and keep the below formula

    SELECT YourTrxDateColumn FROM YOurSubjectArea  where YourTrxDateColumn between Date '@{Fdate}{2017-11-11}' and timestampadd(SQL_TSI_DAY,60,Date '@{Fdate}{2017-11-11}')

  • yaseennawaz
    yaseennawaz Rank 4 - Community Specialist

    Thanks Asim