Error while executing function module BICS_PROV_OPEN

I just got access to a NetWeaver 7.5 SP2 and I want to test it with Analysis for Office 2.3. So I open Excel and insert a query. And here we go first error: „unable to open data
source“, so I thought maybe the query is broken and I developed a new query and insert it. Here we go, same error. Maybe queries don’t work, so I insert a InfoCube directly. Same error…

Now I refresh the insert query and got an Analysis for Office message: Error while executing function module: BICS_PROV_OPEN

In the explanation was one line with the hint „wrong parameter type in an rfc call“, so I looked into st22 and saw a dump which the message: CALL_FUNCTION_ILLEGAL_P_TYPE

The explanation of this dump is „This error appears if parameters submitted incorrectly in a Remote Function Call.“

I searched but found nothing which should help me. After a longer research I found in the SCN this thread and the simple solution is:

Delete all contents in C:Users<your_user>AppDataRoamingSAP AGSAP BusinessObjects Advanced Analysiscache

After deleting the content, close Analysis for Office and it works. Either the Analysis for Office message or the BW dump explain the solution. But maybe someone has the same issue, this is the solution.

These posts might also be interesting:

• Migrating Analysis for Office workbooks from BW to BI Platform
• Analysis for Office Save Query View
• Analysis for Office 2.3 features
• Analysis for Office Addin crashes

I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.