OBIEE 12c - Analytics and VA generate different physical query, showing wrong results in VA

Question

Hi ALL,

I am generating a report in Analytics and a project in VA using the same attributes and measures and they generate different physical queries and in VA it gives wrong numbers for the measures. Any hints here?

Many thanks!

Nicolás

Gianni Ceresa · Answer

Hi,

If you see the different queries you can maybe at least post more details on what you are doing, what your model is like and what the 2 queries are.

If you select col1, col2 and a sum(measure col) and nothing else it will probably be the same, so to get different queries you must have something a bit more complex than a simple thing.