You can translate the question and the replies:


We are using the get_view_columns() function to pull denodo interfaces and columns into the MicroStrategy warehouse catalog. We have run into an issue that if a transformation has had manual vql manipulation, the function fails to return all columns. 1. Is there a way to track down any transformation that has been modified manually rather than opening each transformation to get the message that the vql has been modified? 2. Is there a way to pull back all columns regardless of whether or not they have been modified manually?
30-09-2019 16:25:15 -0400

1 Answer

Hi, Using the [**GET_VIEW_COLUMNS**]( Predefined Stored Procedure, I am able to get the column details of the view even after manually editing the VQL of the view. Further, to identify the views which has been modified, I would export the complete Virtual Database and using the editor tools like Notepad++, I would search with the key word "Formatted"="yes" to know the view which are edited manually. Currently, there is no in-built functionality to know the views which are edited manually. If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
01-10-2019 06:44:41 -0400
You must sign in to add an answer. If you do not have an account, you can register here