I have created a very large and complex report in using a user object. This
report was then exported to the repository. I also inserted the user object
into the Universe that the report was built off of and exported it.
Problem: All of the users are getting an error message “Some Obsolete
Objects Have Been Removed From The Query”. When I have them view the query,
the user object has been removed BUT it appears in the list of available
objects to use. WHAT IS GOING ON!? I have exported and re-exported
everything 4 times over. I checked the security level on both the objects
and the users…all are at Public. Can Someone Please Help??? I am truly
at wits end and I am forced to run this for everyone because the object
keeps getting removed from the query.
Thanks
I have created a very large and complex report in using a user object. This
report was then exported to the repository. I also inserted the user object
into the Universe that the report was built off of and exported it.
Problem: All of the users are getting an error message “Some Obsolete
Objects Have Been Removed From The Query”. When I have them view the query,
the user object has been removed BUT it appears in the list of available
objects to use. WHAT IS GOING ON!? I have exported and re-exported
everything 4 times over. I checked the security level on both the objects
and the users…all are at Public. Can Someone Please Help??? I am truly
at wits end and I am forced to run this for everyone because the object
keeps getting removed from the query.
Thanks
User objects are stored locally on your drive (in files named “xxx.UDO”, they are
“user” objects, and not “common”, i.e. NOT exported to the repository). If you
create a report based on it and export it, all users will be able to “refresh” the
report, because this does not re-generate the sql, BUT they cannot go into the
query editor, because it will not find “user” objects in the (exported) universe.
If you put the object into the Universe (you can do this via designer) this object
will became a “new” one (to my opinion) and existing reports do not know about it.
So, what you should do: replace the user object in your query by the “added”
universe object and it should work.
Hope this helps.
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria
Tel: +43-1-8151456-12, Fax: +43-1-8151456-21
e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at