Calling "Display Design Panel" via Macro

[Former Member]

Dear all,

I'm using a customized planning ribbon, which should allow the user to display the design panel for drag/drop actions. I was not able to find any similar VBA coding in the SAP Analysis User Guide.

For example, I'm using the following coding to trigger the prompt:

'Callback for Selections data onAction

Sub PROMPT(control As IRibbonControl)

Dim lResult As Long

lResult = Application.Run("SAPExecuteCommand",
"ShowPrompts")

End Sub

Is there anything similar possible for the "display panel"?

Thanks in advance

Dominik

[former_member110741 · Accepted solution]

Hi Dominik Drebinger,

There is no VBA API is available yet in analysis office for design panel.

(as mentioned above only available for analysis & componnets tab in design panel)

Thanks & Regards,

Subhash

[former_member110741]

Hi Dominik Drebinger,

To hide Components Tab in Design panel use

Dim lResult As Long

lResult = Application.Run("SAPExecuteCommand", "Hide", "TaskPane", "Components")

To Hide Analysis Tab in Design panel use

Dim lResult As Long

lResult = Application.Run("SAPExecuteCommand", "Hide", "TaskPane", "Analysis")

After this to Show Components & Analysis tabs in design panel use

Dim lResult As Long

lResult = Application.Run("SAPExecuteCommand", "Show", "TaskPane", "Default")

i could not find any option to show & hide full design panel as such

for more information Please have a look at help document for SAPExecuteCommand in Analysis Office

Hope the above information meets your requirements

Best Regards,

Subhash

[Former Member]

Hey Subhash,

unfortunately that is not really what I was supposed to achieve. I guess you also found within the User Analysis Guide.

I would need something, that I can assign to some button, which will pop up the "display panel".

Thanks though!

Kind regards

Dominik

[Former Member]

Hello Dominik,

Could you find any solution for this issue?

We have the same requirement and i wonder if you could find any workaround etc.

Thank you

[Former Member]

Dear all,

to be more clear, it should be linked to a button within my ribbon.

I guess I have to first implement this into my UI Editor:

Taskpanel:

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

Analysis-Menu:

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

And afterwards I have to implement some VBA coding via Application.Run

Does anyone know something about it?

Thanks in advance

Dominik