Dynamic Sections and Breaks

[Former Member]

One of the major features in Webi is the ability to break the output data into logical Sections or Breaks. This is great for creating summarized views
based on a dimension, but what about being able to change what we are breaking on dynamically?

Turns out this can be done fairly easily.

1. Create a new report with a table that contains 2 or more dimensions you would like the option to break on.
2. Create a variable named SectionSelection and set it to empty string.
3. Create an input control and give it 1 option for each dimension you want to be an option for breaking/sectioning.
4. Create a variable named Section and set it to the following logical operation:
   • =If [SectionSelection] = "name of first input control option" Then
     [dimensionName] ElseIf [SectionSelection] = "name of second input
     control option" ... etc...
5. Add a new column to the end of the table and populate it with your Section variable.
   • Optionally, you can hide the dimension, but be aware that if you do this, any other attempt to sort the table may not work as breaks na sections apply their own sorting whenever they are created/updated
6. You now have the option to either
   • Break the table - Have 1 continuous table that is organized into sections
   • Section the table - Have the table repeated once for each section

   7.  If you are after Sections, Drag the variable out of the table and drop it above the table (this will automatically section out the report based on what
the variable contains). Otherwise, leave the tale as is and apply a break on the variable table.

Now, choosing a value form the input control will populate the variable column/section and the report will be automatically broken out and sorted accordingly.