Impact on Universe and Reports if the Table Name Changed at Database Level

[vijayb]

Hi All,

What will be the impact on universe and reports if the table name changed at database level, if didn't perform refresh on table or universe structure?

Thanks in advance

[Former Member · Accepted solution]

When you change the table name. following would be impacted.

1) Joins created with the old table are no longer valid

2)Objects/filters which are created on top the Table

3)Reports/dashboards which are using Objects created on the table

IF YOU HAVE FOLLOWED BEST PRACTICES SUCH AS CREATING A ALIAS TABLE FOR EACH TABLE AND USED ONLY ALIAS TABLES IN THE UNIVERSE WORK SPACE, YOU CAN JUST MAP THE ALIAS TABLES TO NEW TABLE.

if you have used the original table then, you have to follow below procedure.

1. check the alias tables and original tables and replace with the new table

2. Objects/filters which are created should be remapped to the new table (select and where clause)

[vijayb]

Thank you

[former_member203850]

Hi Vijay,

If we haven't perform the refresh or modify the table names then we will be getting error while running the webi report.

Some objects are no longer available error in Webi report.

Regards,

Pranay

[vijayb]

Hi,

Thank you for reply.

Could you please tell what will be the impact on universe?

[Former Member]

Hi Vijay,

If there is any change in the table name and then refresh the structure and export the universe.

The objects should get updated automatically in universe and reports.

Regards,

Yuvraj