Skip to Content
author's profile photo
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

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

  • author's profile photo
    Former Member
    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 comment
    10|10000 characters needed characters exceeded

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

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

    Regards,

    salman

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    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 comment
    10|10000 characters needed characters exceeded