Oracle Analytics Cloud and Server

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

Reg: Default values in the prompt

1
Views
3
Comments
User_JZKI6
User_JZKI6 Rank 4 - Community Specialist

Hi Team,

We have date variable prompt in the format of MMM YYYY (JAN 2018), in the report level we need to show default values for last 3 months from the current month of the date prompt.

We don’t have access to RPD for creating variables can someone suggest on this scenario.

Thanks,

Comments

  • [Deleted User]
    [Deleted User] Rank 5 - Community Champion

    First question: Your "date variable prompt" gives you an acutal date as an output which is simply formatted MMM YYYY? Or is that a string?

  • User_JZKI6
    User_JZKI6 Rank 4 - Community Specialist

    Hi Christian,

    Thank you for the response.

    Yes date prompt is converted string format field from datetime field.

    Thanks,

  • [Deleted User]
    [Deleted User] Rank 5 - Community Champion

    There's not much you can do with a string that doesn't require extreme amounts of conversion and hence will costs performance.

    If you work with proper dates and / or properly formed date dimensions then things become a lot easier.