microsoft
Commitment savings are inaccurate, need help to get the true saving numbers from RI and SP like in the ACM
The savings numbers are not correct. the commitment savings do not show values. since moving to MCA, ACM app not available, I have been struggling to find out the true savings from RI and SP.
This is a known limitation in Cost Management where they do not share list and contracted prices/cost for reservations in MCA accounts, so we can't calculate savings today. We are working on a workaround. Stay tuned...
Hi I was just wondering if the work around has ever been figured out? We just changed from EA to MCA now we are seeing this same issue and having that savings shown was a huge part. Thanks for the work on this.
It seems this comment may be relevant: https://github.com/microsoft/finops-toolkit/issues/874#issuecomment-2653292230
@wardjas Yes, we have a workaround to this in FinOps hubs with Data Explorer and the storage reports.
@wardjas is your commitment savings correct? Moved from EA to MCA and the savings data seem off for the MCA months. I've enabled "add misssing prices" and using finops 0.11 with storage/powerbi.
@flanakin any success stories on this workaround? Wondering if there's something I should confirm.
@peter-mogaka Most of the organizations I talk to are using the KQL reports. The storage reports have a tendency to not scale when joining cost with prices.
To add to this. After MCA and enabling "add missing prices" savings cost for RI seem off.
- Storage reports show total savings being way more than effective cost.
- It shows Zero savings when "add missing prices" is false.
See screenshots below. Green boxes = EA billing. Red boxes = MCA billing. Purple line= total savings
Using finops v0.11 for hub and reports.
@flanakin any workaround that doesn't involve ADX/ fabric?
@peter-mogaka Which column is that? What do the rows represent? We'd have to drill into the data to investigate. The storage reports don't have a ton of testing given how slow they are to load. I wonder if there's a specific SKU or set of SKUs that may not be joining correctly 🤔 We'd need more info to know for sure.
The columns are effective costs(left), savings(right) per month. See top of the screenshot for naming. What info do you need? Happy to jump on a call if that helps.
FYI - Top screenshot is for cost savings report: The bottom with a graph is rate optimization report.
Sorry, which savings column are you using? That's what I was asking about. We also need to know what the rows represent to try to reproduce it.
Total savings column (x_TotalSavings) for both reports. Rows are subscriptions. The top screenshot is from the summary tab of the cost summary report.