Tag: SSAS

SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.

Posted on by Reza Rad

This is a common error in SQL Server Analysis Services (SSAS). when you deploy the project to SSAS Server, you might face this error. Reason: There are some user/group membership added to roles in SSAS project, that is not matching with Active Directory user/groups. for example you might find some membership entries with GUID listed Read more about SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.[…]

Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling

Posted on by Reza Rad

Thank you all for attending at my presentation in TechDays 2013 Hong Kong at 2nd day of conference. here you can find presentation file of my speaking session about SQL Server Analysis Services Tabular Modelling Title:  SQL Server Analysis Services Tabular Modelling Description:  SQL Server 2012 provided another method for modelling BI presentation named SSAS Tabular Modelling. Read more about Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling[…]

SSAS Tabular – Microsoft Technical Articles

Posted on by Reza Rad

Yesterday in New Zealand Business Intelligence users group, attendees asked some questions that encouraged me to provide some links to Microsoft Articles written on SSAS Tabular. Here you can read more about these articles; Using DirectQuery in the Tabular BI Semantic Model Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services Read more about SSAS Tabular – Microsoft Technical Articles[…]

SSAS Dimension Processing: Be Careful about Case Sensitivity

Posted on by Reza Rad

Hi folks, Yesterday I faced a situation in one of SSAS cubes, which dimension processing was failed because it found two different members with different attribute values, like Auckland and auckland ! I found out that reason of this problem is SSAS dimension will inherits its collation from underlying database and if you don’t change Read more about SSAS Dimension Processing: Be Careful about Case Sensitivity[…]