Decimals incorrect on attribute in DWH

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

An attribute displays correct number of decimals in Clarity UI and Clarity database, however does not show correctly in DWH database, DWH reports or Odata

Cause

The attribute decimals have been updated after the attribute was included in DWH

Resolution

When updating data type on attributes, we recommend unchecking them from DWH first to recreate with the correct decimal number.

1. Uncheck the attribute from Data Warehouse
2. Run a Full Load DWH job
3. Now check the attribute back in DWH
4. Run a Full Load for DWH

This should correct the decimals to the current number in DWH

Note: If you are using Odata, also run Refresh Odata Model job after the Full Load completes