Processing cube automatically after ETL ends

Hi all,

We have an ETL process running at night and ending at the morning.

We want the system to automatically process a cube after ETL ends.

The ETL program is Infromatica and the server is Linux (Someone told me to use ascmd but it runs on windows server only so it won't work).

I really need a solution for this i order to automate our process.

Thanks in advance,

Ariel.

Could you create a wrapper web service for ascmd, and call it from Informatica?|||

If you are using the Enterprise edition you could also look at using proactive caching to detect when there have been changes to the underlying source data. It also has a silence interval parameter that allows SSAS to wait for a certain amount of silence (ie the ETL has finished) before commencing processing.

If you have HTTP connectivity enabled you could issue a direct xmla command to SSAS. There are some examples of using XMLA from javascript at http://www.activeinterface.com/thinolap.html

Otherwise John's idea of creating a web service wrapper is a good one.