Database Software

I'm trying to calculate the size of cubes after population. When I run the following SQL query for one cube

SELECT objname, SUM((dbms_lob.getlength(awlob)/1024)/1024)
FROM aw$poc
WHERE objname LIKE 'ENV_1_FACTORS%'
GROUP BY objname

I get the following results

ENV_1_FACTORS_COMPOSITE 0.37
ENV_1_FACTORS_NOON_TEMP_1_STORED 28.39
ENV_1_FACTORS_SUNSET_TIME_1_STORED 99.35

However, when I try to calculate object size in OLAP Worksheet, I get the following

->SHOW OBJ(DISKSIZE 'ENV_1_FACTORS_COMPOSITE') * AW(PAGESIZE)
163,520

->SHOW OBJ(DISKSIZE 'ENV_1_FACTORS_NOON_TEMP_1_STORED') * AW(PAGESIZE)
29,793,344

->SHOW OBJ(DISKSIZE 'ENV_1_FACTORS_SUNSET_TIME_1_STORED') * AW(PAGESIZE)
29,793,344

Can anybody explain why the SQL and DML results differ for the 'ENV_1_FACTORS_SUNSET_TIME_1_STORED' variable.

It also strikes me as potentially strange that the OLAP DML calculated values for 'ENV_1_FACTORS_NOON_TEMP_1_STORED' and 'ENV_1_FACTORS_SUNSET_TIME_1_STORED' are identical even though one of these is defined as DECIMAL and the other as TEXT.

Can anybody shed any light on these queries?

Thanks,

Andy White