✆+971 58 5616 616  ✉  info@insightcubes.com

InsightCubes Logo

Featured Blogs

Blog Filter

How to use the getHierarchies() and setHierarchy() APIs with SAP Analytics Designer In this blog post we will give a comprehensive example on using the getHierarchies() and setHierarchy() APIs with SAP Analytics Designer.The getHierarchies() is used to return the description and ID of all hierarchies of the dimension. While the …

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 form 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() 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 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 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 Extension …

In the prior part of the automated eliminations and adjustments 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 eliminations carried out by the Cloud Consolidation Extension for SAP Analytics Cloud. Investment Elimination This automated …

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 …

Why not create a full fledged consolidation solution that runs natively on SAP Analytics Cloud! 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 …

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 advanced exporting of reports to Excel, CSV, & PDF with SAP Analytics Designer In this blog we will be discussing an advanced, and more detailed method of exporting data in the widgets within the analytics application to Excel, CSV and PDF that provides further options to end …

How to export reports to Excel, CSV, 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 we …

Financial data reported by the group companies (subsidiaries, JVs and affiliates) is in the local currencies of these units. The Currency Conversion logic converts the local currencies of these companies into any set of reporting currencies and the group currencies of the scopes. SAP Analytics Cloud provides a standard currency …

How to use the addDimensionToColumns(), addDimensionToRows(), getDimensionsOnColumns(), and getDimensionsOnRows with SAP Analytics Designer 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 brief overall explanation about the EPM …

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 …

Lets 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 API’s you must select a planning model …

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: Expand/Collapse global filter pane Switch Table/Chart View Library Popup 1. Expand/Collapse global filter pane In figure 1.1 the Global Filter Pane is …

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. This empowers group companies with reconciliation of their books among each other. All dashboards include a global filter allowing the …

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: Any …

Recent Posts