3735060 - WFA Drill to Detail (DTD) issue in some Investigate reports when selecting top nodes (ALL) dimensions

• Drill to Detail in some Investigate reports returns error “Something went wrong when trying to show employees. Please try again or check the error log.” when dimension is set as All/Top node.
• A user opens an Investigate report and attempts to use the Drill to Detail (DTD) feature by clicking on a data cell. Instead of the expected detail data, the DTD dialog returns an error or shows no results.
• This behavior occurs specifically when one of the dimensions on the report is positioned at its top-most (All) level, i.e. no dimension member filter has been applied and the report is showing aggregated data across all members of that dimension. Clicking DTD on a cell in that configuration fails silently.
• Reports where a specific dimension member is selected (i.e. filtered to a particular level below the All node) continue to work as expected.

SAP SuccessFactors Workforce Analytics

1. Access SuccessFactors
2. Navigate to Workforce Analytics → Investigate.
3. Open the affected Investigate report.
4. Click any value under drill to detail.
5. The error appears:
   “Something went wrong when trying to export. Please try again or check the error log.”

This issue is due to a long‑standing product limitation in the Workforce Analytics (WFA) Drill to Detail (DTD) mechanism.

When a dimension is displayed at the All/root level, it has no Level identifier, so, WFA generates an MDX Path instead of a numeric level (e.g. FACT_TABLE_1_S_29|[FACT_TABLE_1_S_29].[FACT_TABLE_1_S_29].[]).
The DTD backend logic only supports Level-based lookup (GetNodeByLevel) and does not support MDX Path lookup.

As a result the MDX Path cannot be matched to any dimension node and due to that the system cannot resolve the hierarchy causing DTD to fail and returns no data or an error.

This is a known product limitation of WFA (Workforce Analytics).

WFA is a legacy product currently in sunset mode. This specific gap between the DTD lookup mechanism and the All-level dimension representation has existed for approximately 8 years and was never addressed during the active development lifecycle of the product.

Given the sunset status of WFA, no code fix will be delivered for this issue.

Workaround for affected users:
Apply a dimension filter to select a specific member (any level below the All node) before attempting to use Drill to Detail. DTD will function correctly once the dimension is no longer at the All / top level.

SAP Support, please refer to internal notes for reference. 

Investigate, WFA, Workforce Analytics, Drill to detail, DtD, Something went wrong when trying to show employees. Please try again or check the error log., Something went wrong when trying to export. Please try again or check the error log, INC23572484 , KBA , LOD-SF-WFA-WRK , Investigate , Known Error