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

InsightCubes Logo

Featured Blogs

Blog Filter

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 …

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 and measures in Tables and Charts, current hierarchal …

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 users to configure the content of the output. We discussed the simple way of exporting in …

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 will be discussing an advanced method of exporting to Excel, CSV and …

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 …

In this blog we will be explaining how to use: addDimensionToColumns() adds to dimension to the Columns axis, at the specifies position, If no position is specified, then the dimension is added as the last dimension of the Columns axis. addDimensionToRows() adds to dimension to the Rows axis, at the …

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 sorts all your values “horizontally/vertically” and “ascending/descending”, the Sort & …

getMembers() API getMembers() method returns a set of members from a specified dimension. This method conducts a “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 a condition (example: if statement) to filter the returned …

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