Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Sorting Day of Week in Analyzer

  1. #1
    Join Date
    Nov 2011
    Posts
    25

    Default Sorting Day of Week in Analyzer

    In analyzer I have a column called "Day of Week" (Monday, Tuesday, Wednesday, etc), and I'm trying to get it to sort correctly. I have only figured out how to sort it alphabetically (Friday, Monday, Saturday, etc) or in reverse.

    Is there any way to sort it by day of week without appending numeric day of week to the beginning, ie. 0- Monday, 1- Tuesday, 2- Wednesday, ect?

    I also have a column for numerical day of week and in my SQL datasource I order it asc, but that does not help the Day of Week field unless they are both displayed at the same time, I would prefer to not have to display the numeric field.

    Thank you.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    It needs to be defined in your cube definition.

    In your level definition, you should be able to add element ordinalColumn= <name of numeric column>

  3. #3
    Join Date
    Nov 2011
    Posts
    25

    Default

    I'm not using cubes, I'm just using MySQL tables, is this only possible using a cube?

  4. #4
    Join Date
    Apr 2008
    Posts
    4,690

    Default

    If you are using Penatho Analyzer, then you're not using just MySQL tables... Pentaho Analyzer is a OLAP viewer - which indicates that it's got a Cube Definition.

  5. #5
    Join Date
    Nov 2011
    Posts
    25

    Default

    Aww, I understand now. I didn't realize creating a SQL datasource would automatically create a cube for it, I was under the impression you had to do that through PDI. I figured out how to do it now, thank you for the help.

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.