HFM Interface Table help
Hello, (this is a re-post, i originally posted this on the FDM forum) we are trying to load an HFM application using epm interface table. According to the tutorial, we have to load a table called HS_DATA_CONSOLIDATION, i think we got most of the columns covered, but i have questions about 2 of them, LOADID => not sure what to put here, VIEWDIMENSION, i hardcoded thevalue YTD just to get the data loaded, but i'm not sure if that is the right value to put, the HFM guys are not telling me if there is a "default" value for hfm that can be put here. Anyone has any experience on this ?
"LOADID" NUMBER(38,0),
"SCENARIO" NVARCHAR2(255) NOT NULL ENABLE,
"YEAR" NVARCHAR2(255) NOT NULL ENABLE,
"PERIOD" NVARCHAR2(255) NOT NULL ENABLE,
"VIEWDIMENSION" NVARCHAR2(255) NOT NULL ENABLE,
"VALUE" NVARCHAR2(255) NOT NULL ENABLE,
"ENTITY" NVARCHAR2(255) NOT NULL ENABLE,
"ACCOUNT" NVARCHAR2(255) NOT NULL ENABLE,
"ICP" NVARCHAR2(255) NOT NULL ENABLE,
"CUSTOM1" NVARCHAR2(255) NOT NULL ENABLE,
"CUSTOM2" NVARCHAR2(255) NOT NULL ENABLE,
"CUSTOM3" NVARCHAR2(255) NOT NULL ENABLE,
"CUSTOM4" NVARCHAR2(255) NOT NULL ENABLE,
"DATA" FLOAT(126) NOT NULL ENABLE