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

SEM-BPS functionality

Hi to everybody.

I'm searching for a particular functionality of SEM-BPS but I don't know if it exists or if I have to develop it custom(for ex:with ABAP).

Here, the issue: I have a product-hierarchy, the last two bottom-level of which are PRODUCT and (under) SKU (PRODUCT is parent of SKU).

I want to spread (I mean "distribute") values of particular PRODUCTS down to the respective SKUs following the hierarchy definition. An example: the value of PRODUCT P10 down to SKU 19, SKU 20 and SKU 21, the value of PRODUCT P11 down to SKU 22, SKU 23, SKU 24 and so on.

I have tried to use ALLOCATION function and it works perfectly but there are too much parameters to define (sender, receiver, distributor and so on) and it isn't related to the pre-defined hierarchy (I mean, there is no possibility to define a hierarchical reference).

This problem is born because of the large amount of PRODUCTS and SKUs (it's an hard work defining every single parameter...).

So I'm searching to a function that permits to refer to the product-hierarchy and execute the spread.

Any advice?

Thanx a lot.


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2005 at 10:27 AM

    Hi Luca,

    I am afraid I may not be able to help you with your query! But if you dont mind can I ask for your help. I am new to SEM-BPS. I have done certification in SEM but you know how its like. The pace of the academy is so fast and furious that it is impossible to retain most of the stuff after the academy. Now I am working on an SEM-BPS project. The company wants me to show to them what BPS can offer them. They are currently using their own bespoked planning software but are not very happy. I need to show to them the functionalities of SEM-BPS. Are their standard examples on heirarchies in BPS? Or is their something u can send me to get started with using heirarchies in BPS so that I can map their organistion structure to BPS planning layout and then can proceed from there? And last but not the least can you advise me on the structure of info cube? What things do i need to take in to consideration before I can design my info cube? Thanks a lot.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2005 at 11:24 AM


    What you are looking for is basically standard functionality but it is a little bit hidden. It' ssupported only in Excel Layouts and uses Macros to run de distributions (not allocations).

    Modify your layout, click over the hierarchy icon in the first screen. Select "Calculate Data locally".

    Now execute the layout. A new bar will appear and you can use the several icons to run distributions evenly or with the same pattern that some historical data.


    Alberto Sabate

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Ven V

      I think I discover my problem, but give me a confirmation. The SAP-BW version I've installed is the 3.1, but Local Functions are only available from version 3.5, is it right?

      Another question: I have read that local function are available only using Microsot Excel display mode. Does a work-around exist to have the same functionalities also in the web interface?

      Thanks to everybody.

      Best regards, Luca.

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.