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

Last 3 months data dynamically

Newuser1

Hi Team,

We have Date_1 column with timestamp data type (9/30/2010 12:00:00 AM), we converted to month year format as Date_2 (SEP 2010) and using converted format Date_2 in the report and graph.

Also we are using Date_2 as dashboard prompt requirement is, in the report and graph when we open by default it as to show last 3 months data and it as to change dynamically every month.

As of we are hardcoding using presentation variables every month can anyone suggest how we can achieve this dynamically.

Version we are using: OBIEE 12.2.1.4.0

Regards,

Find more posts tagged with

OBIEE

Comments

[Deleted User]

"We have Date_1 column" ==> You're not giving your columns an understandable and usable name?

" report and graph" ==> Are you talking about analyses or reports? Analyses are analytics. Reports are BIP. Totally different technologies.

"As of we are hardcoding using presentation variables every month" ==> How? You actually go into the RPD manually and set a value??

Newuser1

Hi Christian,

thanks for the reply find the below comments.

---- Column we are using Start_Date and converted to month year format (SEP 2010) in RPD level.

---- Directly using from RPD level in the OBI report and Graph.

---- Also we are using converted date format as prompt, for getting last 3 months data by default into the report and graph, created presentation variables date in the prompt and added filters as below.

---- How we can do this dynamically instead of changing every month hope this makes sense.

Regards,

[Deleted User]

"How we can do this dynamically instead of changing every month hope this makes sense."

No, because you didn't answer my question on HOW you set that? Precisely, in detail, with screenshots.

Also please re-read the post above: What do you call "report" is most likely an "analysis" but please clarify as reports and analyses are two different object types from two different products and technologies.

User_AWXWU

Hi,

You can try creating a repository variable CURRENT_MONTH with format you need and use CURRENT_MONTH,CURRENT_MONTH-1 and CURRENT_MONTH-2 in your filter.

Thanks,

Swathi

New Announcements

Upcoming Events

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion SCM Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion CX Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…