analytics/webcontent/qs/classes/CCalculate.js

/****************************************************************
** Licensed Materials - Property of IBM
**
** BI and PM: qs
**
** (C) Copyright IBM Corp. 2001, 2015
**
** US Government Users Restricted Rights - Use, duplication or 
** disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
*****************************************************************/

// Copyright (C) 2008 Cognos ULC, an IBM Company. All Rights Reserved.
// Cognos and the Cognos logo are trademarks of Cognos ULC (formerly Cognos Incorporated) in the United States and/or other countries.  IBM and the IBM logo are trademarks of International Business Machines Corporation in the United States, or other countries, or both.  Other company, product, or service names may be trademarks or service marks of others.




function CCalculate()
{
	this.m_bFeatureRequiresQualityOfService = true;
};

CCalculate.prototype = new AFeatureObject();

CCalculate.prototype.setup = function (aFeatureParams)
{
	if (typeof aFeatureParams != "undefined" && aFeatureParams instanceof Array && aFeatureParams.length > 0)
	{
		newCalculation(aFeatureParams[0]);
	}
	else
	{
		newCalculation();
	}
};


var calcListDefault = new Array(
							 "CALCULATION_CONCATENATION", "calcConcat", false
							);
var calcListNumber = new Array(
							 "CALCULATION_SUM", "calcNumericMultiple", true,
							 "CALCULATION_DIFFERENCE", "calcNumericDouble", true,
							 "CALCULATION_PRODUCT", "calcNumericMultiple", true,
							 "CALCULATION_DIVISION", "calcNumericDouble", true,
							 "CALCULATION_POWER", "calcNumericAdvanced", false,
							 "CALCULATION_ABSOLUTE", "calcNumericAdvanced", false,
							 "CALCULATION_ROUND", "calcNumericAdvanced", false,
							 "CALCULATION_ROUND_DOWN", "calcNumericAdvanced", false,
							 "CALCULATION_SQUARE_ROOT", "calcNumericAdvanced", false,

							 "CALCULATION_PERCENTAGE", "calcNumericDouble", true,
							 "CALCULATION_PERCENT_TOTAL", "calcNumericPercentTotal", false,
							
							 "CALCULATION_PERCENT_DIFFERENCE", "calcNumericDouble", false,

							 "CALCULATION_AVERAGE", "calcNumericMultiple", true,
							 "CALCULATION_MAXIMUM", "calcNumericMultiple", false,
							 "CALCULATION_MINIMUM", "calcNumericMultiple", false,
							 "CALCULATION_RANK", "calcNumericRank", false,
							 "CALCULATION_PERCENT_TOTAL", "calcNumericPercentTotal", false,
							 "CALCULATION_PERCENTILE", "calcNumericPercentile", false,
							 "CALCULATION_QUARTILE", "calcNumericPercentile", false,
							 "CALCULATION_QUANTILE", "calcNumericPercentile", false
							);
var calcListDate = new Array(
							 "CALCULATION_DATETIME_DIFFERENCE", "calcDateTimeDifference", true,
							 "CALCULATION_DATETIME_DAYS_BETWEEN", "calcDateTimeDifference", false,
							 "CALCULATION_DATETIME_MONTHS_BETWEEN", "calcDateTimeDifference", false,
							 "CALCULATION_DATETIME_YEARS_BETWEEN", "calcDateTimeDifference", false,
							 "CALCULATION_DATETIME_ADD_DAYS", "calcDateTimeAdd", false,
							 "CALCULATION_DATETIME_ADD_MONTHS", "calcDateTimeAdd", false,
							 "CALCULATION_DATETIME_ADD_YEARS", "calcDateTimeAdd", false,
							 "CALCULATION_EARLIEST", "calcDateTimeMaxMin", false,
							 "CALCULATION_LATEST", "calcDateTimeMaxMin", false,
							 "CALCULATION_YEAR", "calcDateTimeUnits", false,
							 "CALCULATION_MONTH", "calcDateTimeUnits", false,
							 "CALCULATION_WEEK", "calcDateTimeUnits", false,
							 "CALCULATION_DAY", "calcDateTimeUnits", false
							);
var calcListTime = new Array(
							 "CALCULATION_DATETIME_DIFFERENCE", "calcDateTimeDifference", true,
							 "CALCULATION_EARLIEST", "calcDateTimeMaxMin", false,
							 "CALCULATION_LATEST", "calcDateTimeMaxMin", false,
							 "CALCULATION_HOUR", "calcDateTimeUnits", false,
							 "CALCULATION_MINUTE", "calcDateTimeUnits", false,
							 "CALCULATION_SECOND", "calcDateTimeUnits", false
							);
var calcListDatetime = new Array(
							 "CALCULATION_DATETIME_DIFFERENCE", "calcDateTimeDifference", true,
							 "CALCULATION_DATETIME_DAYS_BETWEEN", "calcDateTimeDifference", false,
							 "CALCULATION_DATETIME_MONTHS_BETWEEN", "calcDateTimeDifference", false,
							 "CALCULATION_DATETIME_YEARS_BETWEEN", "calcDateTimeDifference", false,
							 "CALCULATION_DATETIME_ADD_DAYS", "calcDateTimeAdd", false,
							 "CALCULATION_DATETIME_ADD_MONTHS", "calcDateTimeAdd", false,
							 "CALCULATION_DATETIME_ADD_YEARS", "calcDateTimeAdd", false,
							 "CALCULATION_EARLIEST", "calcDateTimeMaxMin", false,
							 "CALCULATION_LATEST", "calcDateTimeMaxMin", false,
							 "CALCULATION_YEAR", "calcDateTimeUnits", false,
							 "CALCULATION_MONTH", "calcDateTimeUnits", false,
							 "CALCULATION_WEEK", "calcDateTimeUnits", false,
							 "CALCULATION_DAY", "calcDateTimeUnits", false,
							 "CALCULATION_HOUR", "calcDateTimeUnits", false,
							 "CALCULATION_MINUTE", "calcDateTimeUnits", false,
							 "CALCULATION_SECOND", "calcDateTimeUnits", false
							);
var calcListString = new Array(
							 "CALCULATION_LEFT", "calcStringLeftRightTrim", false,
							 "CALCULATION_RIGHT", "calcStringLeftRightTrim", false,
							 "CALCULATION_CONCATENATION", "calcConcat", false,
							 "CALCULATION_TEXT_TRIM", "calcStringLeftRightTrim", false
							);
var calcListInterval = new Array(
							 "CALCULATION_SUM", "calcNumericMultiple", true,
							 "CALCULATION_DIFFERENCE", "calcDateTimeDifference", true,
							 "CALCULATION_DAYS", "calcIntervalUnits", true,
							 "CALCULATION_LATEST", "calcDateTimeMaxMin", true,
							 "CALCULATION_EARLIEST", "calcDateTimeMaxMin", true,
							 "CALCULATION_RANK", "calcNumericRank", true
							);



var defaultList = new Array(
	new Array("ces_concatenate")
);

var numberList = new Array(
	new Array("ces_add"),
	new Array("ces_subtract"),
	new Array("ces_multiply"),
	new Array("ces_divide"),
	new Array("sql99_power"),
	new Array("sql99_abs"),
	new Array("btf_round"),
	new Array("sql99_floor"),
	new Array("sql99_sqrt", "sql99_abs"),

	new Array("ces_divide"),
	new Array("ces_divide", "ces_for", "ces_for_report", "FOR_REPORT_IN_SIBLING_VSETS_EGROUPS"),
	
	new Array("ces_subtract", "ces_divide", "sql99_abs"),

	new Array("ces_add", "ces_subtract", "ces_divide"),
	new Array("ces_if", "ces_greater"),
	new Array("ces_if", "ces_less"),
	new Array("ces_rank", "ces_for", "ces_for_report", "ces_prefilter", "FOR_REPORT_IN_SIBLING_VSETS_EGROUPS"),
	new Array("ces_divide", "ces_for", "ces_for_report", "FOR_REPORT_IN_SIBLING_VSETS_EGROUPS"),
	new Array("ces_percentile", "ces_for", "ces_for_report", "ces_prefilter", "FOR_REPORT_IN_SIBLING_VSETS_EGROUPS"),
	new Array("ces_quartile", "ces_for", "ces_for_report", "ces_prefilter", "FOR_REPORT_IN_SIBLING_VSETS_EGROUPS"),
	new Array("ces_quantile", "ces_for", "ces_for_report", "ces_prefilter", "FOR_REPORT_IN_SIBLING_VSETS_EGROUPS")
);

var dateList = new Array(
	new Array("ces_subtract"),
	new Array("btf_days_between"),
	new Array("btf_months_between"),
	new Array("btf_years_between"),
	new Array("btf_add_days"),
	new Array("btf_add_months"),
	new Array("btf_add_years"),
	new Array("ces_if", "ces_less"),
	new Array("ces_if", "ces_greater"),
	new Array("sql99_extract"),
	new Array("sql99_extract"),
	new Array("btf_week_of_year"),
	new Array("sql99_extract", "btf_day_of_week", "btf_first_of_month", "btf_last_of_month", "btf_day_of_year")
);

var timeList = new Array(
	new Array("ces_subtract"),
	new Array("ces_if", "ces_less"),
	new Array("ces_if", "ces_greater"),
	new Array("sql99_extract"),
	new Array("sql99_extract"),
	new Array("sql99_extract")
);

var intervalList = new Array(); 


var datetimeList = new Array(
	new Array("ces_subtract"),
	new Array("btf_days_between"),
	new Array("btf_months_between"),
	new Array("btf_years_between"),
	new Array("btf_add_days"),
	new Array("btf_add_months"),
	new Array("btf_add_years"),
	new Array("ces_if", "ces_less"),
	new Array("ces_if", "ces_greater"),
	new Array("sql99_extract"),
	new Array("sql99_extract"),
	new Array("btf_week_of_year"),
	new Array("sql99_extract", "btf_day_of_week", "btf_first_of_month", "btf_last_of_month", "btf_day_of_year"),
	new Array("sql99_extract"),
	new Array("sql99_extract"),
	new Array("sql99_extract")
);

var stringList = new Array(
	new Array("sql99_substring"),
	new Array("sql99_substring", "sql99_character_length"),
	new Array("ces_concatenate"),
	new Array("sql99_trim")
);



var oldNumericSelection = 0;
var cSizeOfCalcListItem = 3;
var cNumCalcDialogs = 7;


var cErrInvalidSelection = -1;
var cErrInvalidStringSelection = -2;
var cErrInvalidDateSelection = -3;





function CCalcDlg(aDlgOperations, DbValidationArray, labelId)
{
	
	this.aDlgOperations = aDlgOperations;
	this.DbValidationArray = DbValidationArray;
	this.labelId = labelId;

	
	this.checkCalcFunctionAgainstDB = checkCalcFunctionAgainstDB;
	this.getCalcDlgOperationName = getCalcDlgOperationName;
	this.hasValidOperations = hasValidOperations;
};

function getCalcDlgOperationName(oldCalcType) 
{
	var selection;
	var selectionBumper = null;
	if (oldCalcType)
	{
		selection = cfgGet("CALCULATION_INDEX_" + oldCalcType.toUpperCase()); 
		if (cfgGet("CALCULATION_INDEX_" + oldCalcType.toUpperCase() + "_BUMPER"))
			selectionBumper = cfgGet("CALCULATION_INDEX_" + oldCalcType.toUpperCase() + "_BUMPER");
	}
	else
	{
		selection = cfgGet("CALCULATION_INDEX_" + this.labelId.toUpperCase()); 
		if (cfgGet("CALCULATION_INDEX_" + this.labelId.toUpperCase() + "_BUMPER"))
			selectionBumper = cfgGet("CALCULATION_INDEX_" + this.labelId.toUpperCase() + "_BUMPER");
	}
	if (selection == null)
		selection = 0;

	var numericSelection;
	var calculationDialogSlot;

	if (this.labelId == "number")
	{
		numericSelection = cfgGet("CALCULATION_INDEX_NUMERIC_TYPE");
		var numericSelectionValue = parseInt(cfgGet("CALCULATION_INDEX_NUMERIC_TYPE_VALUE"));
		if (numericSelection == null)
		{
			numericSelection = 0;
			numericSelectionValue = 0;
			selection = 0;
		}
		else if (oldNumericSelection != numericSelection)
		{
			oldNumericSelection = numericSelection;
			selection = 0;
		}
		if (selection > 0 && selectionBumper != null)
			calculationDialogSlot = (numericSelectionValue * cSizeOfCalcListItem) + (selectionBumper * cSizeOfCalcListItem);
		else
			calculationDialogSlot = (numericSelectionValue * cSizeOfCalcListItem) + (selection * cSizeOfCalcListItem);
	}
	else
		calculationDialogSlot = selection * cSizeOfCalcListItem;

	dlgGlobalSetParm("xxCalcTypeIdx", selection);
	if (this.labelId == "number")
		dlgGlobalSetParm("xxCalcSubTypeIdx", numericSelection);
	dlgSetParm("xxCalcType", this.labelId);
	dlgGlobalSetParm("xxCalcType", this.labelId);
	dlgSetParm("xxDialogType", this.aDlgOperations[calculationDialogSlot]);
	dlgGlobalSetParm("xxDialogType", this.aDlgOperations[calculationDialogSlot]);

	return this.aDlgOperations[calculationDialogSlot + 1];
};



var aCalcDialogs = new Array(cNumCalcDialogs);
if (bEnablePercentageOfFooter === true)
{
	
	calcListNumber.splice(33,0,"CALCULATION_PERCENT_FOOTER", "calcNumericPercentFooter", false);
	numberList.splice(11,0,new Array("ces_divide", "ces_for", "ces_for_report", "FOR_REPORT_IN_SIBLING_VSETS_EGROUPS"));
};
aCalcDialogs[0] = new CCalcDlg(calcListNumber, numberList, "number");
aCalcDialogs[1] = new CCalcDlg(calcListDate, dateList, "date");
aCalcDialogs[2] = new CCalcDlg(calcListTime, timeList, "time");
aCalcDialogs[3] = new CCalcDlg(calcListDatetime, datetimeList, "datetime");
aCalcDialogs[4] = new CCalcDlg(calcListInterval, intervalList, "interval");
aCalcDialogs[5] = new CCalcDlg(calcListString, stringList, "string");
aCalcDialogs[6] = new CCalcDlg(calcListDefault, defaultList, "default");


function getCalculationDlgIdx(calcType)
{
	for(var dlgIdx = 0; dlgIdx < cNumCalcDialogs; ++dlgIdx)
	{
		if(aCalcDialogs[dlgIdx].labelId == calcType)
			return dlgIdx;
	}

	return -1;
};

function requireDialogRefresh(calcType)
{
	var _calcPrevIndex = cfgGet("CALCULATION_PREVIOUS_INDEX_" + calcType.toUpperCase());
	var _calcIndex = cfgGet("CALCULATION_INDEX_" + calcType.toUpperCase());

	var calcDlgIdx = getCalculationDlgIdx(calcType);
	if(calcDlgIdx == -1)
		return true;

	if(aCalcDialogs[calcDlgIdx].labelId == "number")
	{
		var numericSelectionValue = parseInt(cfgGet("CALCULATION_INDEX_NUMERIC_TYPE_VALUE"));
		if ((_calcPrevIndex != null) && (_calcIndex != null) && (numericSelectionValue != null) &&
			(aCalcDialogs[calcDlgIdx].aDlgOperations[(numericSelectionValue * cSizeOfCalcListItem) + (_calcPrevIndex * cSizeOfCalcListItem) + 1] == aCalcDialogs[calcDlgIdx].aDlgOperations[(numericSelectionValue * cSizeOfCalcListItem) + (_calcIndex * cSizeOfCalcListItem) + 1]) &&
			(aCalcDialogs[calcDlgIdx].aDlgOperations[(numericSelectionValue * cSizeOfCalcListItem) + (_calcPrevIndex * cSizeOfCalcListItem) + 2] == true) &&
			(aCalcDialogs[calcDlgIdx].aDlgOperations[(numericSelectionValue * cSizeOfCalcListItem) + (_calcIndex * cSizeOfCalcListItem + 2)] == true))
			return true;
	}
	else
	{
		if ((_calcPrevIndex != null) && (_calcIndex != null) &&
			(aCalcDialogs[calcDlgIdx].aDlgOperations[_calcPrevIndex * cSizeOfCalcListItem + 1] == aCalcDialogs[calcDlgIdx].aDlgOperations[_calcIndex * cSizeOfCalcListItem + 1]) &&
			(aCalcDialogs[calcDlgIdx].aDlgOperations[_calcPrevIndex * cSizeOfCalcListItem + 2] == true) &&
			(aCalcDialogs[calcDlgIdx].aDlgOperations[_calcIndex * cSizeOfCalcListItem + 2] == true))
			return true;
	}

	return false;
};


function refreshNewCalculation(calcType, forceRefresh)
{
	var _calcPrevIndex = cfgGet("CALCULATION_PREVIOUS_INDEX_" + calcType.toUpperCase());
	var _calcIndex = cfgGet("CALCULATION_INDEX_" + calcType.toUpperCase());
	

	
	var addInsert = false;
	var calcIndexNT = cfgGet("CALCULATION_INDEX_NUMERIC_TYPE");
	if (calcIndexNT != null && calcIndexNT != oldNumericSelection)
		addInsert = false;
	else
		addInsert = requireDialogRefresh(calcType);

	cfgRemove("CALCULATION_REFRESH");
	if (addInsert && !forceRefresh)
	{
		getDialogFrame().addInsert();
		return false;
	}
	else
	{
		goApplicationManager.getFeatureManager().launchFeature('Calculate', [calcType]);
		return true;
	}
};

function newCalculation(oldCalcType)
{
	cfgSet("LAST_DIALOG", "newcalculation");
	dlgReset();
	dlgGlobalReset();

	if (cfgSize("SelColumns") == 0)
	{
		dlgShowMessage("CALCULATE_CREATE_BASIC_TITLE", "", "CALCULATION_CREATE_NO_SELECTION");
		return;
	}

	setupCalculation(oldCalcType);
};

function setupCalculation(oldCalcType)
{
	var selColCount = cfgSize("SelColumns");
	if(selColCount <= 0)
	{
		dlgShowMessage("CALCULATE_CREATE_BASIC_TITLE", "", "CALCULATION_CREATE_NO_SELECTION");
		return;
	}

	var calcDlgIdx = getCalculationDlgIdxFromSelection();

	if (calcDlgIdx == cErrInvalidStringSelection)
	{	
		dlgShowMessage("CALCULATE_CREATE_BASIC_TITLE", "", "CALCULATION_INVALID_STRING_SELECTION");
		return;
	}

	if (calcDlgIdx == cErrInvalidDateSelection)
	{	
		dlgShowMessage("CALCULATE_CREATE_BASIC_TITLE", "", "CALCULATION_INVALID_DATE_SELECTION");
		return;
	}

	if ( (calcDlgIdx == cErrInvalidSelection) || (calcDlgIdx < 0 || calcDlgIdx >= cNumCalcDialogs) )
	{	
		dlgShowMessage("CALCULATE_CREATE_BASIC_TITLE", "", "CALCULATION_INVALID_SELECTION");
		return;
	}

	if(!aCalcDialogs[calcDlgIdx].hasValidOperations())
	{
		dlgShowMessage("CALCULATE_CREATE_BASIC_TITLE", "", "CALCULATION_HAS_NO_VALID_OPERATIONS");
		return;
	}

	dialogName = aCalcDialogs[calcDlgIdx].getCalcDlgOperationName(oldCalcType);

	if (dialogName == "")
	{	
		dlgShowMessage("CALCULATE_CREATE_BASIC_TITLE", "", "CALCULATION_CREATE_NO_SELECTION");
		return;
	}

	if (!checkForValidSelection(true))
		return;

	buildExpression(aCalcDialogs[calcDlgIdx].labelId, dialogName);

	
	if (cfgGet("calcConstants"))
		setupSubstVars(determineDataType(aCalcDialogs[calcDlgIdx].labelId), "calculation");

	dlgSetParm("m", "/" + qs_dir + "/" + dialogName + ".xts");
	dlgSubmit();
};

