Using SAP Formula Functions

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

To see a list of the SAP formula functions, 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.

Like 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 SAP.GETDIMENSIONFILTER function returns the current filter for a dimension, along with 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 the order in which 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.

This is useful for building report layouts where you want filter controls to appear directly on the worksheet without requiring the user to open the Designer panel.

Additional Information: For a complete reference of all available SAP formula functions, refer to the Analyze and Plan with Formulas guide in the SAP Help Portal.