Skip to content
Advertisement

Error in Parent-Child relationship : The source attribute of the level is marked as ‘Parent’

I am trying to define a parent-child relationship in my SSAS project. The dimension is “employee” with a parent being “supervisor”. The source of my data was automatically imported from a .bak file given by my professor, though I feel like maybe it was somehow corrupeted or I’m doing something wrong.

The error that I am getting during processing:

Level [Sprzedawca].[Subordinate Hierarchy].[Supervisor] : The source attribute of the level is marked as 'Parent'

I set the supervisor’s attribute usage to “parent”. Column names for Id Sprzedawcy (Seller id) and supervisor are both “ImieiNazwisko” (NameAndSurname) which is an attribute that is in the source data, but wasn’t automatically moved to attributes (left column) – I’m not sure if I am supposed to drag it there? Anyhow, this does not help either…

View of Sprzedawca (Seller) Dimension View of the processed cube

Advertisement

Answer

The parent-child hierarchy is automatically created when you set attribute usage to the parents of an attribute and ones marked as parent the attribute cannot be used as a level in a user defined hierarchy.

So to resolve your problem, you just need to remove the hierarchy that you have created “Subordinate hierarchy” and things will work perfectly.

3 People found this is helpful
Advertisement