Skip to Content
0
Former Member
Jun 02, 2005 at 08:33 AM

Hierarchies with external characteristic in querry

37 Views

Hello,

I have following problem:

I have hierarchy for basic characteristic G\L Account and external characteristic Cost Center.

On report I want to display data like that:

1st hier level: Text node e. g. "Larbour"

2nd hier level: G\L Accounts e.g. 1000, 1001, 1002

3rd hier level: Cost Centers e.g. A, B, C

and I want to display on a report data only for those combinations:

1000A

1000B

1000C

1001A

1001B

1001C

1002A

1002B

1002C.

But on a report data is displayed as follows e. g.:

for G\L 1000 and all cost centers even if I did not defined others in hierarchy.

Could you explain what I should do?

Thanks

Andrzej