public virtual MemberResult GetMembers(MembersDiscoveryRequest command)
{
var cmd = new MembersCommand(command.ConnectionString, command.Function, command.MemberCaption, command.ExcludedMembers, command.ExcludedPatterns);
var filters = command.GetAllFilters();
return(cmd.List(filters));
}
public void List_HierarchyWithExclusionOfAll_ListOfMembers()
{
var connStr = ConnectionStringReader.GetAdomd();
var excludedMembers = new List<string>() { "All" };
var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, null);
var filters = new List<CaptionFilter>(){
new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
new CaptionFilter("Date", DiscoveryTarget.Dimensions),
new CaptionFilter("Month Of Year", DiscoveryTarget.Hierarchies),
};
var result = cmd.List(filters);
Assert.That(result.Count, Is.EqualTo(12));
}
public void List_HierarchyWithExclusionOfPatternContainEm_ListOfMembers()
{
var connStr = ConnectionStringReader.GetAdomd();
var excludedMembers = new List<string>() { "All" };
var excludedPatterns = new List<PatternValue>() { new PatternValue() { Pattern = Pattern.Contain, Text = "em" } };
var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, excludedPatterns);
var filters = new List<CaptionFilter>(){
new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
new CaptionFilter("Date", DiscoveryTarget.Dimensions),
new CaptionFilter("Month Of Year", DiscoveryTarget.Hierarchies),
};
var result = cmd.List(filters);
//SeptEMber, NovEMber, DecEMber
Assert.That(result.Count, Is.EqualTo(9));
}
public virtual MemberResult GetMembers(MembersDiscoveryRequest command)
{
var cmd = new MembersCommand(command.ConnectionString, command.Function, command.MemberCaption, command.ExcludedMembers, command.ExcludedPatterns);
var filters = command.GetAllFilters();
return cmd.List(filters);
}
public void List_HierarchyWithMemberChildrenAndExclusion_ListOfMembers()
{
var connStr = ConnectionStringReader.GetAdomd();
var member = "Q3 CY 2006";
var excludedMembers = new List<string>() { "All" };
var excludedPatterns = new List<PatternValue>() { new PatternValue() { Pattern = Pattern.Contain, Text = "em" } };
var cmd = new MembersCommand(connStr, "Children", member, excludedMembers, excludedPatterns);
var filters = new List<CaptionFilter>(){
new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
new CaptionFilter("Date", DiscoveryTarget.Dimensions),
new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),
};
var result = cmd.List(filters);
//REturns the 3 months of the Q3 and remove SeptEMber
Assert.That(result.Count, Is.EqualTo(2));
}
public void List_Level_ListOfMembers()
{
var connStr = ConnectionStringReader.GetAdomd();
var cmd = new MembersCommand(connStr, "Members", null);
var filters = new List<CaptionFilter>(){
new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
new CaptionFilter("Date", DiscoveryTarget.Dimensions),
new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),
new CaptionFilter("Month", DiscoveryTarget.Levels)
};
var result = cmd.List(filters);
Assert.That(result.Count, Is.EqualTo(72));
}
public void List_LevelWithMemberChildren_ListOfMembers()
{
var connStr = ConnectionStringReader.GetAdomd();
var member = "January 2005";
var cmd = new MembersCommand(connStr, "Children", member, null, null);
var filters = new List<CaptionFilter>(){
new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
new CaptionFilter("Date", DiscoveryTarget.Dimensions),
new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),
new CaptionFilter("Month", DiscoveryTarget.Levels)
};
var result = cmd.List(filters);
//Returns the 31 days of the month
Assert.That(result.Count, Is.EqualTo(31));
}
public void List_LevelWithExclusionOfJanuary2005AndNovember2005_ListOfMembers()
{
var connStr = ConnectionStringReader.GetAdomd();
var excludedMembers = new List<string>() { "January 2005", "November 2005" };
var cmd = new MembersCommand(connStr, "Members", null, excludedMembers, null);
var filters = new List<CaptionFilter>(){
new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
new CaptionFilter("Date", DiscoveryTarget.Dimensions),
new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),
new CaptionFilter("Month", DiscoveryTarget.Levels)
};
var result = cmd.List(filters);
Assert.That(result.Count, Is.EqualTo(70));
}
public void List_LevelsWithMemberChildrenAndExclusion_ListOfMembers()
{
var connStr = ConnectionStringReader.GetAdomd();
var member = "January 2005";
var excludedPatterns = new List<PatternValue>() { new PatternValue() { Pattern = Pattern.Contain, Text = "3" } };
var cmd = new MembersCommand(connStr, "Children", member, null, excludedPatterns);
var filters = new List<CaptionFilter>(){
new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
new CaptionFilter("Date", DiscoveryTarget.Dimensions),
new CaptionFilter("Calendar", DiscoveryTarget.Hierarchies),
new CaptionFilter("Month", DiscoveryTarget.Levels)
};
var result = cmd.List(filters);
//Returns the 31 days of the month minus 3, 13, 23, 30, 31
Assert.That(result.Count, Is.EqualTo(31-5));
}
public void List_Set_ListOfMembers()
{
var connStr = ConnectionStringReader.GetAdomd();
var cmd = new MembersCommand(connStr, string.Empty, string.Empty, null, null);
var filters = new List<CaptionFilter>(){
new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
new CaptionFilter("Top 50 Customers", DiscoveryTarget.Sets)
};
var result = cmd.List(filters);
Assert.That(result.Count, Is.EqualTo(50));
}
public void List_SetWithExclusion_ListOfMembers()
{
var connStr = ConnectionStringReader.GetAdomd();
var excludedPatterns = new List<PatternValue>() { new PatternValue() { Pattern = Pattern.StartWith, Text = "A" } };
var cmd = new MembersCommand(connStr, string.Empty, string.Empty, null, excludedPatterns);
var filters = new List<CaptionFilter>(){
new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives),
new CaptionFilter("Top 50 Customers", DiscoveryTarget.Sets)
};
var result = cmd.List(filters);
Assert.That(result.Count, Is.EqualTo(50));
}
