Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: A transactionally consistent view on real-time data with MicroStrategy
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 BoyerReceived on Sun Jun 04 2006 - 08:09:02 CDT