Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Reg: Default values in the prompt

11
Views
3
Comments
User_JZKI6
User_JZKI6 Rank 4 - Community Specialist
edited Aug 13, 2024 5:15PM in Oracle Analytics Forum

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.