Dashboard Prompt Values not getting limited by another Prompt Values

(Doc ID 2222652.1)

Last updated on JULY 29, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Analytics


I have created prompts having year, quarter and month column respectively. I have limited quarter based on year and month based on quarter, but when I am selecting quarter month is not getting limited although I have checked the "limited by" option and selected quarter but it is not working. When I went to manage session to fetch the prompt query I did not find any prompt query.

Month should get limited

The issue can be reproduced at will with the following steps:
1. Created a dashboard prompt based on a Custom Subject Area
2. Add a column to display year
3. Add a column to display quarter and select Limit Values by Year
4. Add a column to display month and select Limit values by Quarter
5. Test the prompt and it does not work. 

The issue has the following business impact:
Due to this issue, users cannot use prompting correctly.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms