Price Metric Not Calculating Properly
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")
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