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

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




      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

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

      - Used Rule file to load data

      - EPM version


      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 !!