Dropdown button automatically changes table columns

Hello @Fdsramires97 ,

You can easily look at the code implemented in any of the Demo.

Steps:

1. Open Any Demo Analysis having that OLAP Table Component with the functionality.
2. Open the analysis sheet in EDIT Mode.
3. Check the Table Title and Dimensions by Right Click on the OLAP Table>> Settings.
4. B1811417 44.3 KB

4.Also check the Variables used and the Code for the same by Clicking on

Sheet Analysis Settings>> Variables>>(Click the variable you want to see)

B21329598 30.7 KB

I dont know your source System data.

Just read the code and you can easily implement the same for your source system data by mentioning the Table Names and Alias.

Hope this helps. Thank You.

Warm Regards,

Jayanta

For this functionality we are always using 2 variables. 1x for the name of the Column & 1x for the PQL code. You need to make sure that both variables are filled when selecting in the dropdown (functionality 'Set variable') and then ultimately these variables need to be added in the component title (variable for the name) and the dimension (variable for the PQL code). Make sure you are using the correct syntax for the variables when including them <%=variable_name%>

Best,

Kevin

Hello Francisco,

see below a detailed example on how to configure the button dropdown

1 Go to the Edit mode(required Analyst access)

2 Create 2 variables (i.e. <%=ButtonDrilldown1%> and <%=ButtonDrilldown1_TEXT%>

3 Add component Button drilldown

4 Set it as "Set Variable" and select the variable

5. Add the Variable <%=ButtonDrilldown1_TEXT%> to the Title so it changes once you change the value of the dropdown

6. Add the variable in the OLAP table as dimension <%=ButtonDrilldown1%>

Best,

Gabriel

Hi @gabriel.okaba11 , Is it possible to do exactly the same that you have described in Celonis Views?