title: SSRS 2016/2012 which is best for complex logic - Stored procedures or MDX
body: <p>I have 1000 SPs. The complex report has 50 stored procedures , 40 input parameters 400 fields and the users have built some 10,000 intermittent tables. This was created some 10 years ago. Now it is being migrated. What is the best solution</p>
  
  <p>Move business logic from SP to MDM cube and then use MDX to source data or is stored procedure is the only option for very complex procedure as building a PowerBI report is not possible for this complex report</p>