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.
- SAPGetData
- SAPGetMember
- SAPGetDimensionInfo
- SAPGetUniformScaling
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.
- Navigation using Drag & Drop is no longer possible.
- The context menu is not available.