SAP Analytics Cloud: Top 5 New Features | Q4 2026 Release Highlights — Transcript

Full transcript

1. 0:06In this video we take a look at the top five
2. 0:09features coming your way in SAP Analyst Cloud.
3. 0:12These include data entry repost data, data
4. 0:16entry insertion of multiple new lines,
5. 0:18advanced formulas string manipulation functions,
6. 0:21new flexible table filters and sorting in waterfall charts.
7. 0:25Hi my name is Orla Cullen and these are
8. 0:28your what's new updates for QRC4 2026.
9. 0:45Time saver for all the planners out there is the introduction of
10. 0:49the repost data capability which lets you refresh the displayed
11. 0:52values in your table directly without leaving your planning context.
12. 0:55Planners can now repost data to unbooked target member combinations
13. 0:59in tables by changing dimension values on booked member combinations.
14. 1:03So let's take a look.
15. 1:04Firstly, the repost feature needs to be switched on.
16. 1:07Story designers can enable it directly in the Table Builder panel.
17. 1:11Once active, planners simply right
18. 1:13-click a cell and select Repost Member.
19. 1:15They pick a new target combination and the data moves over in a
20. 1:19single step. Fast, clean and without leaving the table, no more
21. 1:22manual workarounds, just a quick repost to any unbooked combination.
22. 1:27Sticking with data entry, next up we have another time saver
23. 1:31that allows planners to add multiple new lines in tables in
24. 1:34one go. This is thanks to a new ad member combinations option.
25. 1:38Let's take a look at it in action.
26. 1:40Up until now, planners had to add new rows one at a time which can
27. 1:44be tedious and repetitive. Now they simply right-click and open a
28. 1:48dialog that shows 5 rows right away, ready to fill in all at once.
29. 1:52They can add more rows if needed, paste in the data and the
30. 1:55inline validation checks each cell before anything gets saved.
31. 1:59No surprises after submitting, it's a much faster
32. 2:02and cleaner way to enter new planning data.
33. 2:06In this release, we're adding string manipulation to
34. 2:09support advanced formulas. This allows scripts to dynamically
35. 2:12process data based on string conditions at runtime,
36. 2:15reducing the need for extra dimension
37. 2:17elements or attribute master data maintenance.
38. 2:20Scripts can now use concatenate, left, right and substring functions
39. 2:24to work with dimension member names and properties directly inside
40. 2:27your formula, making your data actions smarter and your models leaner.
41. 2:32Here we have an advanced formula step inside a data action.
42. 2:35On line 12, we use the let function to check whether
43. 2:38the first character of the product ID equals the letter E.
44. 2:41This lets the script branch logic based on string conditions without
45. 2:45needing a separate attribute or dimension to classify products.
46. 2:49Inside the branch, concatenate is used on line 16 to dynamically
47. 2:54build the target account member name, taking the product's category
48. 2:57property and appending the growth rate string as the suffix.
49. 3:01back in the story we can see the growth rate accounts that exist
50. 3:05in the model each holding the respective growth rate factors rather
51. 3:09than hard coding each of these names in the script concatenate
52. 3:12constructs the reference dynamically at runtime combining the product
53. 3:15category attribute and the growth rate suffix to resolve the correct
54. 3:19account for each product when we then run the data action the
55. 3:22dynamic lookup is performed and the resulting growth rates are applied
56. 3:26against the specific products on the product category attribute
57. 3:30SAP Analytics Cloud now gives you two new ways to
58. 3:33filter your tables that meaningfully improve the
59. 3:36experience for both storage designers and consumers.
60. 3:40You can now add filters from the table headers directly. You
61. 3:44have the option between the member and conditional filter.
62. 3:47With the member option, you can choose from a lift of
63. 3:50available members and with the conditional filter, you
64. 3:54have even more flexible and can define rules like contains
65. 3:57and both options are available in view and edit mode.
66. 4:02In this quarter the waterfall charts now support sorting by value,
67. 4:06variance and custom sorting as well as enabling users to establish a
68. 4:10waterfall chart as the driver for linked analysis but let's have a look.
69. 4:14Here in my story we see a waterfall chart and when
70. 4:18I click on the quick action menu I now have the
71. 4:20option to apply sorting to the waterfall chart.
72. 4:23Sorting can either be applied on company
73. 4:25code, a date dimension or on the value itself.
74. 4:28In this scenario I apply a sort on company code to show it in the
75. 4:32descending order and now I see that it's reflected in my waterfall chart.
76. 4:37Let's now take a look at some pre -configured iterations of sorting
77. 4:40on various waterfall charts. The first example shows a sort on
78. 4:44dimension, similar to my first scenario I've sort on company code and
79. 4:49as you can see on the left it always starts with America and Europe
80. 4:52whereas on the right it starts with Europe and Americas because
81. 4:55it has been sorted in ascending and descending order respectively.
82. 5:00You can also apply a sort on the version dimension so on the left
83. 5:05you can see the default order actual comes first followed by plan
84. 5:08but in the sorted order we have the plan first and then the actual.
85. 5:13Next we have a variant waterfall chart. In this scenario when a sort
86. 5:17is applied on the value, which could either be the account dimension
87. 5:20or the measure, the value is sorted based on the variance value.
88. 5:24So here what I've done is I've applied a sort and you can
89. 5:27see that the sort has been applied based on the variance
90. 5:30value and this shows progression in the waterfall chart.
91. 5:34Finally, as we are introducing the capability to sort in the
92. 5:37waterfall chart, we are also very excited to share that we
93. 5:39also support linked analysis on the waterfall chart. So
94. 5:43when I click on a date dimension, I can see that my combination
95. 5:46of column and line chart has also been filtered on 2024.
96. 5:51Note, a waterfall chart can act as a sender
97. 5:53as well as a receiver of the filter value.
98. 5:58Thank you for joining us to learn about some of the top features coming
99. 6:02in the Q4 2026 release of SAP and this cloud. Check out the video
100. 6:06descriptions for more links to resources about this quarter's updates
101. 6:09and also remember to leave a like on this video and subscribe to our
102. 6:13YouTube channel to stay up to date on everything SAP and this cloud.
103. 6:17Thanks again and we'll see you next time.