I've built a successful analysis based on union query that pulls from two different subject areas:
1. HCM Salary Projections and
2. GL Comittments
I want to create a dashboard prompt that pulls from these two areas but don't want the user to be redundant with the choices, if possible.
From HCM Salary Projections I want the user to be able to select
A,)Budget Year Code,
B.)left(Dept Code,3) and
C.)Fund Code.
From FSM GL Comittments area i want the user to be able to select
A.)Budget Period,
B.)left(Dept Code,3) and
C.)Fund Code
I would love to have one prompt so that user isn't faced with redundant selections. The HCM and FSM are the same even though different names for Budget Year Code and Budget Period. I am after letting user select Left(Dept,3) which are the same to grab in both enviroments. Same with Fund Code.
Typical Selection will be one Budget Year/Budget Period, one Left(Dept Code,3) and multiple Fund Codes.
Example will be user can select Budget Year/Budget Period = "2014", Left(Dept Code,3) = "R10" and left Fund Codes default to all.
I would like to have a prompt with the 3 fields that operates a union query analysis in the other column/section.