Introduction SAP Analytics Cloud live queries are often described as real-time and push-down, but what actually happens behind the scenes when a user opens a live story or analytic application? Understanding the execution flow – from CDS views in S/4HANA, through BW Query runtime and RSRT, all the way to SAC- helps developers design performant models, troubleshoot issues faster, and
S/4HANA Embedded Analytics introduces a layered analytics architecture built on Core Data Services (CDS). One of the most common sources of confusion for SAP BI architects and developers is the distinction between I_ views, C_ views, and 2C_ queries. These artifacts serve different purposes, target different consumers, and follow clear modeling rules. Misunderstanding
Choosing between Live and Import (Load) connections in SAP Analytics Cloud (SAC) is one of the most critical architectural decisions organizations face when building analytics, planning, and reporting solutions. This choice impacts performance, data governance, security, scalability, and total cost of ownership. Despite this importance, the topic is often oversimplified. This guide provides a clear, technical, and practical explanation of
In today’s dynamic business environment, uncertainty is the only constant. Therefore, organizations need robust tools to anticipate potential outcomes and make informed decisions. SAP Analytics Cloud (SAC) Compass is a native feature designed to help planners and analysts simulate the impact of uncertain drivers, providing a probabilistic view of key
Master the use of popups in SAP Analytics Cloud with this practical guide. Understand when to use Story Popups vs. Page Popups, how to configure them, and boost your dashboard interactivity without sacrificing user experience.
By leveraging the power of Theme Builder and integrating JavaScript and CSS, users can seamlessly tailor their dashboards’ appearance to align with specific brand guidelines and aesthetic preferences.
What is Extended Planning and Analysis (xP&A)? Briefing: The Extended Planning and Analysis is a prepackaged content for SAP Analytics Cloud designed to establish a simplified, comprehensive planning process by bringing together financial, supply chain, and workforce planning. By creating one connected plan across lines of business, they can strengthen
SAP Analytics Cloud Calendar Features and API’s Workflow Organization (Calendar) Use the SAP Analytics Cloud calendar to organize your workflows with calendar events: You can create different types of tasks and assign people to work on them and others to review the work. You can use processes to manage multiple
Live connection (Online) and Import connection (batch) with SAP Analytics Cloud SAP Analytics Cloud enables access to on-premise and cloud data sources using two main connection types: Live connection (Online) and Import connection (batch). Both access data from a variety of source systems. Live (Online) connection: With a live (online)
How to export reports to Excel, CSV and PDF with SAP Analytics Designer In this blog, we explain how to export data in the widgets within the analytics application to Excel, CSV, and PDF. This method is simple and easy to use. In a follow-up blog, we will cover an
How to use the setHierarchyLevel() API to set a hierarchy level of a dimension with SAP Analytics Designer In a previous blog, we discussed how to use addDimensionsToRows(), and addDimensionsToColumns() in the EPM Report Developer Analytics Application. The same analytics application also includes a property value and a hierarchy level
Show and hide report filtering widgets on tabstrip according to tab selection with SAP Analytics Designer In a previous blog we mentioned special filtering requirements. We had to filter the flow as a property of the dimension only on balance sheet related tabs. And the Intercompany dropdown filter only on
How to use the removeDimensionFilter() and setDimensionFilter() API’s with SAP Analytics Designer The removeDimensionFilter() and setDimensionFilter() API’s are used to filter either on members or properties of a dimension on tables and charts with SAP Analytics Cloud Analytics applications. In this blog we used an example that sets filters from
How to use the getDimensions() and getDimensionProperties() API’s with SAP Analytics Designer. getDimensionProperties() Returns all available dimension properties of the specified dimension of a data source. Only supported on data sources from table widgets. Mandatory parameter is dimension name. In this blog we will be sharing an example use case
How to use the getHierarchies() and setHierarchy() APIs with SAP Analytics Designer In this blog post, we will give a comprehensive example of using the getHierarchies() and setHierarchy() APIs with SAP Analytics Designer.The getHierarchies() API is used to return the description and ID of all hierarchies of the dimension. While
How to Use the getDataSource() API in SAP Analytics Designer The getDataSource() function returns the corresponding data source from a Table, Chart, Geo Map Layer, or from a data frame with data binding. If the data binding has no data source, it returns undefined. Overview of getDataSource() Methods: There are
How to use the getResultSet() APi with SAP Analytics Designer The getResultSet() API returns result sets. A result set consists of property-value pairs. The property is a dimension name. The value contains information about the member or measure. You can get an array of result sets with getDataSource().getResultSet(). We are
How to use the getPlanning() API and its methods and functions with SAP Analytics Designer The getPlanning() API returns the Planning object of the table. If the table links to a model (data source) that does not support planning, it returns undefined. This blog provides an overview of all functions
Something isn’t Clear?
Feel free to contact us, and we will be more than happy to answer all of your questions.