cognos增量刷新cube

lirui6587 贡献于2012-09-25

作者 creator  创建于2010-11-23 07:07:00   修改者creator  修改于2010-11-23 07:07:00字数1333

文档摘要:cognos增量刷新cube,可以模仿以下代码,进行设计,此代码只能适用于xp/2003环境中。实现的代码如下(在xp环境中,可以写成bat文件执行)
关键词:

cognos增量刷新cube,可以模仿以下代码,进行设计,此代码只能适用于xp/2003环境中。 实现的代码如下(在xp环境中,可以写成bat文件执行): @echo off rem 获取当前日期 rem set time=%date:~0,4%%date:~5,2%%date:~8,2% set a=%date:~0,4% set b=%date:~5,2% set /A a1=%a% set /A a2=%a% set /A b1=%b%-1 set /A b2=%b%-2 if %b%==01 ( set /A a1=%a%-1 set /A a2=%a%-1 set /A b1=12 set /A b2=11 )else if %b%==02 ( set /A a2=%a%-1 set /A b2=12 ) if %b1% lss 10 set b1=0%b1% if %b2% lss 10 set b2=0%b2% rem 设置过去三个月的开始时间 set curr=%a: =%%b: =%01 set currm=%a: =%%b: =% set curr1=%a1: =%%b1: =%01 set curr1m=%a1: =%%b1: =% set curr2=%a2: =%%b2: =%01 set curr2m=%a2: =%%b2: =% rem 开始循环获取过去三个月的结束日期,并将其MDC文件移到备份文件夹 for /l %%a in (28,1,31) do ( IF EXIST E:\AbbottBI_OLAP\MDC\PG_off_take_Sale_Targ_Ims\%curr%-%currm%%%a.mdc (move E:\AbbottBI_OLAP\MDC\PG_off_take_Sale_Targ_Ims\%curr%-%currm%%%a.mdc "E:\AbbottBI_OLAP\MDC backup\PG_off_take_Sale_Targ_Ims\") IF EXIST E:\AbbottBI_OLAP\MDC\PG_off_take_Sale_Targ_Ims\%curr1%-%curr1m%%%a.mdc (move E:\AbbottBI_OLAP\MDC\PG_off_take_Sale_Targ_Ims\%curr1%-%curr1m%%%a.mdc "E:\AbbottBI_OLAP\MDC backup\PG_off_take_Sale_Targ_Ims\") IF EXIST E:\AbbottBI_OLAP\MDC\PG_off_take_Sale_Targ_Ims\%curr2%-%curr2m%%%a.mdc (move E:\AbbottBI_OLAP\MDC\PG_off_take_Sale_Targ_Ims\%curr2%-%curr2m%%%a.mdc "E:\AbbottBI_OLAP\MDC backup\PG_off_take_Sale_Targ_Ims\") ) taskkill /f /im PPESBusServer.exe echo PG_off_take_Sale_Targ_Ims.pyj "E:\Cognos8\c8\bin\cogtr.exe" -c -n2 -s "E:\AbbottBI_OLAP\PYJ\PG_off_take_Sale_Targ_Ims.pyj" exit

下载文档到电脑,查找使用更方便

文档的实际排版效果,会与网站的显示效果略有不同!!

需要 2 金币 [ 分享文档获得金币 ] 0 人已下载

下载文档