7 Replies Latest reply: Feb 6, 2014 8:02 PM by Praveen. A RSS

    Uploading data via aliases

    1042469

      Hi,

      We can upload data via members in using FDM.

      Can we upload data via aliases using FDM?

       

      Regards.

        • 1. Re: Uploading data via aliases
          Praveen. A

          Hi

           

          Yeah we can do that but we need to map it with target Dimension members .

           

          Source can be anything but we need to map it to proper dimenson members.

           

          Thanks

          • 2. Re: Uploading data via aliases
            1042469

            Thanks for reply.

             

            I tried to map against alias member.

            When i select browse for hyperion dimension i can see two columns.

            Target Key and Description

             

            In description we are having aliases.

            Please guide me how can i do it.

             

            Regards.

            • 3. Re: Uploading data via aliases
              SH

              If you read the initial response to your question you will see the following staement

               

              Yeah we can do that but we need to map it with target Dimension members .

               

              The target in the mapping has to be a member name you cannot use aliases. What the previous poster was trying to say was you can use any identifier as a source member. You can as you state see the alias in the description when choosing the target member but you have to map to the member name

              • 4. Re: Uploading data via aliases
                1042469

                In short i can't map against alias but use them in description.

                 

                I am using this format to upload mapping.

                e.g.

                Source Account,Target Account

                1111,00001

                1112,00002

                 

                Where does the description comes in?

                I tried using this format

                 

                Source Account,Description Account,Target Account

                1111,Account 1,00001

                1112,Account 2,00002

                 

                The above file didn't work. It puts Account 1 and Account 2 in Target account.

                How can i add description.

                 

                Regards

                • 5. Re: Uploading data via aliases
                  1042469

                  Any help. Please.

                   

                  Regards

                  • 6. Re: Uploading data via aliases
                    Francisco Amores

                    I think you are confused.

                     

                    are you talking about file with mappings to be imported?

                     

                    That account description is not the alias, it is the MAPPING DESCRIPTION.

                     

                    If you want to import mappings from TRA format (text file) you cannot import the mapping description.

                     

                    You will have to use Excel file for mappings.

                    • 7. Re: Uploading data via aliases
                      Praveen. A

                      Hi why dont you use maploader for Mapping,

                       

                      or you can do one thing map 1 member manually from Activities ->Maps after mapping  export that excel file

                      then add the total member in the excel file and import.

                       

                      Thanks,

                      Praveen