BusinessObjects Board

Converting UNV to UNX & SQL Expression is missing

Hello All

I am on BI4.3 SP2 Patch 500, I converted a linked universe (5 universes linked) and the datasource is Teradata from UNV to UNX. I see a lots of objects are missing SQL expression (tablename.fieldname), but if I convert one of the core universes, the SQL expressions are there, no issues, it’s just the master linked universe that is causing issue. Anyone faced this issue? Appreciate for any insight.

Welcome to B :mrgreen: B @rperez.

I haven’t worked with Teradata in quit a while and the only conversions that I have done have been with SQL Server as the database and no linked servers so I haven’t run into this issue. Also, I have done my conversions in BI4.2sp8.

With that disclaimer, did you trying running the Refresh Structure in the linked universe(s) after the conversion? Maybe this will pick up the needed changes.

Hi John, Thanks for your feedback. Yes, I did refresh the structure, same issue.

Did you convert all of the individual universes before converting the one with the links? Then refresh each link?