Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Doubt special character MDX - CDE

  1. #1

    Unhappy Doubt special character MDX - CDE

    Hello Everyone,

    Please could someone help me??

    I have the following mdx query (please check the bolded word):

    select NON EMPTY {([Hour Type Senior.Hierarchy].[Todos os Tipos de Hora],
    [Measures].[Worked Hours])} ON COLUMNS,
    NON EMPTY {[Location Senior.Hierarchy].[Todos os Tipos de Local],
    [Location Senior.Hierarchy].[Acabamento tarde],
    [Location Senior.Hierarchy].[Acabamento noite],
    [Location Senior.Hierarchy].[Acabamento manhã]} ON ROWS
    from [2.2 Senior Worked Hours]
    where {[Date.Hierachy Month Number].[2013-07-05]}

    This query works fine in mondrian, but when I try to get the data from CDE it does not returns the "Acabamento manhã" values, if I remove the ~ character from my dimension table and from the query it works fine. I checked with CDA and I have the same problem, it does not show the column, just the columns without special character.

    Thank you very much for any help!

    Leandro Guimarães.

  2. #2
    Join Date
    Nov 2011
    Posts
    1,229

    Default

    anything on the server logs ?
    Pedro Vale
    --
    CTools Product Development
    http://www.webdetails.pt

  3. #3
    Join Date
    Jun 2013
    Posts
    1

    Default

    Hi,


    I want to say thank you for such useful tool like ctools. I have installed plugins using

    ctools-installer.sh. But when I try to bind datasource to dashboard component error occurs.


    OLAP Chart wizard can not show dimensions, measures when my xml schema contains russian words in dimension, measure captions. But when I choose SampleData Schema it retrieves all dimensions, measures successfully.

    I browsed pentaho forums but did not find a solution. How to fix it? Please, help!

    Thank you in advanced!

    I have attached my xml schema and pentaho.txt log file for clarity.

    p.s. I my view this issue because of Mondrian parser, though it successfully parses MDX in JPivot.
    Attached Files Attached Files
    Last edited by b.kazybayev; 07-23-2013 at 02:58 AM. Reason: to add key phrase

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.