2374729 - How to Indent Descendants in a Pivot Query to Show Structure

SAP Knowledge Base Article - Public

2374729 - How to Indent Descendants in a Pivot Query to Show Structure

Symptom

I am trying to build a report which has a pivot. In Query Workspace, the descendants of selected elements (e.g. the children of a parent organization in Organization sturcture)  are indented. However, when I use that query in Report Designer (table based on published data component), the indentations go away. How can I make the indentations appear in Report Designer as well?

Resolution

Please use a Composite Query component in Report Designer and enable the the "Indent Labels" setting in the Edit Component menu.
See below: 

Indent Labels.jpg

Keywords

Composite query
Pivot query
Indent, Indentation
Report designer
elements, descendants , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , How To

Product

SAP SuccessFactors HCM Core 1608