The <field> source column and the <field> destination column have different data types cubes

Posted on 2011-04-27
Medium Priority
Last Modified: 2016-02-15
I am trying to build my cube using microsft VS studio, and I have one problem with one of the dimensions.

All my dimensions are views sitting in orcale,

My fact table has a key
Accounting period month key which is a number in orcale

I have have two dimension tables
1) Accounting period year month
it has the accounting period month key which is a number
and a accounting year key whcih is also a number

2) Accounting period year
it has the accounting year key
and is a number

Now in the oracle 10g database they keys are all numbers
but when I add these views to the .dsv it makes the data types as follows

Table                         column                                        Oracle          MS .dsv
                                                                                     Data Type    Data Type
Fact                           Accounting period month key     Number       System.double
DIM AP Month Year   Accounting period month key     Number       System.Int64
DIM AP Month Year   Accounting period year key        Number      System.Int64
DIM AP Year              Accounting period year key        Number      System.Double

Is there a way for me to change this.

I am using the Native OLE DB\ Microsoft OLE DB Provider for Oracle on the connection manager

I need some help so that I can define the dataypes
Question by:jhacharya
  • 2

Accepted Solution

jhacharya earned 0 total points
ID: 35478069
you get get around this issue by making sure you select the correct connection manager, i used the oracle one and the issue went away

Author Closing Comment

ID: 35478073
this solved the issue and no one has responded

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question