Display caracteristics only if hierarchy expanded

[Former Member]

Hi,

I looking for help to produce a report using a hierarchy and didn't found any thread or documentation about what I'm trying to do...

In row I have 3 caracteristics: Car1, Car2, Car3.

In colums: my key figures.

I want to display Car1 with a hierarchy.

Here is an example of the result I wish:

<b>__________________________________________________Amount

Car1_______________Car2_______________Car3</b>

Node 1

_Node 2

___Car1Val_________Car2 Val____________Car3Val_______1000$

But here is the result I have:

<b>__________________________________________________Amount

Car1_______________Car2_______________Car3</b>

Node 1_____________Car2 Val____________Car3Val

Node 2___________Car2 Val____________Car3Val

___Car1Val_________Car2 Val____________Car3Val_____1000$

I would like to know how to design my query so my caracreristics 2 and 3 show values only Car1 hierarchy is fully expanded.

Here is an example with my real data:

ZCS_ITEM = our corporate chart of accounts presented under a coporate group of accounts (hierarchy)

0CS_ITEM = our internal chart of accounts.

Exepcted result

<b>__________________________________________________Amount

ZCS_ITEM___________0CS_ITEM________0FUNC_AREA</b>

ASSET

CURRRENTASSET

___100001__________11100___________6000____________1000$

Actual result:

<b>__________________________________________________Amount

ZCS_ITEM___________0CS_ITEM________0FUNC_AREA</b>

ASSET________________11100___________6000

CURRRENTASSET____11100___________6000

___100001_____________11100___________6000___________1000$

Any ideas?

Thanks in advance!

[former_member189638]

I am not very sure but try the following option

Goto the Properties of the Query and the to the Display tab

There you can see an option Hide Repeated Key Figure values. Just tick the checkbox.

See whether it is giving you the desired output

[Former Member]

if u select ur characteristics

then in the characteristics properties u will have tab called HIERARCHY....

over here if u can make proper selections of following options

it will surely solve ur issue :

SELECTED HIERARCHY

EXPAND TO LEVEL

POSITIONS OF LOWER LEVEL NODE

VALUE OF POSTED NODE

NODES WITH ONLY ONE LOWER LEVEL NODE

SORTING

SORT BY

SORT DIRECTION

[Former Member]

Hi

I may not provide you exact solution for your question but here is my suggestion.

If you can restrict your hierarchy node Asset or 100001 with you char-1 and place it under a structure,Then you can get a display like this.

ZCS_ITEM___________0CS_ITEM________0FUNC_AREA

100001______________11100____________6000__________1000$

[Former Member]

If any one has answer please forward it

Regds

RAJ

[Former Member]

We have the same problem. If any one has a solution please forward to this thread. Full points will be rewarded.

Regards

RAJ