question

ovonemty avatar image
0 Votes"
ovonemty asked CarrinWu-MSFT commented

why select edition of AS instance where the project will be deployed?

In the properties before deploying, I have to select the version of the SSAS:
126016-image.png


What's the purpose of this? what if I select the wrong version? Why doesnt it get auto-completed?

My server is:
126034-image.png



Does EnterpriseCore64 mean Enterprise: Core-Based Licensing ?


sql-server-analysis-servicesvs-extensions
image.png (4.1 KiB)
image.png (19.7 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ovonemty, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·
cooldadtx avatar image
0 Votes"
cooldadtx answered

Not an SSAS person but SSAS, like SSIS, is dependent upon the version to know what features are available. As specified here the edition tells the designer what features are available because they vary by edition. But this is for development purposes. It seems like deployment should default to the same thing but in theory you could develop on a lower edition (maybe Developer) and then target a higher edition even though you aren't using the advanced features. But I'm just guessing here. This question may be better suited for the SSDT team that own the SSAS project extension.

Server edition values are defined here. EnterpriseCore64 maps to a 64-bit Enterprise Core version, from my understanding, whereas Enterprise64 would map to the 64-bit Enterprise edition. Not sure why the edition differences would matter here, if they do at all.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

dgosbell avatar image
1 Vote"
dgosbell answered

What's the purpose of this?

@cooldadtx is correct in his assumptions. This setting exists so that the SSDT designers can throw warnings and errors or block functionality that is not available in the edition you are planning to deploy to.

what if I select the wrong version?

You can change this setting at any time and it will change what warnings errors the designers will show.

The only edition that has limitations is the Standard edition. All the other editions have the same feature set in SSAS.

Why doesnt it get auto-completed?

Because often the first server that people deploy to is a development box running the development edition which has no restrictions on the features, but if your final production server is a Standard Edition you want to set your project to that so that you do not accidentally use features in development that are not available in production.

If they did not have this setting you could spend months building and testing a data model only to find at the end of the project that it will not deploy to production because someone used functionality that is not available in the edition you are running in production.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @ovonemty,

Welcome to Microsoft Q&A!

Deployment Server\Edition: This property enables you to set the edition of SQL Server that you are using on your production server and prevents you from developing by using any features that are not available in that edition. Because, at the moment, there are no feature differences between the Enterprise and Business Intelligence editions of SQL Server, the only two editions in which the Tabular model is available, setting this property is not very important, but it might be a good idea to set this property in case there are differences in functionality in the future.


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.