AnsweredAssumed Answered

Adding Service Contracts and related CI's to the universe

Question asked by pespinar on Jun 15, 2015

Hello,

 

I am facing problems trying to add to the universe the service contracts and related CI's. The problem is that the table that related contracts and ci's (sdsc_map) contains only the persid of the resource (like 'nr:KASJSDKSDKASJKD'), and the resource table (nr) only contains id ( in the form of uuid's) and I can not see the way to relate both fields. I have tryed complex joins (sdsc_map.map_persid = 'nr.' + upper (dbo.hex(nr.id)), derived tables, everything, but nothing works.

 

I have also opened several tickets with support, but without luck until the moment.

 

Any advice will be greatly appreciated.

 

Un saludo,

 

Pablo

Outcomes