CustomUI/Ribbon Qualified IDs for Analysis tab and group controls

[Former Member]

In Excel 2007 it's possible to add controls, referenced by a qualified ID (idQ attribute), to the Quick Access Toolbar, and in Excel 2010, to add controls to the Quick Acces Toolbar, or the ribbon. Furthermore, it is possible to add and/or position custom controls on or next to the Analysis tab, or groups on the Analysis tab, by using attributes like insertBeforeQ and insertAfterQ. The approaches for configuring the Ribbon are beyond the scope of this article - See here and here for an overview.

This article provides a summary of the qualified control IDs (idQ attributes) for the Analysis tab, and the groups on the Analysis tab. They're qualified by namespace: "SBO", but you can use a namespace of your own choosing.

The Analysis Tab

idQ="SBO:com.sap.ip.bi.analysis.menu"

The Analysis Groups

Data Source:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.dataconnections"

Undo:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.backandforward"

Data Analysis:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.dataanalysis"

Display:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.display"

Insert Component:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.insertGroup"

Tools:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.tools"

Planning:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.planning"

Design Panel:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.Taskpanel"

Settings:

idQ="SBO:com.sap.ip.bi.newpioneer.excel.setting"