US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: Hierarchies in Schema Workbench

  1. #1
    Join Date
    Jun 2013
    Posts
    3

    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
    Posts
    26

    Default

    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
  •