Show TOC

Main Interface AreasLocate this document in the navigation structure

The EPM plug-in for Microsoft Office adds the following areas to Microsoft Office Excel or Microsoft Office PowerPoint:
  • In the ribbon of Microsoft Office 2007 and 2010, the EPM tab is the main entry point for performing reporting and data input actions.
    Note When positioning your cursor on a command in the EPM tab, a tooltip appears, explaining the command.
    Note Depending on the Microsoft Office application, the EPM tab does not contain all the same commands.
  • In Microsoft Office 2003, the EPM menu is the main entry point for performing reporting and data input actions.
  • The EPM Context bar is displayed by default horizontally and below the ribbon.

    The bar displays the dimensions that are included in the current cube/model and the members that are used in the currently displayed report (or the saved members in an offline report).

    You can hide the bar by unchecking the Display EPM Context Bar option in Start of the navigation path EPM Next navigation step Options Next navigation step User Options End of the navigation path. This bar can also be displayed inside the EPM pane by checking the Display Context inside EPM Pane option. You can also move the bar into and back from the pane, using the mouse move pointer.
  • The EPM pane is displayed by default vertically on the right side of the window.

    This pane includes the following areas: the active connection; information about the selected report, including the connection used by the report, the name of the report, all the dimensions available, the page axis dimensions, the row axis dimensions and the column axis dimensions.

    You can hide the pane by unchecking the Display EPM Pane option in Start of the navigation path EPM Next navigation step Options Next navigation step User Options End of the navigation path. Selecting the title bar of the pane and using drag and drop, you can move the pane to the left side of the window or anywhere else in the window.
    Note The EPM Context bar and the EPM pane can both be hidden or displayed at the same time by clicking the Show Pane & Context button in the EPM tab.
  • Cell Context menu. Only in Microsoft Office Excel, a cell context menu appears when you right-click on any cell in the spreadsheet. The plug-in adds a tab to the ribbon: EPM. This allows you to continue to use the existing Microsoft Office Excel features (such as: cut, copy, paste and insert) and does not take up much space.
Persistent resizing

You can resize the pane, the bar and the dialog boxes. Your resizing choices are kept from one session to the next.

Related Information