2 Replies Latest reply on May 3, 2012 8:21 AM by 783124

    Importing Excel Data files to Essbase through FDM

    783124
      Apologies, another novice FDM question I'm afraid. We are trying to import Excel data files to Essbase. When setting up Import Groups, the only File Type options are:
      - Adapter
      - Delimited
      - Fixed
      - Script

      I tried importing an Excel file by selecting File Type as Delimited (Tab) as you would in an Essbase load rule, however this did not work. Similarly, I tried combinations of the other options without success.

      Additionally, when selecting an Excel file in the Import Format pane (by clicking on Build) the file looked like gibberish, for example:

      000001 � � ࡱ � > � � 9 � � � � b � d � f

      � h � j � l � n � p � r � t � v
      � 000002 �
      x � z � | 000003 x � z � |
      � 000004 �
      ~���b�d�f�h�j�l�n�p�r�t�v�x����������������������������������������������������������������������������������������������������������������������

      �����������������������������������������������������������������������������������������������-tab- 000005 ~ � � � b � d

      � f � h � j � l � n � p � r � t � v � x � � � � � � � � � �

      � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �


      Can one import Excel files to Essbase using FDM? If so, how does one achieve this?