By integrating R, SAP Analytics Cloud transforms data analysis into a more powerful and interactive experience. R, the versatile open-source language for statistical computing and visualization, enhances SAC’s capabilities, enabling users to create insightful, dynamic stories that reveal patterns and trends in ways standard charts cannot. What Is R? R …
Predictive insights are crucial in a fast-moving business landscape, yet human expertise remains essential. Machine learning in SAP Analytics Cloud integrates with augmented analytics and planning, enabling decision-makers to generate accurate, data-driven forecasts while keeping experts fully in control. The central theme of this approach is the harmony between advanced …
Turning data into decisions takes more than powerful tools-it takes structure. With SAP Analytics Cloud (SAC) and its Smart Predict capabilities, businesses can automate predictive modeling and embed AI-driven insights into everyday planning. However, technology alone isn’t enough. Success comes from following a clear project framework.In this post, we’ll unpack …
SAP Analytics Cloud offers the Smart Predict feature, enabling business users to uncover trends and make accurate forecasts using automated machine learning. Its predictive modeling capabilities, including Regression Models, help organizations forecast continuous outcomes such as sales, costs, or demand levels, turning data into actionable insights from the very first …
To stay ahead, businesses need to understand not only where they are but also where they’re heading. With SAP Analytics Cloud Smart Predict, forecasting future trends becomes effortless through intuitive Time Series Models – no coding or data science expertise required.In this post, we’ll explore how time series forecasting works …
Bringing Predictive Power to Business Users The future of business relies on prediction – understanding not just what happened, but what will happen next. Moreover, SAP Analytics Cloud Smart Predict brings this capability to every business user, making advanced analytics intuitive and accessible. Through its Classification Model, organizations can identify …
As organizations generate more data than ever before, the challenge is no longer access – it’s insight. Augmented Analytics in SAP Analytics Cloud bridges this gap by combining automated machine learning with intuitive business intelligence tools.Specifically, with Smart Predict, SAC empowers business users to forecast outcomes, identify trends, and make …
Predictive analytics isn’t just for data scientists anymore. Moreover, SAP Analytics Cloud brings its power to every business user through Predictive Scenarios – a feature that makes forecasting faster, smarter, and easy to use.With a Predictive Scenario, you get a guided workspace to build, train, and deploy predictive models that …
In today’s fast-changing business landscape, data science and predictive analytics are essential for smarter, faster, and more accurate decision-making. From weather forecasts to real-time navigation, machine learning is already part of everyday life. Similarly, with SAP Analytics Cloud, businesses can harness these technologies to transform data into actionable insights. The …
Introduction In the era of data-driven decision-making, organizations need tools that make analytics smarter and more intuitive. Consequently, SAP Analytics Cloud delivers exactly that through its Smart Features – AI-powered capabilities designed to simplify data exploration, automate insights, and enhance predictive accuracy. As a result, these Smart Features help organizations …
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 …
The Consolidation Monitor in SAP Analytics Cloud (SAC) by InsightCubes is a purpose-built financial consolidation solution designed to streamline the financial close process. It gives CFOs, controllers, and finance teams real-time visibility into end-to-end consolidation activities across every entity and scope. From data imports (SAP and non-SAP) to manual entries, …
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.
Compare InsightCubes' SAC Consolidation Extension and NDC’s SAP BTP solution to determine the best financial consolidation approach for your business. This in-depth comparison covers system architecture, integration, functionality, deployment, and cost-effectiveness to help organizations make an informed decision.
Journals in SAP Analytics Cloud (SAC) allow users to make financial adjustments, track audit trails, and ensure consolidation accuracy. This guide covers everything from journal entry creation to posting, locking, and reporting; empowering finance teams with full control over adjustments and compliance.
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.
Understanding the different types of journals for manual adjustments and the process from creating, saving to posting, locking, whether on standalone entity or consolidated level.
Explore how Consolidation Extension for SAC simplifies managing ownership structures, spanning from creating and editing scopes to assigning ownership methods and percentages for accurate consolidation.
Learn how SAP Analytics Cloud’s Consolidation Extension ensures data accuracy with system checks and referential integrity, ensuring proper configuration and identifying inconsistencies in design.
Detailed guide with automated checks and inconsistencies identification on account configure for automated eliminations, cascading behavior, currency conversions and other rules
Summary of all the features and automated system integrity rules included in identifying issues with designs covering scope, currency, account, audit, flow and other dimensions
A guided interface to help you configure the Audit Trail dimension and apply rules covering Copy opening, currency conversion, consolidation, staging, Journals, and others.
Effortlessly create, edit, or delete consolidation scopes, assign parent groups and reporting currencies, and activate staging—all through a user-friendly configuration interface.
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 …
Overcome SAC native limitations by creating unlimited rates and currencies, and assigning them to balance sheet movements and entities through a streamlined configuration interface.
Explore the Landing Page of the Consolidation Extension for SAP Analytics Cloud—where every consolidation process component is easily accessible and right at your fingertips.
Overview of the automated preparatory actions in the consolidation process following the upload of the trial balances from different source systems.
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 …
The Cloud Consolidation Extension for SAP Analytics Cloud streamlines the entire consolidation process, from data import and preparation to currency conversion, ownership management, intercompany matching, eliminations, and journal postings. In this blog, we explain step by step how to use the extension as an end-to-end process. While you can execute …
In a prior blog series, I discussed how the Cloud Consolidation Extension for SAP Analytics Cloud conducts detailed currency conversion and automates the eliminations through the consolidation process. A series of blogs (blog 1, blog 2, blog 3, blog 4) covered the automated eliminations. We will post subsequent blogs about scope and ownership changes, …
In this brief blog, I will describe the different methods of conducting detailed currency conversion using Cloud Consolidation Extension for SAP Analytics Cloud. This is the first step before applying the ‘integration’ logic of the Consolidation process, which we will cover in later blogs. Why Currency Conversion is Needed Financial data …
In the prior blog, I described in detail the automated elimination of investment and the treatment of equity accounts, along with the declaration of NCI and additional eliminations, between the holding company and its subsidiaries, under the same scope. In this part of the blog, I will describe how the Cloud Consolidation …
In the prior part of the automated adjustments and eliminations blog series, I described the automated elimination of intercompany transactions among companies within the same scope. In this blog part, I will proceed with additional automated adjustments and eliminations carried out by the Cloud Consolidation Extension for SAP Analytics Cloud. Investment Elimination …
In the prior part of this blog, I discussed the different consolidation methods and how the Automated eliminations and adjustments run on the attribute values of members across dimensions. In this part, I will describe the intercompany eliminations carried out automatically by the Cloud Consolidation Extension for SAP Analytics Cloud. Please do …
Introduction In the prior blog, I described how the detailed currency conversion works on the Cloud Consolidation Extension for SAP Analytics Cloud. This blog covers automated eliminations and adjustments triggered during consolidation. Due to the content size, I will break this topic into smaller, bite-sized blogs. InsightCubes Consolidation extension for SAP Analytics Cloud comes preconfigured with consolidation …
Overview of the consolidation extension for SAP Analytics Cloud, listing the functionalities, models, reports and other aspects, with links to every relevant blog Something that has the same functionalities and features as SAP BPC, but built natively on SAC… and then go beyond that and get creative! It took …
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 …
How to use the addDimensionToColumns(), addDimensionToRows(), getDimensionsOnColumns(), and getDimensionsOnRows with SAP Analytics Designer Wondering how to use the addDimensionToColumns() API?In this blog, we will be explaining how to use: Before we get into the technical part of adding and removing dimensions from rows and columns, I will start with an …
How to sort and rank reports with SAP Analytics Designer Sort/Rank reports in SAP Analytics Cloud The InsightCubes Cloud Consolidation solution provides users with sophisticated and flexible Sort & Rank capabilities to navigate their data sets. Sorting & Ranking with SAP Analytics Designer for the EPM report allows you to …
How to use the getMembers() API with SAP Analytics Designer. getMembers() method returns a set of members from a specified dimension. This method conducts “a round house trip to the backend”, which is a heavier process than the getResultSet(). In this blog, we use getMembers() with a condition (e.g., an …
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,
By integrating R, SAP Analytics Cloud transforms data analysis into a more powerful and interactive experience. R, the versatile open-source language for statistical computing and
Predictive insights are crucial in a fast-moving business landscape, yet human expertise remains essential. Machine learning in SAP Analytics Cloud integrates with augmented analytics and
Turning data into decisions takes more than powerful tools-it takes structure. With SAP Analytics Cloud (SAC) and its Smart Predict capabilities, businesses can automate predictive
SAP Analytics Cloud offers the Smart Predict feature, enabling business users to uncover trends and make accurate forecasts using automated machine learning. Its predictive modeling
To stay ahead, businesses need to understand not only where they are but also where they’re heading. With SAP Analytics Cloud Smart Predict, forecasting future
Something isn’t Clear?
Feel free to contact us, and we will be more than happy to answer all of your questions.