SEM-BPS functionality

[Former Member]

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.

Luca.

[Former Member]

LUCA,

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.

Cheers,

Alberto Sabate

[Former Member]

Hi Alberto,

when I click over the hierarchy icon appear a menù that allows to me to choose only beetwen a hierarchical and not-hierarchical data-model... nothing about "Calculate Data locally"! Where I get wrong?

Thanks, cheers.

[ven_v]

Hi Luca,

When you open your layout in the first screen you see the Hierarchy Icon and if you click on that you can see the various options Default it will be in Non-hierarchial model and below that you can see the Select option to check - for Calculate Data Locally .

You Need to select that to carry on your task.

Cheers,

Ven

[Former Member]

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.

[Former Member]

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.

[Former Member]

Salman,

The first lesson to learn is that you should not ruin an unanswered posted item by not answering it and posting your own questions.

If you want to ask something, create a new message and wait for it to be answered.

Thanks,

Alberto Sabate

[Former Member]

My name is srinivas and am currently in Singapore and would like to take up the certification in SEM. Could you suggest me whom and where do I need to contact.

Regards

Srinivas