Create Cube Task Fails with 'Could Not Set Alias for the Node KRW' (Doc ID 1533341.1)

Last updated on MAY 06, 2016

Applies to:

Oracle Financial Services Enterprise Financial Performance Analytics - Version 5.6 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2.8 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

For Oracle Financial Services Profitability Analytics (PFTBI) 5.6, when you run a batch for the Cube Build, the Aggregate Data Task is successful but the Create Cube task fails.  The following error is in the OlapEngine log in $FIC_DB_HOME/log/olap:

2013-02-09 | 13:37:18 | olapengine | SEVERE | | | Error : while setting member alias : 1060018
2013-02-09 | 13:37:18 | olapengine | SEVERE | | | Error : Could not set alias for the node KRW
2013-02-09 | 13:37:18 | olapengine | SEVERE | | | Error : Could not add the node to outline -- HEPMCU01
2013-02-09 | 13:37:18 | olapengine | SEVERE | | | Error : Could not add nodes of a hierarchy to the outline
2013-02-09 | 13:37:18 | olapengine | SEVERE | | | Error : Could not add the hierarchy to the outline : HEPMCU01
2013-02-09 | 13:37:18 | olapengine | SEVERE | | | Error : Could not add the dimension to the outline : DEPMCU01
2013-02-09 | 13:37:18 | olapengine | SEVERE | | | Error : Could not add all the dimensions to the outline
2013-02-09 | 13:37:18 | olapengine | SEVERE | | | Error : Outline saving failed


As a result of the error, you cannot create the cube needed for the PFTBI Dashboard.

Note: This is the first month you have data in FCT_COMMON_ACCOUNT_SUMMARY with V_ISO_CURRENCY_CD = 'KRW'.

Steps to reproduce:

  1. Go to Operations > Batch Maintenance
  2. Create a Batch with two Task, one with AGGREGATE DATA and one with CREATE CUBE
  3. Go to Batch Execution and run the Batch for the date of the data in FCT_COMMON_ACCOUNT_SUMMARY

The AGGREGATE DATA task is successful but the CREATE CUBE task fails.

Cause

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