We have a scenario like this. A colleague has created a report that we can run through analysis office in Excel. The report is a direct link to an embedded analytics report. I think we are using an on-premises server.
I have a macro that sets some inputs and refreshes the data. After data refresh, I tried to use SAPMoveDimension and SAPSetFilter in the macro, but neither worked. There was no error, and it just did nothing when the macro called either one of the two functions. Are they supposed to work in our scenario? If yes, how to make them work?
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.