Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Month Hierarchy dispaly problem

  1. #1

    Default Month Hierarchy dispaly problem

    Hi All,

    I am having a dimension of Time and levels year, quarter and Month. When displaying the last level month it is not showing hierarchially like Jan, Feb, Mar instead it is showing Feb, Jan, Mar.

    I am attaching the Pivot view for your clarity.

    How to rectify this?

    Regards,
    sriman.
    Attached Files Attached Files

  2. #2

    Default

    Any solution for my problem?

    Regards,
    sriman.

  3. #3
    Join Date
    Oct 2007
    Posts
    25

    Default

    looks like you need to set an ordinalColumn in addition to your nameColumn/columns... but without seeing your dimensions etc... no way to know. If you have a level set to string, it will display in ABC order... To allow ordering of Strings in non ABC order, you can specify column (value of column), nameColumn (column containing displaytext) and ordinalColumn(integer indicating order of values).
    eg. if you have
    1,Jan
    2,Feb
    3.Mar,
    4,Apr
    and use col1 as "column" and col2 as 'nameColumn' then sorting will be okay
    alternatively, if you have
    1, Jan,1
    3,Mar,3
    2,Apr,4
    4,Feb,2

    and use column3 as the ordinalColumn, then they will still display correctly...

    all up to you )))

  4. #4

    Default

    Hi Rosselet,

    Thank you for sparing your valuable time on giving me a solution. As you said i have
    1,Jan
    2,Feb
    3.Mar,
    4,Apr
    5,May etc in database, eventhough in am not getting sort in order. I am using the hypersonic data only. Here i think ordinalcolumn in not required.
    I am attaching the Schema and Deimesions.
    Can you just guide me where iam doing mistake.

    Regards,
    sriman.
    Attached Files Attached Files

  5. #5
    Join Date
    Oct 2007
    Posts
    25

    Default

    <Level name="Month" table="TIME" column="MONTH_NAME" uniqueMembers="false"/>
    try
    <Level name="Month" table="TIME" column="MONTH_ID" nameColumn="MONTH_NAME" uniqueMembers="false"/>
    same for the quarter.. user QTR_ID and QTR_NAME..

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.