早教吧作业答案频道 -->英语-->
DoesDATAPACKAGEhaveatimestampproperty?HiFolks,Whencreatingroutinesinupdaterules,isitpossibletoidentifythetimeadatapackageisloaded?Here'sthedeal...We'verun3loadstoaninfocube(fromR/3)onceamonthoverthelast3month
题目详情
Does DATA_PACKAGE have a time stamp property?
Hi Folks,When creating routines in update rules,is it possible to identify the time a data package is loaded?Here's the deal...We've run 3 loads to an infocube (from R/3) once a month over the last 3 months.The load dates were 31/03/04,30/04/04 & 31/05/04.I need to re-load this data but I need to add a new field called VERSION.VERSION will contain the Year/Month of the day after the load date (i.e.data loaded on 31/03/04 should have a VERSION of 2004/04).I want to add the new field VERSION to the infocube and add a routine to VERSION in the update rules to calculate VERSION based on the date the data was loaded.Then I hope to re-load the 3 jobs from the PSA back into the cube so they pass through the new update rules.Is this possible?I'd be grateful for any advice.
Hi Folks,When creating routines in update rules,is it possible to identify the time a data package is loaded?Here's the deal...We've run 3 loads to an infocube (from R/3) once a month over the last 3 months.The load dates were 31/03/04,30/04/04 & 31/05/04.I need to re-load this data but I need to add a new field called VERSION.VERSION will contain the Year/Month of the day after the load date (i.e.data loaded on 31/03/04 should have a VERSION of 2004/04).I want to add the new field VERSION to the infocube and add a routine to VERSION in the update rules to calculate VERSION based on the date the data was loaded.Then I hope to re-load the 3 jobs from the PSA back into the cube so they pass through the new update rules.Is this possible?I'd be grateful for any advice.
▼优质解答
答案和解析
You can find the load date/time of a request via the RSREQDONE table.(if you search the forum with "RSREQDONE",you'll find other interesting request-related tables) 查看原帖>>
看了 DoesDATAPACKAG...的网友还看了以下: