Property Tax Cube fails at Load TxPropertyDim

Owned by Knowledge Assistant
Last updated: Dec 30, 2022
Description of Issue

Cubes job is failing on step 12 - Property Tax Cube.

Error Message: Load TxProperty Dim Error.... Conversion failed when converting the varchar value XXXXX to data type int

Context
  • Cubes
  • Step 12
  • Property Tax Cube
Cause

There is a data mismatch in the SQL code being used to populate the cube with Property Tax Data.

Resolution

Open a Support case with the Tax Support team to review the underlying property tax data.

Additional Information

Please review the Master Article - Cubes Reporting with Excel for all Cubes related topics.