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

Partitioning of Planning

Hi Experts,

I try to improve the performance of a sequence which runs on over 700,000 records.

All the explanation regarding using the function: "UPC_BUNDLE_EXECUTE_STEP" target to the old BPS version and not for the new one: integrated planning which I works at.

Can you advise where I can find some help or "how to" that can assist?

Liav Leshem

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Feb 04, 2008 at 09:28 AM

    Hi Liav,

    with SPS13 (i.e. BI support package 15) partioning of planning sequences in BI-IP is supported in process chains, cf. the documentation

    http://help.sap.com/saphelp_nw70/helpdata/en/45/946677f8fb0cf2e10000000a114a6b/frameset.htm

    Regards,

    Gregor

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Liav,

      you can find a full documentation of FOX (including how to call ABAP Function modules) in the system, e.g. just call SE11 and display the data element UPC_Y_FLINE and click the button 'documentation'. This documentation ist also available in transaction BPS0. Since BPS and BI Planning use the same run time to execute FOX formulas this documentation is also valid for BI Planning. The most recent version may not be available in your system, so I quote it here:

      Calling Function Modules

      You use the CALL FUNCTION statement to call function modules. The names of the function modules have to be entered in table RSPLF_FDIR. You can do this in transaction SM30. In the following example, function module UPF_DISTR_RATE_GET is called.

      DATA FISCPER TYPE 0FISCPER.

      DATA FISCYEAR TYPE 0FISCYEAR.

      DATA RATE TYPE F.

      DATA KYF TYPE KEYFIGURE_NAME.

      FOREACH FISCYEAR, KYF.

      FISCPER = OBJV( ).

      CALL FUNCTION UPF_DISTR_RATE_GET

      EXPORTING

      I_FISCPER = FISCPER

      I_VERSION = 'OPTIMISTIC'

      IMPORTING

      E_RATE = RATE.

      {KYF,FISCYEAR} = { KYF, FISCYEAR } * RATE.

      ENDFOR.

      EXPORTING, IMPORTING, and CHANGING parameters can be transferred to function modules. The parameters have to have simple types (F, I, D, STRING and types of characteristics and attributes). Class references, structures and some table parameters are not permitted. All non-optional IMPORTING parameters for a function module have to be filled. If the function module raises an exception, you have to work with construct MESSAGE .... RAISING. THis is shown in the following example. The messages are transferred to the log. Class-based exceptions are also not permitted.

      FUNCTION UPF_DISTR_RATE_GET.

      *"----


      ""Local Interfaces:

      *" IMPORTING

      *" REFERENCE(I_FISCPER) TYPE /BI0/OIFISCPER

      *" REFERENCE(I_VERSION) TYPE STRING DEFAULT 'OPTIMISTIC'

      *" EXPORTING

      *" REFERENCE(E_RATE) TYPE F

      *" REFERENCE(E_FISCYEAR) TYPE /BI0/OIFISCYEAR

      *" EXCEPTIONS

      *" ERROR

      *"----


      DATA: l_fiscper_3 TYPE n length 3.

      l_fiscper_3 = i_fiscper+4(3).

      IF i_version = 'OPTIMISTIC'.

      e_rate = l_fiscper_3 / 5.

      ELSE.

      e_rate = l_fiscper_3 / 7.

      ENDIF.

      e_fiscyear = i_fiscper(4).

      if l_fiscper_3 is initial or e_Fiscyear is initial.

      message e001(upf) with 'Initial Values'(TIV) raising error.

      endif.

      ENDFUNCTION.

      Regards,

      Gregor

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.