1.2 User profiles

There are three user profiles for SAP BusinessObjects Advanced Analysis, edition for Microsoft Office: Workbook Creator Users who create and maintain workbooks based on SAP BEx queries, query views and SAP NetWeaver BW InfoProvider. Data Analyst Users who navigate through existing workbooks and analyze the data they contain. They can also include workbooks in a Microsoft PowerPoint presentation and continue the analysis there. Administrator IT specialists who install, configure and administer SAP BusinessObjects Advanced Analysis, edition for Microsoft Office. They also assign security rights and authorizations to workbook creators and analyzers. If your existing profile needs to be modified, contact your IT administrator.
1.3 About the documentation set
The documentation set for SAP BusinessObjects Advanced Analysis, edition for Microsoft Office, comprises the following guides and online help products:
Administrator Guide The Administrator Guide contains detailed information that a user needs to install, configure and administer the edition for Microsoft Office. The guide is available on the SAP Help Portal. User Guide The User Guide contains the conceptual information, procedures and reference material that a user needs to create and analyze Microsoft Excel workbooks and Microsoft PowerPoint slides with the edition for Microsoft Office. The guide is available on the SAP Help Portal. Online Help The online help contains the same information as the User Guide. It can be called by pressing the Help button in the "Setting" group on the "Advanced Analysis" tab. For dialogs, you can access context sensitive help by selecting F1. Note: SAP BusinessObjects Advanced Analysis, Web edition, although related very closely to SAP BusinessObjects Advanced Analysis, edition for Microsoft Office, has its own documentation set, including its own user guide and online help.

Getting Started

2.1 What is SAP BusinessObjects Advanced Analysis, edition for Microsoft Office?
SAP BusinessObjects Advanced Analysis, edition for Microsoft Office, is a Microsoft Office Add-In that allows multidimensional ad-hoc analysis of OLAP sources in Microsoft Excel, MS Excel workbook application design, and intuitive creation of BI presentations with MS PowerPoint. The Add-In is available for the following Microsoft Office versions: Microsoft Excel 2007 Microsoft PowerPoint 2007 Microsoft Excel 2003 In the edition for Microsoft Office, you can use SAP BEx Queries, query views and SAP Netweaver BW InfoProvider as data sources. The data is displayed in the workbook in crosstabs. You can insert multiple crosstabs in a workbook with data from different sources and systems. If the workbook will be used by different users, it is also helpful to add info fields with information on the data source and filter status. Using the design panel, you can analyze the data and change the view on the displayed data. You can add and remove dimensions and measures to be displayed easily with drag and drop. To avoid single refreshes after each step, you can pause the refresh to build a crosstab. After ending the pause, all changes are applied at once. You can refine your analysis using conditional formatting, filter, prompting, calculations and display hierarchies. You can also add charts to your analysis. If you want to keep a status of your navigation, you can save it as an analysis view. Other users can then reuse your analysis. For more sophisticated workbook design, the edition for Microsof Office contains a dedicated set of functions in Microsoft Excel to access data and meta data of connected BW systems. There are also a number of API functions available that you can use with the Visual Basic Editor, to filter data and set values for BW variables. Advanced Analysis, edition for Microsoft Office, must be installed on your local machine. You can connect directly to a SAP NetWeaver BW system or you can connect via SAP BusinessObjects Enterprise to include data sources. Typically, you use SAP BusinessObjects Enterprise to store and share workbooks in productive environments, but in test systems, you can also directly connect to a BW system. Using SAP BusinessObjects Enterprise enables you to save workbooks and presentations in a central management system and to reuse analysis view in other applications, like Crystal Reports or Advanced Analysis, Web edition.

2.2 Working with Advanced Analysis in Microsoft Excel 2007
In Microsoft Excel 2007, Advanced Analysis is available as a separate tab in the ribbon. The ribbon is part of the Microsoft Office user interface above the main work area that presents commands and options. Starting in the 2007 Microsoft Office system, this replaces menus and toolbars. The Advanced Analysis tab contains the following groups: Data Source Undo Data Analysis Display Insert Component Tools Design Panel Settings
Data Source group The following table describes the options that this group contains for inserting and refreshing data sources.

Icon Description

Insert Data Source More information: To insert in a crosstab with data Refresh All
To open and save existing workbooks, use the corresponding options in the Microsoft Office button. More Information: Open Workbook / Save Workbook Undo group The following table describes the options that this group contains.

Undo Redo

Data Analysis group The following table describes the options that this group contains for data analysis.

Description

Prompts More information: Prompting Filter More information: To filter data by measureTo filter data by member Sort More information: Sorting data Hierarchy Calculations Swap Axes
Display group The following table describes the options that this group contains for editing the display.
Conditional Formatting More information: To define a Conditional Format Member Display Measure Display Totals
Insert Component group The following table describes the options that this group contains for inserting addtional components to the analysis.
Chart More information: To insert a dynamic chart
Info Field More information: To insert an info field Filter More information: To insert a filter
Tools group The following table describes the options that this group contains.
Convert to Formula More information: Converting crosstab cells to formula Create Slide More information: To create a slide out of Microsoft Excel
Design Panel group The following table describes the options that this group contains for working with the design panel.
Display More information: Analyzing data with the design panel Pause Refresh
Settings group The following table describes the options that this group contains.
Settings More information:Settings Style More information: Defining style sets for crosstabs
2.3 Working with Advanced Analysis in Microsoft PowerPoint 2007
In Microsoft PowerPoint 2007, Advanced Analysis is available as a separate tab in the ribbon. The ribbon is part of the Microsoft Office user interface above the main work area that presents commands and options. Starting in the 2007 Microsoft Office system, this replaces menus and toolbars. The Advanced Analysis tab contains the following groups: : Data Source Undo Filter and Sort Display Insert Component Settings

2.5.1 To enable or disable the Advanced Analysis Add-In in Microsoft Excel 2007 or Microsoft PowerPoint 2007
Depending on how Advanced Analysis has been configured, you can enable or disable the Advanced Analysis Add-In in Microsoft Excel 2007 and Microsoft PowerPoint 2007. 1. Open any Microsoft Excel or Microsoft PowerPoint file. 2. Press the Microsoft Office Button. 3. In Microsoft Excel, select Excel Options. In Microsoft PowerPoint, select PowerPoint Options. 4. In the "Excel Options" dialog box and the "PowerPoint Options" dialog box in the categories pane, select Add-Ins. 5. In the Manage box, select COM Add-Ins. 6. Press Go. 7. In the "COM Add-Ins" dialog box, activate or deactivate the option Advanced Analysis. 8. Press OK. If you enable the Advanced Analysis Add-In, it is always available when you open Microsoft Excel 2007 or Microsoft PowerPoint 2007.
If you disable the Advanced Analysis Add-In, it is not available when you open Microsoft Excel 2007 or Microsoft PowerPoint 2007. To work with SAP BusinessObjects Advanced Analysis, edition for Microsoft Office, you have to open the program directly.
2.5.2 To enable or disable the Advanced Analysis Add-In in Microsoft Excel 2003
Depending on how Advanced Analysis has been configured, you can enable or disable the Advanced Analysis Add-In in Microsoft Excel 2003. 1. Open any Microsoft Excel file. 2. On the View menu, choose Toolbars > Customize. 3. Select the Commands tab. 4. In the Categories box, select Tools. 5. In the Commands box, select COM Add-Ins and drag it to a toolbar. 6. On the toolbar, select COM Add-Ins to see the list of available add-ins. Note: The Advanced Analysis Add-In is only available in this list, if your administrator set the corresponding parameter in the registry. If you cannot see the Advanced Analysis Add-In, contact your administrator. 7. Activate or deactivate the option Advanced Analysis. 8. PressOK. If you enable the Advanced Analysis Add-In, it is always available when you open Microsoft Excel 2003. If you disable the Advanced Analysis Add-In, it is not available when you open Microsoft Excel 2003. To work with SAP BusinessObjects Advanced Analysis, edition for Microsoft Office, you have to open the program directly.

