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
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.