I’ve been set the task of documenting the link between our fact tables and reports including the column name - object/universe relationships - i.e, for each fact in our fact tables what universes are they used in and as what objects…
I understand BO have a tool that can do this but I was wondering if anyone has any ideas on how to do this on the cheap?
A while back I downloaded a .rep file off this site that tells me by report what objects and universes are used so I’m looking for something that can tell me for each universe what table and column each object uses.
I had seacrhed althou I will admit not as well as maybe I could have.
By trawling through and opening and down loading lots of different posts I’ve managed to find something that sort of does what I need.