<div>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)</div>
<div> </div>
<div>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:</div>
<blockquote dir="ltr" style="MARGIN-RIGHT: 0px">
<div>select sum("GC_LiDEr_WRK"."TBL_CUBO_CLIENTES_MCL_3000"."MONTO_CHEQUE") as "m0" </div>
<div>from "TBL_CUBO_CLIENTES_MCL_3000"</div></blockquote>
<div dir="ltr">Instead of the original:</div>
<blockquote dir="ltr" style="MARGIN-RIGHT: 0px">
<div dir="ltr">select sum("GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"."MONTO_CHEQUE") as "m0" from "GC_LIDER_WRK"."<br>TBL_CUBO_CLIENTES_MCL_3000" as "GC_LIDER_WRK"."TBL_CUBO_CLIENTES_MCL_3000"</div>
</blockquote>
<div dir="ltr">I hope you can help me a bit more, I feel I'm getting close. Thanks a million.</div>
<div> </div>
<div>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.</div>
<div>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.</div><br><br>
<div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Message: 1<br>Date: Thu, 14 Feb 2008 09:12:15 -0800<br>From: "Julian Hyde" <<a href="mailto:jhyde@pentaho.org">jhyde@pentaho.org</a>><br>
Subject: RE: [Mondrian] I need help conecting to Teradata<br>To: "'Mondrian developer mailing list'" <<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>><br>Message-ID: <459B0A2691BA494D8316BDD1BACB1082@mackerel><br>
Content-Type: text/plain; charset="iso-8859-1"<br><br>Two errors here. First, it can't find the object. Have you maybe spelled the<br>table in lowercase in your schema file, and it is uppercase in Teradata; or<br>
perhaps it needs to be qualified by a schema name in teradata. Turn on SQL<br>tracing (mondrian.trace.level=1) and see what SQL mondrian generates, then<br>try running that SQL using teradata's command line.<br><br>Second, when you changed the schema.xml file you made it into invalid XML. I<br>
think you forgot to terminate the <Level> element with />. Maybe you tried<br>to put comments inside the Level element?<br><br>Julian<br><br><br>_____<br><br>From: <a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a> [mailto:<a href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a>] On<br>
Behalf Of Francisco Martín<br>Sent: Thursday, February 14, 2008 4:48 AM<br>To: <a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>Subject: [Mondrian] I need help conecting to Teradata<br><br><br>Hello, I've been using Mondrn with Pentaho BI Suite and for some reason I<br>
can't connect to Teradata with Mondrian, I can make reports using my DB, the<br>problem only comes with Mondrian. Here's what I do:<br><br>I use Cube Designer to design and publish a cube, at this point I have no<br>
problem accesing the data from Teradata, I can use the graphic interface<br>perfectly. In Cube designer I have to use the JDBC drivers version<br><a href="http://03.01.00.102">03.01.00.102</a>, If I use newer ones I can't connect... So far so good<br>
<br>Now to actually SEE the cube, The JDBC drivers defined in Jboss are version<br>12.0, here the version <a href="http://3.01.00.102">3.01.00.102</a> simply don't work. So, I go to<br>localhost/samples/analysis and when I click on a SampleData cube I can see<br>
it perfectly, but, a Teradatya cube... NOTHING, The only thing I see is the<br>message from Jboss that goes like this:<br><br><br>10:23:15,865 INFO [STDOUT] , exec+fetch 47 ms, 0 rows<br>10:23:15,865 ERROR [MondrianModel] Parse Failure<br>
mondrian.olap.MondrianException: Mondrian Error:Failed to parse query '<br> select NON EMPTY {[Measures].[SUM of<br>TBL_CUBO_CLIENTES_MCL_3000.RUTCLI]} ON columns, NON EMPTY {([Sexo.Sexo].[All<br>sexo], [Rango.Rango].[All r<br>
ango])} ON rows from [cubo0902]<br>'<br> at<br>mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)<br>.<br>.<br>.<br>.<br> at java.lang.Thread.run(Thread.java:595)<br>Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while<br>
parsing MDX statement '<br> select NON EMPTY {[Measures].[SUM of<br>TBL_CUBO_CLIENTES_MCL_3000.RUTCLI]} ON columns, NON EMPTY {([Sexo.Sexo].[All<br>sexo], [Rango.Rango].[All r<br>ango])} ON rows from [cubo0902]<br>
'<br> at<br>mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)<br>.<br>.<br>.<br>.<br>10:23:15,865 ERROR [MondrianModel] [NCR] [Teradata DBMS] : Object<br>'TBL_CUBO_CLIENTES_MCL_3000' does not exist.<br>
10:23:15,865 ERROR [OlapModelProxy]<br>com.tonbeller.jpivot.olap.model.OlapException: [NCR] [Teradata DBMS] :<br>Object 'TBL_CUBO_CLIENTES_MCL_3000' does not exist.<br><br><br>(...And a lot more)<br>Which seems to be because the name of the Database itself is nowehre to be<br>
found, it just references the tables. So, my natural instinct suggest me to<br>change the .xml and add the reference to the table... at this point I get<br>the following error:<br><br><br><br>10:27:51,940 ERROR [Logger] Error: Pentaho Pentaho BI Platform 1.6.0.GA.863<br>
10:27:51,940 ERROR [Logger]<br>misc-org.pentaho.data.connection.mdx.MDXConnection: MDXConnection.ERROR_0002<br>- "Unable to create a native connection for c<br>onnection string: "Mondrian Error:Internal error: while parsing catalog<br>
solution:samples/analysis/cuboprueba.mondrian.xml"<br>mondrian.olap.MondrianException: Mondrian Error:Internal error: while<br>parsing catalog solution:samples/analysis/cuboprueba.mondrian.xml<br> at<br>mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)<br>
.<br>.<br>.<br><br> at java.lang.Thread.run(Thread.java:595)<br>Caused by: org.eigenbase.xom.XOMException: Document parse failed: [Fatal<br>Error] :32:88: Element type "Level" must be followed by either attribute<br>
spec<br>ifications, ">" or "/>".<br><br> at org.eigenbase.xom.wrappers.GenericDOMParser.handleErrors(Unknown<br>Source)<br> at org.eigenbase.xom.wrappers.JaxpDOMParser.parseInputSource(Unknown<br>
Source)<br> at org.eigenbase.xom.wrappers.GenericDOMParser.parse(Unknown Source)<br> at mondrian.rolap.RolapSchema.load(RolapSchema.java:303)<br> ... 94 more<br>10:27:51,956 ERROR [Logger] Error end:<br>
10:27:51,956 ERROR [Logger] misc-MondrianModelComponent:<br>MondrianModel.ERROR_0001 - [es_82] getInitialQuery(): Connection is not<br>valid: {PoolNeeded=fa<br>lse, dataSource=java:TeradataDS, Provider=mondrian,<br>Catalog=solution:samples/analysis/cuboprueba.mondrian.xml}<br>
10:27:51,956 ERROR [PivotViewComponent] Error Start: Pentaho Pentaho BI<br>Platform 1.6.0.GA.863<br>10:27:51,956 ERROR [PivotViewComponent]<br>79ff1a2b-da37-11dc-ad54-931a72ea8013:COMPONENT:context-17354178-120290927190<br>
9:cuboprueba.xactionBase.ERROR_000<br>2 - Ejecucižn fallida del Componente<br>java.lang.NullPointerException<br> at java.util.regex.Matcher.getTextLength(Matcher.java:1127)<br><br>.<br><br>.<br><br>.<br><br>10:27:51,956 ERROR [PivotViewComponent] Error end:<br>
10:27:51,956 ERROR [RuntimeContext]<br>79ff1a2b-da37-11dc-ad54-931a72ea8013:RUNTIME:context-17354178-1202909271909:<br>cuboprueba.xaction RuntimeContext.ERRO<br>R_0012 - [es_33] ActionDefinition for PivotViewComponent did not execute<br>
successfully<br><br><br>(Again, the error itself is a lot longer, but that seems like the most<br>important part)<br>PLEASE, at this point Im desesperate, I've searched every forum I've found<br>and I found nothing to help me, We have a lot of hope in this platform, but<br>
at this point it's begining to be a lot of trouble. HELP!!<br><br>Thanks.<br> Francisco Martín C.<br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20080214/a16cf8d4/attachment-0001.html">http://lists.pentaho.org/pipermail/mondrian/attachments/20080214/a16cf8d4/attachment-0001.html</a><br>
<br>------------------------------<br><br>Message: 2<br>Date: Thu, 14 Feb 2008 11:45:52 -0800<br>From: "Julian Hyde" <<a href="mailto:jhyde@pentaho.org">jhyde@pentaho.org</a>><br>Subject: RE: [Mondrian] High Cardinality for Mondrian<br>
To: <<a href="mailto:luis.canals@stratebi.com">luis.canals@stratebi.com</a>><br>Cc: <a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>Message-ID: <2A840341C8ED4706A866F2BCCA09AF1A@mackerel><br>
Content-Type: text/plain; charset="us-ascii"<br><br>I have logged a bug to track this issue:<br><br><a href="http://sourceforge.net/tracker/index.php?func=detail&aid=1893985&group_id=35">http://sourceforge.net/tracker/index.php?func=detail&aid=1893985&group_id=35</a><br>
302&atid=414616<br><br>I have attached the code after I integrated it with the head revision. It is<br>in the format produced by the packChange utility, so it should be easy to<br>re-integrate with head in future.<br>
<br>Packchange is described here:<br><br><a href="http://p4web.eigenbase.org/open/util/index.html">http://p4web.eigenbase.org/open/util/index.html</a><br><br>and can be downloaded from here:<br><br><a href="http://p4web.eigenbase.org/open/util/bin/">http://p4web.eigenbase.org/open/util/bin/</a><br>
<br>It runs on linux and windows/cygwin.<br><br>Julian<br>-------------- next part --------------<br>A non-text attachment was scrubbed...<br>Name: changelist10559-large-dimension-support.tar.gz<br>Type: application/x-gzip<br>
Size: 496848 bytes<br>Desc: not available<br>Url : <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20080214/1f200d91/changelist10559-large-dimension-support.tar.gz">http://lists.pentaho.org/pipermail/mondrian/attachments/20080214/1f200d91/changelist10559-large-dimension-support.tar.gz</a><br>
<br>------------------------------<br><br>_______________________________________________<br>Mondrian mailing list<br><a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br><a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br><br>End of Mondrian Digest, Vol 15, Issue 19<br>****************************************<br></blockquote></div><br>