You can translate the question and the replies:

'Source-to-Target' like dokumentation

Hi We need a 'Source-to-Target' like dokumentation, primary on for Views. I Design Studio we have the 'Used By' Option but it's hard to get an overview of the sitiation . Is there other way's to create an Overview picture on how View's are used 'downstream'??
user
07-12-2022 04:59:18 -0500
code

1 Answer

Hi In general ** [‘Used by’](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/viewing_the_schema_of_a_base_view/viewing_the_schema_of_a_base_view#used-by)** dialog displays the diagrammatic representation of the views in tree structure with its dependencies such as derived view, data source. For instance: When you click the ‘Used by’ dialog of the ‘View_A’ it will show all of the dependencies such as the derived view ’View_B’ which is created over the View_A and the data source name of the view ‘View_A’. It would also show the views that use ‘View B’ in a hierarchical manner, covering all the dependencies. So, I believe ‘Used by’ has all the information you are looking for. However, you could also make use of the ** [‘VIEW_DEPENDENCIES’](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/view_dependencies)** Predefined Stored Procedure of the Virtual DataPort. You could execute the Stored Procedure in ‘VQL Shell’ with the optional parameters such as **view_name, dependency_name, view_type** etc. You could write VQLs with specific conditions to achieve your requirement. For eg: **SELECT * FROM VIEW_DEPENDENCIES() WHERE VIEW_NAME = ‘<name of the view> OR DEPENDENCY_NAME = <name of the view>** Hope it helps!
Denodo Team
08-12-2022 09:48:13 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here