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 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.11.1.0 version, Analytics

ACTUAL BEHAVIOR
---------------

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.


EXPECTED BEHAVIOR
-----------------------
Month should get limited

STEPS
-----------------------
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. 


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

Cause

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