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.
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.
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
Last activity: Mar 31, 2018, 07:59 PM