From Tables to Views ..

[Former Member]

Hello,

because of permanent changes in table structure specially new columns. we want to replace Table in Universe trough Views. This having the advantage that even if Table strucrure changes. Universe has not necesserly to be changed. In our universes we have many contexts aliases Joins ..etc.

What s best practice to replace tables trough Views. what s best way to to raplace Contexts/ Alias ..etc.

Thanx

[former_member142702 · Accepted solution]

Just insert the view into your universe, setup the joins as they are set the table you want to replace, replace the table name with the view name in the object definition (Find & replace can be very helpful here), rebuild the contexts the table participates to, recreate any existing aliases (incl. joins and contexts) and at the end remove the table from your universe.

Regards,

Stratos

[Former Member · Accepted solution]

Thanks Efstratios

[Former Member]

It can be far easier than that. Simply rename a table so that it now has the view name, and refresh the universe structure. Existing objects, joins, contexts, and so on will remain and not have to be reworked.

Suppose you have a table called FIRST_TABLE and you intend to replace it with a view called FIRST_TABLE_VW. Click on the table in your universe structure, rename the table to FIRST_TABLE_VW and then select View + Refresh Structure from the menu. It will update the table columns with any new (renamed) columns, so you may have to repoint some of your joins. But objects based on the table will be updated automatically, no need to find and replace.