Skip empty cells and Skip consolidated cells properties

Use the Skip empty cells and Skip consolidated cells properties to skip null cells and to skip consolidated cells in Cognos®f TM1 connector files.

Skip empty cells

This option is enabled by default.

  • If the cell type is Numeric, cells that have a value of 0 are skipped.
  • If the cell type is String, cells that have no value are skipped.

Skip consolidated cells

This option is enabled by default. If you plan to write the extracted data into another cube, enable this option because consolidated cells cannot be written.