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

Error in executing a layout which has a hierarchy in lead column

Hi Experts,

I have used a planning level where a characteristic called 'reporting code' is restricted with a hierarchy.

Now when I am trying to execute a layout under this level I am getting some error. The characteristic is used in the lead column in this layout.Two differene type of error I am getting in following two different cases.

1. When I am using the hierarchical settings for the lead column then I am getting the error 'Hierarchy INPUT is not suited to the planning mode.

2. When I am not using the hierarchical settings for the lead column then I am getting the error 'Too many characteristic combinations for manual planning'.

If I reduce the no of nodes in the hierarchy for testing then none of this error is coming. So I think this is related to the volume of the hierarchy.

Can anybody put some light on this why this error is coming and how to resolve this error?

Regards,

Saikat Datta Gupta.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2009 at 07:41 AM

    Hi Saikat,

    firstly, you have to make the Hierarchy node selection by pressing the same for selecting in the Planning level.

    In the layout design, choose ''Key figures in Data column' & 'Reporting code' (and maybe 0fiscper) as the lead column. In the characteristics combination tab, choose 'From Transaction Data' tab. That should be it.

    But if you want a Hierarchy display in the layout, choose the Hierarchy tab in the last page of layout setting and choose 'Totals as Hierarchy' tab.

    Regards,

    Manoj

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In case of text hierarchies, wherein we can plan only on leaves, for the layout to be displayed in a hierarichal manner, we need the following settings.

      In the first screen of the layout builder, next to the layout description, click on the hierarchy icon, choose non-hierarchical data model and in the additional settings, all possible char combinations.

      In the last screen of the layout builder, in lead column settings, check display totals as hierarchy.

      With the above settings, layout shows the result in hierarchy mode.

      In BPS layout, the no of rows will be limited. As you have given all possible combinations, system tries to display the entire hierarchy, i think which is exceeding the max limit. Try reducing the hierarchy size or keep the additional settings as "Transaction data" and check if the problem persists.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2009 at 07:51 AM

    Hi,

    check:

    1. You can post data only to those hierarchy nodes that have a data base represention, check you have selected proper node in planning level for reporting code

    2. In layout builder first screen select 'Hierarchical data model' by pushing the hierarchy button

    3. There should be only one characteristic in lead column and that should be the one which is based on hierarchy

    4. Go to last screen of layout builder and push 'Lead column settings' and select radio button hierarchy for your lead column characteristic

    Regards,

    Deepti

    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.