 |
 |
Archives of the TeradataForum
Message Posted: Thu, 10 Aug 2000 @ 13:09:29 GMT
| Subj: | | Re: SOS! Teradata and Business Objects |
| |
| From: | | Dave Sedgwick |
Thanks for that Dave, the answer is similar to what you've described. The reason it was spooling was actually an object in the
universe that was using the original table name not the aliased name. It did not reveal itself in the universe as clicking on the
table that has been aliased and selecting 'view associated objects' revealed nothing - an interesting feature. If a designer does
create an alias table and performs this check they would assume all objects have been correctly changed to use the alias name.
Obviously as the aliased table is not joined to anything it was doing a 1=1 product join between two sizeable tables.
Right, that's one cracked, next one is figuring out the union part of the report query...
Dave
| |
