I am new with SSAS and not that much experience with it. I was trying to match the result of the cube with extracting directly fro tables. but i have differences.
for example: if customer A pay for item X in cash and credit card. i would get the customer A whether in cash or debit column. but if i extract the data from database i have a record both in cash and credit column.
I would apprecitae any help.