Multidimensional & Tabular Models on Same SSAS Instance or Server

  • Hello,

    Currently I have SQL Server 2014, and SSIS and SSAS Tabular, and about to upgrade to SQL Sever 2016.

    Can I also have a SSAS Multidimensional instance in addition to my SSAS Tabular Mode instance? Can I have both, or what would the setup need to be?

    I'd liek to have a Multidimensional mode to run traditional SQL reports to bring into a cube to publish in the PBI Gateway, so users can end up doing all their reporting with PowerBI, and the cube model, whether Tabular or Multidimensional would be transparent.

    Thanks,

    JPQ

  • you need to setup 2 instances

    Instance 1

    -sql server

    -ssis

    -ssrs

    -ssas tabular

    instance 2

    -ssas dimensional

  • So the 2nd instance to be configured as MD, can it still use the Database Engine, and SSIS instance of the 1st instance for it's use if need be? And the only thing in the 2nd MD instance would need to be the SSAS strictly for MD cubes?

  • yes.

    All access to a sql server database instance is done through a provider (normally OLEDB) so it does not matter if database is on an instance with same name or different. can even be a remote instance.

  • Thank you very much Fredrico

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply