Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: denorm in Report Designer

  1. #1

    Default denorm in Report Designer

    Hi,

    I know that denormalizing rows is possible in Kettle.

    But since PRD cannot be combined with Kettle - repository mode, I am going to re-create my report in PRD.

    Is there a way to denorm rows in PRD ? or does PRD always expect ready-to-use data for the report, with the exception of some function/calculation options.

    My data looks like this

    date member_type count
    2012-11-15 ADULT 3
    2012-11-15 PARENT 2
    2012-11-15 CHILD 3
    2012-11-16 CHILD 1
    2012-11-17 PARENT 2
    2012-11-17 CHILD 1

    I want to split the member_type column, and create 3 separate columns for the member_types, and have the respective counts in those columns.

    I'm guessing this should be done in the query itself, and cannot be done in PRD.. Is that right ?

    Thanks !
    Sue

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

    Default

    You can use the Kettle-datasource in PRD to run KTR files. To export an existing transformation as KTR, use Spoon

    It will be possible to do this normalization in PRD via crosstabs when we release PRD-4.0 in April.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

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.