SAP Analytics Cloud - How to create a hierarchy in the model in the updated version.

[sraji2486]

I have created an import model from SF to SAC using the new model type.

In this model,  I have assigned a description column to the respective ID field.

Now, I have to create a hierarchy (Company -> Business unit -> Department -> Sector). Like the old version, I am not able to create a hierarchy. How to create the hierarchy?

[N1kh1l]

@sraji2486 

When you get the dimension and measure view from data file, if you create dimension table for the dimension you will see option to create the hierrachy

If model is already created without generating the dimension tables, you can open the model and select the field and then click generate dimension table.

Then go click on the dimension and then you have option to add hierarchies on right hand pane.

Br.

Nikhil