Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Charting Woes

  1. #1
    Join Date
    Jun 2009
    Posts
    3

    Default Charting Woes

    Good morning,

    there's probably a very simle explanation to this, but having spent some time searching the forums and trying various different approaches I'm afraid my feeble brain has hit a dead end and any suggestions would be appreciated.

    I using Report Designer 3.0.0 build 3722.

    Given a report containing a data source defined by the SQL:

    SELECT
    log_time,
    CAST(
    dbms_lob.SUBSTR( log_message,
    INSTR( log_message,'->') -
    INSTR(log_message, ': ')-3,
    INSTR(log_message,': ')+2)
    AS NUMBER(10)) AS before_GC,
    CAST(
    dbms_lob.SUBSTR( log_message,
    INSTR(log_message,'(') -
    INSTR(log_message,'->')-3,
    INSTR(log_message,'->')+2)
    AS NUMBER(10)) AS after_GC,
    CAST(
    dbms_lob.SUBSTR(log_message,
    INSTR(log_message,'secs') -
    INSTR(log_message,',')-3,
    INSTR(log_message,',')+2)
    AS NUMBER(10, 3)) AS GC_time,
    host,
    CAST(user1 AS VARCHAR2(2))AS Island
    FROM
    "LOGS"
    WHERE
    app = 'OAS'
    AND log_level = 'PARTIAL GC'
    ORDER BY
    host,
    CAST(user1 AS VARCHAR2(2)),
    log_time

    The query returns data to the report when run.

    I've tried to create a variety of charts based on this query, the current attempt is a bar chart (which is only being used whilst I try to get a clue). The relevant fields in the bar chart definition (left hand column) are:

    Name: GCChartName
    Data: More Stuff
    Title: Garbage Collection Statistics

    and the right-hand column:

    Name: More Stuff
    Category Column: LOG_TIME
    Value Columns: [AFTER_GC, BEFORE_GC, GC_TIME]
    Series Names: [ Ater GC, Before GC, GC Time]
    Series Colum: false
    Summary only: false.

    Executing the query in a SQL client I get 2895 rows returned but when previewing the report I get 'No data for chart to display'.

    So I'm doing something wrong, anyone know what?

    TIA,

    Nick

  2. #2
    Join Date
    Oct 2006
    Posts
    219

    Default

    Untick the "Summary Only" checkbox?

    I don't know your knowledge of charts but if this is your first one then that little checkbox can trip you up.

    Hope that helps!

    Harris
    www.ivy-is.co.uk - Ivy Information Systems

    Come join the non official Pentaho IRC chat room on irc.freenode.net in the ##pentaho channel

  3. #3
    Join Date
    Jun 2009
    Posts
    3

    Default

    Thanks for the reply. The line:

    Summary only: false.

    was supposed to convey the idea that I do have the box unchecked . That came up quite a lot in the postings I've looked at

    My knowledge of charts probably isn't fantastic, this is the first time I've needed to use them in anger.

    Nick

  4. #4
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    The charting in PRD 3.0 and earlier is a bit nasty. The chart-expressions will easily throw up as soon as you have invalid combinations of properties. That was one reason we spent a lot of time on sanitizing the chart-expressions for the Citrus release. (Among others, the infamous "summary-only" option is gone now, as it can be easily derived from the other properties. Few bits in the charting caused more harm than that ugly one.)

    Its also important to have the same spelling on your columns. In your SQL statement, the column names are lower/mixed-case, while in the chart-expression they are all upper-case. The reporting-engine always treats column names as case-sensitive. So "Hello" is not equal to "HELLO".
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  5. #5
    Join Date
    Jun 2009
    Posts
    3

    Default

    Thanks for that, there's an inconsistency in what you ask for and what Oracle gives you back, hence the changes in case.

    I've tried a simpler graph, the SQL is
    SELECT
    APP,
    COUNT(*) AS MSG_COUNT
    FROM
    logs
    GROUP BY
    app

    with a pie chart using APP as the series column and MSG_COUNT as the value column. This is likewise giving the dreaded 'no chart data found' message.

    I've tried the same thing in Citrus M7 and it works as you'd expect so I think I'll have to use M7 to get this particular task done, though I was running into problems with the master report for this task which seemed to start objecting when there were more than ~ 7 sub-reports.

    Thanks again for the suggestions.

    Nick

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.