How can i get SQL from 'table type -select' AdminTool? — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How can i get SQL from 'table type -select' AdminTool?

Received Response
21
Views
4
Comments
Alex Sharkov
Alex Sharkov Rank 5 - Community Champion
edited Aug 13, 2024 5:35PM in Oracle Analytics Cloud and Server

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

  • Joel
    Joel Rank 8 - Analytics Strategist

    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.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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.

  • Alex Sharkov
    Alex Sharkov Rank 5 - Community Champion

    Wow great! Thanks! Your way is perfect for me! because we have a very huge instance

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    No problem!

    Thanks are appreciated here!