Error While Creating a Report Using Loc Open Date Column: "No Fact Table Exists at the Requested Level of Detail" (Doc ID 1491531.1)

Last updated on OCTOBER 28, 2015

Applies to:

Oracle Retail Merchandising Analytics - Version 13.2.4 to 13.2.5 [Release 13.2]
Oracle Retail Merchandising Analytics - Version 13.3 to 13.3.6 [Release 13.3]
Information in this document applies to any platform.
Checked for relevance as on 21-AUG-2014


An error occurs while creating a report using the LOC Open Date column.

Steps to Recreate:

  1. Log in to OBIEE.
  2. Select New - Analysis - As-Is
  3. Select Date, Loc, Net Sales Amt.
  4. Select Result.  No data.
  5. Add loc open date and click on result tab.
  6. The error is displayed  as “No fact table exists at the requested level of detail”:

Error in OBIEE report:



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