Forum Stats

  • 3,770,163 Users
  • 2,253,079 Discussions
  • 7,875,350 Comments

Discussions

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

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

Tagged: