This post is an answer to my earlier post titled Books Online needs some enhancement. In this post I had raised an issue to populate the "All caption" property of Analysis Services 2000 Dimension using DSO and C# as i could not find an answer in Books Online (BOL).

The solution:

Using just the MemberKeyColumn property solves the problem.

DSO.Level allLevelDepartment = (DSO.Level)dsoDimDepartment.Levels.AddNew("(All)", DSO.SubClassTypes.sbclsRegular);
allLevelDepartment.LevelType = DSO.LevelTypes.levAll;
allLevelDepartment.EstimatedSize = 1;
allLevelDepartment.MemberKeyColumn = "All Department";

This syntax of C# will be enough to populate the "All Caption" property of a Analysis Services 2000 Dimension using DSO.