I apologize if this is the wrong forum.
I'd like to be able t create custom non-Universe related reports from the Information Steward Metadata Repository IS_REPO database. For example, I would like to create a lineage report for a relational table (one that is not used in a Universe) and preferable export it into an excel spreadsheet. Is this doable? If so, how would I go about it?
To summarise and breakdown your questions - I've made some assumptions and answered it below:
If you want to create reports from the Metadata repository - this should be "doable"
If you want to export a report into an excel spreadsheet - this is possible
How you would do this depends - but a overview solution could be -
Analyse the data model and the data
Create a report (probably a webi report on a unx)
I've seen cases where you could combine Audit data from auditing database to give additional information on the usage.
It's easy to export webi report into excel