In OBIEE Report, Base Cost Returns No Data

(Doc ID 2354781.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.

Symptoms

While viewing base cost of an item in a store, OBIEE displays No Results.

Steps To Recreate:

1. In OBIEE, create a new analysis using Retail Merchandising Analytics As-Was subject area
2. Select
- "Item As Was"."Item Number"
- "Organization As Was"."Loc Number"
- "Business Calendar"."Fiscal Date"
- "Unit Cost"."Supp Base Cost"
3. Filter out
- Item Number = 38604765
- Loc Number = 2
- Fiscal Date = 06/01/2017
4. Click Results button.
5. OBIEE displays 'No Results'.

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