function setupSubstVars(dialogType, operation)
{
	var numConstants = cfgSize("calcConstants");
	for (var i = 0; i < numConstants; i++)
	{
		var substVarArray = cfgGetAt("calcConstants", i);

		
		if ((operation == "calculation") && ((dialogName == "calcDateTimeAdd") || (dialogName == "calcStringLeftRightTrim")))
		{
			if (substVarArray[2] == 2 || substVarArray[2] == 10 || substVarArray[2] == 11 || substVarArray[2] == 12)
				dlgGlobalSetParmAt("xxSubstVarPair", dlgGlobalSize("xxSubstVarPair"), new Array(substVarArray[0], substVarArray[1]));
		}
		else if (dialogType == determineDataType(parseInt(substVarArray[2])))
			dlgGlobalSetParmAt("xxSubstVarPair", dlgGlobalSize("xxSubstVarPair"), new Array(substVarArray[0], substVarArray[1]));
	}
	if (dlgGlobalSize("xxSubstVarPair") > 0)
		dlgSetParm("xxSubstVar", "true");
};

function buildExpression(calcType, dialogName)
{
	if ( dialogName == "calcNumericPercentFooter" )
	{
		if ( calcType == "number" || calcType == "interval" )
		{
			if ( buildExpressionForPercentFooter() )
			{
				return;
			}
		}
	}

	var oMQMgr = goApplicationManager.getMiniQueryManager();
	var selColCount = cfgSize("SelColumns");

	var detailAggForCalculation, detailAggOfThisColumn;
	var before_col_id = "-1";	
	var lastSelIdx = -1;
	var i;
	for (i = 0; i < selColCount; i++)
	{
		if (cfgGetAt("SelColumns", i) > lastSelIdx)
			lastSelIdx = cfgGetAt("SelColumns", i);
	}
	if (lastSelIdx < (oMQMgr.getAllColumns().length - 1))
		before_col_id = oMQMgr.getColumnId(lastSelIdx + 1);

	dlgGlobalSetParm("xxInsBeforeColid", before_col_id);

	var thisColumn, columnLabel, columnExpr, columnExprWithoutAggWrapped;

	
	if (((calcType == "number")||(calcType == "interval")) && (dialogName == "calcNumericPercentTotal" || dialogName == "calcNumericPercentFooter" || dialogName == "calcNumericRank" || dialogName == "calcNumericPercentile"))
	{
		
		var hasPivot = false;
		var groupings = new Array();
		for (i = 0; i < oMQMgr.getAllColumns().length; i++)
		{
			if (oMQMgr.isPivoted(i))
			{
				hasPivot = true;
				break;
			}
			if (oMQMgr.getColumnRole(i) === MINI_QUERY_GROUP_LIST || oMQMgr.getColumnRole(i) === MINI_QUERY_GROUP_SECTION)
				groupings[groupings.length] = i;
		}
		if (hasPivot == true)
		{
			groupings = new Array();
			for (i = 0; i < oMQMgr.getAllColumns().length; i++)
			{
				if (oMQMgr.isMeasure(i) === false)
				{
					groupings[groupings.length] = i;
				}
			}
		}
		for (i = 0; i < groupings.length; i++)
		{
			dlgGlobalSetParmAt("xxGroupedColInfo", dlgGlobalSize("xxGroupedColInfo"), new Array (oMQMgr.getColumnLabel(groupings[i]), oMQMgr.getExpression(groupings[i])));
		}

		
		for (i = 0; i < selColCount; i++)
		{
			thisColumn = cfgGetAt("SelColumns", i);

			
			if ((oMQMgr.isCalculation(thisColumn) && (isNumeric(thisColumn) || calcType == "interval")) || !oMQMgr.isCalculation(thisColumn))
			{
				
				detailAggOfThisColumn = oMQMgr.getDetailAggregate(thisColumn);
				var regularAgg = oMQMgr.getRegularAggregate(thisColumn);

				
				if (((detailAggOfThisColumn == "") || (detailAggOfThisColumn == "none")) && oMQMgr.isMeasure(thisColumn))
				{
					if ((regularAgg == "") || (regularAgg == "none"))
						detailAggOfThisColumn = "total";
					else
						detailAggOfThisColumn = regularAgg;
				}

				
				detailAggForCalculation = "total";
				switch (detailAggOfThisColumn)
				{
					case "none":
					case "any":
					case "automatic":
					case "calculated":
						
						columnExpr = oMQMgr.getExpression(thisColumn);
						detailAggForCalculation = detailAggOfThisColumn;
						break;
					case "averageNonZero":
					case "countDistinct":
					case "countNonZero":
					case "median":
						
						if (oMQMgr.isCalculation(thisColumn))
							columnExpr = "(" + oMQMgr.getCalculatedExpression(thisColumn) + ")";
						else
							columnExpr = "(" + oMQMgr.getExpression(thisColumn) + ")";
						break;
					default:
						
						if (oMQMgr.isCalculation(thisColumn))
							columnExpr = "(" + oMQMgr.getCalculatedExpression(thisColumn) + ")";
						else
							columnExpr = "(" + oMQMgr.getExpression(thisColumn) + ")";
						detailAggForCalculation = detailAggOfThisColumn;
				}

				
				if ((dialogName != "calcNumericPercentTotal") || (dialogName == "calcNumericPercentTotal" && !oMQMgr.isCalculation(thisColumn)))
				{
					switch (detailAggOfThisColumn)
					{
						case "none":
						case "any":
						case "automatic":
						case "calculated":
							break;
						case "countDistinct":
							columnExpr = "count(distinct " + columnExpr + ")";
							break;
						default:
							columnExpr = detailAggOfThisColumn + columnExpr;
					}
				}
				if (oMQMgr.isMUN(thisColumn))
				{
					dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(oMQMgr.getColumnLabel(thisColumn), "RoleValue('_memberCaption'" + goApplicationManager.getMiniQueryManager().getListSeparator() + " " + columnExpr + ")"));
				}
				else
				{
					dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(oMQMgr.getColumnLabel(thisColumn), columnExpr));
				}
				dlgGlobalSetParmAt("xxAggs", dlgGlobalSize("xxAggs"), new Array(detailAggForCalculation, oMQMgr.getSummaryAggregate(thisColumn)));
			}
		}
	}
	else
	{
		var needToWrapWithCast = false, regularAggForCalculation = -1, detailAggToMatch = "";
		detailAggForCalculation = -1;

		for (i = 0; i < selColCount; i++)
		{
			thisColumn = cfgGetAt("SelColumns", i);

			if (dialogName == "calcConcat" && getDataType(thisColumn) != 5)
				needToWrapWithCast = true;

			columnExpr = "";
			columnExprWithoutAggWrapped = "";

			
			var detailAggOfThisColumn = oMQMgr.getDetailAggregate(thisColumn);
			var regularAggOfThisColumn = oMQMgr.getRegularAggregate(thisColumn);

			
			if (((detailAggOfThisColumn == "") || (detailAggOfThisColumn == "none")) && oMQMgr.isMeasure(thisColumn))
			{
				if ((regularAggOfThisColumn == "") || (regularAggOfThisColumn == "none"))
					detailAggOfThisColumn = "total";
				else
					detailAggOfThisColumn = regularAggOfThisColumn;
			}

			
			if (i == 0)
				detailAggToMatch = detailAggOfThisColumn;
			else if (detailAggOfThisColumn != detailAggToMatch)
			{
				if (detailAggOfThisColumn == "calculated" || detailAggToMatch == "calculated")
					detailAggForCalculation = "calculated";
				else
					detailAggForCalculation = "total";
				regularAggForCalculation = "total";
			}

			if (oMQMgr.isCalculation(thisColumn))
			{
				columnLabel = "(" + oMQMgr.getColumnLabel(thisColumn) + ")";
				switch (detailAggOfThisColumn)
				{
					case "none":
					case "any":
					case "automatic":
						columnExpr = oMQMgr.getExpression(thisColumn);
						break;
					case "calculated":
						columnExpr = oMQMgr.getExpression(thisColumn);
						regularAggForCalculation = oMQMgr.getSummaryAggregate(thisColumn);
						break;
					default:
						columnExpr = oMQMgr.getCalculatedExpression(thisColumn);
						detailAggForCalculation = detailAggOfThisColumn;
						regularAggForCalculation = oMQMgr.getSummaryAggregate(thisColumn);
				}
				if (needToWrapWithCast)
					columnExpr = "CAST((" + columnExpr + ") as nvarchar(30))";
				else
				{
					switch (detailAggOfThisColumn)
					{
						case "none":
						case "any":
						case "automatic":
							break;
						case "calculated":
							columnExprWithoutAggWrapped = oMQMgr.getCalculatedExpression(thisColumn);
							break;
						case "countDistinct":
							columnExpr = "count(distinct " + columnExpr + ")";
							break;

						case "averageNonZero":
						
						case "countNonZero":
						case "median":
							
							
							columnExprWithoutAggWrapped = columnExpr;
							columnExpr = "total(" + columnExpr + ")";
							break;
						default:
							columnExpr = detailAggOfThisColumn + "(" + columnExpr + ")";
					}
				}
				if (detailAggOfThisColumn != "calculated" || columnExprWithoutAggWrapped == "")
					columnExprWithoutAggWrapped = columnExpr;
			}
			else
			{
				columnLabel = oMQMgr.getColumnLabel(thisColumn);

				if (needToWrapWithCast)
				{
					columnExpr = "CAST";
					columnExprWithoutAggWrapped = "CAST";
					if (dialogName == "calcConcat")
					{
						switch (detailAggOfThisColumn)
						{
							case "none":
							case "any":
							case "automatic":
							case "calculated":
								break;
							case "countDistinct":
								columnExpr = "count(distinct " ;
								break;

							case "averageNonZero":
							
							case "countNonZero":
							case "median":
								columnExpr += "(total";
								columnExprWithoutAggWrapped += "(total";
								break;
							default:
								columnExpr += "(" + detailAggOfThisColumn;
								columnExprWithoutAggWrapped += "(" + detailAggOfThisColumn;
						}
					}
				}
				else
				{
					switch (detailAggOfThisColumn)
					{
						case "none":
						case "any":
						case "automatic":
							break;
						case "countDistinct":
							columnExpr="count(distinct ";
							break;
						case "calculated":
						case "averageNonZero":
						
						case "countNonZero":
						case "median":
							columnExpr = "total";
							break;
						default:
							columnExpr = detailAggOfThisColumn;
					}
				}
				columnExpr += "(" + oMQMgr.getExpression(thisColumn);
				columnExprWithoutAggWrapped += "(" + oMQMgr.getExpression(thisColumn);
				if (needToWrapWithCast)
				{
					if (dialogName == "calcConcat")
					{
						switch (detailAggOfThisColumn)
						{
							case "none":
							case "any":
							case "automatic":
							case "calculated":
								break;
							default:
 								columnExpr += ")";
								columnExprWithoutAggWrapped += ")";
						}
					}
					columnExpr += " as nvarchar(30)";
					columnExprWithoutAggWrapped += " as nvarchar(30)";
				}
				columnExpr += ")";
				columnExprWithoutAggWrapped += ")";
				if(detailAggOfThisColumn == "countDistinct")
					columnExpr += ")";
			
			}
			if (oMQMgr.isMUN(thisColumn))
			{
				dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(columnLabel, "RoleValue('_memberCaption'" + goApplicationManager.getMiniQueryManager().getListSeparator() + " " + columnExpr + ")"));
				dlgGlobalSetParmAt("xxSummExpr", dlgGlobalSize("xxSummExpr"), new Array(detailAggOfThisColumn, "RoleValue('_memberCaption'" + goApplicationManager.getMiniQueryManager().getListSeparator() + " " + columnExprWithoutAggWrapped + ")"));
			}
			else
			{
				dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(columnLabel, columnExpr));
				dlgGlobalSetParmAt("xxSummExpr", dlgGlobalSize("xxSummExpr"), new Array(detailAggOfThisColumn, columnExprWithoutAggWrapped));
			}
		}
		if ((dialogName == "calcDateTimeDifference") || (dialogName == "calcNumericDouble"))
			dlgSetParm("xxColCount", selColCount);
		dlgGlobalSetParmAt("xxDetailAgg", dlgGlobalSize("xxDetailAgg"), detailAggForCalculation);
		dlgGlobalSetParmAt("xxRegularAgg", dlgGlobalSize("xxRegularAgg"), regularAggForCalculation);
	}
};

