Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: May 11, 2013 5:01 PM by
dashboard prompt with multiple values from different columns
May 11, 2013 5:01 PM
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
any body please help me in achieving the above requirement
This content has been marked as final.
Show 0 replies