[External][Cost Management] ContractedCost missing in Cost Management exports

[flanakin]

🐛 Problem

Microsoft Cost Management does not include ContractedCost or ContractedUnitPrice in all exported cost data. There are 2 bugs with this:

1. ContractedCost and ContractedUnitPrice should always be specified.
2. If not available, ContractedCost and ContractedUnitPrice should be null and not 0.

There are currently 2 known reasons why ContractedCost and ContractedUnitPrice will be missing:

1. Reservation usage charges for MCA accounts.
2. Reservation usage charges for EA accounts when Cost Management cost allocation is enabled.

If you are using Cost Management cost allocation for an EA account, consider disabling cost allocation rules to work around this.

This is documented in Ingest cost details data as a limitations for UnitPrice column in actual/amortized cost data. This limitation also applies to the ContractedCost and ContractedUnitPrice columns in FOCUS data.

👣 Repro steps

1. Export FOCUS cost data.
2. Filter rows where ContractedCost == 0 and EffectiveCost > 0.

🤔 Expected

• All rows should have an accurate ContractedCost and ContractedUnitPrice values.
• The only records with a ContractedCost or ContractedUnitPrice of 0 should be free.
• If a value is not available, they should be null. (However, ContractedCost and ContractedUnitPrice should always be available.)

ℹ️ Additional context

This is a tracking bug only. The FinOps toolkit community is not responsible for this and cannot resolve the issue. Subscribe to this issue to be notified when the issue has been resolved.

[!IMPORTANT] If you are using Cost Management cost allocation, consider disabling cost allocation rules to work around this.

We are tracking the following workarounds until this issue is resolved:

• [x] #835
• [ ] #614

Related issues:

• [ ] #834

[!NOTE] If you are facing this issue, you can file a support request with the Cost Management team to convey the importance of these columns for your needs; however, as a known issue, the support request will likely be closed. The intent of creating a support request is to raise awareness of your needs and increase the priority of the fix.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Let us know if you see an opportunity to improve the experience from the toolkit.

[lawlormt]

Hi - I'm new to the finops-toolkit but it looks really useful. What primarily drew me to it was to get a view on "commitment savings". Unfortunately we are MCA customer so fell foul of the issue where no savings are shown when contractedcost and listcost are not available in the FOCUS export. As per the advice in the note above I opened a support case to highlight the issue. I just recently got an update back "As per our Product Group, the ETA to fix this limitation would be end of November". I dont know how reliable that might turn out to be, have you heard anything since from the Cost Mgmt team? Thanks Michael L