Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Cast a column in saiku cube

  1. #1
    Join Date
    Oct 2013
    Posts
    27

    Default Cast a column in saiku cube

    How do I change my column from type string to integer in saiku cube?
    Currently I am using postgres Sql database and need to join two columns with different datatype.

  2. #2
    Join Date
    Nov 2014
    Posts
    150

    Default

    Hi,

    When building your Mondrian schema, you could use the KeyExpression tag, as in this example:

    http://mondrian.pentaho.com/document...ng_Hierarchies

    Inside the key expression, specify the cast function.

    Just remember that in this case the dialect would be "postgres", instead of "generic".
    Best Regards,

    Hugo Cerqueira
    Business Intelligence / Data Warehouse Analyst

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.