Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Table component strangeness..

  1. #1
    Join Date
    Apr 2007
    Posts
    2,009

    Default Table component strangeness..

    Hi,

    I have a very simple mdx query which provides data for a choice component in a dashboard, which then drives a parameterised flash chart, all good

    But when I then try to squirt the same data into a table component it just sits there "Processing" for ever.

    This is using 3.5.2 server, and CDF-DE.

    Any ideas?

    Thanks!
    Dan

    PS: The MDX query is:

    <code>
    select {[Measures].[Errors]} ON COLUMNS,
    NON EMPTY [Pharma].Children ON ROWS
    from [Ranges]
    </code>

    And the table is defined as column headers Pharma, Errors, which are String and Integer.

    I did notice errors if i got the number of columns wrong, but they've gone away now, so a bit confused!

    Running the query in schema workbench, i can see it returns empty axis 0, Axis 1 as {[Measures].[Errors]} and Axis#2 as each pharma company, e.g. {[Pharma].[All Pharmas].[Generic Pharma Company]}

    b.t.w. this is my first day learning MDX in anger - so this is probably a very newbie question!

  2. #2
    Join Date
    Jul 2007
    Posts
    2,497

    Default

    No errors in firebug? That should print 2 columns
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  3. #3
    Join Date
    Apr 2007
    Posts
    2,009

    Default

    Ah brilliant - i forgot to try firebug - it showed invalid call to String.asc which showed me i'd used String not string - case sensitive!

    Thanks! Glad im on the right track!

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.