Edition specific SSAS development using BIDS
Problem
It can often happen, that the development environment uses a more feature rich version of SQL Server than the production environment. The main issue that arises from this kind of setup is that development team might use features that might not be available in the target environment. For example, an organization might use SQL Server Enterprise Edition in most cases and therefore the development team uses the Developer edition features of SQL Server for the development phase. But consider the case, that the solution is expected to then be deployed on Standard edition. In this case, the development team needs to identify and remove these features that are used. In this tip we will look at how to deal with this issue in BIDS for SSAS development.
Read more...