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

Problem with BW Hierarchy in BPS Planning Layout

I have done the following things:

1) Created 2 Characteristics, Product Category and Product Group.

2) Each characteristic contains characteristic values.

Values for Product Category (PC):

1, 2, 3, 4, 5, 6

Values for Product Group (PG):

11, 12, 13, 21,22,23,31,41,42,51,52,61

3) Created the following hierarchy in BW for Characteristic PC.

1. Root

1 2 3 (PC level)

11-12-13, 21-22-23, 31, (PG level)

4) The nodes at PC level appear green in color, whereas nodes at PG level appear yellow in color (not postable).

In planning level I have selected the Root node for the characteristic PC.

There is no selection for PG level.

5) I have also defined characteristic relations in the planning area of the type "hierarchy". Have also included PC and PG in the "combination check and proposal option".

6) In the layout I have got PC and PG in the lead columns in the correct order and key fig in data column

7) I am using hierarchical data model option and the BPS characteristic hierarchy is "selected" by default and grayed out.

Having given a complete overview of my settings could some one be gracious enuff to please let me know why do I am not getting correct display when i execute the layout.

I get the following display:

+ 1 Total 0 (input enabled)

+ 2 Total 0 (input enabled)

+ 3 Total 0 (input enabled)

+ 4 Total 0 (input enabled)

+ 5 Total 0 (input enabled)

+ 6 Total 0 (input enabled)

When i click to expand the plus signs e.g for PC "1", I get the following output:

+ 1 Total 0 (input enabled)

. 1 Not assigned 0 (Not input ready)

And similar for all of the remaining PC's. Can someone help me display the correct hierarchy as designed in BW in the BPS layout as well. Thanks a million. Will be very generous with points I promise.

Regards,

Salman

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2005 at 03:27 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2005 at 04:24 PM

    Don't know how much of a change in an audience you might get, but there is a separate Business Planning Forum within the BI group, which might be watched more by folks with BPS knowledge.

    Business Planning

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 05, 2005 at 03:16 PM

    can anyone care to comment on my problem....

    Regards,

    salman

    Add a comment
    10|10000 characters needed characters exceeded

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

    Please refer to the following link and see the post by hari79 for the solution.

    Rolling planning layout

    Regards,

    Salman

    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.