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

Reg: Default values in the prompt

User_JZKI6

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,

Find more posts tagged with

Comments

[Deleted User]

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

Hi Christian,

Thank you for the response.

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

Thanks,

[Deleted User]

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.

New Announcements

New Events

Analytics - Fusion Data Intelligence: Semantic Model Extensions in FDI: Concepts, Use Cases, and Architecture
Learn how Fusion Data Intelligence supports customization and extensibility across content, data, semantic modeling, and security. This session explains why customers extend FDI, how the FDI architecture enables governed customization, and how to choose among OAC self-service, Data Augmentation, Semantic Model Extensions,…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: Salesforce Connector. Unlock the full value of the Salesforce CRM Connector with out-of-the-box subject areas that deliver immediate business insights, and discover how easily they can be extended to meet your unique reporting and analytics needs. Through "art of the possible" demonstrations, explore…
AIDP - Building an AI-Ready Enterprise (Europe and Middle East Time Zones)
Description: Join Oracle and ISG Research to explore what the ISG Buyers Guide™ reveals about the requirements behind successful enterprise AI deployments. ISG will share key findings on the trends shaping buyer priorities, and Oracle will show how Oracle AI Data Platform helps organizations bring AI closer to trusted…