Combining measures with dimensions in table columns + dynamic headers (SAC)

[fernando_guirao]

In my SAP Analytics Cloud (SAC) story's table, I'm working with various measures. When I add the "Year" dimension, it categorizes all the measures by the filtered years. This setup works well for certain measures. However, I encounter a challenge with specific ratios that should not be divided by year. For measures that are derived from already displayed data, I can manually add a column and input a formula. This workaround allows me to reference them as cell values without splitting by year. Yet, the issue arises with measures that should remain unsplitted and rely on data not shown in the table. Currently, the only workaround seems to be placing these measures in a separate table where the "Year" dimension does not influence the columns. I'm wondering if there's a more efficient method to handle this scenario.

Additionally, I'm curious about the potential for enhanced customization in SAC's table widgets, similar to the capabilities in BO Webi. Specifically, the ability to modify column header names in tables would be incredibly useful. This feature could provide a solution to my previous problem by allowing me to rename model measures to reflect dynamic year information, such as renaming "Hours CY" and "Hours LY" to "Hours 2024" and "Hours 2023".

In the following example, Hours Client is a Calculation that must be splitted, and INC % must not. So in this case this increment is easily calculated at the formula bar. But if I had to add a model measure or calculation that uses other measures and should not be splitted, simply could not be done in this table.

[N1kh1l · Accepted solution]

@fernando_guirao 

SAC Table widget has some flexibility issues especially with cell level calculation which are easily done in Excel. Using separate table is a good approach to overcome this issue but yeah its an overhead. Regarding editing the headers of Table , yes this is also a pain but may be you could use a Text widget overlapping your table headers along with formatting table headers with same color as background to do a visual hide.

Br.

Nikhil

[fernando_guirao · Accepted solution]

Thank you! I hope we see some upgrades on this!