Whitepaper
Dashboarding with SAP Analytics Cloud (SAC)
Learn more about the different components, use cases and best practices.
Shaping Business Intelligence
About us
Our Methodology
Data Science & Engineering
SAP Planning
Dashboarding
The SAP Analytics Cloud (SAC) Story Tool allows for the creation of all types of Dashboards, ranging from simple self-service-style Reports to complex and powerful generic Dashboards.
At the core the tool tries to break the barriers between the business and an IT-driven application. Business users have the ability to tailor a Story to their needs, starting from scratch via simple drag-and-drop-mechanics. This ideally decreases the effort in IT and gives access to directly convert the requirements into a solution within the business department.
In our experience, Reports turn out best though, when IT is consulted for input on general best-practices, style guides and more complex, advanced features.
Speaking of advanced, the Advanced Mode was introduced with the Story 2.0 Update and strategically replaces the SAC Analytics Designer. The Advanced Mode allows a more tech-savvy user to extend any drag-and-drop Story with powerful, coded business logic, interaction and styling.
The integration of scripting possibilities within the Story-Tool is the main benefit over Analytic Applications, as the user does not have to choose a Tool at the start of a project.
In its simplest form, SAC Story lets you create interactive Dashboards effortlessly without the need for scripts, coding or any advanced IT-Knowledge. It’s what we at NextLytics call the 80% solution, because the tool will allow you to set up a somewhat polished report with almost all the data you need in a fairly short amount of time.
SAC Story already offers many chart types out-of-the-box. These are all fairly simple to set up, so you can quickly present the key takeaways from the data you want to emphasize on. Simply select the type of chart you need (like Bar-, Line- or Waterfall-Chart), the measures/key figures and the dimension (like Time-, Product- or Organizational-Characteristics). Besides the most common chart types SAC also a offers a variety of specialized charts like bubble charts, heat- and tree maps or a geomap widget.
Need just a simple display of a certain KPI? There is a chart option for that as well!
Sometimes it just has to be a table. Although we personally prefer charts for displaying data, SAC Story still offers a powerful Crosstab component. With that you have a whole range of options, allowing you to create everything from a fixed financial report to a dynamic analysis table.
Any Report needs filtering. Changing the time period, selecting a product or a location is essential to any Dashboard. SAC Story provides you with simple options to set up these so called Input Controls. You can choose between single and multiple Selection and can exclude members in design-time, so they don't even show up for users (pre-filtering).
You can bind Filters to individual charts or all charts and tables connected to the same data source - or even across multiple data sources with linked dimensions.
Define a color palette, choose border and border-radius. Change your font type, font size, color and more based on your corporate design and preferences.
We usually like to implement a design guide in our projects (if none has been setup already). Together with you, we go over each and every detail of a hypothetical dashboard, so that every report follows the same style. You could say every report should speak the same color and style language. SAC supports this approach by giving you the opportunity to save one or multiple Layouts. The layout will be created based on your individual design guide and can be applied to any new and old dashboard, to make sure you get the same look and feel without much hassle to check the design guide every time anew.
It’s the last 20% for advanced interactive features, small parts of Business Logic and styling that you will need the Advanced Mode of the Story Designer for.
Want to group two categories together in a dropdown? Need things to change according to a fixed day in the month?
Then the Advanced Mode will be the right fit for you. It does require script knowledge though, so you might want to ask your friendly neighborhood IT-Professional.
Don’t be afraid to try out the Advanced Mode, as the Story 2.0 Update lets you toggle the Advanced Mode seamlessly on and off. Prior to the unified Story Update, the Advanced Mode was its own tool called Analytics Designer.
A pretty default case for any modern dashboard is to have a button that toggles between views or shows a popup. To implement such behaviors in SAC Story, you’ll need to code those interactions within the Advanced Mode.
Furthermore it lets you create powerful scripts that react to events such as a user clicking on data in a chart or the user changing the page.
Coding and designing intuitive interactions is what gives SAC Story the edge over other Dashboarding Tools like Salesforce Tableau or Microsoft PowerBI, where custom interactions are either hard or impossible to implement.
Given enough time and effort to develop a SAC Story, the result will be a polished Web-Application with delightful little UI-/UX-Details. If done correctly, Scripts will allow you to make previously thought complex and unintuitive interactions flow seamlessly throughout the Report.
If you thought that scripts in the Advanced Mode take your reports to another level, let’s talk Custom Widgets. Did you ever need a specific visualization that the SAC does not offer? Believe us, this rarely happens, but there is a solution for this too. Custom Widgets allow for the creation of a visualization tailored to your needs. Complete with interactions and data access from all regular SAC Models. The result might be a complex chart, a more complex table or something else entirely, like a KPI tile.
Speaking of tiles, we actually developed a SAC Custom Widget for an advanced KPI tile that displays YTD comparisons and a time series out-of-the-box. No more creating 50+ elements for a KPI tile and duplicating those to have multiple tiles.
For those little touch ups that add a lot to the polish and the look-and-feel of any report you can utilize the CSS component of SAC Story Advanced Mode. This lets you change the default appearance of elements for example setting the default text color for all text elements.
Defining your own CSS classes will help you change things around dynamically, like changing the text color or border of a button the user just toggled.
Though the SAC allows you to to write CSS, note that it is unfortunately strictly limited to a few selectors (elements that you can style) and properties (like text color, size or border-properties). So the SAC CSS is only a subset of proper CSS and does not allow you to position elements, create beautiful animations or target SAC’s default elements.
We hope that this will improve in the future as we are getting tired of our developers complaining that they could make this dashboard even more perfect if they only could write proper Javascript or CSS.
Once the SAP Analytics Cloud has been technically implemented, users trained, and the first stories...
A new year has begun and 2024 is now behind us. It was an exciting year full of innovations and...
In the original SAC stories (Classic Experience), there were a variety of no-code functions that...
» Jan 10, 2025 SAP Analytics Cloud Themes and Templates for more beautiful dashboards
» Jan 7, 2025 SAP Analytics Cloud annual review 2024
» Nov 26, 2024 Implementing SAP Analytics Cloud interactions with no-code
» Oct 4, 2024 How to effectively measure user adoption in SAP Analytics Cloud
» Oct 18, 2024 German SAP User Group Conference 2024: Exciting insights into data and analytics
More Blogs» Jan 10, 2025 SAP Analytics Cloud Themes and Templates for more beautiful dashboards
» Jan 7, 2025 SAP Analytics Cloud annual review 2024
» Nov 26, 2024 Implementing SAP Analytics Cloud interactions with no-code
» Oct 4, 2024 How to effectively measure user adoption in SAP Analytics Cloud
» Oct 18, 2024 German SAP User Group Conference 2024: Exciting insights into data and analytics
+