Custom Ribbon with Analysis 2.0

[j_pick]

Hello,

We created a custom ribbon which includes individually programmed features based on VBA and references standard functionality from the Analysis Ribbon.

The reference is handled in the CustomUI.xml based on the following Code:

<?xml version="1.0" encoding="utf-8"?>

<mso:customUI xmlns:x1="SBOP.AdvancedAnalysis.Addin.1" xmlns:mso="http://schemas.microsoft.com/office/2009/07/customui">

  <mso:ribbon startFromScratch="false">

    <mso:tabs>

      <mso:tab idQ="x1:com.sap.ip.bi.analysis.menu" visible="true"></mso:tab>

      <mso:tab id="Tab1" label="Custom Ribbon">

        <mso:group id="DataGroup" label="Analysis" visible="true">

          <mso:control idQ="x1:com.sap.ip.bi.pioneer.core.command.refresh" size="normal" visible="true" />

          <mso:control idQ="x1:com.sap.ip.bi.newpioneer.controls.sort" size="normal" visible="true" />

          <mso:control idQ="x1:com.sap.ip.bi.newpioneer.excel.Hierarchy" size="normal" visible="true" />

          <mso:control idQ="x1:com.sap.ip.bi.newpioneer.excel.calculations" size="normal" visible="true" />

          <mso:control idQ="x1:com.sap.ip.bi.newpioneer.excel.totals" size="normal" visible="true" />

        </mso:group>

      </mso:tab>

    </mso:tabs>

  </mso:ribbon>

</mso:customUI>

With the Upgrade to Analysis 2.0 the referenced functionality stopped working. The buttons don't show at all.

Is it still possible to reference functionality from Analysis 2.0 in custom ribbons?

Thanks in andvance and regards,

Jason

[former_member110741 · Accepted solution]

Hi Jason Pick,

Your code will not work due to the fact that id  idQ="x:com.sap.ip.bi.analysis.menu" is different to 2.0, which is SapExcelAddIn. and for SapExcelAddIn idQ is not implemented yet in 2.0/2.1

So answer is No, its not possible with current 2.0 & 2.1 to develop custom ribbons.

Regards,

Subhash

[j_pick · Accepted solution]

Thank's for the input. After trying different scenarios, I got it working with the follwing simple change (highlighted red):

<?xml version="1.0" encoding="utf-8"?>

<mso:customUI xmlns:x1="SapExcelAddIn" xmlns:mso="http://schemas.microsoft.com/office/2009/07/customui">

  <mso:ribbon startFromScratch="false">

    <mso:tabs>

      <mso:tab idQ="x1:com.sap.ip.bi.analysis.menu" visible="true"></mso:tab>

      <mso:tab id="Tab1" label="Custom Ribbon">

        <mso:group id="DataGroup" label="Analysis" visible="true">

          <mso:control idQ="x1:com.sap.ip.bi.pioneer.core.command.refresh" size="normal" visible="true" />

          <mso:control idQ="x1:com.sap.ip.bi.newpioneer.controls.sort" size="normal" visible="true" />

          <mso:control idQ="x1:com.sap.ip.bi.newpioneer.excel.Hierarchy" size="normal" visible="true" />

          <mso:control idQ="x1:com.sap.ip.bi.newpioneer.excel.calculations" size="normal" visible="true" />

          <mso:control idQ="x1:com.sap.ip.bi.newpioneer.excel.totals" size="normal" visible="true" />

        </mso:group>

      </mso:tab>

    </mso:tabs>

  </mso:ribbon>

</mso:customUI>

Yet not all the commands work properly. The menu for surpressing 0 in rows or columns seems to have a new IdQ.

Do you know if there are any plans to providing the functionality of creating custom ribbons officially? In this case we would require a complete reference of IdQ's from the Analysis Ribbon.

Regards,

Jason

[former_member110741 · Accepted solution]

Hi jason pick,

Yes this is planned in further release 2.2

I would request you to please be wait until we get official confirmation

Subhash

[j_pick · Accepted solution]

Okay. Thanks!

[former_member110741]

Hi Jason Pick,

this issue is fixed with below note, check the note for the versions

http://service.sap.com/sap/support/notes/2163209

Subhash