Format String Issue of SSAS Measures in Excel Front-End

Posted by on Dec 10, 2013 in SSAS | No Comments

Most of you faced such situation that you’ve set the FormatString property of your measures in the cube from BIDS or SSDT, But when you browser the cube in Excel you will not see that format. Let’s say you applied format string to add thousands separator, two decimal points, and dollar sign to your Amount ...

Read More

Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling

Posted by on Mar 14, 2013 in Presentations, SSAS | No Comments

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

SSAS Dimension Processing: Be Careful about Case Sensitivity

Posted by on Oct 26, 2012 in SSAS | No Comments

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