Operations division of the integer data type column


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:




It is seen that here there is no correct rounding. What with it if I have the opportunity to intervene in such a repository and properly prepare a computed column?
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: