Hello,

I have a very strange problem. The value I get in a dimensional field does not match what the physical query behind the report should retrieve from database.

I have a simple report with just 2 dimensional fields, country_id and country_population (not an id, or a kpi, just a simple dimensional field). The report has a filter on country_id to only display data for a certain country. Both fields are from the same dimensional table. The physical query that runs behind shows a simple sql:

WITH

SAWITH0 AS (select distinct T7088.COUNTRY_ID as c1,

     T7088.COUNTRY_POP as c2

from

     DIM_COUNTRIES T7088 /* Dim_Countries */

where  ( T7088.COUNTRY_ID = 2) )

select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3 from ( select distinct 0 as c1,

     D1.c1 as c2,

     D1.c2 as c3

from

     SAWITH0 D1

order by c3, c2 ) D1 where rownum <= 1000001

The problem is the country_population field is showing different data than what is in the database. If I run the above query directly on the database the results are correct! But what report shows is some other, seemingly random value.

I have cleared cache, even fully restarted the server.

The strange thing here is it only shows country_population wrong for some countries, not all. Some are shown correctly. COUNTRY_POP field is type UINT.

Does anyone have any idea why such a simple report would show wrong data?