Creating Workbooks

3.1 To insert in a crosstab with data
To add a crosstab with data to a workbook, you select a data source in a SAP NetWeaver BW system. You need the appropriate authorizations for SAP BusinessObjects Enterprise and the relevant SAP NetWeaver BW systems to insert a data source in a workbook. For more information, contact your IT administrator. You can insert SAP BEx Queries, query views and SAP Netweaver BW InfoProvider as data sources. These data sources are stored in a SAP NetWeaver BW system. You can add multiple crosstabs to worksheet or workbook. The crosstabs can contain data from the same data source or from different sources. You can also use data sources that are stored in different systems in one workbook. 1. Select the cell in the worksheet where the crosstab with the data from the selected data source should be inserted. 2. Select Insert Data Source. The "Log on to BusinessObjects Enterprise" dialog box appears. 3. Enter your User, Password and the WEB Service URL to BusinessObjects Enterprise. Note: By selecting Skip you can log on to a BW system directly without using BusinessObjects Enterprise. Continue with step 8 if you use this log on. 4. Optional step: Enter System and Authentication. You will normally not be asked to supply this information. However, if you are asked to log on to a special Central Management System (CMS), you can add these two additional fields to the dialog box by selecting Options. Enter the name of your Central Management System in the System field and the authentication type in the Authentication field. 5. Press OK. The "Select Data Source" dialog box appears. 6. Select a connection in the Show Connections list: If you select All, all available systems, Cubes / InfoProvider and Query / Query views on SAP BusinessObjects Enterprise are displayed. If you select System, all available systems on SAP BusinessObjects Enterprise are displayed. If you select Cube / InfoProvider, all available Cubes and InfoProvider on SAP BusinessObjects Enterprise are displayed. If you select Query / Query View, all available Queries and query views on SAP BusinessObjects Enterprise are displayed.
If you select Local System, all systems in your local "SAP Logon" are displayed.
7. Select a system and Next. To select a Query, query view or InfoProvider directly, double-click the object you want to select. The "Logon to System" dialog box appears. 8. Enter Client, User and Password in the fields and press OK. If you want to specify the system language, select Options and enter the language in the Language field. 9. Select a data source in the Select Data Source box and press OK. On the Folders tab, you can navigate in the Roles or InfoAreas views to find a data source. On the Search tab, you can search for the description or technical name of a data source. To retrieve data sources that begin with a specific string, you can type * after a partial string. A new crosstab with the data of the selected data source is inserted in the worksheet. You can now analyze the data and change the displayed data set according to your needs. You can also add other components to your anaylsis, for example charts.

3.2 Defining style sets for crosstabs
A style set is a cellection of Microsoft Excel cell styles that is applied by Advanced Analysis to format the cells of a crosstab. Whenever you insert a new crosstab in a workbook, the styles of the current default style set are used to format the crosstab cells. You can change the applied style set in your analysis. With Advanced Analysis, the following style sets and their cell styles are installed: SAP Tradeshow Plus SAP Blue SAP Black&White By modifying the cell styles of these style sets, you can create own style sets and share them with other users.

3.2.1 SAP cell styles

SAP standard styles SAP standard styles are availabe after the installation of the Add-In. You can modify them in the Styles group on the Home tab of Microsoft Excel. They affect the formatting as described in the following table:

Style Name

SAPDimensionCell Format for dimension header cells. SAPMemberCell Format for member cells (non-hierarchical dimensions).
SAPHierarchyCell Format for hierachical member cells (even levels 0, 2,.). SAPHierarchyOdd- Format for hierarchical member cells (odd levels 1, 3,.). Cell SAPMemberTotal- Format for member total cells. Cell SAPDataCell Format for data cells.
SAPDataTotalCell Format for data total cells. SAPExceptionLev- Format for highlighted cells due to conditional formats (rule priorities 1-9). el1-9 SAPEmphasized SAPBorder Format for highlighted data cells (as per query definition). Format for borders around a crosstab and between header/member and data cells (format for left border is taken).
SAP custom styles The following SAP custom styles are not availabe after the installation of the Add-In, but you can create them in the Styles group on the Home tab of Microsoft Excel. They affect the formatting as described in the following table:

Style Name Description

SAPMemberCellX Format for member cells on columns (overriding SAPMemberCell). SAPMemberTotal- Format for member total cells on columns (overriding SAPMemberTotalCell). CellX SAPHierarchyCellX Format for hierarchical member cells on columns, even levels (overriding SAPHierarchyCell). SAPHierarchyOdd- Format for hierarchical member cells on columns, odd level (overriding SAPHierCellX archyOddCell). SAPHierarchyCell0-9 Format for hierarchical member cells on specific level (overriding SAPHierarchyCell and SAPHierarchyOddCell).

3.3.3 To insert a filter

You can insert a filter component to your analysis to simplify the filtering. This helps you to quickly change the view of the displayed data, for example to different periods of time. 1. Select an empty cell where you want to place the filter component. 2. Choose Filter and select one of the listed dimensions to insert a filter component for this dimension. The dimension name and a filter component formula are inserted in the worksheet. The functions used for the formulas are SAPGetDimensionInfo and SAPSetFilterComponent. The formulas are created automatically. 3. Optional Step: Specify the filter component formula. The formula that is inserted automatically, allows the user to select multiple members for filtering. It looks like this: =SAPSetFilterComponent("DS_2"; "0CALYEAR";"ALL"). You can add one of the following parameters to the formula: SINGLE, MULTIPLE, LOWERBOUNDARY, UPPERBOUNDARY to specify the filtering options. If you add the parameter SINGLE, the user can only select one member for filtering. The formula looks like this: =SAPSetFilterComponent("DS_2"; "0CALYEAR";"ALL";"SINGLE"). You can also insert filter components to enable a range selection. Insert two filter components for the same dimension and add to one the parameter LOWERBOUNDARY and to the other the parameter UPPERBOUNDARY. You can now filter for the lower and upper bounds of a range. 4. Optional step: Format the filter component. You can use the formatting options of Microsoft Excel to format cells of the filter component. 5. Select the filter icon to define a filter. All tables on the current sheet that contain this dimension, will be filtered according to the selected filter. On the Components tab in the design panel, you can define which tables should be affected if not all tables should be filtered accordingly. The filter is added to the analysis according to your configuration. Related Topics SAPGetDimensionInfo SAPSetFilterComponent
3.4 Working with formulas
In Advanced Analysis, edition for Microsoft Office, you can use the standard functions of Microsoft Excel to build formulas. The Add-in also contains an own set of functions that you can use to build formulas.
You can use this functions to include data and meta data of used data sources into your analysis. For example, you can insert information fields on data source properties, display the measure filter or list the variables of a data source. With the SAPGetData function, you can also define measure values for certain member combinations. A Microsoft Excel formula for Advanced Analysis consists of a function and references to the data source, measures and/or dimensions. You can use the text or the key of an object to use it as reference. You can also use a cell value like B10 as reference. The formula alias of a data source is displayed and can be changed in the data source properties on the Components tab in the design panel. For measures, dimensions and their members text references are better to read, but if you want to create a multi-language enabled analysis or there are duplicate texts in the meta data of your data source, you should reference these objects with their keys. Advanced Analysis functions The following functions are available in the Advanced Analysis category: SAPGetData SAPGetDimensionDynamicFilter SAPGetDimensionEffectiveFilter SAPGetDimensionInfo SAPGetDimensionStaticFilter SAPGetDisplayedMeasures SAPGetInfoLabel SAPGetMeasureFilter SAPGetMember SAPGetSourceInfo SAPGetVariable SAPGetWorkbookInfo SAPListOfEffectiveFilters SAPListOfVariables SAPSetFilterComponent

3.4.9 SAPGetMeasureFilter
The function returns a list of all filtered measures and their rules defined for a data source. This formula is made up of the following argument: Data Source. Enter the formula alias for the data source. You can set the alias when configuring the data source on the Components tab in the design panel. Example: Cell G10: =SAPGetMeasureFilter("DS_1") If you enter the formula in cell G10, all measures that have a filter definition and the corresponding rules are displayed in a list in cell G10. If you add or remove a filter to a measure, the list in cell G10 is updated accordingly.

3.4.10 SAPGetMember

The function returns the dimension member or attribute. This formula consists of 3 parameters and is made up of the following arguments: Data Source Enter the formula alias for the data source. You can set the alias when configuring the data source on the Components tab in the design panel. Dimension Member Enter the technical name of a dimension and assign a member key, for example "0DIVISION=R1". Member Display You can enter TEXT or KEY to define how the filtered members should be displayed in the workbook. Example: Cell G15: =SAPGetMember("DS_1";"0DIVISION=R1";"TEXT") You want to display the text for the member Retail. The key for Retail is R1. If you enter the formula in cell G15, the text of member R1 (Retail) is displayed in cell G15.

3.4.11 SAPGetSourceInfo

The function returns an info field value of a data source. The info field label can be inserted with the function SAPGetInfoLabel. The available property names correspond to the info field values that are available for data sources on the Information tab in the design panel. This formula consists of 2 parameters and is made up of the following arguments: Data Source Enter the formula alias for the data source. You can set the alias when configuring the data source on the Components tab in the design panel. Property Name You can enter the follwoing property names: DataSourceName LastDataUpdate LastRefreshedAt LastDataUpdateMP KeyDate QueryName QueryTechName QueryCreatedBy QueryCreatedAt QueryLastChangedBy QueryLastChangedAt InfoProviderTechName InfoProviderName System

Refresh Worbook on Opening Workbook Force Promp for Initial Refresh
Store Prompts with Workbook
Data Source Name Data Source Technical Name Data source Formula Alias System Alias Sheet Name

Component

Properties
Name Formula Alias Data Source Name Range
Displays the crosstab name. You can change it here. Displays the formula alias. You can change it here. Displays the data source name. Displays the cell range of the crosstab in the sheet. You can change the range to move the crosstab in the sheet. If you select this check box, the default formats are applied after each navigation step. If you select this check box, a symbol is displayed for parent members in a hierarchy (+/-). If you select this check box, the table is displayed with optimum cell width and height. If you select this check box, texts that are not displayed because they occur several times in a column or row, are repeated in each cell. In the BEx Query Designer, you can define if key figures should be displayed in multiple lines.

Apply Default Formats

Display Symbols for Parent Members Crosstab Optimum Cell Width/Height

Repeat Members

Wrap Headers
If you select this check box, these key figures/measures are displayed in Advanced Analysis like defined in the Query Designer. If you clear the check box, the measures are displayed in one line. Displays data source name. Displays the name of the filtered dimension. You can select which of the available data sources in the workbook should be filtered.
Data Source Name Dimension Filter Filter applies to the following data sources
Name Chart Cross Tab Name Sheet
Displays sheet and chart name. Displays the crosstab name. Displays the sheet name. You can change it here.
Related Topics To select workbook properties for prompting

4.3 Prompting

In the prompting dialog, you can set values for prompts. Prompts are defined as variables in BEx Query Designer. The variables are parameters of a BW query and are filled with values when you insert a query as a data source in a worksheet. They serve as placeholders for members, hierarchies, hierarchy nodes, formula elements and texts. After defining the variable values, the crosstab is displayed according to the selected values. To be editable in the prompting dialog, a variable must be defined as input-ready and set to Manual Input in Query Designer. A variable can be defined as mandatory or optional in Query Designer. If a query contains mandatory variables without default values, the prompting dialog appears automatically when you insert the query in a worksheet and requires the definition of mandatory variable values before the crosstab is added. If you cancel the prompting dialog, the query data is not included in the workbook. For queries with optional variables only, you can open the prompting dialog with the prompting icon in the menu and define variable values. You can also use this manual option to open the dialog to change existing values. At workbook level, you can select properties to define how the prompting dialog and defined values behave in workbooks. For example, you can define that variable values are saved in a workbook. If you open this workbook again, the data is displayed according to the defined values. You can then open the prompting dialog and change the values. If there are no input-ready variables in the query that you use as your data source, the prompting dialog is disabled. Note: Objects that are defined as input-ready variables in BEx Query Designer are called prompts in Advanced Analysis, edition for Microsoft Office. In the following documentation the Advanced Analysis term prompt is used for these variables. A query can also contain other variable types. All variables and values of these variables that a query contains, are displayed in the Variables area on the Information tab in the design panel.

4.5.1.2 To filter data by member within hierarchies
The data source you use, includes hierarchies. 1. Select a cell in the crosstab that belongs to the hierarchy you want to use for filtering. 2. Choose Filter > Filter by member. The "Filter by Member" dialog box for hierarchies appears. Note: You can also open this dialog box using the context menu on the crosstab or the design panel. 3. If you want to search for members, clear the Select All check box in the members list and enter a search string in the entry field. In the drop-down list of the search button, you can select if you want to search for a key or a text. Members that match the search string are displayed in the members list and can be selected.
4. With the Display list, you can select how the members are displayed. The following options are available: Key, Text, Text and key, Key and text and Show Attributes. In the Show Attributes list, you can find the attributes that are available for the members in your hierarchy. For example, a product hierarchy could have size and colour as attributes. You can select and add these attributes to the member list in the filter dialog. This additional information may help you to make the selections for filtering. 5. Select in the list box which members should be displayed in the list for selection. Select Hierarchy in the list if you want the members to be listed with the hierarchy. Select one of the available hierarchy levels if you want all members of this level to be listed. Select Leaves if you want all members of all levels to be listed in a flat view. 6. Press the Show Selected button if only the selected members should be displayed. The button name changes to Show All. Press this if you want all members to be displayed. 7. Select the members that you want to use for filtering in the members list. In the members list, all members are selected in the default setting. To deselect a member, clear the corresponding checkbox. You can also deselect all members b clearing the Select All checkbox and selecting individual members from the list. 8. Press OK to apply the filter to your data. The data in the worksheet is filtered according to your selection. The filter is saved with the workbook and is available to other users or in other sessions. You can also open and edit existing filters again.

