Monthly Archives: January 2009

MDX:SELECT  {[Measures].[Internet Sales Amount], Measures.y} ON 0,   [Date].[Calendar].[Month] .Members ON 1FROM [Adventure Works]WHERE  [Product].[Product Categories].[Product].members(0) The corresponding AdoMD.Client code:cst is Microsoft.AnalysisServices.AdomdClient.CellSet cst.Axes[0].Set.Tuples[0].Members[0].Caption : "Internet Sales Amount"cst.Axes[0].Set.Tuples[0].Members[1].Caption : "y" cst.Axes[1].Set.Tuples[0].Members[0].Caption : nameColumn of members at level month cst[0,0].FormattedValue  is the cell … Continue reading →

//Percent contribution //1. Postal code portion/State total WITH MEMBER [Measures].[stateSalesPortion] as ( [Measures].[Reseller Order Quantity], [Geography].[Geography].CurrentMember ) / ( [Measures].[Reseller Order Quantity], Ancestor ( [Geography].[Geography].CurrentMember, [Geography].[Geography].[State-Province] ) ), format_string = ‘#.##%’ SELECT { [Measures].[Reseller Order Quantity], [Measures].[Measures].[stateSalesPortion] } ON 0, … Continue reading →

T-SQL: type 1: select * from tblA where column1 > 1000  –more like a measuretype 2: select * from tblA where column2 = ‘United States’ –more like a member of a dimension MDX: //this is for type 1 t-sql look-alikeSELECT … Continue reading →

I always believed that it’s not that you can’t learn but that the teacher can’t teach.  Bad teachers galore and it kills generations of intelligent minds and learning drives.  Looking back on my informative years, there were only two teachers … Continue reading →

iSoftStone 软通动力 is rated as the best outsourcing company to work for in China from seecoco.com.  I visited their website and found what I love to see. They have two career routes for employees, one up to expert, another up … Continue reading →