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

Infopackage - ABAP routine or OLAP variable

Hi,

I need to load sales data from R/3 into Infocube based on top 1000 materials. These top 1000 materials are in query in BW are from 0material. The question is: How do I load these 1000 values into infopackage which contain 0material as selection criteria? Should I use ABAP routine or should I use OLAP variable? I appreciate if someone could cast some light on this problem with some ABAP code. If I have to create a OLAP variable, where do I create that variable? is it in Bex or somewhere else?

Thanks,

Rao.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2005 at 03:42 AM

    Hi,

    I hope, it is not good practise to make restriction of load on the basis of top 1000 sales. It is better to load all sales data to cube, then you can built a query on this cibe to display only top 1000 materials.

    With rgds,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2005 at 04:01 AM

    Hi Anil,

    Yes you are right. But here my requirement is different. Infact, I already have data in my ODS. I would like to load this sales data to infocube with top 1000 materials oly. Then I want to use this infocube as my datasource to extract data into APO. The APO guys want sales data on top 1000 material for demand planning. The top 1000 materials are on a flat file. That is the reason why I want to create a variable with replacement path and refer this variable in infopackage to load data. What do you think. I appreciate your help in this regard.

    Thanks,

    Rao.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2005 at 04:15 AM

    Hi Rao,

    You can use both the Infopackage routine or OLAP variable to load the cube. The OLAP Variable is created under the user exit for Bex.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2005 at 11:26 AM

    Hi Dinesh,

    Do you have any ABAP code for any of these OLAP variable or Routine. I appreciate your help if you can provide with some sample code.

    Thanks,

    Rao

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2005 at 11:35 AM

    Hi Rao,

    Refer this post for OLAP Variable:

    customer-exit-variable

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2005 at 02:19 PM

    Hi Dinesh,

    Thanks for the link. Can you also please explain how the following code works and the naming convention, declarations, data flow logic etc. in the code. I think this references to some dates. What if I have to pass some list of characteristic values into the selection criteria of an infopackage. I appreciate your help.

    Thanks again,

    Rao.

    when 'V*******'.

    clear l_s_range.

    tables: /bic/dzprpipe6, /bic/fzprpipe.

    data pmaxdate type i.

    data: begin of pcdate,

    yyyy(4),

    mm(2),

    dd(2),

    end of pcdate.

    data: pmdate like pcdate, presult type d.

    select max( sid_zcsnpshot ) into pmaxdate from /bic/dzprpipe6

    inner join /bic/fzprpipe on

    /bic/fzprpipe~key_zprpipe6 =

    /bic/dzprpipe6~dimid where

    /bic/dzprpipe6~dimid > 0 .

    move pmaxdate to pmdate.

    presult = pmdate.

    l_s_range-low = presult.

    l_s_range-sign = 'I'.

    l_s_range-opt = 'EQ'.

    append l_s_range to e_t_range.

    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.