'Display as hierarchy' in the Query Designer

[Former Member]

Hi,

Can anyone highlight some points or importance of 'display as hierarchy' in either rows or columns in the query designer. Also could someone put some thoughts on the 'new structure' in the query designer, is it just that we can create some new selection and new formula from the structure or is there any other explanation for its existence. Any kind of explanation would be greatly appreciated.

Thanks,

Anjali.

[mstrein · Accepted solution]

Hi Anjali,

display as Hierarchies:

simply enables you to select and use hierarchies for that InfoObject if available.

Structures:

you can create structures with or without keyfigures. Structures give you a great deal of flexibility and consistancy in your reports. Eg. you can create a structure that gives you a drilldown on char selections that are different for each line or column. We use that to "simulate" divisions in a drilldown that we don't have backed up by masterdata.

Also structures enable you to keep reports consistant by using the same global structure eg. for all Contribution margin reports

Hope that helped,

regards,

michael

[Former Member · Accepted solution]

Thanks Micheal,

For the explanation and mainly for the example.

Regards,

Anjali