InputScale Property
The InputScale property sets or returns a scale value used to convert column numbers from decimal values to integer values.
Syntax
Column .InputScale
Applies To
Discussion
Use this property for data types other than Float to convert decimal values to integer values. The value you supply defines how source values are multiplied as they are read from your data source.
For example, if this property is set to 2, Transformer writes the source value, 94.5, to the cube as 9450; that is, 94.5*10^2. PowerPlay® then displays the value 9450.
Use the OutputScale and FormatDecimals properties to change scaled values back to their original values. The OutputScale property specifies how the source values are divided when PowerPlay is run. In brief, the InputScale property removes decimal positions for use in calculations, and the OutputScale and FormatDecimals properties put them back.
For example, if OutputScale is set to 2, PowerPlay shows a value of 95 (rounded). If the FormatDecimals is set to 1, PowerPlay shows a value of 94.5.
The range for scaling values is from -16 to 16, which represents 10**-16 to 10**16.
Default: 0
A COM exception is thrown in error situations. The message that is passed with the exception varies depending on the error situation. For example, an exception occurs on Update() if outside the boundaries -16 to 16.
Type
Long
Access
Read/Write
Examples
objDataSource
= objModel.DataSources.Add(xtrObjectType.trFlatFileDataSource)objColumn.InputScale
= 0