on 01-22-2013 5:40 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.