When we export an ad-hoc view from Advanced Reporting for an investment, the export shows extra cents added that was never added to the benefit plan. In checking the main database (Niku/Clarity) and the data warehouse database (DWH), we see the extra cents is being stored in the DWH. Example: For a 10,000 Benefit Plan it shows as 10,000.04 This is seen in Benefit Plan Adhoc Views (including exporting to CSV).
STEPS TO REPRODUCE:
Expected Results: No Extra cents added, the Benefit total equals 30,000.00
Actual Results: Extra cents are added. In the above project example, the Benefit Total equals 30,000.04 (extra 4 cents)
Notes:
Query that shows issue in DB: Select * from dwh_fin_Benefit_summary_facts where investment_key=xxxxxx
Benefit, Billing_Benefit, Benefit_Actual_var all show the incorrect amount
Caused by DE57440. The amount is off by a few cents due to DWH DB adding the additional decimal amount.
Release : 15.7, 15.8, 15.8.1, 15.9, 15.9.1
Component : CA PPM DATA WAREHOUSE
Targeted to be fixed in 15.9.2.
See KB: 141061 for tips on how to optimize use of Self Service for Clarity