Price Metric not Calculated Properly When Fiscal Week is Selected in the OBIEE Report

(Doc ID 2252783.1)

Last updated on APRIL 11, 2017

Applies to:

Oracle Retail Merchandising Insights - Version 15.0 and later
Information in this document applies to any platform.

Symptoms

Price metric not calculating properly when fiscal week is selected in the report.

Steps To Recreate:

1. Create new OBIEE AS-WAS analysis using the following:
- Fiscal Week
- Loc Number (filter for "4059")
- Item Number (filter for "36269512")
- Price
2. Click Result tab and note that the Price metric is calculated incorrectly.

sum(Fact_W_RTL_PRICE_IT_DY_A.SELLING_UNIT_RTL_AMT by http:// Dim_W_MCAL_DAY_D_Retail_Calendar.MCAL_CAL_WID * 100000000 + Dim_W_MCAL_DAY_D_Retail_Calendar.MCAL_YEAR * 10000 + Dim_W_MCAL_DAY_D_Retail_Calendar.MCAL_WEEK_OF_YEAR, Dim_W_PRODUCT_D.PROD_NUM, Dim_W_MCAL_DAY_D_Retail_Calendar.ROW_WID, Dim_W_MCAL_DAY_D_Retail_Calendar.MCAL_PERIOD_NAME_WEEK ) as c6

Price Amt:http://DAggr(Fact - Retail Pricing.Price Amt) / nullif( Price Count:http://DAggr(Fact - Retail Pricing.Price Count) , 0)

Pricing should either take sum of all the prices and then be divided be the number of days, or the last price for the timeframe.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms