Comment Here's something to think about (Score 1) 180
If your analyzing sales data and you have dimensions related to customer type, product classifications, and market channel and let's say a credit memo is issued to a record merely crediting the customer account; no information is provided regarding product in the line item grain of the transaction. No datacube on earth can resolve that unless you have a very good ETL methodology to catch those kinds of errors.