Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Attribute against forecasted value displayed as decimal

Received Response
91
Views
3
Comments
Mandar -Oracle
Mandar -Oracle Rank 2 - Community Beginner
in Oracle Analytics Forum

Summary:

In DV report , while building report ,attribute result showing decimal while data is varchar

Content (required):

HS2 Code which is the character data & having values as 01,02,03,04 ( not as 1.0,2.0,3.0,4.0 etc) but in DV it is showing as 1.0 ,2.0 against forecasted values



Version (include the version you are using, if applicable):

5.9

Code Snippet (add any code snippets that support your topic, if applicable):

FORECAST("TRE_MOD"."Fact_V_GREEN_LANE"."DUTIABLE_VALUE", ("TRE_MOD"."Dim_D_DAY"."CAL_PER_NAME_MONTH"), 'forecast', 'modelType=arima;numPeriods=%1;predictionInterval=70;', 3)

Tagged:

Answers

  • Anirban Basu-133546
    Anirban Basu-133546 Rank 5 - Community Champion

    Hi Mandar ,

    Can you check if the datatype is set correctly in data preparation tab .


    Thanks

    Anirban

  • Mandar -Oracle
    Mandar -Oracle Rank 2 - Community Beginner

    Hi Anirban ,

    Thanks for your reply .In RPD , the datatype is set as Char .


    Also for more information showing result of HS2 Code as below .

    Actual - In May 22

    Forecasted : June 22 (After May)


  • Joshua C. Stewart
    Joshua C. Stewart Rank 5 - Community Champion

    You should be able to manually change the appearance of these values to remove the decimal. If you select the Measures tab then navigate to your measure and change the Number Format, you can remove the decimal.