If you ever need to share values in a column that is defined in the metadata repository as the data type INTEGER, then you will find that just using slashes, as operator for the division will cause some inaccuracies in the result. The following example will try to demonstrate all behavior, and outline possible solutions. The repository available after installing the latest version (10.1.3.4.1) Oracle BI Enterprise Edition, I used two columns: Target Area: Sample Sales, Table: F2 Units - 23 Total Dimension , Column: Total # 8-66 or Orders (Cnt Dt for All Orders) Table: Market D2, Column: M01 MarketAlso, for convenience I set the filter to the last column with one value "Market 5." The final table after renaming the columns looked like this :
Facts in the query column I reiterated to him and set the value of 1 / 100:
The result was as follows:
I tried to add one more column in the same group and use mathematical rounding function with subsequent division of stem:
ROUND function seems to have allocated for their calculation of the memory space for a data type that can handle floating point operations (eg REAL or FLOAT) and therefore result corresponded to my expectations: