- 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.
- 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"
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.
New Data Source Pivot Query Report Center Online Report Designer Published Data Component , KBA , LOD-SF-ANA-RCT , Report Centre , LOD-SF-ANA-ORD , Online Report Designer , Problem