title: SSAS cube with multiple DB
body: <p>I have 3 databases with the same structure, but different data, since they are from different clients.</p>
  
  <p>Now, I have an existing SSAS project. Its Data Source Views, Cubes and Dimensions can only use or access one DB.</p>
  
  <ul>
  <li>What I want is to be able to use multiple databases with the same structure, and create a cube using them.</li>
  <li>Each client must also be able to use the cube, but they can only see their own data.</li>
  </ul>
  
  <p><a href="https://i.stack.imgur.com/jTRNa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jTRNa.png" alt="diagram"></a>
  </p>
  
  <p>Are these possible? Can you please provide insights and some useful references?</p>