[FOCUS] SubAccountId column value is different than SubscriptionId Cost Management column value, but transformation is documented as "None"

[imranmaszeri]

⚠️ Problem

In https://learn.microsoft.com/en-us/cloud-computing/finops/focus/convert#how-to-convert-cost-management-data-to-focus, the FOCUS column SubAccountId is documented to require no transformation from Cost Management SubscriptionId column.

finops-toolkit/docs-mslearn/focus/convert.md

Line 80 in f5bf284

| SubAccountId | SubscriptionId | None |

In reality, FOCUS column SubAccountId from real observed data has a prefix /subscriptions/ attached before SubscriptionId. The difference looks more like this example:

SubscriptionId = abcdef-12345-ghijk
SubAccountId = /subscriptions/abcdef-12345-ghijk

🛠️ Solution

I would appreciate some clarification to describe that SubAccountId structure will not be the exact same as SubscriptionId to prevent issues in querying FOCUS data, so end users can know whether to query using either of these filter clauses:

WHERE SubAccountId = 'abcdef-12345-ghijk', or
WHERE SubAccountId LIKE '%abcdef-12345-ghijk'

Perhaps the Transform column in the table should be reworked to say something like "add the prefix /subscriptions/ to SubAccountId"

ℹ️ Additional context

A bigger conversation to be had is whether the prefix /subscriptions/ should be added at all as it is not defined by the FOCUS Specification column library, but I am happy to follow Microsoft's definitions as long as it is clear.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.

[microsoft-github-policy-service]

Thank you for submitting this issue! We try to respond within 3 business days. In the meantime:

• 📖 Check the troubleshooting guide for common issues
• 💬 Ask questions in Discussions
• 📅 Join our biweekly office hours for live help from the team

[flanakin]

Are you looking for what Cost Management does or what you need to do? Technically, this is accurate for what you need to do. But it's not what Cost Management does. Cost Management uses the fully-qualified resource ID for the subscription, so it's actually set to /subscriptions/{id}. This isn't strictly required by FOCUS (although I believe it is implied).