V
value expression
An expression in multidimensional expressions (MDX) that returns a value. Value expressions can operate on sets, tuples, members, levels, numbers, or strings. For example, set value expressions operate on member, tuple, and set elements to yield other sets.
varbinary data type
A SQL Server system data type that holds up to 8000 bytes of variable-length binary data.
varchar data type
A SQL Server system data type that holds variable-length non-Unicode data with a maximum of 8000 characters.
variables
Defined entities that are assigned values. A local variable is defined with a vertical filtering
Filtering columns from a table. When used as part of replication, the table article created contains only selected columns from the publishing table. See also filtering, vertical partitioning.
vertical partitioning
To segment a single table into multiple tables based on selected columns. Each of the multiple tables has the same number of rows but fewer columns. See also partitioning, vertical filtering.
very large dimension
In Analysis Services, a dimension that contains more than approximately five million members and fewer than approximately 10 million members. Special techniques are used to process very large dimensions. See also huge dimension.
view
A database object that can be referenced the same way as a table in SQL statements. Views are defined by using a SELECT statement and are analogous to an object that contains the result set of this statement.
view generation
A repository engine feature that is used to create relational views based on classes, interfaces, and relationships in an information model.
virtual cube
A logical cube based on one or more regular cubes or linked cubes.
virtual dimension
A logical dimension that is based on the values of properties of members of a physical dimension. For example, a virtual dimension that contains the colors red, green, and blue can be based on the Color member property of a product dimension. See also dimension, member, member property.
visual total
A displayed, aggregated cell value for a dimension member that is consistent with the displayed cell values for its displayed children. The visual total of a cell can vary from the actual total if some children of the cell are hidden. For example, if the aggregate function is SUM, the displayed cell value for Spain is 1000, and the displayed cell value for Portugal is 2000, the visual total for Iberia is 3000.