Great question. There needs to be a better way of retrieving this data, but as far as I know, it is currently a lot of very detailed work. I believe you will find the best available options for getting this data from the following other posts here on this forum:
https://forums.autodesk.com/t5/inventor-customization/determine-scale-of-the-drawingdimension-s-pare...
https://forums.autodesk.com/t5/inventor-customization/deleting-all-dimensions-on-a-specific-view/m-p...
https://forums.autodesk.com/t5/inventor-customization/drawingviews-and-drawingdimensions/m-p/2324524
I think this issue would be an excellent candidate for a post on the Inventor Ideas forum. Seems like a common enough issue to have been mentioned there before, but I didn't find any obvious links related to this specific issue already in the Ideas forum. It would be great if the DrawingDimension object had a direct Method or Property that would return which drawing view it is being used in. I know there is a manual method in the UI right-click menu when you have a dimension selected that will allow you to "Move Dimension", and lets you select another DrawingView to move it to, so you'd think it would 'know' which view it is 'assigned to'.
If this solved your problem, or answered your question, please click ACCEPT SOLUTION.
Or, if this helped you, please click (LIKE or KUDOS) 👍.
If you want and have time, I would appreciate your Vote(s) for My IDEAS 💡or you can Explore My CONTRIBUTIONS
Wesley Crihfield

(Not an Autodesk Employee)