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 184.108.40.206
- IM Used : IKM SQL to Hyperion Essbase (DATA)
- Used Rule file to load data
- EPM version 220.127.116.11.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 !!