function buildExpressionForPercentFooter()
{
	var isDone = false;

	var oMQMgr = goApplicationManager.getMiniQueryManager();
	var selColCount = cfgSize("SelColumns");

	var detailAggForCalculation, detailAggOfThisColumn;
	var before_col_id = "-1";	
	var lastSelIdx = -1;
	var i;
	for (i = 0; i < selColCount; i++)
	{
		if (cfgGetAt("SelColumns", i) > lastSelIdx)
			lastSelIdx = cfgGetAt("SelColumns", i);
	}
	if (lastSelIdx < (cfgSize("QueryIDs") - 1))
		before_col_id = cfgGetAt("QueryIDs", lastSelIdx + 1);

	dlgGlobalSetParm("xxInsBeforeColid", before_col_id);

	var thisColumn, columnExpr;

	var hasPivot = false;
	var groupings = new Array();
	for (i = 0; i < oMQMgr.getAllColumns().length; i++)
	{
		if (oMQMgr.isPivoted(i))
		{
			hasPivot = true;
			break;
		}
		if (oMQMgr.getColumnRole(i) === MINI_QUERY_GROUP_LIST || oMQMgr.getColumnRole(i) === MINI_QUERY_GROUP_SECTION)
			groupings[groupings.length] = i;
	}
	if (hasPivot == true)
	{
		groupings = new Array();
		for (i = 0; i < oMQMgr.getAllColumns().length; i++)
		{
			if (oMQMgr.isMeasure(i) === false)
				groupings[groupings.length] = i;
		}
	}

	for (i = 0; i < groupings.length; i++)
	{
		dlgGlobalSetParmAt("xxGroupedColInfo", dlgGlobalSize("xxGroupedColInfo"), new Array (oMQMgr.getColumnLabel(groupings[i]), oMQMgr.getExpression(groupings[i])));
	}

	for (i = 0; i < selColCount; i++)
	{
		thisColumn = cfgGetAt("SelColumns", i);

		
		if ( (oMQMgr.isCalculation(thisColumn) && (isNumeric(thisColumn) || calcType == "interval")) || !oMQMgr.isCalculation(thisColumn) )
		{

			

			detailAggOfThisColumn = oMQMgr.getDetailAggregate(thisColumn);
			var regularAgg = oMQMgr.getRegularAggregate(thisColumn);

			

			if ( detailAggOfThisColumn == "" ||
				 detailAggOfThisColumn == "none" ||
				 detailAggOfThisColumn == "any" ||
				 detailAggOfThisColumn == "automatic" ||
				 detailAggOfThisColumn == "calculated"
			   )
			{
				detailAggOfThisColumn = regularAgg;
			}

			
			detailAggForCalculation = oMQMgr.getSummaryAggregate(thisColumn);

			if ( detailAggForCalculation == "" ||
				 detailAggForCalculation == "none" ||
				 detailAggForCalculation == "any" ||
				 detailAggForCalculation == "default" ||
				 detailAggForCalculation == "automatic" ||
				 detailAggForCalculation == "calculated"
			   )
			{
				detailAggForCalculation = detailAggOfThisColumn;
			}

			
			

			if ( detailAggOfThisColumn == "" ||
				 detailAggOfThisColumn == "none" ||
				 detailAggOfThisColumn == "any" ||
				 detailAggOfThisColumn == "automatic" ||
				 detailAggOfThisColumn == "calculated"
			   )
			{
				detailAggOfThisColumn = "";
				detailAggForCalculation = "total";
			}

			
			
			if (oMQMgr.isCalculation(thisColumn))
			{
				columnExpr = "(" + oMQMgr.getCalculatedExpression(thisColumn) + ")";
			}
			else
			{
				columnExpr = oMQMgr.getExpression(thisColumn);
			}


			if (oMQMgr.isMUN(thisColumn))
			{
				dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(oMQMgr.getColumnLabel(thisColumn), "RoleValue('_memberCaption'" + goApplicationManager.getMiniQueryManager().getListSeparator() + " " + columnExpr + ")"));
			}
			else
			{
				dlgGlobalSetParmAt("xxColInfo", dlgGlobalSize("xxColInfo"), new Array(oMQMgr.getColumnLabel(thisColumn), columnExpr));
			}
			dlgGlobalSetParmAt("xxAggs", dlgGlobalSize("xxAggs"), new Array(detailAggOfThisColumn, detailAggForCalculation));
			isDone = true;
		}
	}

	return isDone;
};

