public String createMembersClause(MemberState ms)
{
String[] attributes;
attributes = ms.getChecked();
String ret = "WITH ";
int i = 0;
String memberName, memberClause;
foreach (String member in attributes)
{
memberName = createMemberName(member, i);
memberClause = " MEMBER " + memberName + " AS ";
ret = ret + memberClause + "'Aggregate({" + member + "})' ";
i++;
}
return ret;
}
private String createWhereClause(MemberState ms)
{
String[] attributes = ms.getChecked();
String[] memberNames = createMemberNames(attributes);
String sep = "";
String memberNameList = "";
String whereClause = "";
if (memberNames.Length != 0)
{
whereClause = whereClause + " WHERE ( ";
foreach (String memberName in memberNames)
{
memberNameList = memberNameList + sep + memberName;
sep = ",";
}
whereClause = whereClause + memberNameList + ") ";
}
return whereClause;
}