Will the board still load rows into the cubes if the entities have NULL values ?

Rodi

Hi everyone,

I'm currently facing a problem where some rows can't be loaded into the cubes.

Some rows are loaded without any issues, but others are not. For example, rows where the entity is_productive = 1 are loaded into the cube, but rows where is_productive = 0 are not loaded at all.

One important detail: for the rows where is_productive = 0, some of the other entities have NULL values. Could these NULL values be the reason why those rows aren't being loaded into the cube?

Thanks in advance for any help!

Robert Barkaway

Hi Rodi, if you load values against NULL entity values you'll need to have the entity set to ADD NEW VALUES in the data reader, Board will then automatically substitute the NULL for an underscore as the code and Not Available as the description. The alternative is you use ETL to replace the null with a predefined value.