Price Metric not Calculated Properly When Fiscal Week is Selected in the OBIEE Report
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.
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")
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms