Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Numerical Attribute Filter

  1. #1
    Join Date
    Sep 2007

    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?


  2. #2
    Join Date
    Nov 1999


    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:

    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:

    [Salary range]
        [0 to 10k]
       [10k to 20k]
    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.


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.