Category / Section
How to remove a specific item from the element editor
1 min read
It is possible to remove any specific item from the element editor. This can be done by removing the particular item from its level members collection which is generated from the GetLevelMembers() method.
Please modify the GetLevelMembers() function in OlapManager.svc.cs as below.
C#
public MemberCollection GetLevelMembers(string levelUniqueName, string cubeName)
{
MemberCollection levelMembers = _dataManager.GetLevelMembers(levelUniqueName, cubeName);
_dataManager.DataProvider.CloseConnection();
if (!string.IsNullOrEmpty(_selectedCountry) && levelUniqueName == "[" + _dimensionName + "].[" + _hierarchyName + "].[" + _levelName + "]")
{
var selectedMembers = levelMembers.Select(i => i).Where(j => j.Caption == _selectedCountry).ToList<Member>();
levelMembers.Clear();
foreach (var item in selectedMembers)
{
levelMembers.Add(item);//Selects only the selected country to level member collection.
}
}
var selectedMembers2 = levelMembers.Select(i => i).Where(j => j.Caption != "FY 2005").ToList<Member>();
levelMembers.Clear();
foreach (var item in selectedMembers2)
{
levelMembers.Add(item);//Removes the Date from level member collection.
}
return levelMembers;
}
