Level-based hierarchy in SAC with Datasphere

[cristina_talmaciu]

Hi!

We created a level-based hierarchy in a dimension view in Datasphere, based on the columns Company-Product. Then, we associate this view to the analytical data set that will be consumed from SAC. When we display this hierarchy in SAC and we add an additional column in the SAC table (in this example the Customer), the data are displayed wrongly. We have the node with the company 1120 and the Customer null and below are displayed the rows with all the combinations of companies and customers. We don't understand why it is happening as we didn't expand the node. If the node is collapsed, we expected to see the node 1120 repeated for each customer.

Please, see the image for a better understanding.microsoftteams-image-19.png

[maxpinato_horsa]

Hi Cristina, difficult to understand by your image, it seems as the "Company-Product" dimension is not correctly mapped with the fact (but I don't see any measures, so I'm not sure).

Could you post the dimension definition and how you mapped its on the ads ?