Pivot tables embedded in dashboards as active sections can be scripted to enable users to double-click cells and build interactivity around them. This feature is available on all fact cells of pivot tables. When a fact cell is double-clicked, the OnCellDoubleClick event is fired, and JavaScript associated with the event can be executed. The event is associated with the dashboard object, not with the pivot section.
Embedded pivot section interactivity is available for Interactive Reporting Studio and Interactive Reporting Web Client. It is not available for documents deployed in EPM Workspace.
Prior to executing the script associated with the OnCellDoubleClick event, certain object-tree properties are set. The properties are then valid from wherever within the object model that the object is accessible, such as from document startup and shutdown scripts. If the pivot section is recalculated, the properties are reset to the initial, default state, as if no double-click event had occurred.
Properties set prior to executing OnCellDoubleClick events:
OnCellDoubleClick (Method)
FactName (Property)
CellValue (Property)
TopLabelValues (Array)
SideLabelValues (Array)
See Object-Level Events.