Analysis Office 2.4 Table Design features

In Analysis Office 2.4 SAP improved the Table Design Editor. You can now create and edit formulas. In an earlier post, I described how to work with Excel formulas in a crosstab. You can add a new column with the table design functionality.

Analysis Office with Excel formula
Analysis Office with Excel formula

As you can see in the screenshot above, I wrote a simple formula in the new column. If you have now installed Analysis Office 2.4, you can see in the design rules tab of the design Panel the rule type formulas. If you select this rule type, you can see how many formulas are in your crosstab and you can edit them directly from here.

Analysis Office Design Rules tab
Analysis Office Design Rules tab

When you select a formula, the formula Definition is directly displayed in the properties area. You also see the Location and the corresponding cell. The button with the two arrows allows you to show or hide your formulas in the crosstab. It is the same function like the Excel function Show Formulas. It seems like a nice feature, but I don't know if you really need it, because you can do the same in the Excel formula bar. Or does anybody need this feature?

Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0