AnsweredAssumed Answered

Adding Service Contracts and related CI's to the universe

Question asked by pespinar on Jun 15, 2015



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(, 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,