Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dashboard Prompt displays Year in State field

Received Response
1
Views
7
Comments
user4808868
user4808868 Rank 1 - Community Starter
edited Aug 13, 2024 5:51PM in Oracle Analytics Cloud and Server

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.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Variable, aliases and few other possible things.

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

  • Joel
    Joel Rank 8 - Analytics Strategist

    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
    user4808868 Rank 1 - Community Starter

    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.

    dashboard.pngPrompt.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    user4808868 Rank 1 - Community Starter

    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.

    pastedImage_0.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    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
    user4808868 Rank 1 - Community Starter

    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="&quot;Property Management&quot;" 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>