on 04-18-2016 7:55 PM
Hi guys, this is my first discussion on SCN. Please excuse-me if I did something wrong.
I would like to know if it is possible to disable Design Panel for the end user consumers.
In my company we have the context where the "Power Users" are responsible to create, mantain and save the workbook Analysis on BIP (Business Intelligence Platform). The "End Users" will just consume that workbook already created/saved by the Power User on BIP without be allowed to make changes, just refresh the data.
I am thinking to disable the design panel, but if there is another way to do that, feel free to help me.
Thanks in advanced.
Abel Junior
Hi Abel,
You can play around with Macros or with customized ribbon.
For example, you can use the Macro code below to hide the Design Panel in AO:
Dim result
result = Application.Run("SAPExecuteCommand", "Hide", "TaskPane", "All")
However, the user will still be able to show the panel by clicking on "Display" button in AO, so you may have to write some more Macro code.
You can also remove the entire Design Panel group from the ribbon like below:
This is achieved via Excel > Options > Customize Ribbon.
Regards,
Filipe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abel ,
I believe your end users don't have access to save work book to BIP !
In that case we don't need to disable any feature , users can play around and close .
afaik , we can't control this features from BIP CMC.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abel,
Currently there is no setting to disable the design panel.
Actually if you open the saved workbook by default it doen not opens the design panel,if you want see it you have to enable it from the ribbon menu.
As Tammy mentioned give some guided navigation to just consume workbook.
Thanks and Regards,
Basavaraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can review the settings in admin guide to on where to display the design panel https://websmp201.sap-ag.de/~sapidb/012002523100004457362016E/22SP2_aaoffice_admin_en.pdf - search 'design panel'
You can also provide some guided navigation so your end users can just 'consume' the workbooks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.