Module 2: Test Categories & Test Case 1 – Successful Data Load
Creating Test Categories
Categories are organisational buckets for your tests. Create the following 5 categories before starting the test cases:
- Go to the Categories section in the Test Hub.
- Click New Category, enter a name, optional description and colour, then click Save.
- Create: Test Case 1, Test Case 2, Test Case 3, Test Case 4, Test Case 5.
Test Case 1: Successful Data Load
Ensuring a successful data load in TM1 is critical for maintaining data accuracy, consistency, and reliability. If data is not loaded correctly, reports and business decisions may be based on incomplete or incorrect information.
Test Details
| Name | 01 Successful Data Load |
| Category | Test Case 1 |
| Description | Execute Process - GL cube has values as expected |
Preconditions
- TI process:
Cube.GeneralLedger.LoadFromFile - Data source:
AdventureworksDW2019-GLdata.csvin the TM1 data directory
Test Execution
| Set Up | Leave blank. |
| Action | Test Type: Process Run Target: Cube.GeneralLedger.LoadFromFileParameter: pYear = 1 (load all years) |
| Clean Up | Leave blank. |
Assertions
| # | Name | Type | Details |
|---|---|---|---|
| 1 | TI Runs = Success | Check Action Result | Operator: Equals | Expected: Completed Successfully |
| 2 | Cube Results as Expected, Net Income for 2024 | Compare Cell Cube Value | Cell: General Ledger [Version=Actual, Year=2024, Period=Year, Currency=Local, Region=Total Europe, Dept=All Departments, Account=Net Income, Measure=Amount] | Operator: Equals | Expected: 2167598.28 |
| 3 | Balance Sheet Balances – 2024 | Compare Cell Cube Value | Operator: Equals | Expected: 0 |
| 4 | Balance Sheet Balances – 2023 | Compare Cell Cube Value | Operator: Equals | Expected: 0 |