RI Metric "NSF - Net Sales Amt" Not Working For Gregorian Month (Doc ID 3068468.1)

Last updated on JANUARY 23, 2025

Applies to:

Symptoms

On : 24.1 version, OBIEE - Reports/Dashboard

RI Metric "NSF - Net Sales Amt" not working for Gregorian Month ?

The metric "NSF - Net Sales Amount displays blank values when the Gregorian Month is added into the report.

After some tests and analysis on the SQL generated code, it seems the issue only happens when the report queries the Daily table:
- when fiscal date or, Gregorian month is added, the metric is blank
- when fiscal week or fiscal period is added, or no calendar dimension, the metric displays the correct results.

This is probably a metadata issue as other metrics like NSF Sales Tax or NSF Sales Qty are working properly.
I'm adding two logs:
- execution with fiscal period - it works
- execution with Gregorian month - does not work


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create report/answers with
- Item Number
- Loc Number
- NSF Net Sales Amt
- Gregorian Month

2. Notice that NSF Net Sales Amt is blank but other metrics will have values.
Also, noted it works for week or fiscal period levels.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.