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

PTD/QTD/YTD feature not available in FDI

Syed Fahad

PTD/QTD/YTD feature is not available in FDI. This is needed for many of our reports. This needs to be enabled in FDI.

Please see a screenshot form SmartView for reference.

Thanks,

Syed

Find more posts tagged with

Needs Votes

Status: Needs Votes

Comments

Krishna Prasad Kotti-Oracle

Syed, Can you elaborate a little bit more on the Use case ?

Syed Fahad

Hi Krishna,

We have reports for which we need the data for period-to-date, quarter-to-date or year-to-date.

Please see a sample report below.

So for Aug'23, PTD data will be for the month of Aug'23.

Aug'23 QTD, data will be cumulative for the months of Jul'23 and Aug'23 combined (two months).

Aug'23 YTD, data will be cumulative for the months of Jan'23 and Aug'23 combined (eight months).

Thanks,

Syed

Ezzeldin Ashraf

Hello syed, did you find any solution for this ?

Andrew at MKL

This would be significantly helpful, especially in cases that we'd like to perform QTD and YTD analysis side-by-side.

Top Leaders

mgoswami 45

Govardhana Gurumal 34

Bhavin Desai 17

Victor H 16

Andrew at MKL 2

Top Ideas

Enhancement Request: Data Role and Security Lineage in FDI Query Execution
Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager, Regional Manager, Country, Area of Responsibility (AOR), Organization, and other business-specific access rules. One of the…
Enhancement Request: Data Role and Security Lineage in FDI Query Execution
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hi All, In our organization, data security is highly customized and complex. A single user can have multiple custom data roles assigned based on different security contexts, such as Line Manager,…
Enable Public Access to Reports and Dashboards in Oracle Fusion Data Intelligence (FDI)
Idea / Enhancement Request Oracle Analytics Cloud (OAC) has introduced the capability to provide public access to analytics content using the BI Public Role, allowing reports and dashboards to be shared with users without requiring authentication. I would like to propose extending similar functionality to Oracle Fusion…
DATA PIPELINES CAPABILITY FOR NON FUSION SOURCES IN ORACLE FUSION DATA INTELIGENCE
hi All, The existing FDI pre-built artifacts/Common Subject Areas give us useful information about data reload and warehouse refresh activities. However, I see a gap when troubleshooting Data Augmentation execution at row level. For example, we have a BI Publisher report returning approximately 1M rows, but the…
Enable the Option to Hide Fusion SCM Content in FDI Reporting Configuration
In Fusion Data Intelligence (FDI) release 26.R3.P4, Reporting Configuration provides options to hide Human Capital Management (HCM) and Enterprise Resource Planning (ERP) content. However, an equivalent option is not available for Fusion Supply Chain Management (SCM) content. SCM content remains visible in the catalog…