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

Restricted account hierarchy nodes

Hi BI Gurus,

I have a requirement to generate Profit and Loss statement in BI. I pulled up account hierarchy out of R/3 into BI.

The issue is client want to see some nodes of the account hierarchy restricted by specific Functional Area only.

Please suggest some solution.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 07:29 PM

    you would have to manually restrict the nodes and account numbers instead of using the hierarchy

    hope it helps

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi KK,

      Can you please explain about manually restricting the nodes instead of using hierarchy? Should it be done at R/3 or BI level and how?

      At R/3 level in Report Painter reports each node of the account hierarchy can be easily restricted to a particular Functional Area (at account node or set level) and client want to achieve the same in BI.

      Also the account hierarchy should not be maintained at two places. Since well maintained account hierarchy is already there in R/3 which is why BI pulled it from there; now they are looking for ways to restrict some of the nodes by Functional Area.

      Hope I have explained the situation with all the variables.

      Please provide your valuable suggestions.

      Thanks & Regards,


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.