Using the getDimensions() and getDimensionProperties() API’s with SAP Analytics Designer
How to use the getDimensions() and getDimesnionProperties() 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 for the getDimensions() and getDimensionProperties() […]
Using the getHierarchies() and setHierarchy() APIs with SAP Analytics Designer
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 setHierarchy() is used to set […]
Overview of the getDataSource() API and related methods and functions with SAP Analytics Designer
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 undefined is returned. There are […]
Using the getResultSet() API with SAP Analytics Designer
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 getDataSource().getResultSet(). We are using an […]
Overview of the getPlanning()API and related functions with SAP Analytics Designer
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 all the functions used with […]
Consolidation Extension for SAP Analytics Cloud – IC Matching and booking
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 staging method of consolidation will […]
Consolidation Extension for SAP Analytics Cloud – Detailed Currency Conversion
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 by the group companies (subsidiaries, […]
Consolidation Extension for SAP Analytics Cloud – Automated Eliminations and Adjustments (part 4)
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 for SAP Analytics Cloud will treat […]
Consolidation Extension for SAP Analytics Cloud – Automated Eliminations and Adjustments (part 3)
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 process will eliminate the carrying […]
Consolidation Extension for SAP Analytics Cloud – Automated Eliminations and Adjustments (part 2)
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 note, that SAP Analytics Cloud […]