Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Hierarchies in Schema Workbench

  1. #1
    Join Date
    Jun 2013

    Talking Hierarchies in Schema Workbench

    Hi, How can I add attributes to a dimension that don't fall under any hierarchy? For example, can I add productName and ProductDescription to my product dimension without having to put them in a single hierarchy? Also, can I put same attribute in different hierarchies in same dimension? For example, can I have a hierarchy year - month - date and another hierarchy year - week - date in the same date dimension? I am using Pentaho Enterprise edition. Thanks, AP

  2. #2
    Join Date
    Sep 2011


    By definition, you have to have at least one Hierarchy in each Dimension element. In your case I would implement a Product dimension with one hierarchy and one level: ProductName. You can specify a description in a Property element.

    And yes you can put the same attribute in different hierarchies in same dimension.

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 - 2017 Pentaho Corporation. All Rights Reserved.