Change table name of table in published view
Answered
We have a handful of dimension & fact tables across multiple YF views (used by many production reports & dashboards) where we have a business need to change the table names. The table structures remain the same. Can I change the table name in the view without having to rebuild the views and/or reports?
We use Oracle, so if synonyms can come into play to assist us here, that's an option as well. I'm just trying to determine the scope of this project before I dive in to development.
Hi Bryan,
Thanks for reaching out. Do you mean simply changing the Display Name for the table from the Model Stage of the View Editor?
If so, then yes, the changes will be picked up automatically in the reports:
If you're referring to something other than changing the Display Name, please specify what specifically is being changed.
Regards,
Mike
Hi Bryan,
Thanks for reaching out. Do you mean simply changing the Display Name for the table from the Model Stage of the View Editor?
If so, then yes, the changes will be picked up automatically in the reports:
If you're referring to something other than changing the Display Name, please specify what specifically is being changed.
Regards,
Mike
not the display name, the name the table will actually be in the Oracle database
not the display name, the name the table will actually be in the Oracle database
Hi Bryan,
Thanks for your response. So if you change the table name from the back-end, if you head back into the View Builder, you'llsee the following:
You'll click 'Rename' and change the name:
Click 'Save' and all good now:
And changes are picked up automatically in reports:
I checked a couple other reports to confirm as well. There is one potential problem to look out for though. In one of my reports I saw this:
I went into the report and found out this was being generated by a Freehand SQL Calculated Field I had:
Which is of course static, and now incorrect. If I change it to 'dateint_tbl2' it then works. If you don't use this feature you won't have to worry about it, but if you do, it's certainly something to check existing reports for. I should also probably note that Standard builder Calculated Field's will be updated, however. Please let me know if you have any questions.
Regards,
Mike
Hi Bryan,
Thanks for your response. So if you change the table name from the back-end, if you head back into the View Builder, you'llsee the following:
You'll click 'Rename' and change the name:
Click 'Save' and all good now:
And changes are picked up automatically in reports:
I checked a couple other reports to confirm as well. There is one potential problem to look out for though. In one of my reports I saw this:
I went into the report and found out this was being generated by a Freehand SQL Calculated Field I had:
Which is of course static, and now incorrect. If I change it to 'dateint_tbl2' it then works. If you don't use this feature you won't have to worry about it, but if you do, it's certainly something to check existing reports for. I should also probably note that Standard builder Calculated Field's will be updated, however. Please let me know if you have any questions.
Regards,
Mike
Replies have been locked on this page!