I’ve converted a .unv universe to .unx. The universe is built on Oracle synonyms of materialized views. The .unv (3.1) version works correctly. Completing integrity checkings on the new .unx version I receive error messages like:
“Table AAA referenced in data foundation BBB does not exist in the database.”
I suppose the error messages like below are only consequencies:
“Failed to execute the expression for business object ‘CCC’. Check the object properties.”
It is maybe surprising that I can show the values of such tables and the validation of such objects is successful without error messages.
If I try inserting tables into the data foundation the synonyms aren’t accessible. Now I’m really confused because I can see the values of invisibles tables (synonyms) but the integrity check of them raise error message. I can validate the objects but the integrity check of them raise error message.
The universe contains more than 70 tables (synonyms) with many aliases and more than 1000 objects. Should I keep and develop the .unv version or does anybody a possibility using Oracle synonyms in IDT 4.1?
I would really appreciate any help.
feri.h 
(BOB member since 2012-12-12)
(BOB member since 2002-08-29)