| problem with purging cache automatically [message #309616] |
Fri, 28 March 2008 03:05 |
mike2103 Messages: 1 Registered: March 2008 |
Junior Member |
|
|
My problem is the following:
everytime I run my ETL to update the Datawarehouse, I also want to automatically purge the BI Cache. I make this by using the nqcmd.exe.
I run the following command in a batch-file:
nqcmd -d Analyticsweb -u Administrator -p myPassword -s purge_cache.sql
As long as I run this batch-file on the server (where BI is installed) everything is working fine.
But I have to run this file on the client, and this is not working, because the nqcmd.exe command does not know the BI-Servers IP. So my question is, if there is any possibility to change one of the parameters in this command, so that it knows, on which machine BI is installed.
I hope, someone can help me with this problem.
|
|
|