Skip to Content
Product Information

SAP Analytics Cloud Table: Best Practices Webcast Recap

This was an ASUG webcast last week covering what SAP has done inside SAP Analytics Cloud (SAC) for the table.  Another nice surprise was SAP Analytics Cloud, add-in for Microsoft Office, was demo’d/covered too.

Promotion – join the askSAP call next week, “Meet SAP’s New Data Management Offerings Optimized for SAP Analytics Cloud”

Register here – open to all!

_______________________________

For background please see this blog by Steffen Heine who was one of the webcast speakers.

Source: SAP Figure 1
Fast track

How to make tables as beautiful as possible in SAC

Source: SAP Figure 2

Table is not scrolling, click inside, then you could scroll

New – Beta Table checkbox (builder) – available for table widgets, responsive or canvas page
Cleans table
Makes row heights consistent
Have a nice table grid
Responsive check mark – handles column width for you; fits columns in as best as possible

Lazy loading – load data in background just when it is needed to make scrolling experience smooth

Context menu, right click, have functions, set drill level

For versions – have several functions

Row height adjustment is available on table properties

Figure 3: Source SAP
Different topic, an extension to table: SAP Analytics Cloud, add-in for MS Office
No installation is required for this product as it is deployed via cloud
Excel look and feel to enrich data
Used by power user for planning/reporting
Use Excel features – formulas, VBA, and macros

In beta now, GA is planned for May
Excel online
Add in his there
Get it via central deployment

Get updates automatically
Limited to data acquired model
Working on live model for future

Work with hierarchies

Time, dimension, production
Choose flat presentation

Can jump to desktop app from Excel online

Above video is what I tried to demo, attempting to repeat what SAP’s Alexander Peter showed.
Go to Excel online
Add-in is already there
Get it by central deployment
Activate once, get updates automatically
Limited to data acquired models; working on live connections
Search for model
insert to grid/sheet
side panel opens; filter
work with hierarchies, add new dimensions
Can jump to desktop app from Excel online
Insert Excel formulas
Go back
Excel experience with data, to analyze better and deeper

Figure 4: Source: SAP
Style – for designer, creating stories, analytical apps in SAC

Style in the web; sometimes tricky
For the designer, creating stories in SAC

4 templates – stylinging panel, at top
Report Styling template is IBCS certified


Figure 5
New default template has report styling template features, with clear lines

Figure 6
When you are in the table, it detects where you are at – “data region” and can easily change the styling


Figure 7
Ad hoc styling allows for selected cells – interesting! Performance implications, however, and speaker advised to have fewer style rules

Different regions, dimensions, whole columns or rows can be selected

Can also use thresholds for styling; at data level

Questions:
Q: Explorer facet view, how can it be more powerful
A: Working on that strategy

Q: Beta for MS office add-in
A: Will reach GA soon, will have focus on write back for planning

Q: Can you save templates and reuse?
A: Is there a need? SAP hasn’t heard interest in this

Valuable session; available in Wave 05 in tenant

Be the first to leave a comment
You must be Logged on to comment or reply to a post.