Linked Universe problem

[nickdaniels]

An existing report provides information relating to<br>failed loan applications.&nbsp;&nbsp;A simple 'yesterday' pre-defined condition is<br>used based upon trunc(sysdate-1) for the loanapplicationinvalid.dateloaded.<br><br>It is becoming apparent that this condition excludes cases where any of the<br>invalid details are changed after the intial application process.&nbsp;&nbsp;The<br>dateloaded field is only set at the initial application stage.&nbsp;&nbsp;So I need a<br>last updated date field to check on.&nbsp;&nbsp;Unfortunately there isn't one in this<br>database.&nbsp;&nbsp;However, in another database which also holds loan information<br>(but not enough information for me to base my universe off it) there is a<br>lastupdateddate field.<br><br>So!&nbsp;&nbsp;I've created a very simple child universe with the one table that has<br>the lastupdateddate field and have linked that into the main parent<br>universe.&nbsp;&nbsp;Fortunately both have accno in common.<br><br>I now want to change my yesterday condition syntax to read as follows:<br><br>loanapplicationinvalid.dateloaded = trunc(sysdate-1) or<br>otheruniversetable.lastupdateddate = trunc(sysdate-1)<br><br>But Designer (4.1.6) is unhappy, giving a ORA-00942 :table or view does not<br>exist.&nbsp;&nbsp;Clicking on the Tables...button shows both tables have been<br>highlighted.&nbsp;&nbsp;So Designer seems to support what I am doing until I try to<br>parse it, at which point no joy.<br><br>Any suggestions, I can't get the lastupdateddate added to the original<br>table.<br><br>cheers, Nick <p> Nick<br><a href=mailto:ndaniels@ventura-uk.com>ndaniels@ventura-uk.com</a><br><a href= > </a><br>If it's Data Warehousing or related then I want to know - but post it to the forum!

 

[LordLobo]

AFIK, until 4.1.7 BizOb is very non-fond of Multi-Universe querys.&nbsp;&nbsp;I'm no master, but I've been told when I thought that would be a good ides.<br><br>--LL