Hi,
I am fairly new to ODI and was wondering if any guru's could help me overcome an issue im facing. I am attempting to load data from a csv file into HFM. I have selected the correct KM's (LKM File to SQL and IKM SQL to Hyperion Financial Management Data), with Sunopsis Memory Engine as the staging area.
For ease the csv file has the exact same structure as the HFM applications dimensions, and has been mapped in the interface as shown below:
Source file column - HFM target column
Scenario - Scenario
Year - Year
View - View
Entity - Entity
Value - Value
Account - Account
ICP - ICP
Custom1 - Custom1
Custom2 - Custom2
Custom3 - Custom3
Custom4 - Custom4
Period - Period
DataValue - Datavalue
- Description (no source column, mapped as '')
The csv file contains base members only. I have defined the error log file path, and when executing the interface I get an error. When I open the error log, I see the following messages:
Line: 1, Error: Invalid dimension name
!Column_Order = C1_SCENARIO, C2_YEAR, C3_VIEW, C4_ENTITY, C5_VALUE, C6_ACCOUNT, C7_ICP, C8_CUSTOM1, C9_CUSTOM2, C10_CUSTOM3, C11_CUSTOM4, C12_PERIOD, C13_DATAVALUE
Line: 3, Error: A valid column order is not specified.
Actual;2007;YTD;20043;<Entity Currency>;13040;[ICP None];[None];1000;[None];[None];Jan;512000;""
>>>>>>
I am unsure how to resolve, as based on the interface mapping the dimensions match on a 1:1 basis. Also, the dimension names in the target column match the HFM application dimension names (as this application was reverse engineered).
Please help!
Many Thanks,
Jorge
Edited by: 993020 on Mar 11, 2013 5:06 AM