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

    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

    Default

    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:
    http://mondrian.pentaho.org/document...hema.php#Level

    Will

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.