FNHBI Measures: Dimension Mismatch Between Master and Local Domains Producing "DimensionException" Error

(Doc ID 1927212.1)

Last updated on MAY 01, 2018

Applies to:

Oracle Retail Predictive Application Server - Version and later
Information in this document applies to any platform.


In Oracle Retail Predictive Application Server (RPAS) 13.4.x, dimensions which are branched off a partitioned hierarchy do not match between the master domain and subdomains.   This causes misbehavior of FNHBI measures that are associated with these dimensions.   The error that occurs is:


Steps to Reproduce:

  1. Assume that the local domain is directly under the master domain.
  2. Register an FNHBI measure.
  3. Navigate to the measure array in the local domain and do:   printArray -array ... -specs -options
  4. Use populateArray to set the dimpath to point to the Master domain (to simulate the problem).  If the dimpath is "../../dimregistry2.db", then set it with "../../../dimregistry2.db".
    populateArray -array ... -setOptions "dimpath" -value
  5. Run reindexDomain to increment the version.
  6. Navigate to the same measure array as in step 3 and do:  printArray -array ... -specs -options
  7. Note that the dimpath still points to dimregistry2.db instead of dimregistry3.db.


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