instantOLAP Online documentation 2.2.7 - Trim

Trim

Type

Constant Boolean

Since

1.2

Description

With the Trim-property you can force the loader to trim the IDs generated by the SQL-query after they have been read out of the query-result. Use this property to avoid unnecessary white spaces after the IDs if the if database produces them.

Examples

Trim = "true"

Trim = "false"

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Query properties
Chart properties
Configuration properties
Configuration
Database
Table
Column
Alias
Link
Link-Expression
Table-Expression
CSV-Source
CSV-Column
XMLA-Source
Dimension
Grant
Key
Key-Attribute
SQL-Keyloader
Database
Distinct
Format
Ignore Hierarchy Violation
Level Name
Mode
Null-Value
Order-By-ID
Parent Attribute
Parent Format
Parent Null-Value
Parent SQL-Expression
Parent Trim
Recursive
SQL-Check
SQL-Expression
SQL-Order
SQL-Order Descending
SQL-Where
Trim
SQL-Attribute
CSV-Keyloader
CSV-Attribute
Time-Keyloader
Time-Attribute
XMLA-Keyloader
XMLA-Attribute
Number-Keyloader
SQL-Cube
SQL-Fact
SQL-Dimension
CSV-Cube
CSV-Fact
CSV-Dimension
XMLA-Cube
XMLA-Fact
XMLA-Dimension
Formula
File-Cache
File-Store
Include
Expressions
Formats
SQL-Expressions