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 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.
See Configuring data.
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 contains multiple hierarchies, you can select which hierarchy
is used. Click the filter hierarchy and select the
option.
See Actions on filters.
- 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
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.
See Zero suppression.