| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | |
|---|---|---|---|---|---|---|---|---|---|
Show Hidden Datasets for Parameter Values - Multidimensional Data |
Learn how to show hidden datasets for parameter values so you can display all datasets in a report. |
kfollis |
kfollis |
09/25/2024 |
reporting-services |
report-data |
conceptual |
|
Show Hidden Datasets for Parameter Values - Multidimensional Data
Your report might include automatically-generated datasets (also known as hidden datasets) that do not appear by default in the Report Data pane. These datasets are created in the following ways:
-
In some query designers for multidimensional databases, you can specify fields to filter on in the filter area of the query pane, and select whether to create a query parameter for the filter. If you select the parameter option, report datasets are automatically created to provide valid values for the report parameter.
-
If you import a query based on multidimensional databases, you might also include hidden datasets in your report.
Hidden datasets are not available to use from a wizard.
You can change the view in the Report Data pane to display all datasets in the report.
Note
[!INCLUDEssRBRDDup]
To display hidden datasets
- In the Report Data pane, right-click the Datasets folder, and then click Show Hidden Datasets.