nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Dashboard Prompt displays Year in State field

user4808868

We have a dashboard that when brought up the first time, displays the year (2019) in the State prompt as a default. The report on the dashboard associated with the the prompt errors giving invalid number error. The value of 2019 is not a valid selection. I have no idea where it is coming from.

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

Variable, aliases and few other possible things.

Bu you aren't really providing anything to give you a better answer ....

Joel Acha

Exactly what @Gianni Ceresa said. You'll need to provide a bit more information. query log extracts, screenshots, OBIEE versions. How is the dashboard prompt getting its default value etc etc

user4808868

The prompt does not have a variable associated with it. This is also only occurring in our development environment. Our production dashboard does not show the '2019'. We are using OBIEE 12.2.1.0.0 and the RPD is custom.

Gianni Ceresa

As Joel said: check the logs. Things generally do not happen without being logged.

Is that prompt new or a migrated content? Do you see "2019" in the XML of the prompt?

By the way: you know that 12.2.1.0.0 isn't supported anymore for some time and it's also the most bugged of 12c being the very first release?

user4808868

This is not a new prompt. It has been in place for a number of years through our upgrades from 11g to 12c. Where do I get the XML for the prompt?

When I look at the session log. It looks like it is getting a year for the prompt. But there is nothing within my prompt asking for a year.

Gianni Ceresa

The XML you get it from Catalog Manager.

As it's a migrated object it can also have pieces in the XML which aren't in the GUI anymore (because of the change of versions).

If you delete that prompt entry and create it again do you still have the issue?

user4808868

Nothing I can see in the XML. We recreated the Prompt from scratch and still have the same issue. We are going to pull the RPD down from Prod to DEV.

<saw:prompt xsi:type="saw:columnFilterPrompt" columnID="c14" subjectArea=""Property Management"" required="false">

<saw:formula>

<sawx:expr xsi:type="sawx:sqlExpression">"Business Unit"."State"</sawx:expr>

</saw:formula>

<saw:promptOperator op="in" />

<saw:promptUIControl xsi:type="saw:browse" maxChoices="-1" includeAllChoices="false">

<saw:customWidth width="120" using="custompixels" />

</saw:promptUIControl>

<saw:promptDefaultValues type="reportDefault" usingCodeValue="false" />

<saw:constrainPrompt type="none" autoSelectValue="default" />

<saw:setPromptVariables>

<saw:setPromptVariable location="value" type="none" variableFormula="" />

</saw:setPromptVariables>

<saw:promptSource xsi:type="saw:allChoices" />

</saw:prompt>