Create hierarchy in a report connected to a SSAS model

[axy5093]

Hi everyone,

I have a need to create a simple hierarchy within a table. But the data is obtained from a SSAS connection and the usual New hierarchy option on right clicking an attribute is missing. Does any one know a workaround to create a hierarchy in this scenario ?

Thanks

[v-shex-msft · Accepted solution]

Hi @axy5093,

Do you means create customer hierarchy in SSAS source with live connection mode?

If so, current live mode not support this, you need to use import mode to instead or create hierarchy at AS side.

Regards,

Xiaoxin Sheng

[v-shex-msft · Accepted solution]

Hi @axy5093,

Do you means create customer hierarchy in SSAS source with live connection mode?

If so, current live mode not support this, you need to use import mode to instead or create hierarchy at AS side.

Regards,

Xiaoxin Sheng

[axy5093]

@v-shex-msft Thank you 🙂

 Could you guide me on how to use the import mode ?

Thanks 

Aish

[v-shex-msft · Accepted solution]

Hi @axy5093,

You can choose import mode at AS connector menu.

BTW, if you choose import mode, all measure will be analyzed as fixed values and the table relationship will be broken.

Regards,

Xiaoxin Sheng