Analysis for Office Open Workbook from Toolbar, instead of Filemenu of Excel

[MXK]

Hi all,

i wanted to ask you, if it is possible to get the functionality of opening an Analysis for Office Workbook from the Analysis Tab (Menu Bar), where you also open DataSources.

I wanted to leverage the UI customizer to use the exact button functionality from the File Menu Analysis > Open Workbook > From SAP Netweaver Server.

This functionality must have a Macro or function behind. But unluckily i am not able to open/display the function as in other functions of the UI customizer. (e.g. something like "Open_Workbook" - but the exact function is yet unknown to me).

I would be happy to receive some help or where i can find some specifics in the code (xml) of Analysis for Office, where these functions are realized.

[harsha_jalakam]

Hi , were you able to achieve this? I would like to achieve the same(open workbook pop up) through a custom button in the ribbon and not sure which macro is associated with this?

Thanks in advance.

Regards,
Harsha

[MXK]

Now i wanted to look, if I can trick the XML of the Menu somehow.

Custom UI profiles are stored in: %APPDATA%/Roaming/SAP/Cof/User Interface

So i tried to copy the function from the File-Menu Button "Open a Workbook" to another Button in the Menu.

This is the function i identified from the FILE MENU Button (nested Button - see MenuGroup 3)

<CofElementBase xsi:type="CofControl">
<Properties>
<Property xsi:type="IdProperty">
<Value xsi:type="xsd:string">Backstage.AOPlugin.OpenWorkbook.Menu.MenuGroup3.OpenWorkbookFromNetWeaver</Value>
</Property>
<Property xsi:type="LabelProperty">
<Value xsi:type="xsd:string">Open a workbook from the SAP Business Warehouse Platform.</Value>
</Property>
</Properties>
<IsVisible>true</IsVisible>
<IsConfigurableControl>true</IsConfigurableControl>
<Type>Button</Type>
</CofElementBase>

But the Button does not work afterwards.

I checked that I put it to the same Button category as the xml is validated afterwards.

But until now no success somehow.

[gleo_SRAM]

Hi Max, were you able to get your request sorted? I'm looking to do the same thing and not having any luck,

With thanks

Gill

[MXK]

Ok i went so far to even search in the DLL files of the plugin for that specific opening function.

But somehow still no success until now.