ASO to ASO Data Sync For FDMEE Large Dimensions Are Not Pulling in Member Names When Set to Level 0 Descendants
(Doc ID 2139551.1)
Last updated on AUGUST 07, 2023
Applies to:
Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.4.000 and laterInformation in this document applies to any platform.
Symptoms
Performing a refresh on members of large dimensions results in an error and the members are not pulled into FDMEE (refreshed).
The data for all members does come through in the data sync.
The members for the large dimensions do not show their associated names.
Error from Erpintegrator0.log indicates that there are unmapped dimensions:
2016-02-04 11:14:35,462 INFO [AIF]: Data Rows Marked as Invalid: 10871
2016-02-04 11:14:35,462 ERROR [AIF]: Error: Data rows with unmapped dimensions exist for Period 'Jan-2015'
2016-02-04 11:14:35,462 DEBUG [AIF]: CommData.updateWorkflow - START
2016-02-04 11:14:35,462 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=12,PROCESSVAL=0,BLNVALDIRTY=0
,PROCESSVALNOTE='AIF_WF_VAL_VALIDATE_ERR;10871'
WHERE PARTITIONKEY=22 AND CATKEY=2 AND PERIODKEY='2015-01-31' AND RULE_ID=102
2016-02-04 11:14:35,462 DEBUG [AIF]: CommData.updateWorkflow - END
2016-02-04 11:14:35,462 INFO [AIF]: Total Data Rows available for Export to Target: 0
2016-02-04 11:14:35,462 FATAL [AIF]: Error in CommMap.validateData
Traceback (most recent call last):
File "<string>", line 2622, in validateData
RuntimeError: [u"Error: Data rows with unmapped dimensions exist for Period 'Jan-2015'"]
Changes
Data Sync is a new feature in 11.1.2.4 and for this feature to work, the dimension name & alias is required to be the same. It is the way the new feature is currently designed.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |