orkungedik/SAP-basis-dataset huggingface dataset:
## 3.4.3  To create cell styles and style sets
## Context
Based on available cell styles, you can define a new style set. You can also define new cell styles and use them in a style set.
In Analysis, you can create your own cell styles according to your needs using the Microsoft Excel style functionality. After the creation, these styles are available in the Custom section of the styles list. Y ou can then save these new defined styles in a style set. You can also use the user-defined cell styles for editing crosstabs with Table Design.
## Procedure
1. On the Home tab, in the Styles group, choose Cell Styles . The available cell styles are listed.
2. Modify the existing cell styles or create new cell styles according to your needs with the Microsoft Excel style functionality.
3. On the Analysis Design tab, in the Format group, choose Styles Save Style Set... .
If there are user-defined cell styles available, the Add to Style Set dialog appears.
In the list, you can select the cell styles that you want to add to the style set. Press Okay and the Save Style Set dialog box appears.
If there are no user-defined cell styles available, the Save Style Set dialog box appears directly.
4. Enter a Style Set Name .
5. Select the Set as Default check box if the style set should be applied as default in your workbooks. The default style set is used when you open a new workbook and insert a data source.
6. Press OK .
## Results
The new defined style set is created and available in the list of style sets that can be applied to a workbook.
## Related Information
Editing crosstabs with Table Design [page 50]
## 3.4.4  To share a style set
## Context
You can share a style set with other users by exporting the style set to a local fileshare. Other users can import the style set and use it for the analysis.
## Procedure
1. Apply the style set that you want to export.
2. Choose Styles Export Style Set... .
3. Save the style set as XML format.
The XML file contains the cell styles of the three SAP style sets and your currently applied style set.
4. Choose Styles Import Style Set... .
5. Select a style file from the server and press Open .
6. Save the imported styles as new style set.
## Results
You have exported a style set to be used by other users and / or you have imported a style set to use it in your analysis.
## 3.4.5  To delete a style set
## Context
You can delete all user-defined style sets. The standard SAP style set that is installed with the Add-In can not be deleted.
## Procedure
1. Choose Styles Delete User Style Set . The Delete User Style Set dialog box appears.
2. In the list box, selet the style set you want to delete.
3. Press OK .
## Results
The style set is deleted and no longer available in the list of style sets that can be applied to a workbook.
## 3.5 Grouping crosstabs
## Context
You can stick two crosstabs together so that they look and behave as they would be one crosstab. Therefore you have to group theses crosstabs.
With grouping crosstabs, they are moved close together that there is no space in between. Furthermore the row axis is building the common axis of this grouped crosstab. The crosstab from which you trigger the grouping is defined as master and determines the structure of the common crosstab, whereas the dependent crosstab is providing its column axis.
From a user interaction point, the grouped crosstab behaves as one entity. The functionality provided within ribbon and context menu is adjusted to the unified behavior of the grouped crosstab. For example:
- You can only move dimensions to or within the master crosstab.
- Filtering dimensions is only possible for dimensions of the master crosstab.
- If you use or change the display in the master crosstab to Compact Display in Rows , the dependent crosstabs behave accordingly.
- If you undo the grouping, the dependent crosstabs will be set back to the behavior before the grouping. If you ungroup the crosstabs, the dependent crosstabs will have the behavior of the grouped crosstab.
Only the rows axis can build the common axis. The crosstabs needs to have a similar row structure so that grouping the crosstabs is feasible.
You can group several crosstabs.
##  Note

