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)
TechNet Community Support
Marked as answer byame54Thursday, March 13, 2014 7:23 AM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.