Restricted account hierarchy nodes

[Former Member]

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.

Regards,

MV

[Former Member · Accepted solution]

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

hope it helps

[Former Member · Accepted solution]

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,

MV