Post reply

Local Fact Table, Remote Dimension Tables

  • August 8, 2003 at 2:27 am

    #106433

    Is it possible to have the fact table on the local server, and the dimension tables on a remote server?

    If so, how?

    Any help is appreciated.

    Thanks,

    Ryan

  • August 8, 2003 at 10:15 am

    #469219

    Have you tried to create a linked server? I have never done this so I am not sure if you can select a different data source connection for the dimensions (as opposed to the fact table) or not in AS, Ryan...

    Michael

    Michael Weiss


    Michael Weiss

  • August 11, 2003 at 1:33 am

    #469342

    The fact and the dimension tables must be from the same data source (so the error messages tell me).

    What I have done is, on the remote dimension tables (linked) server, created a view of the fact table, and just point the data source to that server and create a cube based on that data source.

    Seems to all be OK.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply