Many times we have the need to see the MDX we have generated on the EXCEL Connected to a CUBE.
Without further due; I have attached the excel with the proper macro.
Just right click on the pivot->show mdx…
Suppose your ETL worked fine at the night window but the users calls you at 08:30 and tell you that the numbers does not figure.
Well, there are several reasons for this problems: the data came badly from the OPERATIONAL SYSTEM, something happened to you ETL, or the sales for example where real bad.
In order to eliminate the first two you must build control process that decides whether the data are good enough for the users.
There are two controls you should have: business control and flow control.
The first check the sum, avg… in comparison to the...