The data in the worksheet is filtered according to your selection. The filter is saved with the workbook and is available to other users or in other sessions. You can also open and edit existing filters again.
4.5.2.2 Operators used for filtering measures
When defining filters by measure, you can create rules to get a list of data for a defined threshould value and rules to get ranked list of data. to define threshould values, you can use the following operators: Between / Outside For these operators, you define a range of values that should be included or excluded in the list. Greater Than / Less Than For these operators, you define a specific value to display members that are greater or less than this value. Greater Than or Equal to / Less Than or Equal to For these operators, you define a specific value to display members that are greater or equal to or less or equal to this value. Equal to For this operator, you define a specific value to display members that are equal to this value. To define a ranked list of values, you can use the following operators: Top N / Bottom N For these operators, you must enter a whole, positive number as the value. The ranked list is arranged according to the defined number. For example, if you want a list of the three customers with the strongest sales volume and the five customers with with the weakest sales volume, you create a Top 3 and a Bottom 5 rule in the filter definition. Top% / Bottom % For these operators, you must enter a number between 0 and 100. The ranked list is arranged according to the defined percentage. For example, if you want a list of the strongest products in revenue until 25% of the total revenue is attained, you create a Top 25% rule for this measure with regard to products. Top Sum / Bottom Sum For these operators, you can also enter a floating point number (15.7 for example). The ranked list is arranged according to the defined total value.
For example, you want a list of products with the highest sales volume, whose combined sales volume totals EUR 20,000. All sales volumes are first sorted in descending order. The totals are calculated until the threshold value of 20,000 is exceeded. If the last value that need to be included to achieve EUR 20,000, causes the total to exceed 20,000, it is also included in the list. All products with a lower sales volume than this product are no longer displayed. Products that exceed the EUR 20,000 threshold remain in the list. Note: Do not use these operators for ranked lists for filtering hiearchies.
4.5.2.3 To remove a filter by measure
1. Select a cell in the crosstab. There are four options for defining a filter by measure. To delete an existing filter, you have to select a cell that belongs to the option you used for defining the filter. 2. Choose Filter > Filter by measure > [Selected Filter Option] > Reset. Note: You can also use the context menu on the crosstab. The data in the crosstab is displayed without the removed filter.

4.5.3 To filter out zeros in rows and columns
1. Select a cell in the crosstab. 2. Choose Filter and one of the following options: Suppress Zeros in Rows All rows that only contain zeros are removed. Suppress Zeros in Columns All columns that only contain zeros are removed. The zeros are suppressed in rows and/or columns. When zero suppression is active, a check mark is displayed beside the menu item. To restore the hidden rows and columns, choose Filter > Suppress Zeros in Rows or Filter > Suppress Zeros in Columns again.
4.6 Defining Conditional Formatting
You can use conditional formatting to highlight important values or unexpected results in your data. With conditional formatting, you define rules to select different or critical values in a crosstab. Results that fall outside a set of predetermined threshold values are highlighted in color or designated with symbols. This enables you to identify immediately any results that deviate from the expected results. For example, you directly see answers to questions, such as which products have over 10% revenue increase this year or which regions have sales volume higher than a defined amount. You can add one or more rules to a conditional format and prioritize the application of the rules in your crosstab. You can also define more than one conditional format in a worksheet and decide for each of them when it should be active by toggling it on and off. Existing conditional formats can be edited or deleted. Note: The conditional formatting described in this guide is part of the Advanced Analysis Add-In. There is also a conditional formatting available in Microsoft Excel. Related Topics To define a Conditional Format To edit Conditional Formats
4.6.1 To define a Conditional Format
1. Choose Conditional Formatting > New. The "New Conditional Formatting" dialog box appears. 2. In the Name field, enter a name for the new conditional format. 3. In the Based on list, select the measure you want to apply the conditional format to. 4. In the Format list, select the style you want to use for highlighting values. The following styles are available: Background: the cells background is colored. Values: the text of the cells is colored. Status Sympol: a symbol is displayed in the cells. Trend Ascending: a colored arrow (green to red) is displayed in the cells. Trend Descending: a colored arrow (red to green) is displayed in the cells. Trend Grey: a grey arrow is displayed in the cells. Every style consists of nine members. The numbers 1 to 9 represent the priority of the rule.

5. Define one or more rules on the Definition tab. a. Select the priority. In the first list, select one of the nine priorities of the style selected above. If you define more than one rule in a conditional format, and the rules overlap for values in your crosstab, the priority determines which rule is applied to these cells. You should therefore use a priority only for one rule in a conditional format. Priority one is the highest priority and priority 9 the lowest. b. Select an operator. You can choose one of the following operators: Between, Outside, Greater Than, Greater Than Or Equal To, Less Than, Less Than Or Equal To and Equal To. c. Enter a threshould value or value range. d. Press Add. The rule is added to the "Rules" area. 6. Optional step: Define the selection for the conditional format. On the Selection tab, you can define for each dimension if the conditional formatting should be applied to "All Members and Totals" or only to the "Members" or "Totals". The default value is All Members and Totals. 7. Optional step: Define the visualization on the Display tab. In the "Apply conditional formatting to:" area, you can define which parts of the crosstab are affected by conditional formatting: Data Cells, Row Headers and/or Column Headers. In the "Apply Visualization to Another Measure:" area, you can specify that the conditional format defined for one measure (sales volume for example), is visualized in the data of another measure (sales order items for example). To use this function, select the Applied to check box. 8. Press OK to apply your rules to the crosstab. You have created one or more conditional formats. They are saved with the workbook and are available to other users or in other sessions.
4.6.2 To edit Conditional Formats
Once you have defined conditional formats, you can open and edit them, delete them or activate and deactivate them: 1. ChooseConditional Formatting > [Name of Conditional Formatting]. 2. Select one of the following options: Select Edit if you want to change the current definitions of a conditional format. You can add new rules, or delete existing ones, for example. Select Delete if you want to delete a conditional format. Select or deselect Active if you want to toggle the formatting on and off.

4.7 To save a workbook

You can save a workbook to the SAP BusinessObjects Enterprise Server or as a local file. The workbook is saved with the current navigation state and selected settings. 1. Choose the Microsoft Office Button and Save Workbook. Note: If you want to save a workbook locally, choose the Microsoft Office Button and Save. 2. Enter your User, Password and the WEB Service URL to BusinessObjects Enterprise and press OK. 3. Select a folder in the BOE folder structure where you want to save the workbook. 4. Enter a name for the workbook. The current workbook name is entered as default. You can change this name. 5. Press Save. The workbook is saved to the SAP BusinessObjects Enterprise Server. The workbook is saved. You and other user with access to the server can open and analyze it.

Developer resources https://www.sdn.sap.com/irj/sdn/businessobjects-sdklibrary https://www.sdn.sap.com/irj/boc/businessobjects-articles These articles were formerly known as technical papers.
SAP BusinessObjects articles on the SAP Community Network
https://service.sap.com/notes Notes These notes were formerly known as Knowledge Base articles. Forums on the SAP Community Network https://www.sdn.sap.com/irj/scn/forums http://www.sap.com/services/education Training From traditional classroom learning to targeted e-learning seminars, we can offer a training package to suit your learning needs and preferred learning style. http://service.sap.com/bosap-support Online customer support The SAP Support Portal contains information about Customer Support programs and services. It also has links to a wide range of technical information and downloads. Customers with a maintenance agreement have an authorized user ID to access this site. To obtain an ID, contact your customer support representative. http://www.sap.com/services/bysubject/businessobjectsconsulting Consulting Consultants can accompany you from the initial analysis stage to the delivery of your deployment project. Expertise is available in topics such as relational and multidimensional databases, connectivity, database design tools, and customized embedding technology.

