Pivot table - Changing OLAP Source
We have an Analysis Server which is running on a computer with the name "xx". A couple of user have made several sheets with pivot tables which are connected on the server "xx". To make the connection, the chose OLAP source and it's working perfectly.
The problem is that the server "xx" won't exist any more ant will be replace with the server "yy". Of course, all the pivot table won't work anymore.
My question is the following : is there a possibility to change the server name in a pivot table which is based on an OLAP source ? I'have tried a couple of test but it didn't work.
Thanks for your help.
It is only a function of your code ...
Just make the server name a variable ...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1