There are some limitations when working with grouped crosstabs. For more information, see SAP Note 2631644 .
## Procedure
1. Insert at least two data sources.
2. Select a dimension which is on the rows axis and choose Combine Group Crosstab on the Analysis Design tab.
## Related Information
SAPMoveDimension [page 115] SAPSetFilter [page 117]
## 3.6 Linking dimensions
## Context
You use several data sources in a workbook and you want that an action on a dimension affects the same dimension in other data sources in the same way. For example, you want to have this dimension to be filtered by the same member or have the same hierarchy drill operation.
Therefore, you need to link these dimensions.
With the next action, the linked dimensions behave simultaneously, especially with regards to filter and hierarchy navigation.
Note that you can only link dimensions for data sources that:
- are located in exactly the same system, and not only the same system type, like SAP BW or SAP Analytics Cloud.
- have the same client in case of SAP BW systems.
- have the same port in case of SAP HANA systems.
## Procedure
1. Select a dimension in the crosstab.
2. Choose Combine Link Dimension &lt;dimension of data source you want to link to&gt; on the Analysis Design tab.
## Results
The dimensions are linked.
On the Analysis tab in the design panel, you can recognize linked dimensions by an icon that is displayed next to the dimension name.
You can undo the linking by choosing Combine Link Dimension &lt;dimension of data source you link to&gt; .
## 3.7 Inserting data sources using BW Workspaces
A BW workspace is a special area in which new models can be created based on a central data provider from the BW system and local data. The aim of workspaces is to bridge the gap between the central requirements and the flexibility required locally.
Queries are usually based on InfoProviders. If you need to add new fields, you have to change these InfoProviders in the BW back-end. BW workspaces enable you to react quickly to new analytical requirements. This means you can add fields to a query without changing the objects in the BW system.
BW workspaces are usually created by the central IT department making a set of InfoProviders available in a workspace and assigning the authorizations for workspaces to business users. By uploading local data, you can create a local provider in a workspace. In a CompositeProvider, you can connect your own data in the local provider with BW data in the workspace. By reloading data to a local provider, the data in the local provider can be updated. This allows you to react quickly to new requirements. The central InfoProviders stored on the BW server expose their data to a workspace. The data in these providers is updated with the newest server data with every refresh.
You can insert all providers of a workspace as a data source in Analysis. They are available in the workspace view on the folder tab when you select a data source in a BW system.
##  Note
To create and work with BW workspaces, you need to use a SAP Business Warehouse Accelerator (BWA) or a SAP HANA database.
For more information about creating BW workspaces and authorizations for BW workspaces, see the SAP BW documentation at BW Workspace.
## Related Information
To create a local provider [page 64] To reload data in a local provider [page 65] To create a CompositeProvider [page 66]
## 3.7.1  To create a local provider
## Context
You can upload local data to create a local provider. The data in the local provider can then be analyzed with Analysis and you can use the local provider to create a CompositeProvider.
## Procedure
1. Open the Microsoft Excel file containing the data you want to upload to a local provider.
2. Select the cells you want to upload.
The entries in the first row of the selected range will be defined as column names automatically. You can change these column names in the local provider settings.
3. Select Create in the Build group on the Analysis Design tab.
4. Log on to the BW system.
The new local provider will be added to a workspace. Log on to the BW system containing the workspace where you want to add the local provider.
5. Select the workspace and press Next .
The Details dialog appears.
6. Enter a name for the local provider in the Description field (optional step).
7. Enter a technical name for the local provider in the Technical Name field (optional step). The first part is predefined by the system containing the elements @3 and the workspace prefix.
8. In the Column Definition section, you can define the following settings:
- Column Name
The column name is predefined with the entries in the first row of the uploaded range. You can change the name here. If you change the name, you should also change the entries in your Excel source file to be able to reload data later.
- Measure
Select the check box if the column contains measure data.
A default entry for the measure is made. It can however be changed manually.
- Type
For dimensions, select one of the following types: Time, Date, Dimension, Text (default), Text with Leading Zeros.
For measures, select one of the following types: Integer, Decimal, Floating Point Number, Measure. A default entry for the type is made. It can however be changed manually.
- Type Details
If you want to use this local provider to create a CompositeProvider, you can select the InfoProvider object of the workspace where the uploaded data should be linked to. The selection is possible for type Dimension and Measure. For dimensions, you get a list of all dimensions in the workspace to select an object. For measures, the list contains all measures available in the workspace.
9. Press Next .
In the Target Location dialog, you can specify wether the new local provider should be inserted into the current workbook sheet or a new workbook sheet after being created. You can also select that the new local provider is not inserted in a sheet after the creation.
10. Press OK to create the local provider.
## Results
The local provider is created in the workspace. You can add it to a workbook as a data source and analyze the data with Analysis.
## 3.7.2  To reload data in a local provider
## Context
You can reload data to a local provider to update the data in the provider.
## Procedure
1. Open the Microsoft Excel file containing the data you want to upload to a local provider.
2. Select the cells you want to reload.
The selected range must contain the same number of columns you used for creating the local provider. The column titles must also be identical.
3. Select Reload in the Build group on the Analysis Design tab.
4. Log on to the BW system. Log on to the BW system containing the local provider you want to reload.
5. Select the workspace and press Next .
6. Select the local provider you want to reload. In the Data Source Details section, you see the defined settings for the local provider. You cannot change the settings when reloading data. If the columns in the selected local provider do not match the selected columns for reloading, a message is
displayed.
7. Press Next .
In the Target Location dialog, you can specify whether the reloaded local provider should be inserted into the current workboook sheet or a new workbook sheet after reloading. You can also specify that it is not inserted into a sheet after reloading.
8. Press OK to relaod the local provider.
## Results
The local provider is updated with the reloaded data.
## 3.7.3  To create a CompositeProvider
## Context
In a CompositeProvider, you can combine all the data that you want to view in your query. You can use all central BW InfoProviders assigned to the workspace as data providers, as well as your own data assigned to the workspace as local providers.
## Procedure
1. Insert the query that you want to enhance with a local provider. The query must belong to the same workspace as the local provider.
2. Select a cell of the crosstab.
3. Choose Add Dimension or Add Data Records in the Build group on the Analysis Design tab.
##  Note
If you want to add measure data to a query, we recommend adding it as data records.
The Define Composite Provider Settings dialog appears.
4. Select a local provider from the list.
You can specify whether the local providers for all dimensions in the query should be listed, or jus for one dimension that you select in the drop down list.
If you select a local provider, the data source details are displayed.
5. Press Next .
In the Details dialog, you can enter a description and technical name for the new CompositeProvider and the new data source (composite provider query).
The technical name of the composite provider has the same predefined prefix as the local provider. The technical name of the composite provider query starts with the predefined prefix containing the elements $ and the workspace prefix.
If you add a local provider to a composite provider, you cannot change the descriptions and technical names. These can only be assigned when the first local provider is added to a query.
6. Press Next .
In the Target Location dialog, you can specify whether the CompositeProvider should be inserted into the current workbook sheet or a new one. You can also specify that it should not inserted into a sheet.
7. Press OK to create the CompositeProvider.
##  Note
You can use the graphical view or the table view in the BW Workspace Designer to check the field connections.
For more information on the BW Workspace Designer, see the SAP NetWeaver BW documentation at BW Workspace Designer.
## Results
The composite provider is created in the workspace. You can insert it as a data source into a workbook and analyze the data. You can also add new dimension or data records to the composite provider.
## 3.8 Converting crosstab cells to formula
You can convert all cells of a crosstab into formulas with one step. This deletes the crosstab object and defines every row in the table as a Microsoft Excel formula. The result values called from the server with the formula are still displayed in the table. The formula of the selected cell is displayed in the formula bar. In formula mode, you can edit the analysis table using Microsoft Excel formatting and formula functions and make further calculations using the existing data.
In formula mode, you can use all Microsoft Excel formatting functions. With the deletion of the design item, the individual formatting of the data will not be overwritten by the standard formatting in the crosstab the next time you update this data. For example, if you select a color to highlight interim results in the table and then navigate in this table, only the data for the values from the server is called and not the standard formatting from the crosstab. Your individual formatting is retained.
You can use the Microsoft Excel formula functions to make further calculations on the basis of existing data. You can also copy the formula for a cell to another cell outside the table and thus work independently of the original table. If the workbook contains two crosstabs based on different data providers, you can combine the data from both data providers for your calculations.
## The Formulas
Formulas with the following functions are composed in the formula mode:
- SAPGetData
- SAPGetMember
- SAPGetDimensionInfo
- SAPGetUniformScaling
## Examples for working in formula mode
In formula mode, you can use various functions to modify the layout and perform additional calculations.
- You can highlight cells by formatting the font and background color.
- You can insert spaces to make the display easier to read.
- You can copy parts of the table or individual cells to another position in the workbook in order to compare particular values.
- You can re-use cells.
- You can overwrite a members with another one, or add one in order to call data that you need from the BI server. If member "3.2007" is used to read the sales revenue for March 2007, for example, you can replace the 3 with a 4, thus using member "4.2007" to obtain the sales revenue for April 2007, provided that the data provider contains this data.
- You can also calculate additional subtotals.
- You can create offers based on data from various data providers.
## Restrictions
Converting to formula mode has the following consequences:
- Navigation using Drag &amp; Drop is no longer possible.
- The context menu is not available.
## Related Information
To convert a crosstab to formula [page 68]
## 3.8.1  To convert a crosstab to formula
## Procedure
1. Insert a crosstab into a workbook
2. Choose Convert to Formula .
If the icon Convert to Formula is not displayed in the ribbon Tools group, you can enable it in the Customize User Interface dialog.
Converting to formula performs the following steps:
- Texts that are not displayed because they occur several times in a column or row, are repeated in each cell automatically to produce valid formulas. You can also execute this step manually by selecting the Repeat Members check box for the crosstab on the Components tab in the design panel.
- Every cell in the crosstab is defined as a Microsoft Excel formula.
##  Note
All currently displayed cells of the crosstab are converted to formula. Cells in a hierarchy that are currently not expanded, are not converted.
- For dimensions and members displayed as text in the crosstab, the key is added to the data source during conversion to formula. This doesn't change the display in the original crosstab. You will only see the added key if you insert the crosstab with the same data source again in your workbook. Then columns and rows are added to display the key.
- Crosstab object is deleted.
## Results
All currently displayed cells of the crosstab are converted to a formula using the functions SAPGetData, SAPGetMember, SAPGetDimensionInfo and SAPGetUniformScaling.
##  Note
As long as you haven't changed the data in the table, you can go back to analysis mode by choosing Undo .
## Related Information
Customizing the User Interface [page 17]
## 3.9 Creating Web Applications
## Context
You can transfer components in an Analysis workbook to SAP Lumira / SAP BusinessObjects Design Studio to create a web application. These tools enable application designers to create analysis applications and dashboards for browsers and mobile devices.
In Analysis, you can use methods that are not available in Lumira / design studio. For example, you can use calculations, conditional formatting, and exceptions to change a data source. You may then want to create a web application to use this changed data source in Lumira / the design studio.
The following Analysis components can be transferred:
- Crosstabs
- Charts
The following chart types are enabled: Pie, Line, Column, Bar, Surface, Radar, Bubble, and Scatter.
- Filters
## Procedure
1. Ensure that Lumira / design studio is closed.
2. In Analysis, select the workbook sheet with the components that you want to transfer to Lumira / design studio.
3. Choose Create Web Application in the ribbon. If the icon is not displayed in the ribbon Tools group, you can enable it in the Customize User Interface
4. dialog.
5. The 'Logon' dialog for Lumira / design studio appears.
4. Enter your logon data and choose OK to log on to Lumira / design studio. Lumira or Design Studio is opened and the components of the workbook sheet are added to the template.
## Results
You can now modify the web application with application design:
For more information about working with SAP Lumira, see the Application Designer guide at SAP Lumira
For more information about working with the Design Studio, see the Application Designer guide at SAP BusinessObjects Design Studio.
## Related Information
Customizing the User Interface [page 17]
## 3.10 Launching the Query Designer for editing a data source
## Context
Directly from Analysis, you can access the BEx Query Designer or the BW Modeling Tools for queries or the SAP HANA editor for HANA calculation views to open a data source that has been inserted in the current workbook.
You can use this function to check the query definition and to change the definition according to your needs. After saving the changes, you can update the data source in the workbook immediately.
Prerequisites for using this function with SAP BW:
- You use a BEx query as data source.
- BEx Query Designer with minimum release 7.20 SP10 or 730 SP3 is installed on your client PC.
- BW Modeling Tools with minimum release 7.40 SP16 or 7.50 SP5 (See SAP note 2343003).
Prerequisites for using this function with BW4HANA:
- BW Modeling Tools with minimum release 7.40 SP16 or 7.50 SP5 (See SAP note 2343003 and 2246699).
Prerequisites for using this function with SAP HANA:
- You use a HANA calculation view as data source.
- You use a SAP HANA Web-based Development Workbench editor with minimum release SPS 10.
## Procedure
1. Select a crosstab cell.
2. Choose Launch Query Designer in the ribbon.
3. If the icon is not displayed in the ribbon Tools group, you can enable it in the Customize User Interface dialog.
4. The Logon dialog for the BEx Query Designer, the BW Modeling Tools or the SAP HANA system appears.
3. Enter your logon data and choose OK to log on. The query editor is opened and the data source selected in the workbook is already open and ready to be
6. edited.
4. Edit the query definition and save your changes.
5. In Analysis, select a crosstab cell and choose Reset Data Source in the context menu to display the changed data source.
## Results
The data is displayed corresponding to the new initial state defined in the BEx Query Designer, BW Modeling Tools or SAP HANA Web-based Development Workbench editor.
## Related Information
Customizing the User Interface [page 17]
## 3.11 To smart copy/paste a data source
## Prerequisites
You have inserted a data source in Analysis for Microsoft Excel.
## Context
You can copy a data source (crosstab or chart) that is currently displayed in the workbook and insert it in another workbook, sheet or place in the same sheet.
## Procedure
1. In Analysis for Microsoft Excel, select the crosstab or chart that should be copied.
2. Choose Smart Copy .
3. Select an empty cell in a sheet and choose Smart Paste . The copied data source is inserted as crosstab.
## Results
The current navigation state of the copied data source is displayed, but it exists independently from the origin. Navigation steps in the original object do not affect the pasted crosstab and vice versa.
Note that most of the properties managed on the Components tab in the design panel, are specified as not copy-relevant. That means that the properties for the copied data source will have the default values and not the values of the original object. The only exception is the number of new lines for planning.
## 3.12 To save a query view
## Context
You can save a navigation state of a data source as a query view in a BW system.
## Procedure
1. Select a cell of the crosstab.
2. Choose Save View .
The Save Query View dialog box appears. The dialog has two tabs: Query View and Role .
On the Query View tab, you can save the new query view to the query. If there are already query views based on the same query, they are listed in this tab.
On the Role tab, you can select an existing role and save the new query view there. The roles are created and maintained in the BW system (transaction PFCG). In a role folder, you see all views that are saved to that role even if they are based on different queries.
##  Note
If you are connected to a BI platform server, the view will be saved as analysis view on the BI platform.
3. Enter a name and a description.
4. Select Save Variable Values if the values should be saved with the query view. This option is only selectable if the data source contains variables.
5. Press Save to save the query view.
## Results
The query view is saved on the same server as the data source.
You can open the query view with Insert Data Source .
Note that most of the properties managed on the Components tab in the design panel are specified as not view-relevant. That means that the properties for the saved view will have the default values and not the values of the original object. The only exception is the number of new lines for planning.
You can delete a query view with the context menu in the Save Query View dialog. The system checks if the query view is used in other objects saved on the same server. If the query view is used in an object saved on another server, no message appears.
## Related Information
To save an analysis view [page 224]
## 3.13 Working with formulas
In Analysis for Microsoft Office, you can use the standard functions of Microsoft Excel to build formulas. The Plug-in also contains an own set of functions that you can use to build formulas. You can use these 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 Analysis consists of a function and arguments (references to the data source, measures and/or dimensions). You can use the text or the key of an object to use it as a reference. You can also use a cell value like B10 as reference. The arguments are listed with a list separator, a semicolon for example.
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.
You can also use these functions in VBA macros.
## Analysis functions
The following functions are available in the Analysis category:
##  Note
The examples that you find in the Analysis help for formulas use a semicolon as list separator. If you copy these examples to your Analysis installation, they'll only work properly if you use the same default list separator on your machine.
- SAPGetData
- SAPGetDimensionDynamicFilter
- SAPGetDimensionEffectiveFilter
- SAPGetDimensionInfo
- SAPGetDimensionStaticFilter
- SAPGetDisplayedMeasures
- SAPGetInfoLabel
- SAPGetMeasureFilter
- SAPGetMeasureInfo
- SAPGetMember
- SAPGetSourceInfo
- SAPGetUniformScaling
- SAPGetVariable
- SAPGetWorkbookInfo
- SAPListOf
- SAPListOfDesignRules
- SAPListOfDimensions
- SAPListOfDynamicFilters
- SAPListOfEffectiveFilters
- SAPListOfMeasureFilters
- SAPListOfMembers
- SAPListOfMessages
- SAPListOfStaticFilters
- SAPListOfVariables
- SAPSelectMember
- SAPSetData
- SAPSetFilterComponent
## Related Information
Using Analysis functions [page 129]
## 3.13.1  To create a formula
## Context
To create a formula with Analysis functions:
## Procedure
1. Select the cell in which you want to enter the formula.
2. To start the formula with a function, press the Insert Function button on the formula bar. The Insert Function dialog box appears.
3. Select Analysis in the Select a category box.
4. Select a function.
5. Press OK . The Function Arguments dialog box appears.
6. Enter the arguments.
To enter cell references as an argument, press the Collapse Dialog button (which temporarily hides the dialog box), select the cells on the worksheet, and then press the Expand Dialog button.
7. When you complete the formula, press OK .
## Results
The formula is added to the cell. When you select the cell, you can see the formula with its function and arguments in the formula bar. The arguments are listed with a list separator, a semicolon for example.
The examples that you find in the Analysis help use a semicolon as list separator. If you use these examples in your Analysis installation, they'll only work properly if you use the same default list separator on your machine.
## 3.13.4  SAPGetDimensionDynamicFilter
This function returns the dynamic filter of a dimension. Dynamic filters are defined by the user.
The formula consists of three parameters and is made up of the following arguments:
## · Data Source
Enter the formula alias of the data source or planning function. You can set the alias when configuring the data source or planning function on the Components tab in the design panel.
## · Dimension
Enter the technical name of the dimension.
- Member Display
You can enter TEXT , KEY , or INPUT\_STRING to define how the filtered members should be displayed in the workbook.
You can use INPUT\_STRING\_AS\_ARRAY if the formula is called from VBA to get the input string as a string array.
## Example
Cell F20: =SAPGetDimensionDynamicFilter("DS\_1";"0DIVISION";"TEXT")
You add a filter for dimension 0DIVISION and the following members are displayed in the analysis: Paints, Lighting, Foods. If you enter the formula in cell F20, the three filtered members are displayed in cell F20 as text.
## 3.13.5  SAPGetDimensionEffectiveFilter
This function returns all effective filters of a dimension: dynamic filters defined by the user, static filters defined in the underlying source, and filters by measure defined for the selected dimension.
The formula consists of three parameters and is made up of the following arguments:
- Data Source
Enter the formula alias of the data source or planning function. You can set the alias when configuring the data source or planning function on the Components tab in the design panel.
- Dimension
Enter the technical name of the dimension.
- Member Display
You can enter TEXT , KEY , or INPUT\_STRING to define how the filtered members should be displayed in the workbook.
You can use INPUT\_STRING\_AS\_ARRAY if the formula is called from VBA to get the input string as a string array.
## Example
Cell F20: =SAPGetDimensionEffectiveFilter("DS\_1";"0DIVISION";"TEXT")
If you enter the formula in cell F20, the members of 0DIVISION that are currently filtered by the user, the static filters that are defined in the data source, and the filters by measure for this dimension are displayed in cell F20 as text. If no static filters are defined for the data source, only the dynamic filter members and filters by measure are displayed.
## 3.13.6  SAPGetDimensionInfo
This function returns the name of a dimension or the name of an active hierarchy.
The 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
Enter the technical name of the dimension.
- Property Name
You can enter the following property names:
- NAME
- ACTIVEHIERARCHY
- ATTRIBUTE
- ISCHARACTERISTICSTRUCTURE
This property returns the value True if the dimension is a structure containing dimension members. If this is not the case, it returns the value False.
- ISMEASURESTRUCTURE This property returns the value True if the dimension is a structure containing measures. If this is not the case, it returns the value False.
## Example
Cell F20: =SAPGetDimensionInfo("DS\_1";"0DIVISION";"NAME")
If you enter the formula in cell F20, the name of dimension 0DIVISION is displayed in cell F20.
## 3.13.7  SAPGetDimensionStaticFilter
This function returns the static filter of a dimension. Static filters are defined in the underlying source and cannot be changed by the user.
The formula consists of three 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 Enter the technical name of the dimension.
- Member Display
You can enter TEXT , KEY , or INPUT\_STRING to define how the filtered members should be displayed in the workbook.
You can use INPUT\_STRING\_AS\_ARRAY if the formula is called from VBA to get the input string as a string array.
## Example
Cell F20: =SAPGetDimensionStaticFilter("DS\_1";"0MATERIAL";"KEY")
If you enter the formula in cell F20, the static filter of dimension 0MATERIAL is displayed in cell F20.
## 3.13.8  SAPGetDisplayedMeasures
This function returns a list of all measures displayed in the analysis as text.
The 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: =SAPGetDisplayedMeasures("DS\_1")
If you enter the formula in cell G10, all measures that are currently displayed in the crosstab are listed in cell G10. If you add or remove a measure from the crosstab, the list in cell G10 is updated accordingly.
## 3.13.9  SAPGetInfoLabel
This function returns the language-dependant label for an info field. The property names correspond to the info fields that are available for workbook and data sources on the Information tab in the design panel. Using this function, the info field labels are displayed in the selected UI language. The info field values can be inserted with function SAPGetWorkbookInfo and SAPGetSourceInfo.
The formula is made up of the following argument: Property Name .
For workbook related info fields, you can enter the following property names:
- WorkbookName
- CreatedBy
- CreatedAt
- LastChangedAt
- LastRefreshedAt
- LogonUser
For data source related info fields, you can enter the following property names:
- DataSourceName
- LastDataUpdate
- LastDataUpdateMaximum This property is related to MulitProviders. It returns the date of the last update of all InfoProviders in a MultiProvider. Example: A MultiProvider contains three InfoProviders. The date when all three InfoProviders were updated succesfully for the last time, is the LastDataUpdateMaximum.
- KeyDate
- QueryTechName
- QueryCreatedBy
- QueryLastChangedBy
- QueryLastChangedAt
- QueryLastRefreshedAt
- InfoProviderTechName
- InfoProviderName
- System
- LogonUser
## Example
Cell D20: =SAPGetInfoLabel("System")
The label of the info field is displayed in the selected UI language, for example in English: System.
## 3.13.10  SAPGetMeasureFilter
This function returns a list of filtered measures created with Filter by Measure (All Dimensions Independently).
##  Note
As of Analysis 1.4 SP7, you can use the function SAPListOfMeasureFillters to get a list of the all filtered measures. This function also returns more detailed information and includes BEx conditions.
The 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.
## Related Information
SAPListOfMeasureFilters [page 93]
## 3.13.11  SAPGetMeasureInfo
This function returns information about a measure. It can return the information if a measure is restricted, the selection behind a restricted measure or the info objects that is represented by this measure.
The 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.
## · Measure
Enter the technical name of the measure. By default, that is an unreadable GUID that is available in the properties view on the Analysis tab in the design panel. If a technical name was defined in the query designer, this name can also be used.
## · Property Name
You can enter the following property names:
- ISRESTRICTED
This property returns the value True if the measure is a restricted measure. If the measure is not restricted, the property returns the value False .
- SELECTION
This property returns the selection behind a restricted measure. If there is no selection behind the measure, an empty string is returned.
- BASEINFOOBJECT
This property returns the info object that is represented by this measure.
## Example
Cell F20: =SAPGetMeasureInfo("DS\_1";"TN\_IncomingOrders";"ISRESTRICTED")
If you enter the formula in cell F20, the return value True is displayed in cell F20 if the measure TN\_IncomingOrders is restricted. If it is not restricted, the return value in cell F20 is False .
## 3.13.12  SAPGetMember
This function returns the dimension member or attribute.
The formula can only return values for dimension members or atttributes that are part of the current navigation state of the data source. To be part of the navigation state, the members must be used in rows, columns or as background filter. If you filter a dimension, you can only return values for members that the filter contains.
The 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 , KEY or Internal\_Key to define how the filtered members should be displayed in the workbook.
Note: If you want to get an attribute with this function, you need to add the attribute name before the Member Display and connect them with an underscore character, for example "0Country\_Key".
## Example
Dimension Member
Cell G15: =SAPGetMember("DS\_1";"0DIVISION=R1";"TEXT")
You want to display the text for 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.
## Example
Attribute
Cell F10: =SAPGetMember("DS\_1";"0Customer=21";"0Country\_Key")
With this formula, you get the key for the country where the customer 21 is located in cell F10.
## 3.13.13  SAPGetSourceInfo
This function returns an info field value for a data source. The info field label can be inserted using the SAPGetInfoLabel function. The property names correspond to the info field values that are available for data sources on the Information tab in the design panel.
The 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 following property names:
- DataSourceName
- LastDataUpdate
- LastDataUpdateMaximum
This property is related to MulitProviders.
For MultiProviders, the property LastDataUpdate returns the date of the last update of all InfoProviders in the MultiProvider.
The property LastDataUpdateMaximum returns the date of the last update of a single InfoProvider of the MultiProvider.
Example: A MultiProvider contains three InfoProviders. The date when all three InfoProviders were updated successfully for the last time, is the LastDataUpdate. The date when a single InfoProvider was updated for the last time, is the LastDataUpdateMaximum.
- KeyDate
- QueryTechName
- QueryCreatedBy
- QueryLastChangedBy
- QueryLastChangedAt
- QueryLastRefreshedAt
- InfoProviderTechName
- InfoProviderName
- System
- LogonUser
## Example
Cell D20: =SAPGetInfoLabel("DataSourceName")
Cell E20: =SAPGetSourceInfo("DS\_1";"DataSourceName")
In cell D20, the Data Source Name label is displayed. In cell E20, the name of the data source with alias DS\_1 is displayed, for example Sales Volume Europe .
## 3.13.14  SAPGetUniformScaling
This function returns the unit/scaling information for a specific dimension member combination.
The formula can only return values for member combinations that are part of the current navigation state of the data source. To be part of the navigation state, the member combinations must be used in rows, columns, or as a background filter. If you filter a dimension, you can return values only for member combinations contained in the filter.
The formula consists of at least three 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.
- Measure
Enter the name of measure, for example "Sales Volume" .
- Member combination
There are two methods for entering the member combination:
- Enter one parameter as member combination, for example "Region=France;Product=IT" . This method is used for converting to a formula.
- Enter several parameters as the member combination, for example
"Region";"France";"Product";"IT" . This method can only be entered manually. It is recommended for member combinations that use cell references.
## Example: 3 Parameters Formula
Cell H20: =SAPGetUniformScaling("DS\_1";"Sales";"Region=France;Product=IT")
The data for the value in this cell comes from data source DS\_1. The name of the measure is 'Sales Volume'. The member combination is 'France' and 'IT'. The formula in cell H20 therefore uses the data from DS\_1 to calculate the unit/scaling factor for the sales volume for region 'France' and 'IT' (e.g. EUR). If you change 'France' to 'USA' in the formula, the unit/scaling factor for the sales volume of 'USA' and 'IT' is displayed in cell H20 (e.g. USD).
## 3.13.15  SAPGetVariable
This function returns the value of the specified property for a specific variable.
The formula consists of three 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.
- Variable Name
Enter the name or technical name of the variable.
## · Property Name
You can enter the following property names:
- VALUE
If you enter VALUE, the current value of the variable is displayed.
- VALUEASKEY
If you enter VALUEASKEY, the current value of the variable is displayed as a key.
- VALUEASTEXT
If you enter VALUEASTEXT, the current value of the variable is displayed as text.
- INPUT\_STRING
If you enter INPUT\_STRING, the current value of the variable is displayed as an input string.
- INPUT\_STRING\_AS\_ARRAY
This property name can only be used if the formula is called from VBA. It returns the input string as a string array.
- DESCRIPTION
If you enter DESCRIPTION, the variable name is displayed.
- ISINPUTENABLED
If you enter ISINPUTENABLED, the function checks if the variable is input-enabled.
- ISMANDATORY
If you enter ISMANDATORY, the function checks if the variable is mandatory.
- TECHNICALNAME If you enter TECHNICALNAME, the technical name of the variable is displayed.
- BASEINFOOBJECT
If you enter BASEINFOOBJECT, the technical name of the dimension the variable is based on is displayed.
## Example
Cell F20: =SAPGetVariable("DS\_2";"0BW\_VAR";"DESCRIPTION")
If you enter the formula in cell F20, the name of variable 0BW\_VAR is displayed in cell F20.
## 3.13.16  SAPGetWorkbookInfo
This function returns an info field value for the current workbook. The info field label can be inserted with the SAPGetInfoLabel function The property names correspond to the info field values that are available for workbooks on the Information tab in the design panel.
This formula is made up of the following argument: Property Name .
You can enter the following property names:
- WorkbookName
- WorkbookDescription
- CreatedBy
- CreatedAt
- LastChangedAt
- LastRefreshedAt
- LogonUser
- PlanningEnvironment
- PlanningModel
## Example
Cell D20: =SAPGetInfoLabel("WorkbookName")
Cell E20: =SAPGetWorkbookInfo("WorkbookDescription")
In cell D20, the Workbook Name label is displayed. In cell E20, the description name used for saving the workbook is displayed, for example Sales in Europe .
## 3.13.17  SAPListOf
This function returns a list of available objects for a specific object type. The list contains two columns for every entry (Alias and Description).
This formula consists of 3 parameters and is made up of the following arguments:
## · Object Type
You can enter the following object types:
- DATASOURCES
- CROSSTABS For object type CROSSTABS, the function returns a list with three columns (Alias, Description and data source Alias).
- PLANNINGFUNCTIONS
- PLANNINGSEQUENCES
- CUSTOMAPPLCONTEXT For object type CUSTOMAPPLCONTEXT, the function returns a list with three columns (SystemID,
RowCount and Content).
## · Search
You can enter a search string. Note that the search is case sensitive. If you do not enter a search string, all available objects of the selected object type will be listed.
## · Search in
You can search in ALIAS or DESCRIPTION. This parameter is optional. The default value is ALIAS.
## Example
Cell G15: =SAPListOf("CROSSTABS";"Cross")
Starting in Cell G15, a list with three columns (crosstab Alias, crosstab Description, data source alias) is displayed with all crosstabs that contain the search string Cross in their Alias.
## Related Information
Using BAdI information [page 132]
## 3.13.18  SAPListOfDesignRules
This function returns a list of design rules. Depending on the search entries, the list can display all design rules for a data source or the design rules for one defined rule type.
This formula consists of 2 parameters and is made up of the following arguments:
- Data Source Enter the formula alias of the data source or planning function. You can set the alias when configuring the data source or planning function on the Components tab in the design panel.
## · Rule Type
You can enter one of the following rule types to define which rules should be displayed:
- ALL This is the default rule type.
- NewLine
- NewDimensionLine
- NewMemberLine
- NewHeaderLine
- Format
- LineSize
- Text
- Formula
## Example
Cell G11: =SAPListOfDesignRules("DS\_1";"NewLine")
Starting in Cell G11, a list with all rules for new lines for data source DS\_1 is displayed.
## 3.13.19  SAPListOfDimensions
This function returns a list of dimensions. Depending on the search entries, the list can display all dimensions with their current drill state, dimensions that match a defined search string with their current drill state or just the dimensions used in rows, columns or background filter.
For planning functions, the function returns a list of all dimensions defined on the aggregation level of the planning function. The axis type is always ROW.
This formula consists of 3 parameters and is made up of the following arguments:
## · Data Source
Enter the formula alias of the data source or planning function. You can set the alias when configuring the data source or planning function on the Components tab in the design panel.
## · Search In
You can determine which columns the search should be executed in by selecting TECHNICALNAME, DESCRIPTION or AXIS. The default selection is TECHNICALNAME.
## · Search
If you have selected TECHNICALNAME or DESCRIPTION, you can enter a search string. Note that the search is case sensitive. If you do not enter a search string, all available dimensions will be listed. If you have selected AXIS, you can use the axis type to define which dimensions should be displayed:
- Enter ROWS to list the dimensions that are used in rows inthe current analysis.
- Enter COLUMNS to list the dimensions that are used in columns inthe current analysis.
- Enter FILTER to list the dimensions that are used as background filter in the current analysis.
- Enter ALL to list all available dimensions with their current drill state. For dimensions that are not used in the current analysis, the drill state column is empty.
If the selected axis type contains no dimensions in the current analysis, the list is empty.
## Example
Cell G11: =SAPListOfDimensions("DS\_1";"TECHNICALNAME";"0SOLD")
Starting in Cell G11, a list with three columns (Technical Name, Description, Drill state) is displayed with all dimensions that contain 0SOLD in their technical name.