icon next to the dimension name, select Format, and then select
the appropriate data type from the list.
After you connect to a data source, Envision attempts to classify data either as a Dimension or Measure, labels the data, and establishes a data type. However, you may want to change the data types of dimensions, modify the dimensional element labels, or rearrange the order of appearance (in case of String data type dimensional elements only).
You can also create custom dimensional values in a dimension based on a computation or formula and add them to the existing list of dimensional elements, and modify the limits in query results using the .ini file.
Changing the data type of any dimension
· In
the Dimensions pane, click the icon next to the dimension name, select Format, and then select
the appropriate data type from the list.
Editing a dimension label
· In the Dimensions pane, double click a dimension name, specify another name for the dimension and press Enter.
Editing a dimensional element label of string data type
1. In
the Dimensions pane, click the 
icon next to the dimension name and then mouse-over
the individual dimensional elements or values.
2. Again,
click the icon to edit a dimensional
value label.
3. Specify a new value for the label and press Enter.
The edited label is now displayed.
4. Click
the icon to save the changes
that you have made to the label.
Rearranging the dimensional elements of string data type
1. In
the Dimensions pane, click the icon next to the dimension name and then mouse-over
the individual dimensional elements or values.
2. Click the up or down arrows to move the dimensional elements up or down the list.
Adding custom dimensional values
1. In
the Dimensions pane, click the icon next to the dimension name to switch to 'edit' mode.
2. Click
the icon and then select
User Defined Dimension Item.
3. In the User Defined Dimension dialog box, specify a name for the new dimensional element.
4. Specify a formula for the custom dimensional value and then click OK.
Optionally, click Cancel to discard the changes that you have made.
Modifying query results in ba.ini file
Add the following code to the ba.ini file:
[DATAENGINE]
commitBlockSize=500000
fetchSize=1000
maxResultCount=10000
maxDimValueCount=1000
maxPivotCount=30;
Max Result Count
All queries that get data from the engine are limited by this number. For example, in a Line chart, the number of points will be limited to 10,000 even though the number of data records in the database may be higher.
Max Dimension Value Count
When you expand a Dimension to see the dimensional values, the maximum number of values that are displayed are 1000. In order to see any other value, you must search for that value by using the keyword.
Max Pivot Count
When a Legend dimension is involved, the maximum number of legend items that are displayed is limited to 30. For example, if you drop a dimension with 100 values into Legend dimension, 30 legends are displayed as opposed to 100 legends.
It is recommended to pre-determine the appropriate data type with respect to dimensions and measures for performing analysis. If you arbitrarily change the data types of measures, the report may not display correctly. For example, if there exists a field that contains dates, Envision may incorrectly identify the Date field as an Integer.