Impact of replacing actual table with table view

building semantic layer
1

Hi All,

Currently in my universe we are using a table say Employee table. Some of the objects in the universe are built on this table. Now we created a view for this Employee table. View is called as Employee_View. Now if I replace Employee table with Employee_View how will it impact the Universe/reports.

Universe objects which are pointing to Employee table, I will make them to point to Employee_View. Let me know is there any issue doing this?

Both table and View have identical definition. Only data will be different in table and view. Under this scenario will it make any difference using table or view in my universe?

Please do the needful.

Karthik LY (BOB member since 2009-02-25)

2

You should be able to change the name of the original table, this will re-point objects for you.

Possibly, from a performance perspective. This will dpend on the DB used and how good the underlying indexing is, of the base tables.

Mak 1 :uk: (BOB member since 2005-01-06)

3

Thanks mak for the quick reply.

So I need to just change the table name to view name.No need to delete the table from universe and re-add the view. Right? Please confirm me.

Note: I just want to use View instead of table.

DB that we are using is Netezza. So will there be any major performance impact

Karthik LY (BOB member since 2009-02-25)

4

Right Click and rename should work providing the BO users account has the permissions to the base tables and the view object.

As for Netezza, as you are using the Ferrari of Data warehouse appliances, I suspect the performance impact will be minimal :).

Mak 1 :uk: (BOB member since 2005-01-06)

5

Thank you very much Mak.

Karthik LY (BOB member since 2009-02-25)