Builder/Browser How To

How To Nest Dimensions
To nest dimensions In the dimension bar, select the dimension you want to nest. Do one of the following: To nest along the rows, drag and drop the dimen...
Mon, 2 Mar, 2020 at 10:22 AM
How To Subset Items In a Dimension
Show Only Items You Select Hide Selected Items from Table Views Search Code or Label Fields Using Reduce Display Members of a Group (Drilldown) Method 1 To...
Mon, 2 Mar, 2020 at 11:19 AM
How To Create A Table (IVT) From a CSV file
You can build a Beyond 20/20 table from comma-separated values (CSV) source files.  This exercise shows you how to create a table from an CSV source file. ...
Tue, 12 Mar, 2024 at 3:55 PM
How To Transfer Numbers In Source Fields Into The Cells of a Table
Numeric fields can be used in 3 ways when building a table using the Beyond 20/20 Builder. Using the field as a weight field (When Your Source File Has Onl...
Tue, 17 Nov, 2020 at 1:04 PM
How To Define Missing Values In Your File And Table
Sometimes source files can contain non numeric values that represent information about the data, e.g. data is not available for that datapoint. This informa...
Tue, 17 Nov, 2020 at 12:12 PM
How To Change Table To Read-only Mode or Read-Write Mode
Sometimes when you create tables to send to other users you do not want the users to be able to modify the IVT files.  You can lock the IVT files so that t...
Tue, 17 Nov, 2020 at 12:46 PM
How To Adjust Cell Values
Adjusting Cell Values After you have created a table, you can apply various computations to the data to adjust the cell values. You can round off or scale ...
Tue, 17 Nov, 2020 at 4:28 PM
How To Set Labels to Display By Default
When you bring labels into a dimension from a CSV file or by adding a field and typing them in, they do not show in the table by default. To get them to sho...
Thu, 4 Jan, 2024 at 4:41 PM
How To Link Codes and Labels From CSV File To Dimension
There are 2 ways to bring codes and labels from a CSV file into a table (IVT). Method 1 - Import Labels Into The Table After the Table is Built: Preparing...
Thu, 4 Jan, 2024 at 11:29 AM
How to Build a Table Using Source Fields With Long Labels
When building tables usually dimensions consist of a set of standard codes with associated labels. These codes are usually short and do not exceed the Beyon...
Tue, 24 Nov, 2020 at 4:03 PM