Skip to Content
avatar image
Former Member

Which system table includes attribute views names and analytic views (or calculation view mapping)

Hi

Can anyone tell which system table includes mapping of attribute view names and analytic views or calculation views and attribute views mapping. I found only those system tables which includes mapping of analytic views with underlying tables of attribute views.

Is there any table which hold logical View mapping?

Thanks and regards

anu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 22, 2013 at 06:10 PM

    Hi Anu,

    You can try looking into the tables "VIEWS" and VIEW_COLUMNS. The VIEWS table keeps track of the name, type etc of all the views created and the VIEW_COLUMNS keep track of all the columns of all the views created.

    These might be helpful.

    Regards,

    Piyush

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Piyush, I checked VIEWS and VIEW_COLUMNS tables. If we search for any analytic or calculation view, it list down all the underlying columns of attribute views and tables. We don't get details like analytic view is created on which attribute view or calculation views is based on which all attribute or analytic view.

      Thanks Anu

  • avatar image
    Former Member
    Jan 23, 2013 at 10:14 PM

    Hi Anu,

    I would recommend query OBJECT_DEPENDENCIES. You can filter on BASE_OBJECT_TYPE and DEPENDENT_OBJECT_TYPE, for example. You can also get creative with joins to other system tables, like Piyush's recommended VIEWS and VIEW_COLUMN tables for more information.

    Also, following are good reference tables for all system tables and columns.

    M_MONITORS

    M_MONITOR_COLUMNS

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25, 2013 at 02:58 PM

    Anu,

    You can view all the  attribute and analytical views created by you under the

    _SYS_BIC folder.

      Please let me know if you have any specific need to look and use the internal tables.

    

     Hope this helps.

    

    Regards,

    Rama

    Add comment
    10|10000 characters needed characters exceeded