12-15-2016 06:57 AM
Have you tried my approach?
Especially look for mismatches in the AttributeHierarchyEnabled propertie between cube- and database-dimensions attributes.
12-15-2016 07:01 AM
Yes I started with your approach - thanks for the pointer on AttributeHierarchyEnabled. I will go through all of those next.
12-22-2016 01:56 PM
Many thanks for this solution! It was the AttributeHierarchy mismatch on a bunch of range dimensions. You made my week
08-02-2017 08:38 AM
Is there any update on this please?
I have the same issue, the Gateway connects fine and user also mapped correctly but report shows error:
08-02-2017 08:43 AM
Is it possible that you have more than one data source for the dataset? If so make sure it is also defined in the gateway. This has happened to me more than once.
08-02-2017 08:56 AM
Thank you so much for the quick reply, it's a live connection. I'm very frustrated with this now, any help of guidance is much appreciated.
Gateway connects perfectly but for some reason the cube wouldn't load into the report. I'm also the admin of the SSAS server.
08-02-2017 09:09 AM
Now I remember the route cause of the error you are seeing. I had to make sure that any dimension attributes that had AttributeHierarchyVisible set to False to also marek sure that the AttributeHierarchyEnabled property was also set to False. This took me some time. I remember we had some hidden sort attributes that where both weren't set to false. See if you have any dimension attriubutes that are in this state.
08-03-2017 04:09 AM - edited 08-03-2017 05:38 AM
Thanks a lot again, I just disabled the AttributeHierarchyEnabled to false and couldn't deploy the project due to errors:
Can you please confirm? Really appreciate the help! I have a sample tiny cube to test the proof of concept before processing the entire data warehouse.
08-03-2017 07:00 AM
So make sure that you are only set AttributeHierarchyEnabled to false if AttributeHierarchyVisible is set to False.
08-03-2017 08:46 AM
@dataguy Thanks a lot again, I have made one simple dimension with no atributes and both options set to false, yet the error doesn't go away. Aplogies if I have missed something too obvious.