Skip to Content
author's profile photo Former Member
Former Member

Reduplicate data records in startroutine

Hello Experts,

does anyone know how I can reduplicate data records in the startroutine? I want to load out of an ODS into a Cube and therefore I need one data record 4 times because I have to fill different characteristics and keyfigures.

Thanks in advance,

T.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 04, 2008 at 09:47 PM

    suppose u have 1 char called char1 in ur cube. this routine will duplicate 4 times each char1 values coming from source.

    put this routine in ur start routine.

    DATA: wa_result TYPE tys_sc_1,

    t_result TYPE STANDARD TABLE OF tys_sc_1.

    DATA:counter(2) TYPE n.

    LOOP AT SOURCE_PACKAGE INTO wa_result.

    counter =0

    while counter < 4 .

    wa_result- char1 = wa_result-char1.

    APPEND wa_result TO t_result.

    counter = counter+1.

    endwhile.

    endloop.

    CLEAR: SOURCE_PACKAGE,wa_result.

    LOOP AT t_result INTO wa_result.

    APPEND wa_result TO SOURCE_PACKAGE.

    ENDLOOP.

    After the start routine executes ur source package would have 4 times the no of records in source infoprovider.

    Note: if ur in BW 3x then replace source_package with Data_package.

    Edited by: Ranjit Rout on Apr 4, 2008 11:48 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      t_result is a table.

      Wa_result is a work area. we need this work area to read a single record at a time from data package and manipulate as we need. we cannt do this manipulation in the table. so after manipulation we can append the modified record to the table.

      then we will read 1 more record and do the same processing for that.

      So we need the WA_result work area to do any type of modification to a record one at a time.

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.