Item Level 1 Desc and Item Level 2 Desc Dimension Values Are NULL in Retail Analytics OBIEE Reports

(Doc ID 1643755.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Merchandising Analytics - Version 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