2.3 Analyze some data

Once you have created a workspace and connected a data source, your next step is to define an analysis and begin working with your data in the analysis window. An analysis is a specific subset of data from the OLAP cube. You create an analysis by adding OLAP data to the crosstab, and then manipulating the data; for example, by sorting and filtering. Add data to the crosstab
The following tasks introduce some of the analysis features available in Advanced Analysis. You can choose to perform or omit each task, perform the tasks in any order, and experiment with the different options available in each task: Remove unwanted members Sort the data Filter the data Apply conditional formatting (exception highlighting) Add a calculation
Related Topics Analyses Terminology essentials
Create an Advanced Analysis workspace Add charts and more crosstabs Save a workspace Open another Advanced Analysis workspace
2.3.1 Add data to the crosstab
The first step in defining an analysis is to add data to the crosstab. Because data is represented by dimensions and hierarchies, you populate a crosstab with data by adding hierarchies. 1. Click a hierarchy on the "Data" panel to select it. If necessary, expand a dimension to reveal its hierarchies. 2. Click the Add to Columns button to add the selected hierarchy to the columns on the crosstab. Alternatively, you can drag the hierarchy to the "Columns" area in the "Layout" panel, or to the "Drop Columns" area on the crosstab. 3. Repeat those steps to add more hierarchies to the crosstab. In addition to the columns, you can add hierarchies to the rows or to the background filter, using the Add to Rows and Add to Background Filter buttons. Note: The crosstab displays numbers only after you add measures. 4. Explore the members within the hierarchies by expanding the hierarchies.
2.3.2 Remove unwanted members
You can remove or filter members so that you can focus on the data that most interests you. 1. On the crosstab, right-click a member and select Remove to remove that member from your analysis. If you later want to add the member back to the crosstab, you can add it by using the "Filter" panel. 2. On the "Layout" panel, double-click one of the hierarchies. The "Filter" panel opens. The panel displays the contents of the hierarchy you chose, with all members initially selected. 3. Select only the members that you want to include in your analysis. 4. Click OK to update the crosstab. Related Topics Filtering Data

Alternatively, you can drag a chart from the "Insert" tab into the analysis window, to the position you select. Note: If you drag a chart family button to the analysis window, the default type from that chart family is added to the analysis window. You can change the chart type later if you wish. To enlarge the view of a component when there are multiple components on a sheet, you can maximize and restore the component using the Maximize/Restore button in the component's title bar. Related Topics Resizing and moving components
2.4.1.2 To add a crosstab to a sheet as a sub-analysis
This procedure describes how to add a crosstab as a sub-analysis. To add a crosstab as a new analysis, see Adding analyses. 1. In the analysis window, select the component that you want the crosstab to be linked to. 2. On the "Insert" tab, click the arrow beside the Crosstab button and select Insert a sub-analysis. The crosstab is added as a sub-analysis, linked to the component that you selected. The added crosstab is placed below or to the right of existing components on the sheet. Alternatively, you can drag a crosstab from the "Insert" tab into the analysis window, to the position you select. To enlarge the view of a component when there are multiple components on a sheet, you can maximize and restore the component using the Maximize/Restore button in the component's title bar.
2.4.1.3 To copy an existing crosstab or chart
1. In the analysis window, select the crosstab or chart that you want to copy by clicking anywhere within the component. 2. On the toolbar, click the Copy button. 3. If you want to add the copied component to the same sheet, click the Paste button. Or, if you want to add the copied component to a different sheet, first select the other sheet tab, and then click the Paste button. The copy is added to the sheet, below or to the right of existing components.
2.4.1.4 To delete a component from the sheet
Click the Delete button on the right side of the component's title bar.

2.5 Save a workspace

Advanced Analysis saves its workspaces to the SAP BusinessObjects Enterprise repository. From the repository, you can open your workspaces via the web, from any machine that has an internet connection. You can choose to save your changes to the existing workspace, or to save the modified workspace as a new workspace in the repository. Note: To save a workspace to the SAP BusinessObjects Enterprise repository, you must have sufficient rights. See your system administrator if you are not sure whether you have such rights. If you leave your workspace idle, the workspace is automatically saved to your Favorites folder as an autosave file, before your session terminates. Typically, a session is terminated after approximately 20 minutes of inactivity, unless your system administrator has set the timeout duration to a different value. Note: Because the autosave workspace is overwritten every time a workspace is automatically saved, you should manually save workspaces that you want to keep, with unique filenames. In addition to saving workspaces, you can also export data from workspaces to Microsoft Excel or to a comma-separated-values file. Related Topics Terminology essentials Create an Advanced Analysis workspace Analyze some data Add charts and more crosstabs Open another Advanced Analysis workspace Exporting Data

3.7.1 To toggle automatic layout updating
1. Select a crosstab or chart component. 2. On the toolbar, click Auto Update. All crosstab and chart components associated with the analysis are temporarily disabled.

Crosstabs

4.1 Overview of Advanced Analysis crosstabs
The crosstab component is a grid, similar to a spreadsheet, that displays data from a cube. You will usually perform most of your data-analysis tasks using crosstabs. For example, you can sort data in a crosstab, add calculations, add conditional formatting, and filter out data that is irrelevant to your analysis. The crosstab comprises three axes, although only two can be displayed on the screen. Row axis: the vertical axis that displays rows of data. Column axis: the horizontal axis that displays columns of data. Background filter axis, or slice axis: the axis that is perpendicular to the two-dimensional crosstab display.
Hierarchies that are placed on the row axis are called row hierarchies. Similarly, you also use column hierarchies and background filter hierarchies in your analyses. With row and column hierarchies, you can see several members simultaneously on the crosstab. With the background filter hierarchy however, you fix a slice of the data in the crosstab at any one time. The member you select in the background filter hierarchy is called the background filter member or slice member. For example, if Week is a background filter hierarchy, you can select any week as the background filter member. With some OLAP providers, for example SAP BW and Microsoft Analysis Services, you can select multiple members of a hierarchy as a background filter. However, you cannot select multiple members of a measures dimension as a background filter. For all hierarchies in the cube that are not used on the row, column, or background filter axes, the default member is used to generate data in the crosstab. Therefore, you can generate a valid analysis by placing hierarchies on only the row and column axes because the default member is used for all other hierarchies. If you place a hierarchy in the background filter and leave the default member unchanged, the data in the crosstab is also unchanged. You can also display more than one dimension or hierarchy on a row or column axis; for example, you can place both a Measures dimension and a Years hierarchy on the same axis to show data from the Measures dimension over several years. This is called nesting hierarchies. Related Topics Adding a crosstab Adding data to a crosstab

Analyses Understanding OLAP Custom aggregates and multiple members in a background filter Nesting hierarchies

4.2 Adding a crosstab

