[Mondrian] NULL literal

[Haridasan T]

Greetings,
Appreciate if you can help me to connect to oracle database from Mondrian

Which all xml files need to be changed

Thanks

Hari Nair
-- 


On 3/1/07, Richard Emberson <remberson at edgedynamics.com> wrote:
>
>
> On one of the web pages written by Mosha Pasumansky he
> said that NULL/NULL == NULL, so I had assumed that
> 4/NULL and NULL/4 were also NULL. The reason I assumed that
> was: if it were true, then running one of our MDX queries with and
> without native crossjoin enabled returned the same result.
>
> I will backout the change.
>
> Richard
>
> -----Original Message-----
> From: mondrian-bounces at pentaho.org on behalf of Julian Hyde
> Sent: Wed 2/28/2007 5:55 PM
> To: 'Mondrian developer mailing list'
> Subject: RE: [Mondrian] NULL literal
>
> Richard,
>
> You only did half of what I suggested: you wrote testcases but you
> didn't validate the results against MSAS.
>
> I ran
>
>   with member [Measures].[Foo] as ' 4 / NULL  '
>   select {[Measures].[Foo]} on 0
>   from [Sales]
>
> on MSAS 2K and it gave
>
>   1.#INF
>
> as the answer. Now you've added a test which ensures the result is NULL,
> i.e. wrong.
>
> Change 8802 is not an improvement. Please back it out.
>
> Julian
>
>
> > -----Original Message-----
> > From: mondrian-bounces at pentaho.org
> > [mailto:mondrian-bounces at pentaho.org <mondrian-bounces at pentaho.org>] On
> Behalf Of Richard Emberson
> > Sent: Wednesday, February 28, 2007 2:18 PM
> > To: Mondrian developer mailing list
> > Subject: Re: [Mondrian] NULL literal
> >
> > In the        8802 checkin I added a NULL literal test method
> > testNullLiteral() to BasicQueryTest.
> >
> > Richard
> >
> > Julian Hyde wrote:
> > >
> > >
> > >> Interesting page on NULL and IS EMPTY
> > >>
> > >>
> > >
> > http://sqljunkies.com/WebLog/mosha/archive/2005/06/30/mdx_is_e
> > mpty.aspx
> > >
> > > Looks like a page full of potential testcases to me!
> > >
> > > Anyone out there itching to contribute to mondrian by
> > writing Q/A tests?
> > > We could use your help!
> > >
> > > Julian
> > >
> > > _______________________________________________
> > > Mondrian mailing list
> > > Mondrian at pentaho.org
> > > http://lists.pentaho.org/mailman/listinfo/mondrian
> > >
> >
> >
> > --
> > Quis custodiet ipsos custodes:
> > This email message is for the sole use of the intended
> > recipient(s) and
> > may contain confidential information.  Any unauthorized review, use,
> > disclosure or distribution is prohibited.  If you are not the intended
> > recipient, please contact the sender by reply email and destroy all
> > copies of the original message.
> > _______________________________________________
> > Mondrian mailing list
> > Mondrian at pentaho.org
> > http://lists.pentaho.org/mailman/listinfo/mondrian
> >
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>


-- 
http://cfo-portal.blogspot.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20070301/75b28114/attachment.html