Post reply

Multidimensional & Tabular Models on Same SSAS Instance or Server

  • November 27, 2016 at 11:44 am

    #149216

    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

  • November 27, 2016 at 3:47 pm

    #1914645

    you need to setup 2 instances

    Instance 1

    -sql server

    -ssis

    -ssrs

    -ssas tabular

    instance 2

    -ssas dimensional

  • November 28, 2016 at 12:53 pm

    #1914811

    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?

  • November 28, 2016 at 1:20 pm

    #1914813

    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.

  • November 28, 2016 at 3:11 pm

    #1914837

    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