0 Replies Latest reply: May 11, 2013 5:01 PM by user13490153 RSS

    dashboard prompt with multiple values from different columns

    user13490153
      Hi all,

      I have a rewuirement to create dashboard prompt with values coming from different columns from same dimension.

      for e.g I have a dimension called Employee dimension.

      I have a table Employee

      EMP ID Dept ID ALL ID Dept name
      1 10 ALL Trainings
      2 20 Facility
      3 30 HR
      4 10 Trainings
      5 20 Facility



      i need to create dashboard prompt named department group as mentioned below.

      All --> "Employee dimension"."All ID'

      Dept Group --> "Employye dimension" . "Dept name"

      ID --> "Employee dimension"."Emp ID"

      finally, my prompt should contain the values mentioned below.

      Department group : All
      Trainings
      1
      2
      3
      4
      5


      any body please help me in achieving the above requirement