title: Missing data while copying data cubes from SAP BW to Azure with OpenHub
body: <p>I need to copy data cubes from SAP BW to some Azure storage (SQL Database, Data Lake, SQL DW - anything which can connect to PowerBI).</p>
  
  <p>I first tried to use a SAP via MDX connector and to copy to a SQL Database - but the tables (in preview) had missing data - ex: I had sales by month and by country, but the combination sales in Jan in UK were missing (and this data is in the cubes)</p>
  
  <p>Now I tried Open Hub connection in SAP but I can see only some basic data (no master data - like name of the country only a code). </p>
  
  <p>What do you advice me to do? I believe this sort of copy activity is quite common so it should be easy to solve.</p>