Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: A transactionally consistent view on real-time data with MicroStrategy

Re: A transactionally consistent view on real-time data with MicroStrategy

From: Galen Boyer <galen_boyer_at_yahoo.com>
Date: 4 Jun 2006 08:09:02 -0500
Message-ID: <uk67wyjz3.fsf@rcn.com>


On 2 Jun 2006, erik.ykema_at_gmail.com wrote:

> A typical MSTR generated SQL scenario could look like this: alter
> session set isolation_level = serialized; -- my addition, trying
> to get it right, using a custom pre-report SQL statement create
> table A1 as select from A; create table B1 as select from B;
> create table C1 as select from C; create table Z as select from
> A, B, C fully outer joined; drop table A1, B1, C1; -- read Z into
> the report engine and present it to the user drop Z;

I don't get why you don't just create a view called Z of A,B and C and point MSTR at that?

-- 
Galen Boyer
Received on Sun Jun 04 2006 - 08:09:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US