Commitment saving field not displaying correctly in Power BI and Raw data about finops-toolkit HOT 7 OPEN

Turns out there's a bug in Cost Management exports where the x_OnDemandCost is not being set correctly, which is causing the commitment savings calculation to be wrong. They're aware of the issue and have a fix in progress. I'll keep this open until that gets resolved.

While investigating this, I also discovered some other issues impacting savings calculation:

1. List price/cost is missing for some EA rows, which means negotiated discount cost savings is incomplete for EA. (Unrelated to the above issue.)
2. On-demand price is missing for some EA rows, which means commitment discount unit price savings is not available for all records for EA. (Unrelated to the above issue.)
3. On-demand price/cost is missing for all MCA rows, which means we cannot calculate commitment discount savings for MCA. (This was known. Covering it for completeness.)

I'll add some of this into the Commitment discounts report to make it easier to identify these issues.

from finops-toolkit.

Turns out there's a bug in Cost Management exports

Good to hear. Thanks :). I attempted a few different things it just wasn't working out. Keen to see how our Savings Plan is going. Quite limited reporting information on them.

from finops-toolkit.

Same problem here. Some more information in my comment here if it helps - #585 (comment)

from finops-toolkit.

Seeing a similar behavior with my data. Having trouble getting accurate data on Savings Plan savings and this seems like it could solve the issue if fixed.

from finops-toolkit.