Data Modelling Question .

27 Views

Hello Gurus,

I have an issue in data modelling. I am extracting some data from a non-SAP source system(SIEBEL) via XI (SOAP Data Source). We load data fortnightly to an ODS. From ODS we update the data to a Finance Cube for reporting.

In ODS, we have 2 Info Objects for dates.i.e. Document Date & Posting Date. We derive Finance billing period(0FISCPER) from Posting Date Info Object. But we are getting only Document Date from Source System(Becasue there is no Posting Date stored in the Source System). Initially we set the Posting Date to sytem date(sy-datum) in the transfer rules and loaded the data to the ODS. So far we have no problems.

Now we want to load some data for the previous periods. But, becasue the Posting Date is set to System Date all the previous periods data is showing under current period in reports.

Is there any way we can use a parameter to set the posting date to previous period date?? any other ways to solve this issue are also welcome. We are still testing in QA. So if there is a need to change the model pls advice .

Thanks in advance.

POPS