title: TM1 Rules - Linking multiple source cubes into one target cube
body: <p>I have two (so far) source cubes and their respective dimensions:<br>
  <strong>EXPENSE</strong>: Date1, Date2, Supplier, Cost/Profit Center, Project, Type of Payment, Measures.<br>
  <strong>INCOME</strong>: Date1, Date2, Subcontractor, Customer, Cost/Profit Center, Project, Type of Payment, Measures.<br><br></p>
  
  <p>I want to use the above mentioned cubes as a source for a third cube:<br>
  <strong>FINANCE</strong>: Date1, Cost/Profit Center, Project, Type of Payment, Measures.<br>
  <br>
  <br>
  The dimension Cost/Profit Center is used is each of these cubes and has following structure:</p>
  
  <pre><code>TOTAL
  --EXPENSE
  ---10000 - Consulting
  ----11000 - Personal Expense
  -----11100 - Sallary
  ------11101 - Gross Salary*
  ------11102 - Bonus*
  ...
  --INCOME
  ---2000 - Services
  ----2100 - Projects
  -----2110 - Support
  ------2111 - Support for ABC*
  ------2112 - Support for XYZ*
  ...
  
  (*) Leaf elements
  </code></pre>
  
  <p><br>
  The goal is to load data from EXPENSE cube into FINANCE cube under Expense, and from INCOME cube to FINANCE cube under Income.<br>
  How do I define the rule without manually linking the corresponding leaf level members? I am looking for something like<br></p>
  
  <pre><code>['TOTAL':'Expense'] = N:DB(... data from Expense cube)
  ['TOTAL':'Income']  = N:DB(... data from Income cube)
  </code></pre>
  
  <p><br>
  <br>
  So far I came up only with one solution which works although I am quite sure it is not the right approach:</p>
  
  <pre><code>[] = N: DB('Expense', '...) + DB('Income', '...)
  </code></pre>
  
  <p><br>
  Thanks a lot!</p>