User manual BUSINESS OBJECTS EPM ADD-IN FOR MICROSOFT OFFICE 10.0 2010-12-06

[. . . ] EPM Add-in for Microsoft Office User Guide SAP BusinessObjects EPM solutions, add-in for Microsoft Office 10. 0 2010-12-06 Copyright © 2010 SAP AG. All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S. A. Business Objects is an SAP company. All other product and service names mentioned are the trademarks of their respective companies. [. . . ] It will persist (be enabled) on a spreadsheet until you do something else on the same spreadsheet using Excel, or another EPM add-in operation on any spreadsheet. Its purpose is to let you immediately back out of a navigational action, layout change, or refresh of the cube that was done in error or gave you undesirable results. 89 2010-12-06 Report Navigation 16. 2 Row and Column Axes Switch You can invert the row and the column axes of a report. To swith the report axes, click the button located between the Row Axis and Column Axis areas in the EPM pane or right-click in the report and select EPM > Switch Axes. Note: · · A message indicates that if you have defined sorting, ranking or filtering criteria in the report, the criteria will be lost. You cannot switch the row and column axes of a report that shares an axis with another report. In this case, the button is deactivated. 16. 3 Expand The Expand command on a member selected in a report, drills down to the members below (depending on the expansion relationship behavior chosen) and all occurrences of the same member. · the children of the selected parent and the parent itself · the children of the selected parent · the descendants of the selected parent and the parent itself · the descendants of the selected parent To specify the expansion relationship behavior you want to apply by default, select an option in the Expand Options area in EPM > Options > Sheet options > Interface. The option selected applies by default: · When you click the Expand button in the EPM tab. However, using the Expand button list, you can select other behaviors, the same as in the sheet options that are listed above. · Also, if you select the Enable Double-Click option in the User Options, the fastest way to perform an expand is to double-click on the member you want to expand on. This allows you to quickly drill down to find what you are looking for. In this example, if you wanted to expand on the USA member in the row axis, you could select the USA cell and then click on the Expand, or you could just double-click on the USA cell shown here: This will expand USA into all of its children like this: 90 2010-12-06 Report Navigation Note that the children are shown indented above their "total" parent. Totals are put at the bottom but you can change them into totals at the top. Note: · · Expand will not work on a page axis dimension member since it has no place to expand to. When the data sorting, ranking and filtering are activated, the expand works in the column axis only if the following options are selected in the Expand Options area in the Sheet options dialog box: · · Member and Children Member and Descendants The Expand does not work in the column axis when the other options are selected. When the data sorting, ranking and filtering are activated, the Expand never works in the row axis. When the data sorting, ranking and filtering are activated, the way the Expand works also applies to the Collapse feature. Related Topics · Expand Options 16. 3. 1 Expand on Nested Axis In a multidimensional (nested) axis, if you expand on an outer dimension, the behavior is the same as in a simple axis. (see example 1) In a multidimensional (nested) axis, if you expand on an inner dimension, then you can have one of the following behaviors: · · all child members will be repeated for each member of the outer dimension. (see example 2) only the child member for the selected member of the outer dimension will be displayed. (see example 3) For example if you expand on Chips below to show its children (Regular Chips and Sun Style): 91 2010-12-06 Report Navigation You would get this: Example 1 The Expand/Collapse on Single Member option in the EPM > Options > User options dialog box enables you to perform asymmetrical expand and out on a nested axis. If you want to perform symmetrical expand and out, uncheck the option. [. . . ] The command names in the EPM tab are displayed in the language you have selected when you re-start the application. Note: If you have opended the EPM add-in from SAP BusinessObjects Enterprise BI launch pad, the add-in inherits the SAP BusinessObjects Enterprise BI launch pad application language defined for the current user. · Data language. If the data language you select does not exist in an SSAS cube, members are displayed in the cube default language. Because the EPM add-in is integrated into Microsoft Office Excel, Word and PowerPoint, it inherits all the Windows international settings for number and date defaults and formats. [. . . ]