On the Ad-hoc Analysis page, you can configure operations such as downloading, merging cells, and displaying totals. You can also configure security settings.
The "download" behavior on an item.
In the upper-right corner of the Ad Hoc Analysis page, click the Page Settings icon. By default, Allow Download is selected in the Page Settings panel. If you want to export ad hoc query results that contain filter conditions, select Export with Filter Conditions.
You can follow the steps shown in the figure to export.
You can export data in the EXCEL and image formats. You can export data in the EXCEL format and export data in the same format.
If the ad hoc query results contain filter conditions, the exported Excel file can contain the filter conditions.
Merges cells
By default, cells of the same type are merged. This helps clearly display data groups. If you do not want to merge cells, you can clear Merge Cells of Same Type in the Page Settings panel. If you want to view detailed data, you can clear this option.
Click Page Settings. By default, Merge Similar Cells is selected. You can clear this parameter.
Show Total
By default, the total of each dimension is displayed. This helps you view the totals of different dimensions in an efficient manner. You can click the Custom Subtotal icon in the feature navigation bar to hide the total for a specific dimension. For more information, see the "Custom subtotal" section in Use the feature navigation bar.
If you want to remove all totals from the page, clear Show Total in Page Settings. In this case, all totals on the entire page are not displayed, not just for a dimension.
Security settings
You can set Allow Roll Up, Allow Expand, and Allow Unhidden Rows and Rows in the Preview state.
These operations may override the control of data permissions and display data that the previewer does not have permissions on. By default, this feature is disabled. Exercise caution when you perform these operations.
Allow roll-up in preview state
Before you select this check box, the preview state does not allow roll-up. After you select this check box, the preview state allows roll-up.
Preview state allows expansion
Before you select this check box, the preview state cannot be expanded. After you select this check box, the preview state can be expanded.
The preview state allows you to unhide rows and columns.
Before you select this check box, the preview state does not allow you to unhide the rows and columns. After you select this check box, the preview state allows you to unhide the rows and columns.