✆+971 58 5616 616    ✆+1 409 995 3618   ✉  info@insightcubes.com

Using the setHierarchyLevel() API with SAP Analytics Designer

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 filter for the Account dimension. In this blog we will be covering the hierarchy level filter using the setHierarchyLevel() API.

To set up a hierarchy dropdown, first create and manually fill the dropdown with the hierarchy levels.

Hierarchy dropdown manually filled

Then add the below code to the dropdowns onClick fx

Hierarchy level is reflected on run time on the table in line 6

Recent Posts

SAP Analytics Cloud Calendar

SAP Analytics Cloud Calendar Features and API’s Workflow Organization (Calendar) Use the SAP Analytics Cloud calendar to organize your workflows with calendar events: You can

SAP Analytics Cloud Data Connections

Live connection (Online) and Import connection (batch) with SAP Analytics Cloud SAP Analytics Cloud enables access to on-premise and cloud data sources using two main

Insightcubes Cloud Consolidation Extension for SAP Analytics Cloud – Landing Page

Landing Page Dashboard

InsightCubes’ SAP Analytics Cloud Consolidation Landing Page Dashboard is a navigational menu designed to provide easy access to all the Cloud Consolidation extension stories and

Get in Touch

Learn more and ask us About Our Cloud Consolidation Solution

Share This Post

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.