Visual components, such as a crosstab or any of the chart types, are added to the analysis window by using the toolbar. You can add a crosstab by clicking the crosstab button, or by dragging the crosstab button to the analysis window. Related Topics Adding data to a crosstab Analyses
4.2.1 To add a crosstab to the analysis window
Click the Crosstab button on the toolbar. The component is added to the sheet, below or to the right of existing components. You can later reposition or resize the component if you wish. Alternatively, you can place a crosstab at a specific location in the analysis window by dragging the crosstab button from the toolbar. Note: Before your crosstab will show any data, you must add a data source to the sheet, and add data to the crosstab.
Related Topics Connecting to OLAP Data Sources Adding data to a crosstab Resizing and moving components
4.3 Adding data to a crosstab
When you create a new Advanced Analysis workspace, it contains an empty crosstab. To add some data, you add dimensions and hierarchies from the metadata explorer to the crosstab. Once you've placed at least one measure on the crosstab, the crosstab is populated with data. You can then proceed to perform your analysis. Related Topics Add data to the crosstab Adding a crosstab Analyses

Charts

5.1 Overview of Advanced Analysis charts
You can add charts to your workspaces to present your data graphically. Charts can often emphasize irregularities or trends in your data, and help you focus your business analysis on those areas. Several chart types are available to help you visualize data: Clustered bar and column charts Stacked bar and column charts 100% stacked bar and column charts 3D column charts Multi line charts Multi pie charts Scatter charts Box plot charts Bubble charts Radar charts
Chart and crosstab components are linked to analyses. A common analysis scenario is to first create a crosstab component, and then add a chart component as a sub-analysis, linked to the main analysis. Both components display the same data, and both components update simultaneously whenever you make changes to either component. This interaction allows you to repeatedly define and refine your analyses, and see the graphical results of your changes in real time. You can also unlink, or disconnect, a chart sub-analysis from its current analysis, converting it to a new, separate analysis. Charts can be easily customized. You can change the chart type, or change the appearance of the chart to increase clarity. You can also expand data in the chart to examine the data in more detail. Swapping the chart axes can sometimes improve the presentation as well. This section describes each of the chart types, how to add a chart to a sheet, how to add data to a chart, and how to customize a chart's appearance. Related Topics Analyses Sub-analyses

6.1 To create a sub-analysis
1. Select an analysis in your workspace by clicking anywhere in a crosstab or chart. 2. On the toolbar, select the Insert tab. 3. To insert a crosstab sub-analysis, click the arrow beside the Insert Crosstab button, and select Insert a sub-analysis. To insert a chart sub-analysis, click one of the chart buttons. The sub-analysis is created, and is linked to the selected analysis.
6.2 To pause sub-analysis updating
1. Click a crosstab or chart that represents an analysis, or select an analysis in the "Outline" panel.
2. On the toolbar, select Display, and then click Update Sub-Analysis. Linked sub-analyses no longer update automatically. Click Update Sub-Analysis again to resume automatic updating.
6.3 Unlinking a sub-analysis
When you add a crosstab or chart sub-analysis to a sheet that contains an analysis, the new component is linked to the main analysis. Changes that you make to the main analysis (usually a crosstab) are reflected in all sub-analyses. During your analysis though, you may encounter data in the sub-analysis that warrants further exploration. You can pause the sub-analysis, so that it is temporarily frozen in its current state while you continue working with the main analysis, or you can sever the link with the main analysis, converting the sub-analysis to a separate analysis. Related Topics To pause sub-analysis updating
6.3.1 To unlink a sub-analysis
1. Select a sub-analysis component in the analysis window. 2. On the toolbar, select Display, and then click Unlink Sub-Analysis.

Filtering Data

In Advanced Analysis, you will often want to narrow the scope of your analysis to focus on important data, by including in your crosstabs and charts only those members that are relevant to your analysis. This action is called filtering. You can filter members by manually selecting and deselecting them from a list. This is called filtering by member. Or, you can filter members by specifying filter conditions; for example by specifying a condition such as Greater than 1000. This is called filtering by measure.

7.1 Filtering by measure

If you want to dynamically select members for your analysis, based on rules you define, you can filter a hierarchy by measure. For example, if you are analyzing worldwide bicycle sales, and you want your analysis to include only those Country members whose bicycle sales are above a certain threshold, then you could define a filter on the Country hierarchy to include members whose bicycle sales exceed 100,000. Unlike filtering by member, filtering by measure is dynamic; that is, whenever you change the view of your data, the filter is reapplied. For example, if you add a Top 5 filter on a hierarchy, five members are shown. If you then add some members that you had previously removed from the analysis, some of those added members could displace some of the five previously shown members. You define a filter by creating one or more filter conditions, or rules. For example, if you wanted to increase your advertising in large countries where bicycle sales are not as high as expected, you could define a filter that comprises these rules: Bottom 5 Greater than 100,000

7.2.1 To remove or add individual members
If you want to remove or add a small number of members, not according to any pattern or parameters, you can accomplish that using the "Filter" panel. 1. In the "Layout" panel, double-click the hierarchy whose members you want to remove or add. Alternatively, you can right-click the hierarchy, and select Filter > By member. The "Filter" panel opens, in Hierarchy view. 2. Select or clear the member check boxes as desired. Click individual members to select and deselect them. Hold down the Shift key as you click members, to select or deselect ranges of members. 3. Click OK to apply your changes to the crosstab or chart. Note: If you deselect all members, the OK button is disabled because you must select at least one member for each hierarchy on the crosstab. Related Topics Showing only selected members
To change the display of member keys and text Displaying parent names Hierarchy view and leaf members view
7.2.2 Searching for members
Because hierarchies can contain thousands of members, you may want to search for members instead of trying to locate them in a long hierarchical list. To search for members, you initiate a filter by member, and enter a search string. Use the Return to Member List button to clear the search results and return to the full member list. Any members that you selected from the search results remain selected. Advanced Analysis uses search techniques similar to popular internet search engines:
Search String Search Result
Selects all members that contain the word book, such as book, book store, and booklet. Selects only members that contain the exact text inside the quotation marks.
"glass bowls" In this example, the search would find glass bowls but not glass soup bowls. Multiple terms include an implicit AND, so in this example, the search would select all members that contain both the words glass and bowls: glass bowls glass soup bowls Selects members which contain either the word glass or the word bowls. The OR must be capitalized. In this example, the search would find members with these names: glass bowls glass soup bowls soup bowls glass Note: If OR is one of the words you want to search for, you must enclose the OR in quotation marks: "OR" OR CA (to perform a search for the states Oregon and California).

glass bowls

glass OR bowls
Note: Search terms are not case-sensitive. Searching for book is the same as searching for Book or BOOK or boOk. Using wildcards in your search You can use the asterisk wildcard character in your search string. For example, if you search for book, you could get this search result: book book store library book booklet textbook textbooks
Or, if you search for book*, you could get this search result: book book store booklet textbooks library book textbook

Other calculations