function hasValidOperations() 
{
	var i;
	
	if(aCalcDialogs[getCalculationDlgIdxFromSelection()].labelId == "interval")
	{
		for (i = 0; i < this.aDlgOperations.length / cSizeOfCalcListItem; i++)
			dlgGlobalSetParmAt("xxValidCalcItem", dlgGlobalSize("xxValidCalcItem"), i);
		return true;
	}
	else
	{
		var bHasValidOperations = false;
		for (i = 0; i < this.DbValidationArray.length; i++)
		{

			var isValid = true;
			for (var j = 0; j < this.DbValidationArray[i].length; j++)
			{

				var currentOperation = this.DbValidationArray[i][j];
				currentOperation = currentOperation.split(",");
				var tempValid = false;
				for (var k = 0; k < currentOperation.length; k++)
				{
					if (this.checkCalcFunctionAgainstDB(currentOperation[k]))
					{
						tempValid = true;
						break;
					}
				}
				if (tempValid == false)
				{
					isValid = false;
					break;
				}
			}

			this.aDlgOperations[(i * cSizeOfCalcListItem) + 2] = isValid;

			if(isValid)
				dlgGlobalSetParmAt("xxValidCalcItem", dlgGlobalSize("xxValidCalcItem"), i);

			if(!bHasValidOperations && isValid)
				bHasValidOperations = true;
		}
		return bHasValidOperations;
	}
};

