3 Replies Latest reply: Jun 7, 2013 11:31 AM by Erich Ranz RSS

    Query on Import profile in EPMA

    970544
      Hi Team,

      I am using an import profile to load metadata into EPMA HFM application from a flat file(.ads file).I am unable to map the below mentioned HFM properties in the Import profile.These properties are not appearing in the Property selector.Version used is Hyperion 11.1.2.2.

      Custom1TopMember
      Custom2TopMember
      Custom3TopMember
      Custom4TopMember
      EnableCustom1Aggr
      EnableCustom2Aggr
      EnableCustom3Aggr
      EnableCustom1Aggr

      Requesting your help.

      Thanks in advance.
        • 1. Re: Query on Import profile in EPMA
          Erich Ranz
          What are you using to create the ads file? EPMA File Generator?
          • 2. Re: Query on Import profile in EPMA
            970544
            It is an export file of a hierarchy from DRM.I am using it as a source file to import into EPMA HFM application.

            Thanks
            • 3. Re: Query on Import profile in EPMA
              Erich Ranz
              Do you have a Dimension Association section in the ads file? Something similar to below:

              !Section = DimensionAssociations
              'BaseDimension;Property;TargetDimension
              Account;Alias;Alias
              Account;Custom1TopMember;Custom1 
              Account;Custom2TopMember;Custom2 
              Account;Custom3TopMember;Custom3 
              Account;Custom4TopMember;Custom4 
              Account;ICPTopMember;ICP
              Account;PlugAccount;Account 
              Account;SecurityClass;Security Class 
              Currency;Alias;Alias
              Custom1;Alias;Alias 
              Custom1;SecurityClass;Security Class 
              Custom2;Alias;Alias 
              Custom2;SecurityClass;Security Class 
              Custom3;Alias;Alias 
              Custom3;SecurityClass;Security Class 
              Custom4;Alias;Alias 
              Custom4;SecurityClass;Security Class 
              Entity;Alias;Alias 
              Entity;Currency;Currency 
              Entity;HoldingCompany;Entity 
              Entity;SecurityAsPartner;Security Class 
              Entity;SecurityClass;Security Class 
              Period;Alias;Alias 
              Scenario;Alias;Alias
              Scenario;DefaultFrequency;View 
              Scenario;DefFreqForICTrans;View 
              Scenario;PhasedSubStartYear;Year
              Scenario;SecurityClass;Security Class 
              View;Alias;Alias 
              Or, is the import profile set up to load a single dimension at a time? The profiles can be configured in many different ways.