You can translate the question and the replies:

How to deploy the derived view in the different environments (Staging/Production) from Development with updated fields without modifying the individual derived views?

I have created a "Selection" Derived View. I would like to add a field in the Derived View for "URL" in the final output for Tableau reports like "https://DevTableauServerName/DevReportname". So, I added like this, Output Tab -> New Field -> Field Name - "tableau_url" and Field expression - "https://DevTableauServerName/DevReportname" -> Save the view Now, I would like to deploy this report in the Staging with Staging Tableau URL. Do I need to update the "tableau_url" field with Field expression - "https://StagingTableauServerName/StagingReportname"? I have many views like this. Do I need to repeat this activity for all views for both deployments - staging and production? Is there any other way to achieve this?
21-01-2019 12:38:29 -0500

1 Answer

Hello, One way you can do this is to store the value of the "tableau_url" in a text file, and then create a new Delimited file data source with that file. That file would have just one line in it, the URL you need on that server, for example on Dev: https://devtableauservername/DevReportname Then create a base view on this new data source. For example the new base view could be called **bv_tableau_url_data**. Then create a new Join derived view from this new base view, and your existing derived view. Add a new field that uses the base view's **bv_tableau_url_data.Column0** in the field expression. Then you only need to update the contents of the Delimited file on each server. This also makes it easy to change the URL in the future, and also this option could be expanded to add more configurable values to the Delimited file and base view if needed. Hope this helps!
Denodo Team
22-01-2019 16:09:34 -0500
You must sign in to add an answer. If you do not have an account, you can register here