Dimension Mismatch Between Primary and Local Domains Producing "DimensionException" Error (Doc ID 1927212.1)

Last updated on APRIL 12, 2021

Applies to:

Symptoms

In Oracle Retail Predictive Application Server (RPAS) 13.4.x, dimensions which are branched off a partitioned hierarchy do not match between the primary 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 primary 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 primary 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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.