made cube using 3 databse without using staging


  • Hi

    I have three database in MYSQL and all have same structrue of tables.

    I need to Build cube using these 3 database ..

    Is there any way to without creating Staging database (and pull data of 3 in database ) to built a cube.?

    MY Question is How can i make a cube in SSAS using 3 database with same structure.

    For Example

    MYSQL1db :list table

    MYSQL2db :list table

    MYSQL3db :list table

    In DSV it would be like

    MYSQL1db union all list table

    MYSQL2db union all list table

    MYSQL3db union all list table

    Then i made dimension over these .

    Please help me to resolve this issue.

    Wednesday, June 19, 2013 5:54 AM