Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Metadata Column Sort

  1. #1

    Default Metadata Column Sort

    Hi,

    I am creating a Metadata layer with the Pentaho Editor for Interactive Reporting within the User Console. I am trying to use a Date dimension table and have found no way to select an alternative column to sort on.

    My example is Sales Month. Obviously I don't want April, August, December etc to appear, but want to sort by Month number. Can this be done using the Metadata editor. I have been trying to search for a column attribute in the business view column but have had no luck. It is possible in the Mondrian schema workbench using the 'ordinal column' drop down. It seems like quite a basic requirement. I also have other items that I would like to sort not alphabetically.

    Many thanks in advance for any help and tips,

    Will

  2. #2
    Join Date
    Apr 2009
    Posts
    337

    Default

    Option 1: your date dimension must have a month number column! simplest.
    Option 2:
    else: Create a new physical column in metadata editor. , say "month_number" or something:

    Then in the formula tab of it, write:

    CASE(
    [salesmonth] = "jan";
    1;
    [salesmonth] = "feb";
    2;
    )
    and so on. Dont forget to check 'is the formula exact' option to true!
    Use this column in your business table and business view.
    Sort by this column!
    Regards,
    Madhu

  3. #3

    Default

    Thank you for your reply,

    So, I had a Month_Int Column in my Date Dimension table. I am stuck on how to specify that column as the 'Order by' column. Am I missing something very obvious in the metadata editor?

    I was expecting it to be an attribute of a column either in the Business View or the Physical Table?

    Option 2 is my backup plan for today!

    Thanks again

  4. #4
    wgorman Guest

    Default

    Here is the feature request for ordinal columns in Pentaho Metdata:

    http://jira.pentaho.com/browse/PMD-619

    Please vote for the case!

Tags for this Thread

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.