Skip to Content
author's profile photo
Former Member

Data Load Question

Ok Experts,

I'm confused. I'm trying to replicate a salescube in production that has data for several different years. The volume of sales orders per day is so big that I can't do a full load with a date range such as 0PSTNG_DATE=20030501-20050505 . This would take several weeks to load.

So, I thought I could do several full loads on just a small portion of each year. I need about three different years of data because I have created a cube for each year. We have a huge cube in production with 800 million records and we are trying to split it into multiple cubes for a multiprovider.

Is it valid to do several full loads with the following selection.

full load #1 - 0PSTNG_DATE=20050501-20050505

then full load #2 - 0PSTNG_DATE=20040501-20040505

then full load #3 - 0PSTNG_DATE=20030501-20030505

in three separate steps to accumulate the data? When I ran #2 and #3 it told me no data found but I know there is data for this time period.

( will award points )

Thanks

Richard

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Oct 07, 2005 at 01:15 PM

    Hi,

    <i>then full load #2 - 0PSTNG_DATE=20040501-20040505

    then full load #3 - 0PSTNG_DATE=20030501-20030505</i>

    Your idea is good ,But it seems you are missing lot of records .Take a re look on the range you have given for the loads 2 and 3 .For both these 3 selections you have taken only 4 days for each request, Is it ok ?

    With rgds,

    Anil kumar Sharma .P

    Message was edited by: Anil Kumar Sharma

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I am sorry to say that, I am not able to understand your scenario perfectly.

      Any way if you are populating data from R/3 with full load , make sure that the set up table has the data with that date ranges.

      With rgds,

      Anil Kumar Sharma .P

  • Oct 07, 2005 at 01:17 PM

    Hi Richard,

    What did you mean after 'replicating a salescube'?

    Did you do it as an export datasource and tried to load from it into 3 another cubes for different years?

    Best regards,

    Eugene

    Add comment
    10|10000 characters needed characters exceeded