Using SAP Formula Functions

You can use SAP-specific formulas to enhance the appearance of your workbook.

To see a list of the SAP-specific formula functions you can use, select the Insert function (fx) icon in Microsoft Excel and then select SAP Analytics Cloud from the Select category dropdown.

To use the function, double-click it as you would any other Excel formula function.

Similar to some other Excel functions, Analysis functions have different parameters to define. Refer to the Analyze and Plan with Formulas guide for complete details on all SAP functions.

The formula function SAP.GETDIMENSIONFILTER returns the filter for a dimension and an icon to open the filter dialog from the sheet.

In the example below, you can see that the SAP.GETDIMENSIONFILTER function has the following required arguments:

• Table: Enter the table name in double quotation marks. The default name for a table is TableX, where X is a whole number indicating which order the table was added. For example, the first table added to a workbook is named Table1.
• Dimension: Enter the dimension name in double quotation marks.