SAP Knowledge Base Article - Public

2545763 - New Data Source creation option is available in Pivot Query window in b1711

Symptom

  • New Data Source creation option is available in Pivot Query window in b171.
  • Users can create Live Data ORD query and Realms query in Pivot Query window.

Environment

  • Report Center
  • Online Report Designer

Reproducing the Issue

Home > Reporting > New > Report Canvas > Select > Give a name to the Report > Done > Add Published Data Pivot Component > Edit Query > New Query > At the Left upper Corner > There is an Icon to create "New Data Source"

Resolution

As per b1708:
Previously users could not save queries as data source for pivot. Without queries being saved, users had to create a new query and then use it a data source when creating a pivot report.
Now queries can be saved and users can create List Report query within Pivot Query Designer.
There was no option to create new query in Pivot query window.


As Per B1711:
Previously users could not build the data source query for a pivot or chart directly in the pivot designer.
Instead users had to first create a list table query, then export that to be used as the pivot data source.
Now users can directly build the data source query when creating their pivot table or chart.

6_AYT-15180_Pivot Query _New Data Source.png

Keywords

New Data Source Pivot Query Report Center Online Report Designer Published Data Component , KBA , LOD-SF-ANA-RCT , Report Center , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core all versions