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

InsightCubes Logo

Featured Blogs

Blog Filter

InsightCubes 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 Cloud Consolidation components, from Data Action Triggers, Stories, and Analytic Applications in a …

After the trial balances have been imported from source systems, for all the subsidiaries and affiliates, we can trigger the automated process of “preparing” the data 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, the ownership structure needs to be maintained. In this blog, we will briefly describe the ownership manager interface and show you how to add new companies to scopes, assign their ownership methods and ownership percentages. This activity doesn’t need to be done every month. If the …

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

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

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: 1. Expand/Collapse global filter pane In figure 1.1 the Global Filter Pane is collapsed, allowing the Animation bar, Logo and dynamic text …

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

Blog Categories

Recent Posts

Share this Page!

Share this with your network.

Want to Know More?

Get In Touch

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