I searched for this issue but there is only 4 questions about it in this forum from 2007 I hope that someone can help me.
Im usign SASS 2008 using a Oracle as a datasource. I already have my fact tables linked with dimensions, lets say, FACTID System.Int64 with DIMENSIONID System.Int64 (My dimensions are replaced by named querys and work perfectly)
I add a new table to my DSV and the NEWDIMENSIONID looks like System.Int64, but at the moment I replace the table with a named query (I have to use Oracle quering) the NEWDIMENSIONID changes to System.Int32 . After that I cant relate the fact table
with the dimension table.
Looked for the columns that relate from Oracle... both are NUMBER(5).
Looked for the differences between my other tables that are already related as System.Int64 and there is not a single difference between the ones that works and the one who doesnt.
Solutions Ive tried and didnt work:
1. Cast the column as SQL query didnt work it send an error. Looks kind of obvious because we are quering Oracle... but I had to try. CAST( X AS BIGINT)
2. Cast the column as Oracle query . TO_NUMBER
3. Do it inside the server using the Analysis Services Enterprise insted of my Analysis Services Developer. Same issue.
Any ideas? suggestions? Please?
Thank you very much ;)
PS. At the begging of
View Complete Post