Oracle Analytics Forum

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

Correct Value Showing only when adding a July in the month prompt

Received Response
1
Views
1
Comments
yaseennawaz
yaseennawaz Rank 4 - Community Specialist
edited Aug 13, 2024 6:16PM in Oracle Analytics Forum

Hi,

We have a problem with a report.When we are selecting months April,May,June in a Month Prompt we are getting a Incorrect Value for one of the highlighted fields(181) for the Month of June,when we are adding July in the month prompt and running the report we are getting correct value for that field (201) and all other values are same(correct).Can you please help me out on this?

AprilMayJune
230134176
213162181
123122190

AprilMayJuneJuly
230134176123
213162201287
123122190145

Regards,

Yaseen

Answers

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics & AI Lead

    As far as I know, there is no option to show correct/incorrect values for June in OBIEE. Your model definitely contains some errors. I'd say the most probable one is incorrect dimension keys. But it's impossible to say that looking at these samples.