Analysis Office 2.4 Customize User Interface

A new feature of Analysis Office 2.4 is that you have a function called Customize User Interface. On the first view it looks similar to the Excel customize ribbon function. But it has more flexiblity to switch between different interfaces. First you have to open the Customize User Interface dialog via File >> Analysis. The following dialog appears.

Analysis Office Customize User Interface
Analysis Office Customize User Interface

To define a new profile you have to click into the drop down box and enter a name, e.g. reyemsaibot. After you entered your profile name, the save button is active.

Analysis Office Customize User Interface save profile
Analysis Office Customize User Interface save profile

After you saved your profile, you can delete it or set it as standard profile.

Analysis Office Customize User Interface saved
Analysis Office Customize User Interface saved

Now you can modify the ribbon interface by select or unselect the groups and elements. If you want to add a own function, make right click and add a New Group.

Analysis Office Customize User Interface add new group
Analysis Office Customize User Interface add new group

You can now define the group.

Analysis Office Customize User Interface define group
Analysis Office Customize User Interface define group

After you add the group, you are able to add your own elements to this group. Make a right click and select New Element. You can choose between Button, Separator, Split Button and Toggle Button as element. For all elements except for Separator you have to define a Label, Macro, Size and an Image.

Analysis Office Customize User Interface add new element
Analysis Office Customize User Interface add new element
Analysis Office Customize User Interface Ribbon
Analysis Office Customize User Interface Ribbon

For example I add a Button Open Workbook and choose my macro SAPOpenWorkbook. You can choose your macro either in this workbook or in an external source like a Excel add-in. So you are able to design different interface for different people or use cases. The interfaces are stored under C:\Users\<User>\AppData\Roaming\SAP\Cof\User Interface. There you find a xml and an image folder, in which are the selected images are saved.

Appdata User Interfaces
Appdata User Interfaces

If you want to distribute them in your company, take these files (xml and the image folder) and move them to C:\ProgramData\SAP\Cof\User Interface\. Now it is a company user interface and can't be deleted by the user.

Analysis Office Customize User Interface Company Interface
Analysis Office Customize User Interface Company Interface

If there is any question feel free to write a comment. I think it is a cool feature if you want to restrict the view of the ribbon and distribute it in your company. If it will be used a lot, will we see in the future. So stay tuned for other Analysis Office 2.4 content.

Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 € 1
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 € 1

Write a comment

Comments: 8
  • #1

    Mark (Friday, 23 December 2016 11:58)

    Thanks for this How-to, this function is a great addition to Analysis Office. In our current project we needed to use the MS Custom UI Editor, to create our own ribbon with specific buttons.

    Is it possible to save the profile within the workbook? For our planning scenarios, we need different interfaces with different buttons and functions, so we don't want to use a standard profile for all our applications.

    Thanks!

  • #2

    Tobias (Friday, 23 December 2016 12:44)

    Hi,

    thanks for your feedback. It is not possible to save the profile in the workbook, because it is saved in the Cof_user_roaming.config file but you could build a macro or something similar which switch the interface.

    Maybe there will be more information when SAP releases the admin and user guide.

    Best regards,

    Tobias

  • #3

    Alexandru (Monday, 20 February 2017 20:50)

    Great article, thanks for sharing it with us all!
    I was thinking if there is any possibility to create a new button that will get an URL address - link to a support website. This might be a super information for our users. Unfortunately I cannot find any information on SAP or any other source. Do you have any idea if this can be done and how?

    Best Regards,
    Alex

  • #4

    Tobias (Monday, 20 February 2017 21:27)

    Hi Alex,

    what do you mean with support website? Do you mean a link to your company intranet or something similar?

    Tobias

  • #5

    Alexandru (Tuesday, 21 February 2017 08:18)

    Hi Tobias,

    Yes, a link to a company website where the user will find some documentation.

    Regards,
    Alex

  • #6

    Tobias (Tuesday, 21 February 2017 20:00)

    Hi Alex,

    this is very easy. Here an example code

    Sub OpenWebsite()

    Set wshshell = CreateObject("WScript.Shell")
    wshshell.Run "https://www.reyemsaibot.com"

    End Sub

    Tobias

  • #7

    Faisal (Thursday, 13 April 2017 21:12)

    Hi Tobias,
    Your overview has been very helpful, thank you!
    I just had a question, as I would like to distribute the interface files to our users, the file path you give doesn't seem to exist for our installs (C:\ProgramData\SAP\Cof\User Interface\), rather the "\User Interface\" folder doesn't appear. Creating the folder doesn't read from their either.
    I was wondering if you would know anything about it?
    We're using the 32 bit version, also installed the first service pack, but i don't remember seeing in the release notes that they had removed this, so I was just curious about your take on it. Thanks again for the post, and thanks for reading

    Faisal

  • #8

    Tobias (Friday, 14 April 2017 16:02)

    Hi,

    if the path is not correct, you can set it with the file system setting AppBuilderCompanyProfileDirectory or AppBuilderUserProfileDirectory (depends if you use the company profile or not).

    If you still have questions feel free to ask.

    Tobias