ChartSection object, (CubeQuery) QuerySection object, OLAPQuerySection object, PivotSection object, QuerySection object, ResultsSection object, Section object, TableSection object,
Returns if a shortcut menu items is enabled for an active embedded section object. This method returns a Boolean value (true or false) and references the BqMenuItem constant group which corresponds to the eligible shortcut menu items in Interactive Reporting Studio,Interactive Reporting Web Client and EPM Workspace. Some shortcut menu items can only be enabled for active embedded section objects in the EPM Workspace and are denoted by “Workspace”. Some shortcut menu items can only be enabled in Interactive Reporting Web Client and Interactive Reporting Studio. These shortcut menu items are denoted by “Desktop”. Other options can be enabled for both.
Note: | When the shortcut menu changes by way of object model for embedded section objects of the same dashboard, the entire dashboard needs to be refreshed for changes to take effect. To refresh entire dashboard, switch to another section and come back to the same section. |
For active Results/Table embedded section objects, the following shortcut menu items are available when a column or columns is selected:
Sort Ascending (Desktop and Workspace)
Sort Descending (Desktop and Workspace)
Background (Desktop)
Auto-Size Column (Workspace)
For active Pivot embedded section objects, the following shortcut menu items are available by selecting the top or side labels, fact column, fact column label, column title or the pivot handles of the top and side labels. Individual or multiple selections of pivot components is available.
Depending on the selected component selected, the shortcut menu displays the following options:
Drill Anywhere (Desktop and Workspace)
Drill Up (Desktop and Workspace)
Focus on Items (Desktop and Workpace)
Hide Items (Desktop and Workspace)
Show Hidden Items (Desktop and Workspace)
Show All Items (Desktop and Workspace)
Auto-Size Column Width (Workspace)
Swing
Horizontal (Workspace)
Vertical (Workspace)
Up (Workspace)
Down (Workspace)
Left (Workspace)
Right (Workspace)
Before (Workspace)
After (Workspace)
Sort Ascending (Workspace)
Sort Descending (Workspace)
Refresh Pivot (Workspace)
For active Chart embedded section objects, shortcut menus can be launched by selecting bars, pie slices, lines, slice labels, or X and Z axis labels. Individual or multiple selections of Chart components is available. Multiple component selection can be performed by selecting Ctrl + Click. This command allows the selection of multiple like components, one at a time (it also allows for the deselection of components one at a time) Depending on the selected component(s) selected, the shortcut menu displays the following options:
The list of available speed menu options is context sensitive and depends on what component of the report is selected (label, bar, slice) and the state when the component selection is made (if items have been hidden, if additional columns are available for drill down, etc).
Drill Anywhere (Desktop and Workspace)
Drill Up (Desktop and Workspace)
Focus on Items (Desktop and Workspace)
Hide Items (Desktop and Workspace)
Show Hidden Items (Desktop and Workspace)
Show All Items (Desktop and Workspace)
(Un)Group (Workspace)
Show Negative Values (Desktop)
Show Pie Outline (Desktop)
Show Bar Border (Desktop)
Show Marker Border (Desktop)
Show Label (Desktop and Workspace)
Sort Ascending (Workspace)
Sort Descending (Workspace)
Zoom (Workspace)
In (Workspace)
Out (Workspace)
Return to original (Workspace)
Refresh Chart (Workspace)
For active OLAP Query/CubeQuery embedded section object shortcut menu items are launched by either selecting the top or side labels, fact column, fact column label or column title or by selecting the handles of the top and side labels. Individual selections of these components can be performed as well as the selection of multiple components. The list of available shortcut menu options is context sensitive and depends on what component of the report is selected (label, bar, slice) and the state when the component selection is made (if items have been hidden, if additional columns are available for drill down, etc).
. Depending on the selected component selected, the shortcut menu displays the following options:
Keep Only (Desktop and Workspace)
Remove Only (Desktop and Workspace)
Drill (Desktop and Workspace)
Down (Desktop and Workspace)
Up (Desktop and Workspace)
Next (Desktop and Workspace)
Bottom (Desktop and Workspace)
All Descendants (Desktop and Workspace)
Siblings (Desktop and Workspace)
Same Level (Desktop and Workspace)
Same Generation (Desktop and Workspace)
Suppress (Desktop and Workspace)
Missing rows (Desktop and Workspace)
Missing columns (Desktop and Workspace)
Missing columns (Desktop and Workspace)
Zero rows (Desktop and Workspace)
Zero columns (Desktop and Workspace)
Drill-Through (Desktop and Workspace)
Column width ... (Desktop and Workspace)
Row height (Desktop and Workspace)
Expression.EnableMenuItem(BeMenuItem as ItemId, Boolean as enables)
The BqMenuItem constant group consists of these values:
bqMenuItem_AddRefLine = 28
bqMenuItem_AddTrendLine = 27
bqMenuItem_AutoSizeCol = 5
bqMenuItem_Background = 4
bqMenuItem_Drill = 6
bqMenuItem_DrillAllDesc = 13
bqMenuItem_DrillAnywhere = 7
bqMenuItem_DrillBottom = 12
bqMenuItem_DrillDown = 9
bqMenuItem_DrillNext = 11
bqMenuItem_DrillSameGen = 16
bqMenuItem_DrillSameLevel = 15
bqMenuItem_DrillSiblings = 14
bqMenuItem_DrillThrough = 8
bqMenuItem_DrillUp = 10
bqMenuItem_FocusOnItem = 17
bqMenuItem_HideItems = 18
bqMenuItem_KeepOnly = 38
bqMenuItem_Refresh = 45
bqMenuItem_RemoveOnly = 39
bqMenuItem_SetColWidth = 50
bqMenuItem_SetRowHeight = 51
bqMenuItem_ShowAll = 20
bqMenuItem_ShowBarBorder = 24
bqMenuItem_ShowHidden = 19
bqMenuItem_ShowLabel = 26
bqMenuItem_ShowMarkerBorder = 25
bqMenuItem_ShowNegative = 22
bqMenuItem_ShowPieBorder = 23
bqMenuItem_Sort = 1
bqMenuItem_SortAsc = 2
bqMenuItem_SortDesc = 3
bqMenuItem_SupMissCols = 42
bqMenuItem_SupMissRows = 41
bqMenuItem_Suppress = 40
bqMenuItem_SupZeroCols = 44
bqMenuItem_SupZeroRows = 43
bqMenuItem_Swing = 29
bqMenuItem_SwingAfter = 37
bqMenuItem_SwingBefore = 36
bqMenuItem_SwingDow = 33
bqMenuItem_SwingHorz = 30
bqMenuItem_SwingLeft = 34
bqMenuItem_SwingRight = 35
bqMenuItem_SwingUp = 32
bqMenuItem_SwingVert = 32
bqMenuItem_ToggleGroup = 21
bqMenuItem_Zoom = 48
bqMenuItem_ZoomIn = 46
bqMenuItem_ZoomOriginal = 49
bqMenuItem_ZoomOut = 47
This example show how to read which shortcut menu items for the Results embedded section object have been enabled, and writes the values to the Console window and a text box:
Console.Writeln("Start") TextBox3.Text = "" if (Results1.MenuItemEnabled(bqMenuItem_SortAsc) == true) { Console.Writeln("bqMenuItem_SortAsc") TextBox3.Text += "bqMenuItem_SortAsc" } if (Results1.MenuItemEnabled(bqMenuItem_SortDesc) == true) { Console.Writeln("bqMenuItem_SortDesc") TextBox3.Text += "\r\nbqMenuItem_SortDesc" } if (Results1.MenuItemEnabled(bqMenuItem_Background) == true) { Console.Writeln("bqMenuItem_Background") TextBox3.Text += "\r\nbqMenuItem_Background" } if (Results1.MenuItemEnabled(bqMenuItem_AutoSizeCol) == true) { Console.Writeln("bqMenuItem_AutoSizeCol") TextBox3.Text += "\r\nbqMenuItem_AutoSizeCol" } Console.Writeln("End")