Prompt value is set to default

User_B7ZTH · Nov 21, 2018 2:51AM

Hello Experts,

We are facing an issue where prompt value is getting reset to "select values" whenever we are selecting the other prompt value.

Detail issue:-

We have a month prompt > constrained on Quarter and Year - (default value is showing as current month based on SQL result)

Quarter prompt > Constrained on Year - (default value is showing as current quarter based on sql result)

Year prompt > showing last two year (2016, 2017, 2018). (default value as current year based on sql result)

--All this time prompt has been created on Departure date, by extracting year, quarter and month from departure date.

However in the Subject area we have dedicated time dimension.

We have other prompts too like Region, sub region, unit, department etc.

Now issue is whenever user is selecting any region value or sub region or any value from other prompts then the value of month prompt is getting reset to "select values".

However when for testing I have created the same prompt form time dimension with same formula and its working fine(month value is not getting reset).

I am wondering why the value for month prompt created from Departure date by extracting month is getting reset.

Thanks for your help.

Regards,

Abhi

Robert Angel · Nov 21, 2018 3:28AM

Check if you have 'filter based on ....' ticked on any of the filters, it sounds like someone has deliberately linked the first prompt to the second - behavior typically used when one prompt is a subset of another prompt, like months in a year, sub-expense types of an expense code etc.

User_B7ZTH · Nov 21, 2018 7:28AM

Hi Robert,

I am sorry but I am not able to understand the solution.

However i would like to explain in more simple way, I guess i was unable to express the problem more clearly.

I have 5 prompt based on Region, Sub-region, Year (based on Dispatch Date), Quarter (based on Dispatch date filed), and Month-year Short filed (based on Dispatch date).

Region is showing the correct value from the column

Sub - Region is showing value from the column

Year is getting showing value for last two year - 2018, 2017

Quarter is based on limit by value based on above year

--------------------------------------------------------------------------------------------------------------------------

Month-Year short has limit by value on year/ Quarter, also it has default selection value on SQL result:-

SELECT

"Logistic departure date"."Logistic departure month year"

from "Departure Logistics"

WHERE year("Logistic departure date"."Logistic departure date") = year(current_date-5)

AND month("Logistic departure date"."Logistic departure date") = month(current_date-5)

Now this month-year short prompt is showing the value as Nov 2018, however if we are selecting any value either from "Region or Sub Region" the default value of Month-Year short (which is showing Nov 2018) is getting changed to "Select Value".

I am just assuming is there something wrong with my default selection value of SQL.

Thanks & Regards,

Abhi

Robert Angel · Nov 21, 2018 7:43AM

What I am asking you is are any of these ticked ->

Under the section ->

User_B7ZTH · Nov 21, 2018 7:47AM

Hi Robert,

Yes, it has been set on Quarter and Year prompt mentioned above

Robert Angel · Nov 21, 2018 7:50AM

So everytime, for that column, either Year or Quarter are changed, then the prompt will go back to the default position, that is what the 'Limit values by' tickbox does, and then the column in question will be filtered such that only combinations that have data for the Year / Quarter selections will be presented to the end user after the change.

If you do not want that then just untick the box!

User_B7ZTH · Nov 21, 2018 7:55AM

Also I would like to add, there are few more prompts like Division, sub division, Region etc, but let say if I select the value of Division = 'Automobile" and Region ="APAC" still the value of Year and Quarter default prompt doesn't change but Month prompt changes to select value.

Robert Angel · Nov 21, 2018 8:01AM

So, exactly which of View By, Year, Quarter, Month have the 'Limit Values By' ticked and which columns are they 'listening to'?

I would expect any that have the values ticked for any of the columns that are currently being changed to revert to 'Select Value' - is this not what is happening?

So for the screenshot you showed if you change either Year or Quarter then the column in question (month?) will change to select value - that is the behavior that you have configured.

Robert Angel · Nov 21, 2018 8:02AM

As you present it it would make sense to have; -

Year - NO limit values.

Quarter, Limit Values by Year

Month, Limit Values by Quarter

User_B7ZTH · Nov 21, 2018 8:14AM

So my complete prompt look like

Here Month is showing default value as Nov 2018.

Now if i select region as Europe then Month value is showing as "select value".

Also month prompt has following configuration:-

SELECT

"Departure date"."Departure month year"

FROM "Dispatch Logistics"

WHERE year("Departure date"."Departure date") = year(current_date-5)

AND month("Departure Date"."Departure date") = month(current_date-5)

This is what the configuration is for the month prompt.

Thank you again for your help.

Thanks & Regards,

Abhi

Robert Angel · Nov 21, 2018 8:21AM

One more thought, are you sure that data exists for the region / sub-region selection when the Year and Quarter values are set?

i.e. the data is filtered based on the underlying table data combinations?

Kindly note also that your default value will clash with this also as it is currently a very small time frame - the last five days.

Oracle Analytics Cloud and Server

Categories

Prompt value is set to default

Answers