SIN COS
SIN("operand1") COS("operand1")
Returns the sine of an angle, represented by operand1, specified in radians. Returns the cosine of an angle, represented by operand1, specified in radians.
TAN ASIN ACOS ATAN SINH COSH TANH
TAN("operand1") ASIN("operand1") ACOS("operand1") ATAN("operand1") SINH("operand1") COSH("operand1") TANH("operand1")
Returns the tangent of an angle, represented by operand1, specified in radians. Returns the arcsine of operand1 (between -pi/2 and pi/2), when the value of operand1 is between -1, and 1. Returns the arccosine of operand1 (between 0 and pi), when the value of operand1 is between -1, and 1. Returns the arctangent of operand1 (between -pi/2 and pi/2). Returns the hyperbolic sine of an angle, represented by operand1, specified in radians. Returns the hyperbolic cosine of an angle, represented by operand1, specified in radians. Returns the hyperbolic tangent of an angle, represented by operand1, specified in radians. Returns 1 if both <expression1> and <expression2> do not equal 0. Otherwise the result is 0. Only the numerical values of <expression1> and <expression2> are considered, without taking units into account. Returns 1 if either <expression1> or <expression2> does not equal 0. Otherwise the result is 0. Only the numerical values of <expression1> and <expression2> are considered, without taking units into account. Returns 1 if either <expression1> or <expression2> (but not both) does not equal 0. Otherwise the result is 0. Only the numerical values of <expression1> and <expression2> are considered, without taking units into account. Returns 1 if <expression> is 0, otherwise the result is 0. Only the numerical value of <expression> is considered, without taking units into account.
<expression1> AND <expression2>
<expression1> OR <expression2>
<expression1> XOR <expression2>

NOT(<expression>)

Totals, Parents, and Aggregations
You can toggle the display of grand totals and subtotals in rows and columns of the crosstab. Subtotals are aggregations of member values within an inner hierarchy, while grand totals are aggregations of member values of the outermost hierarchy. The default aggregation type is Sum, but you can change the aggregation type; for example, to Minimum or Average. Subtotals and grand totals are added as additional rows or columns in the crosstab, named Result and Overall Result, respectively. Parent members also display aggregated values. For example, the value of the parent member Europe could be the sum of the values of its child members France, Germany, and Italy. Parent members can also display aggregation types other than sums, however. Parent members are normally displayed above or to the left of child members, and totals below or to the right of child members. Thus, the parent member Europe would be shown above child members France, Germany, and Italy. You can change the positions of totals and parents though. For example, if you are analyzing sales figures for European countries, and if the Europe member represents the sum of the country members France, Germany, and Italy, you may want the Europe member to be displayed below the country members. You can also choose to show parents and totals differently on the columns and rows.

12.1.1 To expand a parent member in a crosstab
Click the plus sign next to the member name to display its child members.
12.1.2 To collapse a parent member in a crosstab
Click the minus sign next to the member name.
12.1.3 To expand a parent member in a chart
1. Right-click a member in the chart. Note: Expanding and collapsing members in a chart is possible only if the chart represents an analysis, and not a sub-analysis. Depending on the type of chart, the member could be represented by a marker such as a pie slice or column chart riser, or by a name in the chart legend, or by a caption. 2. Select Expand to display the child members.
12.1.4 To collapse a parent member in a chart
1. Right-click a member in the chart. Note: Expanding and collapsing members in a chart is possible only if the chart represents an analysis, and not a sub-analysis. Depending on the type of chart, the member could be represented by a marker such as a pie slice or column chart riser, or by a name in the chart legend, or by a caption. 2. Select Collapse to display the parent member.
12.2 Swapping hierarchies
You can swap hierarchies with others to reorient the data in the crosstab or chart. You can swap a row or column hierarchy with one of the background filter hierarchies, or with another row or column hierarchy. You can also swap all rows with all columns, both in an analysis and in a sub-analysis.
12.2.1 To swap two hierarchies
1. Drag a hierarchy toward the hierarchy that you want to swap it with. 2. When the existing hierarchy is highlighted, release the mouse button to swap the two hierarchies.
12.2.2 To swap all rows with all columns
1. Select a crosstab that represents either an analysis or a sub-analysis. 2. On the toolbar, select Display, and then click Swap Axes.
12.2.3 Swapping hierarchies containing sorts and filters
When you swap hierarchies, or add a new hierarchy to a row or column axis, all existing sorts and filters are removed from the analysis. However, if you swap the positions of the row and column hierarchies using the Swap Axes button, the sorts and filters are preserved. Related Topics Sorting Filtering by measure
12.3 Removing hierarchies
You can remove hierarchies from the crosstab or chart to simplify your analysis.
12.3.1 To remove a hierarchy from a chart or crosstab
1. Select the crosstab or chart component. 2. Drag the hierarchy out of the "Layout" panel. Alternatively, you can right-click the hierarchy, and select Remove.

12.4 Nesting hierarchies

Displaying two or more hierarchies in a particular row or column in the crosstab is called nesting. When you nest hierarchies, the one nearest the cells is called the inner hierarchy, and any others are called the outer hierarchies.
12.4.1 To nest hierarchies

17.2.1 To export data to a.csv file
On the toolbar, click the arrow beside the Export button, and then click CSV. Note: The Export button is disabled until the current sheet contains a valid analysis.
2. In the dialog box, select the crosstab or chart component whose data you want to export. You can also select the component in the analysis window or on the "Outline" panel before you click the Export button. 3. If your analysis contains nested hierarchies, and you want to repeat the outer hierarchy member header for each inner hierarchy member, select the Repeat outer header members option. 4. Click OK to export the data. If you have a.csv file viewer such as Microsoft Excel installed on your machine, you can save the file to disk, or open the file immediately. If you do not have a.csv file viewer installed, save the file to disk with a.csv extension. You can then install Microsoft Excel or another application to open the saved file.
Connecting to OLAP Data Sources
18.1 OLAP data source objects
Before you can begin working with data in Advanced Analysis, you must add a data source to the workspace. A data source is a repository object, created by your system administrator, that contains all the information that is required for Advanced Analysis to connect to an OLAP server. The administrator creates data source objects for as many different OLAP data providers as you and your fellow analysts require. Analysts then have all of these data sources available to add to their workspaces. These types of data source objects can be defined by the administrator:
Icon Data source type Description

Cube Query System

The data source object points directly to a single OLAP cube on the OLAP server. The data source object points directly to a single OLAP query on the OLAP server. The data source object points to an OLAP server, which can contain many cubes and queries.
Related Topics Adding data sources Changing data sources Removing a data source Disabled data source connections SAP BW Data Sources

18.2 Adding data sources

19.1 To create a jumplink to a report
1. Right-click the row header, column header, or cell that represents the parameter or parameters that you want to pass to the report, and select Jumplink > New. If you right-click a row or column header, that parameter is made available to pass to the report. If you right-click a crosstab cell, then the cell value, the row and column headers, and any background filter members are made available to pass to the report. 2. Click Change to select a report from the SAP BusinessObjects Enterprise repository. 3. Select the parameter or parameters that you would like to pass to the report, and click OK. The jumplink is created, and the report is opened in your browser. The jumplink is saved with the workspace, so that other users of the workspace can follow the jumplink later.
19.2 To view a linked report
1. Right-click a row header, column header, or cell, and select Jumplink. 2. Select the linked report name from the list of options. The linked report is opened in your browser, and the parameters corresponding to the member header or cell that you right-clicked are passed from Advanced Analysis to the report.
19.3 To delete a jumplink to a report
1. Right-click a cell, row header, or column header in your crosstab. 2. Select Jumplink > Clear. Because jumplinks are associated with analyses, not with members or crosstab cells, you can right-click any cell or member in the crosstab to access a jumplink. If any jumplink is associated with the current analysis, it appears in the list when you right-click.
Using Analyses in Other SAP BusinessObjects Applications
After you perform an analysis, you may want to use other SAP BusinessObjects applications to communicate your findings and share the analysis. For example, you can use SAP Crystal Reports to create highly formatted reports for broad distribution. Or you can use the edition of SAP BusinessObjects Advanced Analysis for use with Microsoft Office to share your analysis with Finance department users. To use an analysis in other applications, you export it as an analysis view. An analysis view is a saved navigation state of an analysis, that includes applied filters, hierarchies, and available metadata. Analysis views can be shared among applications such as SAP BusinessObjects Advanced Analysis (both the Web edition and the edition for Microsoft Office), SAP Crystal Reports, and SAP BusinessObjects Interactive Analysis. Both editions of SAP BusinessObjects Advanced Analysis can import and export analysis views, but other applications can only import analysis views. Like workspaces, analysis views are saved to the SAP BusinessObjects Enterprise repository. While a workspace can encompass several analyses, an analysis view encompasses only one analysis.

