<div>Thanks, I can't change the charset from the DB itself, what I did was check the configuration of the ODBC drivers, it was set to ASCII, so, I change the connection string in the teradata-ds.xml file accordingly and I still have the problem. I hope someone can help.</div>
<div><br><br> </div>
<div><span class="gmail_quote">2008/2/20, <a href="mailto:mondrian-request@pentaho.org">mondrian-request@pentaho.org</a> <<a href="mailto:mondrian-request@pentaho.org">mondrian-request@pentaho.org</a>>:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Send Mondrian mailing list submissions to<br> <a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>
<br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:mondrian-request@pentaho.org">mondrian-request@pentaho.org</a><br><br>You can reach the person managing the list at<br> <a href="mailto:mondrian-owner@pentaho.org">mondrian-owner@pentaho.org</a><br>
<br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Mondrian digest..."<br><br><br>Today's Topics:<br><br> 1. Reg.Export JPivot (Smruti Naik)<br> 2. Problem with special characters ( Francisco Mart?n )<br>
3. Re: Reg.Export JPivot (Agustin Campos)<br> 4. Re: Problem with special characters (Agustin Campos)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Wed, 20 Feb 2008 16:29:34 +0530<br>
From: "Smruti Naik" <<a href="mailto:mehtasmruti@gmail.com">mehtasmruti@gmail.com</a>><br>Subject: [Mondrian] Reg.Export JPivot<br>To: <a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>Message-ID:<br>
<<a href="mailto:64c4ff000802200259y12e8cf43g3e8e95952030774@mail.gmail.com">64c4ff000802200259y12e8cf43g3e8e95952030774@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>
Hi there ,<br><br>When I do Export To Excel From Jpivot .then I do not get Drill through table<br>in Exported data , i get only hirarchy table and graph .<br><br>Is this thing configurable or there is a bug . can you please tell me how to<br>
do that ?<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20080220/8df62046/attachment-0001.html">http://lists.pentaho.org/pipermail/mondrian/attachments/20080220/8df62046/attachment-0001.html</a><br>
<br>------------------------------<br><br>Message: 2<br>Date: Wed, 20 Feb 2008 09:26:04 -0300<br>From: " Francisco Mart?n " <<a href="mailto:franciscomartin.cl@gmail.com">franciscomartin.cl@gmail.com</a>><br>
Subject: [Mondrian] Problem with special characters<br>To: <a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>Message-ID:<br> <<a href="mailto:e9ef00d0802200426g6be99c73i9f711c89b27d198e@mail.gmail.com">e9ef00d0802200426g6be99c73i9f711c89b27d198e@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br><br>Hey, I'm having some problems seeing special characthers (Ñ, ñ, Á, á, É, é,<br>Í, í, Ó, ó, Ú, ú). I change the codification of the .xml file to ISO-8859-1<br>
And now the special characters that I write on the .xml (.mondrian or<br>.xaction) work correctly, but the data that comes from the DB does not<br>display correclty. This wouldn't be so important except that I can't<br>
desagregate any field with one of these characters, when I try to do that,<br>the generated query includes a '?' where the special character should be and<br>that returns (obviously) no results. Any ideas if this a Mondrian, Pentaho,<br>
Jboss or other problem?? Thanks<br><br><br>Regards,<br> Francisco Martín C.<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20080220/117674f8/attachment-0001.html">http://lists.pentaho.org/pipermail/mondrian/attachments/20080220/117674f8/attachment-0001.html</a><br>
<br>------------------------------<br><br>Message: 3<br>Date: Wed, 20 Feb 2008 16:44:12 +0100<br>From: "Agustin Campos" <<a href="mailto:aguscampos@gmail.com">aguscampos@gmail.com</a>><br>Subject: Re: [Mondrian] Reg.Export JPivot<br>
To: "Mondrian developer mailing list" <<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>><br>Message-ID:<br> <<a href="mailto:5522111a0802200744g1e13aea9x7807cda3d1d7b335@mail.gmail.com">5522111a0802200744g1e13aea9x7807cda3d1d7b335@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br><br>if I am not wrong, there isn't any bug.<br>If you want to insert drill-down table on the exported file i would take a<br>look at the template file (in this case xls_mdxtable.xsl, or something like<br>
it).<br>Then, I would search the the table or the graph which will be shown, in the<br>case they are vissible.<br>Once you know HOW they are embeded, I would copy the line(s) that allow you<br>to show them and paste them in the place where you whant the drill-down<br>
table to be shown.<br><br>Once you have pasted thhose lines, change them making reference to the<br>drill-down table. So, when it is visible, you will see it on your exported<br>file.<br><br>I repeat that I am not very sure if this is the way to achive your needs,<br>
but that's what I would do.<br>I'm sorry, but i can't help you more.<br><br>2008/2/20, Smruti Naik <<a href="mailto:mehtasmruti@gmail.com">mehtasmruti@gmail.com</a>>:<br>><br>> Hi there ,<br>><br>
> When I do Export To Excel From Jpivot .then I do not get Drill through<br>> table in Exported data , i get only hirarchy table and graph .<br>><br>> Is this thing configurable or there is a bug . can you please tell me how<br>
> to do that ?<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><br><br>--<br>Agustín Campos Muñoz<br><a href="http://www.acampos.net">http://www.acampos.net</a><br><br>Email: aguscamposENgmailPUNTOcom<br> acamposENiiesPUNTOes<br>MSN Messenger: acampozENhotmailPUNTOcom<br>
Skype: acamposnet<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20080220/84b71122/attachment-0001.html">http://lists.pentaho.org/pipermail/mondrian/attachments/20080220/84b71122/attachment-0001.html</a><br>
<br>------------------------------<br><br>Message: 4<br>Date: Wed, 20 Feb 2008 17:01:37 +0100<br>From: "Agustin Campos" <<a href="mailto:aguscampos@gmail.com">aguscampos@gmail.com</a>><br>Subject: Re: [Mondrian] Problem with special characters<br>
To: "Mondrian developer mailing list" <<a href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a>><br>Message-ID:<br> <<a href="mailto:5522111a0802200801i7f06adb9pa6398836b1552d20@mail.gmail.com">5522111a0802200801i7f06adb9pa6398836b1552d20@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br><br>Some time ago I had the same problem, but It wasn't Pentaho neither<br>mondrian... But it could be the same case as yours.<br><br>I had Apache and MySQL. When I wanted to get data from the database, all<br>
those characters that you are saying appeared as '?'. I managed to solve it<br>changing charset from the DATABASE. So, what I would do in your case, is<br>have a look at your database charset and see if it's the same as ISO-8859-1.<br>
<br><br>Tell me something when you are done, so I'll see if I am able to help you.<br>But I don't think so.<br><br>2008/2/20, Francisco Martín <<a href="mailto:franciscomartin.cl@gmail.com">franciscomartin.cl@gmail.com</a>>:<br>
><br>> Hey, I'm having some problems seeing special characthers (Ñ, ñ, Á, á, É,<br>> é, Í, í, Ó, ó, Ú, ú). I change the codification of the .xml file to ISO-8859-1<br>> And now the special characters that I write on the .xml (.mondrian or<br>
> .xaction) work correctly, but the data that comes from the DB does not<br>> display correclty. This wouldn't be so important except that I can't<br>> desagregate any field with one of these characters, when I try to do that,<br>
> the generated query includes a '?' where the special character should be and<br>> that returns (obviously) no results. Any ideas if this a Mondrian, Pentaho,<br>> Jboss or other problem?? Thanks<br>><br>
><br>> Regards,<br>> Francisco Martín C.<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><br><br>--<br>Agustín Campos Muñoz<br><a href="http://www.acampos.net">http://www.acampos.net</a><br>
<br>Email: aguscamposENgmailPUNTOcom<br> acamposENiiesPUNTOes<br>MSN Messenger: acampozENhotmailPUNTOcom<br>Skype: acamposnet<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://lists.pentaho.org/pipermail/mondrian/attachments/20080220/f272ab7d/attachment-0001.html">http://lists.pentaho.org/pipermail/mondrian/attachments/20080220/f272ab7d/attachment-0001.html</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 29<br>****************************************<br></blockquote></div><br>