When working with planning and forecasting using the SAP Analytics Cloud Excel Add-in, a frequent challenge is managing Actuals and Forecast data together without breaking formulas or requiring constant manual updates. Previously, in our blog SAC Excel Add-in Rolling Forecast, we described how to build rolling forecasts using the SAC
Traditional annual budgets can’t keep up with today’s fast-moving business demands. Companies need forecasting that adapts in real time, allowing finance teams to make informed decisions as actual data arrives. Using the SAC Excel Add-in, rolling forecasts in SAP Analytics Cloud enable this agility by continuously extending the planning horizon
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
How to bookmark selections with SAP Analytics Designer The Bookmark Set allows users to bookmark the current state into multiple versions of the same dashboard and easily switch between different scenarios within the application with SAP Analytics Designer. Bookmarks save all the current filtering selections in the dashboard from dimensions
Something isn’t Clear?
Feel free to contact us, and we will be more than happy to answer all of your questions.