Setting Advanced View Properties

Advanced view properties contain additional settings which control how the view information is returned from TM1. The advanced properties are shown below:

 

TM1Connect - Advanced View Properties

 

hmtoggle_arrow1Use Member Names as Labels

The default behavior of TM1Connect is to use the member names of the column dimensions to generate the names of the columns. When temporal dimensions, such as Scenario, Period, Year, Month, etc are placed on columns, consider disabling the Use Member Names as Labels option in the advanced view settings, or assigning generic names to the columns using mappings (see Creating Mappings for details) rather than the default value (which is usually the member name). Consider the following view:

Temporal Dimensions

By default, TM1Connect will create column names that match the elements used to create the view. In the case of years, using 2010 and 2011 for a variance report could affect the application when the next year begins. Disabling the Use Member Names as Labels option will use the names Col1 and Col2 instead of 2010 and 2011, or rename the columns to Year1 and Year2, using mappings, such that the column names do not change over time.

hmtoggle_arrow1Record Limit

Record limit option allows for limiting how many rows will be returned once the view is constructed. This is valuable in preventing large queries from being transmitted to applications inadvertently, or when filtering criteria is not constrained sufficiently. Setting this value to zero (default) will disable row limit constraints.

 

hmtoggle_arrow1Skip Consolidated Values (batch mode only)

Skip Consolidated Values option is used only for scheduled exports in batch mode only. It is analogous to the Skip Consolidated Values option in TM1 Turbo Integrator extract views. It is important that this property be set in coordination with what information is to be extracted.

 

Note_200

NOTE: If a view is defined with consolidated values in the titles dimensions or has only consolidated members in the rows or columns, no data will be extracted during the scheduled export to the data file even if the values display properly on the screen when the view Preview is used.

 

hmtoggle_arrow1Skip Rule Calculated Values (batch mode only)

Skip Rule Calculated Values option is used only for scheduled exports in batch mode only. It is analogous to the Skip Rule Values option in TM1 Turbo Integrator extract views. This option will skip any measures which are calculated by rules. It is important that this property be set in coordination with what information is to be extracted.

 

Note_200

NOTE: If a view is defined with rule driven values in the titles dimensions or has only rule driven members in the rows or columns, no data will be extracted during the scheduled export to the data file even if the values display properly on the screen when the view Preview is used.

 

hmtoggle_arrow1Skip Zero Values (batch mode only)

Similar to the skipping of rules and consolidated values, Skip Zero Values also behaves in a manner consistent with TM1 view exports. Care must be taken when deselecting this option, especially with larger cubes, as this can explode the size of the export considerably if used improperly.