0 Replies Latest reply on Jul 10, 2020 10:39 AM by Las071214

    Load NULL or #MISSING in Hyperion Essbase in place of zeros

    Las071214

      Hi,

       

      We are loading data from a FlatFile to Oracle Table(staging) to Hyperion Essbase.

      I am able to load 'NULL' till Oracle staging table.

      But unable to load 'NULL' to Hyperion Essbase. Zero is getting loaded without any error.

       

      - ODI version 11.1.1.5

      - IM Used : IKM SQL to Hyperion Essbase (DATA)

      - Used Rule file to load data

      - EPM version 11.1.2.3.5

       

      I assume, we are unable to load '#MISSING' / NULL as Data column in Essbase is always Number.

       

      Could anyone who has experienced this and have any suggestions or workarounds will help. Thank you !!

       

      Regards

      Sowjanya