New in SQL Server 2016 – Part 1: A Much Needed Facelift for the Tabular Model

New in SQL Server 2016 – Part 1: A Much Needed Facelift for the Tabular Model

I recently attended Microsoft’s quarterly Minnesota BI User Group Meeting, and I particularly enjoyed learning from Will Weber (a Data Platform Solution Architect at Microsoft) about their upcoming release of SQL Server 2016. This blog series will summarize the various additions and enhancements that Microsoft is introducing to their BI stack from the perspective of a BI developer.…

Read More

A Workaround for Column Security in the SQL Server Analysis Services BISM Tabular Model

An often needed feature in the SSAS BISM Tabular Model is the ability to restrict users from viewing certain columns.  Perspectives enable a better user experience but are not meant to be used as a security feature, as users can still access the underlying cube.  Tabular models enable flexible row filtering, but do not provide any functionality for column or perspective security.…

Read More

How to Resolve ID and Name Mismatch in Tabular Model Databases in Analysis Services

If you’ve been deploying tabular models to Analysis Services, at some point you may find you needed to have two different named instances on a server – one for test, and one for production.  And once done with testing, you just used the Rename right-click menu option on the database in order to rename it as the production instance. …

Read More
Phone: 312-602-4000
Email: marketing@westmonroepartners.com
222 W. Adams
Chicago, IL 60606
Show Buttons
Share On Facebook
Share On Twitter
Share on LinkedIn
Hide Buttons