Symptom
- For users who access Query Workspace or switched to this view from Investigate, this article will show how to select one element from the selected dimension
- Selecting one element only will allow the user to report on a single node. The tool will automatically report on selected node along with all levels underneath the selected node. The selected node will need to be edited within design view to select on single node.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
- SAP SuccessFactors Workforce Analytics (WFA)
Reproducing the Issue
1. In Workforce Analytics, navigate to Query Workspace or switch to Query Workspace view from Investigate.
Resolution
- Select Desired Measure (Ex. EOP Headcount).
- Select desired dimension by clicking and dragging to Gray column or row. Click “Show Design View”. (Ex. Organizational Unit)
- Select “Edit” of selected dimension.
- Under dimension name, you can drill down to preferred single node you would like to report on. The Qualifier should be listed as “Selected element only” then click “Add”.
- The select element will appear under Distance if successful and will list the selected node to report on that node only. The first level dimension should be removed by selecting “Remove” on the far right.
- To save the changes, the black arrow in the gray row at the bottom should be selected.
- The selected node will report as a single element thus removing counts from other levels.
Keywords
query workspace, select one node, select one element, select one dimension value, wfa dimensions , KBA , sf wfp_a , LOD-SF-WFA-WA , Workforce Anaytics , How To
Product
SAP SuccessFactors Workforce Analytics 2505
SAP Knowledge Base Article - Public