Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Hierarchy of parameters

  1. #1

    Default Hierarchy of parameters

    Prompt please how to construct hierarchy of parameters.
    For me at parameter should be present "department" and "employee". At a choice "department №1" employees of this department (record "All employees") should be selected.
    For the report it is necessary to filter departments (the report on full department) and employees in department.

  2. #2


    Good afternoon.
    Someone has ideas about such functionality? At least any sentences.
    I except concatenation of strings of department and employee have thought up nothing that.

  3. #3
    Join Date
    Nov 2009


    i don't understand your question but you want to have a master and slave parameter?

    if this is, you have to write 2 querys like

    query 1
    Select Departments from departments

    Select employees from "any table join any table(not necesary to join)" where
    tableX.department in ${Department}

    so query1 and query2 are "paramters query"
    and in your main query

    Select * from table where department = ${parameter1} and employe = ${parameter2}

    hope it helps you

  4. #4


    Many thanks!
    Your advice has very much helped. All works as it is necessary.

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.