Price Metric Not Calculating Properly

(Doc ID 2355290.1)

Last updated on FEBRUARY 06, 2018

Applies to:

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


Price metric is not calculating properly. 

If the item was at $29.99 for all seven days of the week it should display $29.99 instead of ($29.99 / 7) = $4.284.

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.


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