早教吧 育儿知识 作业答案 考试题库 百科 知识分享

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.
▼优质解答
答案和解析
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...的网友还看了以下: