Sounds to me like you want the Semantic Layer SDK vs the Report Engine SDK.
I’ve not done this but it seems feesible to take a data from the Report Engine SDK results and pass them into the Semantic Layer SDK to get the metadata for the objects used in the report. You can get a lot of guidance in using the Semantic Layer SDK by reviewing
https://bobj-board.org/t/59650
I have to believe that someone has done this as it is a very common need and a definite shortcoming of the BO suite. I’ve not found any commercial or shareware tools that will do this–has anyone else found (or developed) anything. I’m pretty sure that there is a market for it if you have. If not, I’d be interested in partnering with any interested parties in creating one.
mkrigba (BOB member since 2006-11-22)