Table Name Update in IDT

building semantic layer
1

Hi, All

one table NAME got renamed in the database and when I refresh structure in Data foundation(IDT) for that table then whole table will be get deleted as existing table don’t recognize the new table name from database.

when I try to rename table in data foundation, getting “Renaming the table in data foundation may cause errors in data foundation(Invalid Join SQL, or errors when viewing table data)”.

Can anyone share how to handle above scenario.

Thank You for the help!

MIUSA (BOB member since 2011-05-01)

2

Refreshing the structure in IDT will work, if not then you have to delete that table and try to insert again and it will work

surya_sudheer :india: (BOB member since 2006-11-01)

3

Agree. Refreshing the structure in IDT will work but it doesn’t work for me.Not sure, if anyone faces same issue before. We are on 4.1sp6.

If I delete the table and insert again, then my understanding is:

  1. I need to define the mapping of new table added with existing tables.
  2. In Business Layer, since I deleted the old table in DF, dimensions columns wont work as there is no table available in DF pointing to old table. Then, I believe, reports pointing to this old table throw error at report level.
  3. I need to add new table from DF to BL and make the necessary changes to calculated columns and at report level as well.

Please share your thoughts.

MIUSA (BOB member since 2011-05-01)

4

you should not refresh the structure.

You should right-click the table, select replace by -> database table and pick the new table. Yes, a table with a different name is a new table. The IDT does not keep tack of tables by other thing than their names.

Derf :canada: (BOB member since 2011-05-16)

5

If I’m Replacing existing table with new database table, a message showing as ‘All business layer items referencing this table will need to be manually updated.’. Look like this require manually efforts to update fields in business layer along with conditional objects if any.

MIUSA (BOB member since 2011-05-01)

6

I’ve seen that error, but the table names in the BL were renamed correctly. I did have to save the DF, then close and reopen the BL, but when I did that the changes were done as expected.

joepeters :us: (BOB member since 2002-08-29)

7

Good to know. Thanks Joe!

MIUSA (BOB member since 2011-05-01)

8

I’ve come across a situation where I need to replace one table with another (same table format, different content), but this method does not work for me. I get ‘unresolved table’ populated into all of my dependent dimensions. :hb:

jresendez :mexico: (BOB member since 2004-05-03)

9

Hi,

If you’ve a backup Universe, use it, follow the below steps, and hopefully you’ll get it resolved easily.

1. DON’T DELETE the table (with old name) from Data Foundation Layer DFX while refreshing the table structure.

  1. Add the new table (renamed table rather) to the DFX

  2. Follow my blog to update the Table name in Dimensions (Select clause) / Filters (Where Clause) and/or other Case statements. Please look at the items 6, 10, 13, 16 in “Below things in Business Layer.” Also, at the items 4 & 7 in, “And below things in Data Foundation Layer”.

https://blogs.sap.com/2016/10/21/bulk-renaming-objects-lot-things-universe-idt/

  1. Check Integrity, make sure nothing fails, if it does, fix it, and Check Integrity again…

  2. Finally, refresh table structure again, and delete the old (renamed) table from the DFX.

M H Mohammed :us: (BOB member since 2010-06-16)

10

Thank you ! This looks like exactly what I need. I’ll test this out this week and let you know if I run into any issues.

jresendez :mexico: (BOB member since 2004-05-03)

11

Good luck! Glad that my blog can help at least some people! :slight_smile:

M H Mohammed :us: (BOB member since 2010-06-16)