At times there is a requirement where user wants to see the drill down option (like tree node) . Like users wants to see the customer transactions or vendor transaction or some service users wants to see the sales data based on region or specific date. Similarly I am taking an example of existing Trial balance report where i will add the drill down option for the dimension set.
Lets open the trial balance report : navigation – GL > Reports > Detailed trial Balance
Scenario: User wants to see the drill down option for the “Primary financial dimension set’ option.As below in highlighted.
So here is the work around.
The highlighted is selected which is for the main account to be shown which is under the group of ‘PrimaryFocus_0’ which is our primary financial dimension set group.
So checked the ‘Hide’ property and mark the ‘Display can be toggled by this report item’ and set the value to ‘PrimaryFocus’ which is our group name ‘field’ and finally deploy it.
The result look like this below