Open Ad-hoc report action

Opens the slice definition of the Application Studio report in the web Ad-hoc Report widget or a dialog box.

Allowed and visible elements are supported by the slice MDX in both Application Studio and Ad-hoc Report. Reports are calculated in the same way in both reporting tools, regardless of whether the slice definition includes allowed, visible, or both element types.

The difference in the user interface is that allowed elements are supported by Application Studio and visible elements are supported by Ad-hoc Report.

Allowed elements define what elements are available in a report.

Visible elements define the initial state of a report in which you can drill down into the level of allowed elements. When you create an ad-hoc report in the web Ad-hoc Report widget, the whole hierarchy is used in allowed elements. If you open an ad-hoc report from an Application Studio report in which the data view is limited by the structure selection, you can drill down only to the level defined in allowed elements of the Application Studio report.

Manual expand and collapse states are part of visible elements and are saved within each hyperblock. You can retrieve information about manual expand and collapse states from hyperblocks through the VisibleElements property. Information about manual expand and collapse states is saved in the VisibleElements property in the XML format. You can pass that information through the Open Ad-hoc report action. In the Open Ad-hoc report action, input of row and column visible elements is used. The XML format is interpreted by the Ad-hoc Report widget, and the expand and collapse states are applied to visible elements.

You can use the Convert allowed elements input to remove all allowed elements from the slice definition and replace them with visible elements. This makes the slice that is displayed in the web version of Ad-hoc Report match the original Application Studio report. Consequently, you can browse the data of the web version of Ad-hoc Report without allowed elements limitations.