✆ UAE: +971 58 5616 616, ✆ USA:+14099168409,   ✉ 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

account configuration guide for the consolidation extension

Account Configuration Guide

Consolidation Extensions’ Account Configuration Guide The Account Configuration Guide serves as a preconfigured administrative tool designed to guide users with specific roles to effectively manage

Configuration Starter Kit

Consolidation Extensions’ Configuration Starter Kit The configuration of the Consolidation Extension for SAP Analytics Cloud can be conducted using a preconfigured toolkit. The purpose is

Audit Trail Configuration Toolkit for the consolidation extension

Audit Trail Configuration Toolkit

Audit Trail Configuration Toolkit Audit Trail Configuration Toolkit provides a comprehensive set of tools and resources to help developers easily configure the behavior of the

Scope configuration guide for the consolidation extension

Scope Configuration Toolkit

Scope Configuration Toolkit With our Scope Configuration Toolkit, you can take control of your consolidation scopes with confidence and precision. This interface makes it extremely

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

Something isn’t Clear?


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