[Mondrian] Problem with special characters

Wed Feb 20 12:42:55 EST 2008

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.

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