Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Numerical Attribute Filter

  1. #1
    Join Date
    Sep 2007
    Posts
    1

    Question Numerical Attribute Filter

    I have an employeed table with all the attribute of the employee, one of this attributes is the salary, when I try to use a filter in JPivot he showme the complete list of distinct values of de column, how can I define a filter like
    Salary < 10.000 ? or > or =,

    Can I do that through jpivot?,
    Can I do that through MDX?

    Thanks

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default

    MDX parameters are effective here. Define a parameter, say 'Minimum salary', and use it in a filter function to only show employees above that salary.

    There is an example of using parameters here: http://mondrian.pentaho.org/document...chitecture.php

    Another useful approach is to create a so-called 'bucketing dimension'. In this case it would be called 'Salary range', and its values might look like this:

    Code:
    [Salary range]
        [0 to 10k]
           [Fred]
           [Bill]
       [10k to 20k]
            [Eric]
            [Mabel]
       ...
    You can choose whichever bucket ranges make sense for your application. Assign the bucket value to a column in the employees table, and populate it during your etl process.

    Julian

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.