SAC Modeler - load data into a model - defines blank as '<root>'

[Eladtayarr]

In SAP Analytics Cloud (SAC) Modeler, whenever I load data into a model from an Excel file that includes blank values in a certain column, the system automatically defines everything that is blank as '<root>' in the hierarchy.
Is there a way to disable this?
So that blank values appear as they are (for example, an empty cell or another value I define) instead of creating the '<root>' entry in the hierarchy.

Any guidance or suggestions would be greatly appreciated!

[William_Yu · Accepted solution]

It's a current limitation. One workaround: split data load into two jobs: 

1. Job 1 with data having parent member value for that hierarchy, map the column to hierarchy property 
2. Job 2 with data having parent member empty, DON"T map hierarchy property in this case. 

[Eladtayarr · Accepted solution]

Thank you so much for your help!

[AbdullahShaffi]

It will be <root> if left blank which technically means this member doesn't have any other parent. There's no option to disable this <root> if you have created a hierarchy in your dimension.

1. You can create a default parent like "H1/ALL" and assign everything under this default parent.
2. You can keep <root> as default initially and then subsequently load hierarchy using another query.  

[Eladtayarr]

Thanks for your help.

Maybe you can help me understand the (2) option..

To keep <root> as default initially and then subsequently load hierarchy using another query?