Skip to Content
0
Former Member
Nov 03, 2005 at 07:05 PM

Hierarchy Reporting

180 Views

Hi,

We have created "Sets" for G/L accounts in R/3 via GS01 and maintained Hierarchies, created generic data source via BW07 and extracted the data to BW system. We maintained Hierarchies assigning the G/L accounts (ranges as well as single accounts) for Financial statement. When I displayed the results of the Hierarchy in BW the structure looks same ( Info Object-> 0GL_ACCOUNT -> double click on the hierarchy under the info object) as in R/3. Fine!

There is no transaction data yet in the BW system. So created one query on G/L info Object. Selected the Hierarchy by right clicking the G/L account in query definition and checked the Hierarchy Active check box and selected the respective Hierarchy name.

But when I run the query, all the G/L accounts coming under "not assigned G/L Account nodes". Why?

We expected the G/L accounts to come under each node as assigned!

Even when I extracted the standard Hierarchies for G/L accounts and used this Hierarchy name in query definition, still the same result:( i.e. all the G/L accounts coming under "not assigned G/L Account nodes". Reason???

Please can any one help explaining the steps/report output how it appears with sample example.

Thanks in advance.

Murphy.