Oracle Business Intelligence
I am creating Prompts for my dashboard. I have Role, Name, Project and Country column values created. The First 2 coming from a different subject area than the 3rd and 4th. The 3rd prompt should be filtered to role and name prompted ( it can be all values) and the project status is open. Lastly the Country Prompt should be based on the first 3 prompts too. I have assigned Role and Name prompts as presentation variables. What is the reason I can't use those two variables in creating a sql result values for my 3rd / 4th creating a new prompts. Thanks !