Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 48 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 286 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 110 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
How can i get SQL from 'table type -select' AdminTool?
Hello So we have a huge instance of OBIEE. With many tables in view of AdminTool. I want get SQL text from 'table type -select' of AdminTool automaticaly. I try Catalog Manager for this ..but useless. How i can do this? Can you help me
Answers
-
Quick way would be in the Admin Tool and in the Physical Layer, to right click on the physical schema for example and click on copy. Paste the content into your editor of choice and then search for the "TABLE TYPE SELECT DATABASE MAP" string. The SELECT statement should follow after this string.
0 -
Or a variant of @Joel_Acha suggestion is save your rpd as XML and then you can use your tool of choice to search / parse its content.
0 -
Wow great! Thanks! Your way is perfect for me! because we have a very huge instance
0 -
No problem!
Thanks are appreciated here!
0
