cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saurabh_kedia_ Regular Visitor
Regular Visitor

Unable to import hierarchy through SSAS

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.

 

SSAS_Error.PNG

 

SSAS_Error_1.PNG

 

Kindly assist on the above.

 

Regards,

Saurabh

4 REPLIES 4
Community Support Team
Community Support Team

Re: Unable to import hierarchy through SSAS

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_ Regular Visitor
Regular Visitor

Re: Unable to import hierarchy through SSAS

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

Community Support Team
Community Support Team

Re: Unable to import hierarchy through SSAS

Hi saurabh_kedia_,

 

You should enable AttributeHierarchyEnabled property to true on SSAS side.

 

Regards,

Jimmy Tao

Community Support Team
Community Support Team

Re: Unable to import hierarchy through SSAS

@saurabh_kedia_,

 

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

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 3,165 guests
Recent signins:
Please welcome our newest community members: