Extracted Data Lines are not all Converted correctly by Selected Entity Conversion Table
Posted by Priya Doyle on 16 February 2011 11:47 AM
Applies to:Hyperion Enterprise - Version: 220.127.116.11.00
Information in this document applies to any platform.
During past maintenance of the application entities within the Entity conversion tables were deleted. Prior to deletion of Entities, the Entity Conversion Tables were not purged of the redundant Entities.
The Entity Conversion Tables contain Entities that are no longer in the Application and which were never purged for the Conversion Tables.
Two solutions to this problem are available.
Before proceeding ensure no users are working in the application and you have a valid back-up.
Solution A delete and re-create existing conversion tables
A1, Navigate to the Application Module from the Oracle Hyperion Enterprise Desktop.
A2, Select TASK
A3, Select EXTRACT APPLICATION.
A4, Deselect the 'ENTIRE APPLICATION Check Box of the Extract Application Window.
A5, Under the ENTITIES tag Select ENTITY CONVERSION.
A6, Back at the FILE tag , give the file a suitable name.
A7, Select OK and allow the extract to run.
A8, Access the Extract file and open in a suitable TXT file editor (Notepad.exe or similar)
A9, The format of the file will be as follows for an extract conversion table .
The second column after the delimiter contains the entities that MUST be available in the Application. If they are not the error is produced.
Each of these 'Missing Enterprise Entities' need to be corrected and changed to valid Enterprise Entities or removed.
A10, Once the extract file is cleaned proceed as follows.
A11, From the Entities Module
A12, Select NAVIGATE
A13, Select Entity Conversion Tables.
A14, Open Any Table by highlighting it and pressing OK
A15, From the File Menu , Select and delete all Entity Conversion Tables. (Removing them from Database Formats they are attached to if needed)
A16, Return to the Application Module
A17, Select Task, Load Application
A18, Re-load the corrected extract file of Conversion tables to re-create the Conversion Tables.
A19, If the Conversion Table names were removed form Database Formats..Re-add them at this point.
Verify the Conversion Tables are working by running an Extract or Load of Data using the Formats that apply them.
Solution B Create New Entity Conversion Tables
Follow the same steps as solution path A but
B1 While editing the Conversion Table Extract, Adjust the conversion table NAME field to a new desired name.
B2, Negate step A15, the deletion step.
If new Conversion Tables are created, the Database Formats calling these tables Must to changes to the NEW Conversion Table Names.
B3, Enter the Database Module
B4, Select FILE
B5, Select OPEN FORMAT
B6, Open each Format in turn and change the Entity Conversion Table to the newly created appropriate Entity Conversion Table.
B7, Again as in Solution A, verify the Conversion Table works as expected.