Skip to Content
avatar image
Former Member

Where-Used list for HANA Tables

Hi Experts,

We are using HANA Enterprise Edition and ECC as a source. ECC Tables are replicated in HANA.

Is there a way to find out in which Attribute or Analytic views a Table is used.

Something like Where-Used list.

If I decide to drop a table in HANA, I want to know what all Models it will impact.

I am able to find the Where-Used button for Models but not for the base tables.

Regards,

Sandeep

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 24, 2013 at 06:43 PM
    11

    Hi Sandeep,

    We do not have where-Used functionality for tables.

    The alternate solution is to write SQL querying from tables referring to repository.

    Here is the SQL

    SELECT   BASE_SCHEMA_NAME, BASE_OBJECT_NAME,

                   DEPENDENT_SCHEMA_NAME,DEPENDENT_OBJECT_NAME,

                   DEPENDENT_OBJECT_TYPE

    FROM     "SYS"."OBJECT_DEPENDENCIES"

    WHERE   BASE_SCHEMA_NAME = 'SRK'                /*   <==  Schema Name */

         AND   BASE_OBJECT_NAME = 'EMPLOYEE'      /*   <==  Table Name     */

    ;

    Query looks simple but it took me more than 2 hours to find the solution 😊

    Regards

    Raj Kumar


    S1.JPG (72.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hey Raj,

      I used that table a lot, but recently found that the dependencies to Analytic Views are not there.

      The tables that are in the Analytic view are there but other views ( like a AT view ) that joins to the base table are not.

      There must be a different table for these?

      Mike

  • avatar image
    Former Member
    Apr 25, 2013 at 07:09 AM

    Thanks a lot Raj.

    Its really helpful.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 23, 2016 at 05:03 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded