Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a 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

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.