Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Dimension value different in report than in database

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?
Answers
-
Is your INT in the database bigger than 32bit? So bigger than 2147 million?
Because INT in OBI is a 32bit SIGNED INTEGER. Can never be bigger or smaller than 2147million / -2147million
0 -
Thank you, that was it!
I changed UINT to NUMERIC and the correct numbers are now displayed.
0 -
Good to hear.
0