Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Hierarchy of parameters

  1. #1

    Default Hierarchy of parameters

    Hello!
    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

    Default

    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
    Posts
    25

    Default

    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

    query2
    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

    Default

    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.