title: How to create OLAP cube from multiple stores in databrewery cubes
body: <p>I'm currently trying to wrap my head around OLAP cubes.</p>
  
  <p>For learning, I am using the <a href="http://cubes.databrewery.org/" rel="nofollow">cubes</a> framework.</p>
  
  <p>I'm currently stuck at making a cube that depends on dimensions from two different stores.</p>
  
  <p>I've tried to use the fact that all defined dimensions are public by default to achieve this.</p>
  
  <p>Below is some anonymized code showing how I'm trying to solve it:</p>
  
  <pre><code>workspace = Workspace()
  workspace.register_store("store1", "sql", schema="schema1", url="postgresql://&lt;URL&gt;")
  workspace.register_store("store2", "sql", schema="schema2", url="postgresql://&lt;URL&gt;")
  workspace.import_model("model1.json", store="store1")
  workspace.import_model("model2.json", store="store2")
  workspace.import_model("cube_with_dimensions_from_model1_and_model2.json")
  browser = workspace.browser("cube_with_dimensions_from_model1_and_model2")
  </code></pre>
  
  <p>I get the error </p>
  
  <blockquote>
    <p>cubes.errors.NoSuchDimensionError: Dimension 'dimesion_from_model2'
    not found</p>
  </blockquote>
  
  <p>This obviously means that it can't find the dimensions imported in model1 and model2.</p>
  
  <p>Can anyone point me in the right direction on how to solve this? </p>
  
  <p><strong>PS:</strong> If there are more sample projects than those found <a href="https://github.com/Stiivi/cubes-examples" rel="nofollow">here</a> I would be very grateful to know.</p>