Ad-Hoc Cube Creation, in MD or Tab?

• quinn.jay

  SSCertifiable

  Points: 5505

  More actions

  November 30, 2016 at 9:48 am

  #149382

  Hello,

  I currently have an SSAS instance of a Tabular model, where I have several cubes which are loading Fact and Dimension tables via SSIS.

  In taking SQL report code on a DW, wrap a Create Table statement around it, and putting the output into a single table on the DW, I want to source that data into a Cube. In this case, does the cube have to be a Multidimensional or a Tabular model?

  I've already determined that the MD and Tab must have their own separate SSAS instance.

  I'm trying to find a way to turn a large amount of regular SQL Report code to Excel File placed on a SharePoint/Share drive, into cubes, which can be published on a PBI Gateway, and move away from from so much manual SQL/Excel. Should this process of cube building be done in a MD model, and not a Tabular model?

  Thanks,

  JPQ