none
Multiple Cubes being Source of a Single Cube

    Question

  • Hi,

    Is there a way to use multiple Cubes as the source for one Cube ?

    In details, i have same Cube created over multiple data marts.

    The data volume I'm working with is rather large  (in the Terabytes), so i would prefer not moving the Data back to a separate DB and union there.

    Example:

    Cube over project A

    Cube over project B

    MASTER CUBE has Fact Table : Cube A Fact Union Cube B Fact

    And of course same for the dimensions, even though dimensions are, size wise, manageable so they can be replicated at the other "Master" Cube.

    Is there a way to link to multiple Cubes and basically union the fact table from each in another Cube ?

    therefore just taking advantage of space already taken by the individual project specific Cubes.

    Any advise on how to approach this problem is helpful. 

    Wednesday, March 12, 2014 7:20 AM

Answers

  • Hi Ames54,

    According to your description, you want to use other cubes as the data source of one cube, right? Currently, when build a cube, it only support relational database as the data source, multidimensional database is not supported. So I am afraid your requirement cannot be done. For the detail information about supported data source types (SSAS Multidimensional), please refer to the link below.
    Supported Data Source Types (SSAS Multidimensional)

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by ame54 Thursday, March 13, 2014 7:23 AM
    Thursday, March 13, 2014 7:01 AM
    Moderator