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

The Top 3 Reasons to Deploy PowerPivot to SQL Server Analysis Services (SSAS)

Microsoft’s PowerPivot add-in to Excel (2010 and 2013) is a powerful tool for business users to combine multiple types of data sources into a single pivot table. Leveraging technology shared by Microsoft SQL Server Analysis Services (SSAS) OLAP solutions, PowerPivot provides aggregated data filterable by a common set of attributes, which can be designed by users without having to engage an IT...

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