Skip to Content
author's profile photo Former Member
Former Member

From Tables to Views ..

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Oct 07, 2010 at 07:24 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 08, 2010 at 11:48 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.