I wonder if anyone can help me to create a script example for the following.
I have created the following table with customized bins that can be changed dynamically by the user
I made the bins as hiearchies in the cube by using data input, so that the users can dynamically change the bin sizes in the dashboard.
I want to create a script where the unique name of the bin hierarchie (Bin 1-5 in this example) can dynamically change based on what the user enter as bin value in the dashboard.
In this example i want to change the hierarchy value name in the table from Bin 1 --> Bin 1: 1-19, for instance, and so on for the rest of the bins.
Does anyone know how I can script this so the hierarchy naming is changing dynamically? And if yes, can anyone help me with an example? I am a bit stuck…
I have tried to use HierarchyService’s getHierarchyById method to get the hierarchy you want without any success.