I have two Analysis Services databases - SupplyChain and Production.

In the supplychain database I have three cubes - SALES, INVENTORY and
BILLING and these are sourced from the fact table FACT_SALES,
FACT_INVENTORY & FACT_BILLING.

In the Production Database I have a cube called MAINTENANCE sourced
from a fact table called FACT_MAINTENANCE.

I need to build the dimension material sourced from all these fact
tables.

Please advice the best way to implement this how can I make a dimension
shared between two seperate databases and how to build them sourced
from multiple fact tables.

In a typical datawarehouse how do we implement a dimension to be shared
between databases.

Thanks
Karen