Most of the answers here refer you to receiving messages and notifications of errors in your chain, but I think you are asking about automating the handling of errors, as in automating a repair and restart etc... if I'm not mistaken.If this is the ca...
As mentioned earlier in this post - you need to select the specific inforprovider associated with the Key Figure from that Cube, by converting it to a restricted key figure.But... you need to know also that your report will only align the results int...
You can't do this before the refresh, but you can do it in the Callback macro - that you can find in the developer section of Excel.What you will need to do is create three worksheets in your workbook. In the first two worksheets you will have your q...
The simple answer is no you can't do this in your query design.However, you might be able to abuse the report results, from Bex if you execute the report into Excel workbook, because MS excel has a standard functionality that looks for text that "loo...
