Is there a way to toggle on and off a hyperblock? Our report users would sometimes like to see the detail given by a certain dimension, but predominantly wouldn't want to see this detail See example - toggle on and off the highlighted hyperblock,
While you cannot toggle a hyperblock on or off, you can set a filter that is controlled by a variable, so the filter can be toggled on and off.
The filter, when on can limit the hyperblock to only the top level element and,when off all elements included in the structure selection will be used.
For on the variable is set to TRUE, for off the variable is set to FALSE.
Though Tom’s suggestion is a great method for controlling what’s being displayed in a hyperblock, I think the solution in your case is far more simple; hide/unhide columns using a variable on a button click.
Thank you for your response Ibrahim. I think in this situation I do want to filter the hyperblock in order to collapse the rows. In this example there might be two groups associated with the hyperblock I want to hide. If I hide the rows I think they will still show up rather than collapsing to one group. I am interested in your solution for another application. Could you tell me how to hide rows or columns with a button click? Is there a certain action that I can use? Thanks again!
So, I just need create a filter for this hyperblock with options of TRUE/FALSE. Where if it's TRUE it is the highest level of hierarchy. If False it is the base level (or desired level)? Do you have an example that I could see on how to create this association between TRUE/FALSE and the levels of the hierarchy? Thanks so much for your help!
given the amount of nested hyperblocks - have you considered using a slice?
Create a variable that will have the value of TRUE or FALSE
Then use that variable in the formula for the Enabled property of the specific filter.
You must supply someway for the user to perform the action of changing the value of the variable.
You may have additional filters to suppress 0 rows so carefully construct the AND and OR structure.
I think this will work with a slice or a separate hyperblock.
I have but in this case I have numerous calculations that I am performing within the hyperblock and I wasn't certain how to perform these calculations within the hyperblock. Is there a way to do this?
Thank you Tom! This is very helpful. It looks like a very promising solution - I'm excited to try it. Thanks again!
One way to control the level of the hierarchy you want to display with is using attribute-based filters.
You can use attributes like Level Number or Children Cardinality to control the level you want to display.
For example, Level Number = 0 displays top elements only. Children Cardinality = 0 display all base elements.
You create filters controlled by variables (as Tom explained in another reply) and each filter contains the specific criteria.
You can right click on the header of a row or column and select the option Rows... or Columns... For example, this is what you see when you right-click on the J column and then select Columns...:
The "Variable" option allows you to link the width of the column with a variable. Then you can use an action to set a value to the variable linked to the column.
I just applied this in a couple reports and it works perfectly - thank you!
Thank you for the additional information. I tried to implement this solution and am having issues with the Structure Selection. I had previously selected the "Elements underneath MASTER Tope Level (base elements)." When I enable the filter as you showed above nothing returns in the hyperblock (or in the report). Do I need to select something different for my Element Caption in order for this to work?
