Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: CDG - Creating Other Measures

  1. #1
    Join Date
    Jul 2012
    Posts
    20

    Question CDG - Creating Other Measures

    Hi everyone,

    I have been working in CTools CDG Tool and I'm trying to generate a data warehouse to show my dashboards.
    I'm following step by step the CDG guide by @pmalves at:
    http://pedroalves-bi.blogspot.com.br...l/ctools%20cdg

    I would like to know if there is any way to add other metrics values (measures) e.g.:
    total_value1
    total_value2
    total_value3

    Using the CDG guide I could easily create the DW schema but I would like to add
    3 more metric values to my Fact Table. Is this possible?

    Any assistance on the approach will be greatly appreciated.


    Thanks and Regards.
    Anderson Katao
    BI Developer

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

    Default

    It's possible - but you need to change the javascript steps..

    It would be a great v2 allowing for more measures...
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  3. #3
    Join Date
    Jul 2012
    Posts
    20

    Default

    Hi Pedro,

    on your blog you say: " it's then up to you to do specific optimizations like indexes or even aggregate tables."

    Could you show me some reference of how to work with indexes and aggregate tables in this CDG script?

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.