'Dimension Attribute not rolling up

I am relatively new to cube development and looking for some help from more seasoned developers. I am building a new cube that is based on a Invoice Number / Invoice Line hierarchy. What we see in other cubes we have built is when we have the same Invoice Number with multiple Invoice Lines and the Invoice Number attribute is selected that the dollars for all invoice lines roll up. When adding the Invoice line then the dollars separate to their associated Invoice Line.

For this cube, the data source is Epic and the keys to make a unique Invoice record are Invoice ID / Invoice Number / Invoice Line. We have set up attribute relationships and hierarchy but something is missing, please see behavior in screenshots below. We are not seeing the dollars roll up when only the Invoice Number attribute is selected. We are also not seeing the indent behavior when the Invoice Line is added. When collapsing the Invoice Line, only the row we collapse changes.

Simple cube report with Invoice Number showing line level details

When adding in the Invoice Line attribute the hierarchy is recognized with the minus sign Simple cube report with Invoice Number and Invoice Line

When collapsing the Invoice Line only the row we collapse is affected, other cubes all rows are affected by collapsing. Collapse Invoice Line

When expanding the Hierarchy Invoice Line a new column is added for the Line Expanding Hierarchy Invoice Line

I have researched the attribute property settings but nothing I have tried changes this behavior. Please advise,

John



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source