25.5 Toolbar reference

You can perform most of your data-analysis tasks with the toolbar. Note: Some of the toolbar buttons may be disabled, depending on the rights that have been assigned to users within the Central Management Console, and depending on which object or component is selected in the analysis window. For more information on rights in the Central Management Console, see your system administrator or the SAP BusinessObjects Advanced Analysis, Web edition Administrator's Guide. For details on using the toolbar, see the following topics: Related Topics Workspace reference Analysis window reference Task panel reference Crosstab component reference Charts reference

25.5.1 Toolbar overview

The toolbar contains buttons for the most commonly used functions, many grouped into tabs. Several buttons have more than one function associated with them. For example, the Calculation button is used to perform several types of calculations. Some of these multi-function buttons have a default action associated with them. For example, clicking the arrow beside the Sort button displays the sort operations that can be applied to the selected member, but clicking the Sort button itself applies the default Ascending sort.
A chart button can be clicked to add a chart of that type to the default position in the analysis window, or the button can be dragged to add the chart at a specific location in the analysis window. Note: Many of the toolbar functions are also duplicated in context-sensitive right-click menus. For example, if you right-click a hierarchy or a member header, a menu that contains relevant options appears.
25.5.2 Application buttons
25.5.2.1 New Workspace button
Use this button to create a new Advanced Analysis workspace. Related Topics Create an Advanced Analysis workspace

25.5.2.2 Open button

Use this button to open an existing workspace from the SAP BusinessObjects repository. Click the Open button to execute the default Open Workspace function, or click the arrow beside the Open button to display options for opening workspaces or analysis views. Related Topics Open another Advanced Analysis workspace

25.5.2.3 Save button

Use this button to save your workspace to the SAP BusinessObjects repository. Click the Save button to execute the default Save function, or click the arrow beside the Save button to display options for saving your file. These save options are available:

Option Function

Saves the current workspace. Save If you have created a new workspace and have not yet saved it, choosing the Save function executes instead the Save As function. Saves the current workspace as a new repository object. The workspace can be newly created or a modification of an existing workspace. Save As The Save As function allows you to choose the location and name of your new workspace.
Related Topics Save a workspace

Manually Hide Chart Labels For pie charts, this option allows you to suppress labels for small pie slices. When this option is set to Yes, the "Hide Labels Less Than" property is enabled. Hide Labels Less Than For pie charts, this option sets the level below which the pie slice labels are suppressed. This option is enabled only if the "Manually Hide Chart Labels" property is set to Yes. Related Topics Properties panel Charts reference Chart range slider Chart graphic Chart types

More Information

Information Resource

Location

SAP BusinessObjects product information
http://www.sap.com Navigate to http://help.sap.com/businessobjects and on the "SAP BusinessObjects Overview" side panel click All Products. You can access the most up-to-date documentation covering all SAP BusinessObjects products and their deployment at the SAP Help Portal. You can download PDF versions or installable HTML libraries. Certain guides are stored on the SAP Service Marketplace and are not available from the SAP Help Portal. These guides are listed on the Help Portal accompanied by a link to the SAP Service Marketplace. Customers with a maintenance agreement have an authorized user ID to access this site. To obtain an ID, contact your customer support representative. http://service.sap.com/bosap-support > Documentation Installation guides: https://service.sap.com/bosap-instguides Release notes: http://service.sap.com/releasenotes

SAP Help Portal

SAP Service Marketplace
The SAP Service Marketplace stores certain installation guides, upgrade and migration guides, deployment guides, release notes and Supported Platforms documents. Customers with a maintenance agreement have an authorized user ID to access this site. Contact your customer support representative to obtain an ID. If you are redirected to the SAP Service Marketplace from the SAP Help Portal, use the menu in the navigation pane on the left to locate the category containing the documentation you want to access. https://cw.sdn.sap.com/cw/community/docupedia

Docupedia

Docupedia provides additional documentation resources, a collaborative authoring environment, and an interactive feedback channel. https://boc.sdn.sap.com/
Developer resources https://www.sdn.sap.com/irj/sdn/businessobjects-sdklibrary
SAP BusinessObjects articles on the SAP Community Network
https://www.sdn.sap.com/irj/boc/businessobjects-articles These articles were formerly known as technical papers. https://service.sap.com/notes
Notes These notes were formerly known as Knowledge Base articles. Forums on the SAP Community Network https://www.sdn.sap.com/irj/scn/forums http://www.sap.com/services/education Training From traditional classroom learning to targeted e-learning seminars, we can offer a training package to suit your learning needs and preferred learning style. http://service.sap.com/bosap-support Online customer support The SAP Support Portal contains information about Customer Support programs and services. It also has links to a wide range of technical information and downloads. Customers with a maintenance agreement have an authorized user ID to access this site. To obtain an ID, contact your customer support representative. http://www.sap.com/services/bysubject/businessobjectsconsulting Consulting Consultants can accompany you from the initial analysis stage to the delivery of your deployment project. Expertise is available in topics such as relational and multidimensional databases, connectivity, database design tools, and customized embedding technology.
100% stacked bar and column charts 48, 169 3D column charts 48, 169
background filter 39, 73, 172, 177 changing the member, or slice 103 definition 13, 103 multiple members 152 bar charts 47, 48, 169 between (filter) 62 Between operator 81 BI launch pad 9, 18 blank cells 171 bottom (filter) 62 box plot charts 50, 169 break hierarchies in sorts 166 bubble charts 49, 169 properties 57 Bubble Size Measure property 182 BusinessObjects Enterprise. See SAP BusinessObjects Enterprise 9 buttons. See toolbar 149
accessibility 143 Add to Background Filter button 155 Add to Columns button 155 Add to Rows button 155 adding a chart 44, 169 a chart or crosstab 24 a crosstab 40, 168 a data source 126 analyses 159 data 31 data to charts 45 data to crosstabs 41 adding or removing members 66 aggregation-level hinting 174 aggregations 95, 171 alphanumeric sorting 78 analyses 24, 43, 45 adding 35, 159 complex 35 create sub-analysis 59 defining 19, 31 defining using a chart 45 deleting 36 explained 31 modifying 33 using with other applications 133 Analysis Name property 176, 182 analysis views 133 analysis window 149, 150 analysis window, definition 13 analysis, definition 13 analyzing data 19 ascending sort 77, 166 authentication 18 Auto Update button 165 automatic updating 36, 59 automatically removed sorts and filters 65, 79 autosave 27, 28 average 95 axes 31, 39 axis, definition 13