[Mondrian] RE: I need help conecting to Teradata (Julian Hyde)

Francisco Martín franciscomartin.cl at gmail.com
Mon Feb 18 07:14:04 EST 2008


Julian, Thanks, that was it, I was way of with my xml, At one point I became
a little desesperate so I tried anything that went through my mind. Now,
with the 'schema' atribute the cube is working perfectly. I really
appreciate your help and patience specially considering my ignorance in this
topic. Thank you again.

Regards,
   Francisco Martín C.


2008/2/17, mondrian-request at pentaho.org <mondrian-request at pentaho.org>:
>
> Send Mondrian mailing list submissions to
>        mondrian at pentaho.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.pentaho.org/mailman/listinfo/mondrian
> or, via email, send a message with subject or body 'help' to
>        mondrian-request at pentaho.org
>
> You can reach the person managing the list at
>        mondrian-owner at pentaho.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Mondrian digest..."
>
>
> Today's Topics:
>
>   1. RE: RE: I need help conecting to Teradata (Julian Hyde)
>      (Julian Hyde)
>   2. RE: Parent-child hierarchies and StrToMember (Julian Hyde)
>   3. RE: Problem with aggregate tables.. (Julian Hyde)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 17 Feb 2008 10:52:05 -0800
> From: "Julian Hyde" <jhyde at pentaho.org>
> Subject: RE: [Mondrian] RE: I need help conecting to Teradata (Julian
>        Hyde)
> To: "'Mondrian developer mailing list'" <mondrian at pentaho.org>
> Message-ID: <5C97BB5AC144409DAC0F71EC9EAACE0C at mackerel>
> Content-Type: text/plain;       charset="iso-8859-1"
>
> Really?
>
>        <Table name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"/>
>
> isn't even valid XML and shouldn't parse.
>
> Use the 'schema' attribute, and take those dots out of the table names.
> Let
> me know if that fixes the problem.
>
> Julian
>
> > -----Original Message-----
> > From: mondrian-bounces at pentaho.org
> > [mailto:mondrian-bounces at pentaho.org] On Behalf Of Francisco Martín C.
> > Sent: Sunday, February 17, 2008 6:38 AM
> > To: mondrian at pentaho.org
> > Subject: [Mondrian] RE: I need help conecting to Teradata
> > (Julian Hyde)
> >
> > The base .xml I'm using is the one created with cube
> > designer, the reason I
> > use '"."' is because Teradata doen't support table names
> > longer tan 30 bytes
> > so I have to put them like that (in the query). Im not in the
> > office right
> > now so I can't check, but I think that when I putt he names with a '.'
> > insteade of '"."' I got the 'Can't create native connection'
> > error from
> > mondrian. The file definition of the cube is:
> >
> > <?xml version="1.0" encoding="UTF-8"?>
> > <Schema name="cubosimple">
> >     <Cube name="cubosimple">
> >         <Table name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"/>
> >         <Dimension name="Sexo">
> >             <Hierarchy name="Sexo" hasAll="true"
> > allMemberName="All sexo">
> >                 <Table
> > name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"/>
> >                 <Level
> > name="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000.SEXO"
> > table="GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000" column="SEXO"
> > uniqueMembers="false"/>
> >             </Hierarchy>
> >         </Dimension>
> >         <Measure name="Monto" column="MONTO_CHEQUE" aggregator="sum"
> > datatype="Numeric" formatString="#.##0,###"/>
> >     </Cube>
> > </Schema>
> >
> > Thanks.
> >
> >       FmC
> >
> >
> >
> > Message: 1
> > Date: Fri, 15 Feb 2008 13:03:13 -0800
> > From: "Julian Hyde" <jhyde at pentaho.org>
> > Subject: RE: [Mondrian] RE: I need help conecting to Teradata (Julian
> >       Hyde)
> > To: "'Mondrian developer mailing list'" <mondrian at pentaho.org>
> > Message-ID: <27980DD428C24149B59AEFD732ABA466 at mackerel>
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > Are you using the 'schema' attribute of the <Table> element?
> > You should be.
> > I have a feeling that you're doing funny stuff like putting
> > '"."' in table
> > names - if so, that's bound to confuse things.
> >
> > Julian
> >
> >
> >   _____
> >
> > From: mondrian-bounces at pentaho.org
> > [mailto:mondrian-bounces at pentaho.org] On
> > Behalf Of Francisco Martmn
> > Sent: Friday, February 15, 2008 7:35 AM
> > To: mondrian at pentaho.org
> > Subject: [Mondrian] RE: I need help conecting to Teradata
> > (Julian Hyde)
> >
> >
> > Apparently I screwed up the previous message because i
> > attached a file...
> > Sorry about that, Anyway, here it goes again without
> > attachment... (In case
> > that the message is duplicate I am Double sorry, I'm just new
> > here and need
> > help)
> >
> > Julian, thanks for the response, unfortunately I am still
> > having problems, I
> > now don't have the problem with the '>' delimiter. What I did
> > was create a
> > new cube definition, very simple so I can test it. I modified
> > the xml so it
> > includes de Database name, but none of the .xml worked.
> > Teradata is not case
> > sensitive so that isn't a problem, but the query that
> > mondrian is creating
> > is not working, Maybe I added the DB name in too may places
> > (I added in
> > every 'Table' and 'Table name' field). I modified the query from the
> > modified definition so that it would work in teradata, the
> > 'correct' query
> > would be:
> >
> > select
> > sum("GC_LiDEr_WRK"."TBL_CUBO_CLIENTES_MCL_3000"."MONTO_CHEQUE") as
> > "m0"
> > from "TBL_CUBO_CLIENTES_MCL_3000"
> >
> > Instead of the original:
> >
> > select
> > sum("GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"."MONTO_CHEQUE") as
> > "m0" from "GC_LIDER_WRK"."
> > TBL_CUBO_CLIENTES_MCL_3000" as
> > "GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"
> >
> > I hope you can help me a bit more, I feel I'm getting close. Thanks a
> > million.
> >
> > PS: I dont think it matters, but the JDBC driver I use in
> > cube designer is
> > older that the one in Design Studio, for some reason the new
> > one does not
> > connect in CD and the old one doesn't connect in DS.
> > PSS: Apparently I can't attach files here and to post the
> > entire error logs
> > + the definitions would be a bother to everyone, If more
> > information is
> > needed just ask.
> >
> >
> >
> > Message: 1
> > Date: Thu, 14 Feb 2008 09:12:15 -0800
> > From: "Julian Hyde" <jhyde at pentaho.org>
> > Subject: RE: [Mondrian] I need help conecting to Teradata
> > To: "'Mondrian developer mailing list'" <mondrian at pentaho.org>
> > Message-ID: <459B0A2691BA494D8316BDD1BACB1082 at mackerel>
> > Content-Type: text/plain; charset="iso-8859-1"
> >
> > Two errors here. First, it can't find the object. Have you
> > maybe spelled the
> > table in lowercase in your schema file, and it is uppercase
> > in Teradata; or
> > perhaps it needs to be qualified by a schema name in
> > teradata. Turn on SQL
> > tracing (mondrian.trace.level=1) and see what SQL mondrian
> > generates, then
> > try running that SQL using teradata's command line.
> >
> > Second, when you changed the schema.xml file you made it into
> > invalid XML. I
> > think you forgot to terminate the <Level> element with />.
> > Maybe you tried
> > to put comments inside the Level element?
> >
> > Julian
> >
> >
> > _____
> >
> > From: mondrian-bounces at pentaho.org
> > [mailto:mondrian-bounces at pentaho.org] On
> > Behalf Of Francisco Martmn
> > Sent: Thursday, February 14, 2008 4:48 AM
> > To: mondrian at pentaho.org
> > Subject: [Mondrian] I need help conecting to Teradata
> >
> >
> > Hello, I've been using Mondrn with Pentaho BI Suite and for
> > some reason I
> > can't connect to Teradata with Mondrian, I can make reports
> > using my DB, the
> > problem only comes with Mondrian. Here's what I do:
> >
> > I use Cube Designer to design and publish a cube, at this
> > point I have no
> > problem accesing the data from Teradata, I can use the
> > graphic interface
> > perfectly. In Cube designer I have to use the JDBC drivers version
> > 03.01.00.102, If I use newer ones I can't connect... So far so good
> >
> > Now to actually SEE the cube, The JDBC drivers defined in
> > Jboss are version
> > 12.0, here the version 3.01.00.102 simply don't work. So, I go to
> > localhost/samples/analysis and when I click on a SampleData
> > cube I can see
> > it perfectly, but, a Teradatya cube... NOTHING, The only
> > thing I see is the
> > message from Jboss that goes like this:
> >
> >
> > 10:23:15,865 INFO  [STDOUT] , exec+fetch 47 ms, 0 rows
> > 10:23:15,865 ERROR [MondrianModel] Parse Failure
> > mondrian.olap.MondrianException: Mondrian Error:Failed to
> > parse query '
> >         select NON EMPTY {[Measures].[SUM of
> > TBL_CUBO_CLIENTES_MCL_3000.RUTCLI]} ON columns, NON EMPTY
> > {([Sexo.Sexo].[All
> > sexo], [Rango.Rango].[All r
> > ango])} ON rows from [cubo0902]
> > '
> >        at
> > mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
> > .
> > .
> > .
> > .
> >        at java.lang.Thread.run(Thread.java:595)
> > Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while
> > parsing MDX statement '
> >         select NON EMPTY {[Measures].[SUM of
> > TBL_CUBO_CLIENTES_MCL_3000.RUTCLI]} ON columns, NON EMPTY
> > {([Sexo.Sexo].[All
> > sexo], [Rango.Rango].[All r
> > ango])} ON rows from [cubo0902]
> > '
> >        at
> > mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
> > .
> > .
> > .
> > .
> > 10:23:15,865 ERROR [MondrianModel] [NCR] [Teradata DBMS] : Object
> > 'TBL_CUBO_CLIENTES_MCL_3000' does not exist.
> > 10:23:15,865 ERROR [OlapModelProxy]
> > com.tonbeller.jpivot.olap.model.OlapException: [NCR] [Teradata DBMS] :
> > Object 'TBL_CUBO_CLIENTES_MCL_3000' does not exist.
> >
> >
> > (...And a lot more)
> > Which seems to be because the name of the Database itself is
> > nowehre to be
> > found, it just references the tables. So, my natural instinct
> > suggest me to
> > change the .xml and add the reference to the table... at this
> > point I get
> > the following error:
> >
> >
> >
> > 10:27:51,940 ERROR [Logger] Error: Pentaho Pentaho BI
> > Platform 1.6.0.GA.863
> > 10:27:51,940 ERROR [Logger]
> > misc-org.pentaho.data.connection.mdx.MDXConnection:
> > MDXConnection.ERROR_0002
> > - "Unable to create a native connection for c
> > onnection string: "Mondrian Error:Internal error: while
> > parsing catalog
> > solution:samples/analysis/cuboprueba.mondrian.xml"
> > mondrian.olap.MondrianException: Mondrian Error:Internal error: while
> > parsing catalog solution:samples/analysis/cuboprueba.mondrian.xml
> >        at
> > mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)
> > .
> > .
> > .
> >
> >        at java.lang.Thread.run(Thread.java:595)
> > Caused by: org.eigenbase.xom.XOMException: Document parse
> > failed: [Fatal
> > Error] :32:88: Element type "Level" must be followed by
> > either attribute
> > spec
> > ifications, ">" or "/>".
> >
> >        at
> > org.eigenbase.xom.wrappers.GenericDOMParser.handleErrors(Unknown
> > Source)
> >        at
> > org.eigenbase.xom.wrappers.JaxpDOMParser.parseInputSource(Unknown
> > Source)
> >        at
> > org.eigenbase.xom.wrappers.GenericDOMParser.parse(Unknown Source)
> >        at mondrian.rolap.RolapSchema.load(RolapSchema.java:303)
> >        ... 94 more
> > 10:27:51,956 ERROR [Logger] Error end:
> > 10:27:51,956 ERROR [Logger] misc-MondrianModelComponent:
> > MondrianModel.ERROR_0001 - [es_82] getInitialQuery():
> > Connection is not
> > valid: {PoolNeeded=fa
> > lse, dataSource=java:TeradataDS, Provider=mondrian,
> > Catalog=solution:samples/analysis/cuboprueba.mondrian.xml}
> > 10:27:51,956 ERROR [PivotViewComponent] Error Start: Pentaho
> > Pentaho BI
> > Platform 1.6.0.GA.863
> > 10:27:51,956 ERROR [PivotViewComponent]
> > 79ff1a2b-da37-11dc-ad54-931a72ea8013:COMPONENT:context-1735417
> 8-120290927190
> > 9:cuboprueba.xactionBase.ERROR_000
> > 2 - Ejecuci>n fallida del Componente
> > java.lang.NullPointerException
> >        at java.util.regex.Matcher.getTextLength(Matcher.java:1127)
> >
> > .
> >
> > .
> >
> > .
> >
> > 10:27:51,956 ERROR [PivotViewComponent] Error end:
> > 10:27:51,956 ERROR [RuntimeContext]
> > 79ff1a2b-da37-11dc-ad54-931a72ea8013:RUNTIME:context-17354178-
> 1202909271909:
> > cuboprueba.xaction RuntimeContext.ERRO
> > R_0012 - [es_33] ActionDefinition for PivotViewComponent did
> > not execute
> > successfully
> >
> >
> > (Again, the error itself is a lot longer, but that seems like the most
> > important part)
> > PLEASE, at this point Im desesperate, I've searched every
> > forum I've found
> > and I found nothing to help me, We have a lot of hope in this
> > platform, but
> > at this point it's begining to be a lot of trouble. HELP!!
> >
> > Thanks.
> >   Francisco Martmn C.
> >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL:
> > http://lists.pentaho.org/pipermail/mondrian/attachments/200802
> > 14/a16cf8d4/at
> > tachment-0001.html
> >
> > ------------------------------
> >
> > Message: 2
> > Date: Thu, 14 Feb 2008 11:45:52 -0800
> > From: "Julian Hyde" <jhyde at pentaho.org>
> > Subject: RE: [Mondrian] High Cardinality for Mondrian
> > To: <luis.canals at stratebi.com>
> > Cc: mondrian at pentaho.org
> > Message-ID: <2A840341C8ED4706A866F2BCCA09AF1A at mackerel>
> > Content-Type: text/plain; charset="us-ascii"
> >
> > I have logged a bug to track this issue:
> >
> > http://sourceforge.net/tracker/index.php?func=detail
> > <http://sourceforge.net/tracker/index.php?func=detail&aid=1893
> 985&group_id=3
> > 5> &aid=1893985&group_id=35
> > 302&atid=414616
> >
> > I have attached the code after I integrated it with the head
> > revision. It is
> > in the format produced by the packChange utility, so it
> > should be easy to
> > re-integrate with head in future.
> >
> > Packchange is described here:
> >
> > http://p4web.eigenbase.org/open/util/index.html
> >
> > and can be downloaded from here:
> >
> > http://p4web.eigenbase.org/open/util/bin/
> >
> > It runs on linux and windows/cygwin.
> >
> > Julian
> > -------------- next part --------------
> > A non-text attachment was scrubbed...
> > Name: changelist10559-large-dimension-support.tar.gz
> > Type: application/x-gzip
> > Size: 496848 bytes
> > Desc: not available
> > Url :
> > http://lists.pentaho.org/pipermail/mondrian/attachments/200802
> > 14/1f200d91/ch
> > angelist10559-large-dimension-support.tar.gz
> >
> > ------------------------------
> >
> > _______________________________________________
> > Mondrian mailing list
> > Mondrian at pentaho.org
> > http://lists.pentaho.org/mailman/listinfo/mondrian
> >
> >
> > End of Mondrian Digest, Vol 15, Issue 19
> > ****************************************
> >
> >
> >
> > -------------- next part --------------
> > An HTML attachment was scrubbed...
> > URL:
> > http://lists.pentaho.org/pipermail/mondrian/attachments/200802
> > 15/f2951773/at
> > tachment-0001.html
> >
> > ------------------------------
> >
> > _______________________________________________
> > Mondrian mailing list
> > Mondrian at pentaho.org
> > http://lists.pentaho.org/mailman/listinfo/mondrian
> >
> >
> > End of Mondrian Digest, Vol 15, Issue 23
> > ****************************************
> >
> > _______________________________________________
> > Mondrian mailing list
> > Mondrian at pentaho.org
> > http://lists.pentaho.org/mailman/listinfo/mondrian
> >
>
>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 17 Feb 2008 10:59:52 -0800
> From: "Julian Hyde" <jhyde at pentaho.org>
> Subject: RE: [Mondrian] Parent-child hierarchies and StrToMember
> To: "'Mondrian developer mailing list'" <mondrian at pentaho.org>
> Message-ID: <0A64A0EC9F3445C4A7E54CD62CDF3A93 at mackerel>
> Content-Type: text/plain;       charset="KOI8-R"
>
> Nikolay,
>
> Can you please log a bug with all of this information in it. I will get to
> it as soon as I can. If you can reproduce the problem against the FoodMart
> database, even better - we will be able to fix it faster.
>
> Julian
>
> > -----Original Message-----
> > From: mondrian-bounces at pentaho.org
> > [mailto:mondrian-bounces at pentaho.org] On Behalf Of Nikolay Samofatov
> > Sent: Sunday, February 17, 2008 3:32 AM
> > To: Mondrian developer mailing list
> > Subject: [Mondrian] Parent-child hierarchies and StrToMember
> >
> > Hi, Dear Mondrian developers!
> >
> > We have encountered an issue with parent-child hierarchies.
> >
> > The problem is that if you take UniqueName for a member in a
> > parent-child hierarchy and than pass it to a StrToMember it
> > cannot find
> > a member.
> >
> > The UniqueName is generated in the form:
> > <HierarchyName>.<AllMemeberName>.<ParentName>.<ChildName>......
> >
> > Such name does not resolve in recent mondrian (tested
> > perforce version
> > as of yesterday).
> >
> > This logic doesn't work for a while already. I think this is a
> > regression from Mondrian 2.2 release, but I didn't test to find exact
> > build where it got broken.
> >
> > To reference members in parent-child hierarchy now one has to use:
> > <HierarchyName>.<LevelName>.<MemberName>
> >
> > If so, shouldn't UniqueName return names in this form for
> > members of a
> > parent-child hierarchy?
> >
> > As an example, see cube:
> >
> >   <Cube name="æÉÌØÔÒÙ É ÐÒÅÄÓÔÁ×ÌÅÎÉÑ">
> >     <Table name="KBK_REGION_FACT"/>
> >
> >     <Dimension name="ôÅÒÒÉÔÏÒÉÑ" foreignKey="REGION">
> >       <Hierarchy hasAll="true" parentColumn="PARENT_ID"
> > allMemberName="÷ÓÅ ÔÅÒÒÉÔÏÒÉÉ" primaryKey="ID">
> >         <Table name="TERRITORY"/>
> >         <Level name="ôÅÒÒÉÔÏÒÉÑ" column="ID" nameColumn="CAPTION"
> > parentColumn="PARENT_ID" uniqueMembers="true">
> >           <Property name="HasChildren" type="Numeric"
> > column="HAS_CHILDREN"/>
> >           <Closure parentColumn="PARENT_ID"
> > childColumn="TERRITORY_ID">
> >             <Table name="TERRITORY_CLOSURE"/>
> >           </Closure>
> >         </Level>
> >       </Hierarchy>
> >     </Dimension>
> >
> >     <Dimension name="ëâë" foreignKey="KBK">
> >       <Hierarchy hasAll="true" allMemberName="÷ÓÅ ËÏÄÙ"
> > primaryKey="KBK">
> >         <Table name="KBK_VIEW"/>
> >         <Level name="ëâë1" column="KBK1" uniqueMembers="true"/>
> >         <Level name="ëâë2" column="KBK2" uniqueMembers="true"/>
> >         <Level name="ëâë" column="KBK" uniqueMembers="true"/>
> >       </Hierarchy>
> >     </Dimension>
> >
> >     <Measure name="PARAM" column="AMOUNT" aggregator="sum"
> > formatString="#,###.00"/>
> >
> >   </Cube>
> >
> > The query:
> >
> > with member [Measures].[Test] as
> > 'StrToMember([ôÅÒÒÉÔÏÒÉÑ].CurrentMember.UniqueName)'
> > select NON EMPTY {[Measures].[Test]}
> > ON COLUMNS,
> >   crossjoin({[ôÅÒÒÉÔÏÒÉÑ].[ôÅÒÒÉÔÏÒÉÑ].[÷ÅÎÇÒÉÑ]},
> > {[ëâë].AllMembers})
> > ON ROWS
> > from [æÉÌØÔÒÙ É ÐÒÅÄÓÔÁ×ÌÅÎÉÑ]
> >
> > Dies with:
> >
> > Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object
> > '÷ÅÎÇÒÉÑ' not found in member '[ôÅÒÒÉÔÏÒÉÑ].[÷ÓÅ ÔÅÒÒÉÔÏÒÉÉ]'
> >     at
> > mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:802)
> >     at mondrian.olap.Util.lookupCompound(Util.java:585)
> >     at
> > mondrian.rolap.RolapSchemaReader.lookupCompound(RolapSchemaRea
> > der.java:345)
> >     at
> > mondrian.olap.DelegatingSchemaReader.lookupCompound(Delegating
> > SchemaReader.java:100)
> >     at
> > mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1539)
> >     at
> > mondrian.olap.Query$QuerySchemaReader.lookupCompound(Query.java:1506)
> >     at
> > mondrian.olap.fun.BuiltinFunTable$23.strToMember(BuiltinFunTab
> > le.java:649)
> >     at
> > mondrian.olap.fun.BuiltinFunTable$23$1.evaluateMember(BuiltinF
> > unTable.java:639)
> >     at
> > mondrian.calc.impl.MemberValueCalc.evaluate(MemberValueCalc.java:47)
> >     at
> > mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:529)
> >
> >
> >
> > Nikolay Samofatov
> > _______________________________________________
> > Mondrian mailing list
> > Mondrian at pentaho.org
> > http://lists.pentaho.org/mailman/listinfo/mondrian
> >
>
>
>
> ------------------------------
>
> Message: 3
> Date: Sun, 17 Feb 2008 11:19:04 -0800
> From: "Julian Hyde" <jhyde at pentaho.org>
> Subject: RE: [Mondrian] Problem with aggregate tables..
> To: "'Mondrian developer mailing list'" <mondrian at pentaho.org>
> Message-ID: <29891C70C8A846DCB4B151BF55916870 at mackerel>
> Content-Type: text/plain; charset="us-ascii"
>
> I don't think any progress has been made on this issue. I looked at the
> history of the email thread, and it quickly diverged into another issue. I
> ran the tests, but as I said, I need that regression test, and I'm not
> going
> to have any time soon to write it. Maybe someone else will write it - my
> description re. TestAggregationManager is as much as I'll give as far as
> 'pointers' - any more and I'd be writing the code myself - but I have a
> feeling that no one else will write the test.
>
> So, please log a bug with all of this information in it, so it doesn't get
> forgotten, and we will get to it one day.
>
> Julian
>
>
> _____
>
> From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
> On
> Behalf Of Ati Rosselet
> Sent: Sunday, February 17, 2008 5:04 AM
> To: Mondrian developer mailing list
> Subject: Re: [Mondrian] Problem with aggregate tables..
>
>
> Julian (and others?)
> Ok... I give up.. I have no idea how to properly test these changes.  Are
> they still applicable to the current CVS version? (I assume so.. since I
> haven't seen any notes/commits pertaining to this problem).   You
> mentioned
> that you were going to run it through the regression suite to see if any
> problems popped up - but I never heard of any results.. Does this mean
> that
> basically all is ok?  This fix is kind of important.. pretty vital to us
> in
> fact, and I'm surprised no-one else has encountered the problem I address
> in
> it.   If you (or anyone) would be willing to either write the test, or
> give
> me some pointers (I'm completely lost - probably partly from being in the
> middle of a large .NET project :)), I'd be very grateful.   I'll try to
> get
> the CVS version of 3.0 and see if the patches can still be applied.
>
> Cheers
> Ati
>
>
> 2007/10/23 Julian Hyde <julianhyde at speakeasy.net>:
>
>
> Ati,
>
> Thanks for the fix. I've run your changes through the regression suite.
> Looking good so far. I'll run the suite in all of its various property
> settings tonight and see if anything pops out.
>
> Since this change is a bug fix, I need a regression test before I will
> check
> in. I think you could construct a testcase based on the foodmart database.
> Add the test to TestAggregationManager; testMultipleMeasures is an example
> of a test which runs an MDX query and checks that a particular SQL query
> is
> generated. You will also need to use TestContext.create() to alter the
> XML;
> testKeyExpressionCardinalityCache is an example of a test which does that.
>
> Julian
>
>
> _____
>
>
> From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org]
> On
> Behalf Of Ati Rosselet
>
> Sent: Monday, October 22, 2007 5:23 PM
> To: Mondrian developer mailing list
> Subject: Re: [Mondrian] Problem with aggregate tables..
>
>
> sorry... cut and paste got me.. end of first function ended up after the
> end
> of the 2nd modified function. so
>
>      /**
>         * Finds ALL the child tables of the fact table with the given
> columnName
>         * used in their left join condition. This is used by the
> AggTableManager
>         * while characterizing the fact table columns. (previous only
> returned FIRST child)
>         */
>       public ArrayList<RolapStar.Table>
> findTablesWithLeftJoinCondition(final String columnName)
>
>       {
>            java.util.ArrayList<RolapStar.Table> tables = new
> java.util.ArrayList<RolapStar.Table>();
>            for (Table child : getChildren()) {
>                Condition condition = child.joinCondition;
>                if (condition != null) {
>                    if (condition.left instanceof MondrianDef.Column) {
>                        MondrianDef.Column mcolumn =
>                            ( MondrianDef.Column) condition.left;
>                        if (mcolumn.name.equals(columnName)) {
>                            tables.add(child);
>                        }
>                    }
>                }
>            }
>            return (tables.size()==0?null:tables);
>        }
>
> and  remove the return part from other function..
>
> Cheers..
> Ati
>
>
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.pentaho.org/pipermail/mondrian/attachments/20080217/43be873f/attachment.html
>
> ------------------------------
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
>
> End of Mondrian Digest, Vol 15, Issue 25
> ****************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080218/3e8a7eb1/attachment.html 


More information about the Mondrian mailing list