Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dimension from substring of a column/dimension

  1. #1
    Join Date
    Oct 2007

    Post Dimension from substring of a column/dimension

    Hi all,
    I have a dimension named 'ProductCode' that is taken from the column "Code".

    The last char in that code represents the size of the product.

    how can i create a new dimension by using that last char of the column or other existing dimension?

    Thanks a lot,

    Ran Zask.
    Last edited by royroy; 10-04-2007 at 12:35 PM.

  2. #2
    wgorman Guest


    It may be possible to use expressions to access the last character in the column as a key. Check out KeyExpression as part of a level here:


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.