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

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

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