I am trying to schedule a task in DAC to purge all cache entries in BI Server after every ETL run. I could find Windows based installation related information on internet but in my case OBI is installed on a Unix machine. Can someone guide me how it can be done?
I was reading on the web about this issue. I found that first we need to run bi-init.sh before running nqcmd to launch a shell window that is initialized to your Oracle instance and then, run nqcmd from the resulting shell window with the desired options. I am not sure how to achieve this.
Even we tried creating script from bi-init.sh file and user.sh which will initiailize environment variable and then issue nqcmd command.. but it was not working for us.. might be some errror.. let us know if it worked for you..
then we created small shell script with only required initialization of environment variables having followed by nqcmd it worked for us and cache purge was done successfully.
Hmm..regarding your below question.
One more thing, we have DAC and OBI installed on two separate machines, would it be an issue? Where do I provide the user credentials for the user where OBI is installed(Do I need to)?
if you have OBIEE utilities setup and nqcmd available on DAC server then .. it should not be problem.. and you can put all in shell script and then call it from DAC/infa workflow it should work else you would have try setting up ssh without password which will connect to OBIEE Server and call nqcmd there to purge cache.
Yes you were right, I had to include lib path. I ran it without lib path first but that gave error. Also I created SSH link and I was able to invoke the script successfully. I have to try it with DAC now. Hopefully it will go though.