Ever wondered how to make life easier when executing regression tests on cube content?
Wouldn't it be easy to just download the cube content to excel twice and compare the 2 downloads?
To achieve the above, just use transaction RSCRM_BAPI
Via RSCRM_BAPI you can easily make query extracts and save these extracts to excel.
The preferred regression test way of working:
1) Execute RSCRM_BAPI on a query on a particular cube and download query result to excel
2) Apply changes to the transformation/update rule of that particular cube
3) Reload a subset of data to that particular cube
4) Execute step 1 (with the same variables)
5) Compare the 2 (created in step 1 and step 4) excel downloads and you're done!
That's all folks....
