Sample Header Ad - 728x90

SSAS Cube Only Displays Total Values

1 vote
1 answer
216 views
When browsing my cube it shows the correct invoice values by date when I select only a date type (the date table was generated by SSAS with hierarchies), but if I add the customer name it shows the combined value of the invoices for the date period, rather than the total per customer. I expect to see the total value for the customer that month, not the overall monthly total. Excel Example My tables are joined with foreign keys and the DSV shows a star schema. A simplified version of the schema is below. factInvoice invoicePK customerFK -> customerPK dateFK -> datePK dimDate datePK dimCustomer customerPK The dimension usage tab shows both dimensions are linked to the invoice table. dimension usage tab Please can somebody shed some light on why this is happening? I'm sure I'm missing something pretty basic here! Thanks.
Asked by scampbell (143 rep)
Mar 30, 2018, 03:22 PM
Last activity: Mar 31, 2018, 07:59 PM