Item Level 1 Desc and Item Level 2 Desc Dimension Values Are NULL in Retail Analytics OBIEE Reports
Last updated on AUGUST 17, 2016
Applies to:Oracle Retail Merchandising Analytics - Version 184.108.40.206 and later
Information in this document applies to any platform.
The dimensions 'Item Level 1 Desc' and 'Item Level 2 Desc' all display null values in OBIEE reports.
Steps to Reproduce:
1. In Oracle Business Intelligence - Enterprise Edition (OBIEE), create an analysis formed as:
- Fiscal date
- Item Level 1 number
- Item Level 1 desc
- Item Level 2 number
- Item Level 2 desc
- Net sales qty
- Net sales amount
2. Note that in the resulting report, 'Item Level 1 desc' and 'Item Level 2 desc' are NULL.
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