Thank you for using Oracle Communities. You can use nqquery.log to find the physical table columns of the analysis.
Please refer to the below doc to generate the nqquery.log:
Fusion Applications: How to set up and access the nqquery.log to troubleshoot a single OTBI or OBIA query (Doc ID 1469168.1)
This nqquery.log contains the query that analysis fires on the database.
Please let us know if the above information is helpful.
Thanks & Regards,
Check the Lifecycle Admin dashboard pages in the SampleApp 406 - they contain what you need:
Username = Prodney; Password = Admin123
Did you at least click on the links Christian posted?
Oracle did a fantastic work, they give you a script to extract the information from the webcatalog, you can schedule it to run every night, they give you the script to load the data in a database, they give you the RPD to use it, they give you the dashboard to display and do your impact analysis online.
And how much does it cost? Nothing, zero, free ....
(Everybody working with OBIEE must have a copy of SampleApp accessible, if not it's just about downloading some files).
Of course if you prefer to redo everything you are welcome ... Doing it by hand once or spending the same time to setup what Oracle offer for free and be able to run that impact analysis when you want in just few seconds, your choice.
You link a blog post but don't look at SampleApp 406 which basically pre-masticates everything so you just have to digest it? Which of those two alternatives do you think is closer to the Oracle product suite and will most likely end up in the actual product itself?