Oracle Analytics and AI

yaseennawaz

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?

April	May	June
230	134	176
213	162	181
123	122	190

April	May	June	July
230	134	176	123
213	162	201	287
123	122	190	145

Regards,

Yaseen

Andrew Fomin.

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.