Skip to Content
Author's profile photo Former Member

Dynamic Sections and Breaks

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.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Shankar Jinka
      Shankar Jinka

      Hi Ryan,

      Thanks for your post. I am looking for similar solution. With provided steps i could not able to do. Can you please explain more elaborately. by taking with example that would be more helpful.

      Thanks in advance.

      Author's profile photo Former Member
      Former Member

      Hi Ryan,

      Thanks, it is a great idea. Just one question: When creating the Input Control you have by default the "All Values" entry, which will not make sense.

      Is there a way to eliminate that "All Values" default?

      Thanks in advance

      Author's profile photo Shankar Choudary
      Shankar Choudary


      You can hide "All Values" option in input controls from BI 4.1 SP3 onwards.