InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 03:48:58 GMT20http://www.sqlservercentral.com/Forums/Topic1420389-17-1.aspxHiI 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.Regards,Thu, 14 Feb 2013 22:55:16 GMTshiva-403877