Unable to import hierarchy through SSAS

[saurabh_kedia_]

Hi folks,

May be I'm missing out on a simple solution.

I'm trying to import hierarchy dimensions (User Hierarchy) when connected through SSAS cube.

I would like to import level 3 name & level 4 name of hierarchy.

Although if this is comparatively complex then I'm fine with importing the complete hierarchy.

Kindly assist on the above.

Regards,

Saurabh

[v-yuta-msft]

Hi saurabh_kedia_,

Have you enabled AttributeHierarchyEnabled property to false in SSAS side? Please check it. Also refer to the similar case in SSAS forum: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d1595f37-5b52-4b18-b234-ce8a61ed201e/the-al...

Regards,

Jimmy Tao

[saurabh_kedia_]

Hi Yuta,

Thanks for your inputs.

Just to summarize, the AttributeHierarchyEnabled property should be turned to false in SSAS even if I want to import the complete hierarchy.

Please correct me if I'm wrong.

Thanks,

Saurabh

[v-yuta-msft]

@saurabh_kedia_,

Have you solved your issue? If you have, could you please kindly mark the correct answer?

Regards,

Jimmy Tao

[v-yuta-msft]

Hi saurabh_kedia_,

You should enable AttributeHierarchyEnabled property to true on SSAS side.

Regards,

Jimmy Tao