Working with published datasets

In simple terms, a published dataset is nothing more than a SQL statement that has been stored in the Report Portal. This can be extremely valuable as business users often lack the ability to write even simple SQL queries.

In addition, this allows experienced SQL developers to write complex SQL queries and make them available to business users so that they can write reports from them. It also allows queries that are used over and over to be stored, saving users from having to rewrite them every time they wish to write a report.

Getting ready

Unlike published data sources, it is possible to create a published dataset from Report Builder.

Prior to creating the dataset, we will need a place to store it in the Report Portal. Go to the Report Portal, and click on the + (New) button. In the menu, click on Folder and name the new folder Datasets.

Now open report builder if it is not open to bring up the Getting Started window, or go to File | New in order to bring up...