function checkCalcFunctionAgainstDB(calcFunction) 
{
	var calcFnSize = cfgSize("CalcFns");

	for (var iter = 0; iter < calcFnSize; iter++)
	{
		if (cfgGetAt("CalcFns", iter) == calcFunction)
			return true;
	}
	return false;
};

function checkRestrictedCalcFunctionAgainstDB(calcFunction) 
{
	var calcFnSize = cfgSize("CalcFnsRestricted");

	for (var iter = 0; iter < calcFnSize; iter++)
	{
		if (cfgGetAt("CalcFnsRestricted", iter) == calcFunction)
			return true;
	}
	return false;
};

function getCalculationDlgIdxFromSelection()
{
	var outputTypeIsMeasure = false;
	var oMQMgr = goApplicationManager.getMiniQueryManager();
	var numSelCols = cfgSize("SelColumns");
	var type = cErrInvalidSelection;
	for (var i = 0; i < numSelCols; ++i)
	{
		var sel = cfgGetAt("SelColumns", i);

		if (oMQMgr.isMeasure(sel))
		{
			outputTypeIsMeasure = true;
		}

		dlgGlobalSetParmAt("xxCalcParentIds", dlgGlobalSize("xxCalcParentIds"), new Array(oMQMgr.getColumnId(sel), oMQMgr.getColumnLabel(sel)));

		if(oMQMgr.isCalculation(sel))
		{
			var calcType = getCalcType(sel);
			var colType = oMQMgr.getDataType(sel);
			if( (calcType == "unknown") || ( (calcType == "model") && (colType == 0) ) )
				return cErrInvalidSelection;
		}

		if (oMQMgr.getDisplayType(sel) === 1)
		{
			return cErrInvalidSelection;
		}
		var selType = getDataType(sel);
		
		
		if (oMQMgr.hasNumericDetailAggregate(sel))
		{
			selType = 0; 
		}
			
		if(i > 0 && type != selType)
		{
			if ((selType >= 1 && selType <= 4) && ((type >= 1 && type <= 4) || type == cErrInvalidDateSelection))
				type = cErrInvalidDateSelection;
			else
				type = cErrInvalidStringSelection;
		}
		else
		{
			type = selType;
		}
	}

	dlgGlobalSetParm("xxIsMeasureOutput", outputTypeIsMeasure);

	if(type >= cNumCalcDialogs)
		return cErrInvalidSelection;

	return type;
};

function isDetailFilterEnabled()
{
	var bEnabled = ( checkCalcFunctionAgainstDB("DETAIL_FILTER_BEFORE_AGGREGATION") || checkRestrictedCalcFunctionAgainstDB("DETAIL_FILTER_BEFORE_AGGREGATION") );
	return bEnabled;
};