[Mondrian] RE: I need help conecting to Teradata (Julian Hyde)
Julian Hyde
jhyde at pentaho.org
Sun Feb 17 13:52:05 EST 2008
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
>
More information about the Mondrian
mailing list