UAE: ✆+971 58 5616 616       USA: ✆+14099168409        ✉  info@insightcubes.com

Featured

SAP Analytics Blog

Blog Filter

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: Live Connection (online) does …

How to export reports to Excel, CSV, and PDF with SAP Analytics Designer In this blog, we will be discussing how to export data in the widgets within the analytics application to Excel, CSV, and PDF. This method is the easiest and simplest to apply, and in a subsequent blog, …

In this blog, we will describe how to create new Currencies & Rates which will allow us to convert the financial statements from the Local Currencies of the Entities to the different reporting currencies and group reporting currencies per specific flow. Creating and Assigning new Currencies The first activity in …

InsightCubes’ SAP Analytics Cloud Consolidation Landing Page Dashboard is a navigational menu designed to provide easy access to all the Cloud Consolidation extension stories and analytic applications in one interface. The home page consists of links to all the SAP Cloud Consolidation components, from Data Action Triggers, Stories, and Analytic …

After the trial balances have been imported from source systems, for all the subsidiaries and affiliates, we can trigger the automated process of SAP data preparation for consolidation purposes. In this brief blog, I will describe the few steps that are automated by the system to ensure that the data …

Prior to running consolidation, you’ll need to know the process for managing ownership structure. In this blog, we will briefly describe the ownership manager interface and show you how to add new companies to scopes, and assign their ownership methods and ownership percentages. This activity doesn’t need to be done …

Using the Journals dashboard with SAP Analytics Designer The journal interface in SAP Analytics Cloud was built using SAP Analytics Designer, allowing entry of adjustments for specific audit trail (type – manual) to impact the standalone or consolidated balances. These debit and credit balances can be manually entered or uploaded …

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 addDimensionsToRows(), and addDimensionsToColumns() in the EPM Report Developer Analytics Application. In the same analytics application there is 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 and its methods and functions with SAP Analytics Designer The getDataSource() function is used to return the corresponding data source whether from a Table, Chart, Geo Map Layer, or from a data frame and data binding, if the data binding has no data source …

How to use the getResultSet() APi with SAP Analytics Designer The getResultSet() API is used to return 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 …

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 is linked to a model (data source) that does not support planning, then undefined is returned. This blog is an overview of …

In this blog we will explain step by step how-to use the Cloud Consolidation Extension for SAP Analytics Cloud as an End to end process. Although you can run all the processes in one click through the All in One data action trigger, however, we will show the execution of …

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. The automated eliminations were covered in a series of blogs (blog 1, blog 2, blog 3, blog 4) and subsequent blogs regarding scope and ownership changes, in addition to …

In this brief blog, I will describe the different methods of conducting detailed currency conversion using Cloud Consolidation Extension for SAP Analytics Cloud. This will be a preliminary step to the “integration” logic of the Consolidation process, which will be discussed in subsequent blogs. When the Financial data that is reported …

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 …

In the prior blog, I described how the detailed currency conversion works on the Cloud Consolidation Extension for SAP Analytics Cloud. In this blog, I will describe the automated eliminations and adjustments that will happen once the user triggered the consolidation logic. Due to the size of the content, i will break the Automated Elimination and …

  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 me roughly 7 months to develop everything, and it works beautifully. We can customize the interfaces any way we want using SAP Analytic …

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(). However in this blog we will be using getMembers() and specifying …

Let us say you want to add a member to a dimension, in the following example we will be using a dimension called scope and a member along with the attributes will be added, the attributes will define the member. To use the planning APIs you must select a planning …

Some of the functionalities InsightCubes used for ease of navigation, filtering, and best use of space in dashboards.In this blog post you will find the following technical functionalities: Read on to learn exactly how to expand and collapse filters, switch to the table/chart view, and use the Library Popup. 1. …

Intercompany Matching Dashboard The model is designed to allow the group company subsidiaries to match their intercompany balances against values booked against them by their partner companies within the group. Below is more information about our intercompany matching dashboard. All dashboards include a global filter allowing the user to select …

InsightCubes Cloud Consolidation – Central Dashboard Centralized interface for consolidation managers to review standalone and consolidated financial statements for all the group companies, trigger currency translations, automated eliminations, and review the results based on their selections. All dashboards include a global filter allowing the user to select the following: Selections …

Blog Categories

Recent Posts

SAP Analytics Cloud Calendar

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

Read More »

Landing Page Dashboard

InsightCubes’ SAP Analytics Cloud Consolidation Landing Page Dashboard is a navigational menu designed to provide easy access to all the Cloud Consolidation extension stories and

Read More »

Share this Page!

Share this with your network.

Want to Know More?

Get In Touch

Something isn’t Clear?


Feel free to contact us, and we will be more than happy to answer all of your questions.