New Upload weather data from web services into TM1/Planning Analytics — Read the post →

Module 4: Test Case 4 – Cube Data Validate & Test Case 5 – Exporting Data

Test Case 4: Cube Data Validate

Validating that cube data is correctly loaded and matches between source and target is critical for accurate reporting and integrations.

Test Details

Name04 Cube Data Validate
CategoryTest Case 4
DescriptionExecute Process with Expected Params (pZeroOut = 1) — Resulting Clone cube has values as expected

Preconditions

  • TI process: Cub.Load General Ledger Clone From CSV
  • Data source: Ledger Clone Data.csv in the TM1 data directory

Test Execution

Set UpLeave blank.
ActionTest Type: Process Run | Target: Cub.Load General Ledger Clone From CSV
Parameter: pZeroOut = 1 (clear cube data before load)
Clean Up

Assertions

#NameTypeDetails
1TI Runs = SuccessCheck Action ResultOperator: Equals | Expected: Completed Successfully
2Cube Results as Expected, Net Income for 2024Compare Cell Cube ValueCell: General Ledger_Clone [Version=vs, Year=2020, Period=Year, Currency=Local, Region=1, Dept=1, Account=Net Income, Measure=Amount] | Operator: Equals | Expected: -3519931.08
3Compare Source to TargetCheck Process ResultCompares CellGetN between General Ledger and General Ledger_Clone for Net Income 2022 — calls ProcessQuit if values differ | Expected: Completed Successfully

Test Case 5: Exporting Data

Data exports are used for reporting, data integration, replication, and backups. If not done properly, it can lead to data loss, reporting errors, or failed integrations with other systems.

Test Details

Name05 Exporting Data
CategoryTest Case 5
DescriptionExtracting Data to csv file

Preconditions

  • TI process: Cube.Employee.ExportToText
  • Source cube: Employee

Test Execution

Set UpLeave blank.
ActionTest Type: Process Run | Target: Cube.Employee.ExportToText (no parameters)
Clean Up

Assertions

#NameTypeDetails
1Does File ExistCheck Process ResultCode: IF( FileExists( 'Employee Data Export.csv' )= 0); ProcessBreak; ENDIF; | Operator: Equals | Expected: Completed Successfully