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

Posted on 2011-04-27
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
    LVL 2

    Accepted Solution

    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
    LVL 2

    Author Closing Comment

    this solved the issue and no one has responded

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now