Change data in ad-hoc analysis

After you create your ad-hoc analysis, you can change the data source. Click the Properties icon on your ad-hoc analysis toolbar and select the Change Data option.

The Change data dialog box consists of these sections:

Select Data Source

Lists the cubes for the selected database.

Define Filters and Axes

Consists of the filter section on the left and two tables that define the row and column axes on the right. You can adjust the hierarchies that form the axes and filters of your analysis.

• Filters: Lists the filter hierarchies that are highlighted in blue.
  You can select which filter hierarchies are visible in your widget. By default, all hierarchies that are enabled on the Data Configuration dashboard are visible. To hide a hierarchy in the Filter section, clear the corresponding check box.

  Note: Setting the hierarchies as visible applies only to that particular widget. It has a lower priority than enabling or disabling hierarchies using the Data Configuration dashboard.

  You can also click the hierarchy and select the corresponding option to move it to the row or column axis.

  When working with dimensions that contain multiple hierarchies, you can select which hierarchy is used. Click the blue heading and select Change Hierarchy, then select the new hierarchy you want to use.

• Row and column axes: Consists of two tables that represent the rows and columns, respectively.

  To move the hierarchies to the row or column axis, you can click the blue hierarchy and select the corresponding option. Alternatively, you can drag and drop a new hierarchy on the empty space in the row or column axis.

  If you drag and drop a hierarchy on another hierarchy, then the two hierarchies exchange their position. 

  To display attributes, for example, unique IDs, code names, or labels that have been translated to other languages, click the blue hierarchy and select the Select Attributes option.

• Zero suppression: Use the Zero Suppression icons that are located on the left side of the Row Axis and Column Axis headers to apply zero suppression on rows and columns, respectively. If the zero suppression option is enabled, the corresponding icon is highlighted in blue.
  Note: Zero suppression is applied by default if you create a chart or analysis from a multidimensional wizard. You can change this in the "properties" step of the multidimensional wizard, or in the Data Configuration dashboard.