<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6001.17052" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=835590121-15022008><FONT face=Verdana
color=#000080 size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=835590121-15022008><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=835590121-15022008><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><BR>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Francisco
Martín<BR><B>Sent:</B> Friday, February 15, 2008 7:35 AM<BR><B>To:</B>
mondrian@pentaho.org<BR><B>Subject:</B> [Mondrian] RE: I need help conecting
to Teradata (Julian Hyde)<BR></FONT><BR></DIV>
<DIV></DIV>
<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></BLOCKQUOTE></BODY></HTML>