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

Oracle Analytics Cloud and Server

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

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 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.