September 25, 2008 at 12:32 am
Hi all,
I have made one SSAS Cube in connection with Oracle Database. The Cube has already been formed I have Processed Full for making the Cube database. Now when I am browsing for some Fact Data, the digits after decimal points are not matching with those in Oracle SQL PLUS, that is I found that there is mismatch of the Decimal digits of Fact Data between source database and cube database.
Let me Give you one Example.
When I am Using the following MDX Query in Cube Database
select {[Measures].[SALESAMOUNT]
} ON COLUMNS,
{[DimTime].[Quarter]} ON ROWS
FROM Test_Ds1
I am getting the Following results:
SALESAMOUNT
All 29358677.8900045
But when I am watching the same data in Oracle SQL Plus By this query:
select SUM(SalesAmount) FROM dw.factinternetsales;
I am getting this result
Code SnippetSUM(SALESAMOUNT)
----------------
29358677.2
That means, there is a gap of 0.6. Can you please help me out in this regard?
Thanking in advance,
Srabanti
September 25, 2008 at 5:09 am
I have yet to find an Oracle driver that is actually 100% OLEDB compliant. Both the MS and the Oracle native client have trouble with numeric data types. Sometimes they complain about precision, sometimes they make negative numbers zero (that one was painful), and sometimes they end up with decimal differences.
The only solution I have found that is 100% reliable is to CAST numeric data types as VARCHAR or CHAR on the Oracle end and convert them back to numerics on the MS SQL end.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply