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

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

Received Response
1
Views
1
Comments
997799
997799 Rank 1 - Community Starter
edited Aug 13, 2024 5:53PM in Oracle Analytics Forum

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

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.