Producing week ending dates for each week of the year

Hi

I am trying to produce a script that will show date for the last day of the week(Sunday). The script will have to show dates for all weeks of the year. Does anyone know how this can be done?

Thanks

Quote:

Originally Posted by rcr69er

Hi

I am trying to produce a script that will show date for the last day of the week(Sunday). The script will have to show dates for all weeks of the year. Does anyone know how this can be done?

Thanks

hai try this-----------
declare
v_date date;
begin
select next_day('01-JAN-07','sunday') into v_date from dual;
for i in 0..51 loop
dbms_output.put_line(to_char(to_date((v_date)+7*i) ));
end loop;
end;sql

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.