analytics/templates/ps/qs/calcNumericPercentFooter.xts

<?xml version="1.0" encoding="UTF-8"?>
<!--
Licensed Materials - Property of IBM

BI and PM: qs

(C) Copyright IBM Corp. 2001, 2017

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 (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
-->

<!--
Used for percentage of footer
-->
<xts:morphlet version="1.0" xmlns:xts="http://developer.cognos.com/schemas/xts/" messageBase="messages/QSRVUITextPL.xml,messages/portal.xml,messages/portalRL.xml" requiredCapability="canUseQueryStudio">
    <xts:block id="page" type="exec" mode="output" processor="XSLT" mimeType="text/html">

        <!-- get the debug logic sheet -->
        <xts:logicsheet path="logicsheets/debuglogic.xslt"/>

        <!-- get the new theme stuff -->
        <!-- apply the following logicsheets in order -->
        <xts:logicsheet path="qs/logicsheets/calc_theme.xsl"/>
        <xts:logicsheet path="logicsheets/portal.xsl"/>
        <xts:logicsheet path="qs/logicsheets/dialogs.xsl"/>
        <xts:logicsheet path="logicsheets/presentation/dialog/framework.xsl"/>
        <xts:logicsheet path="logicsheets/presentation/layout.xsl"/>
        <xts:logicsheet path="logicsheets/presentation/dialog/presentation.xsl"/>
        <xts:logicsheet path="logicsheets/presentation/controls/framework.xsl"/>
        <xts:logicsheet path="logicsheets/presentation/controls/presentation.xsl"/>
        <xts:logicsheet path="logicsheets/cm-logic.xsl"/>

        <!-- apply the form logic -->
        <xts:logicsheet path="logicsheets/formlogic.xslt"/>
        <xsl:stylesheet version="1.0"
			xmlns:clcdlg="test_calculationDlg"
			xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
			xmlns:xts="http://developer.cognos.com/schemas/xts/"
			xmlns:lyt="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/layout/"
			xmlns:pf="http://developer.cognos.com/schemas/xts/pf"
			xmlns:dp="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/presentation/"
			xmlns:df="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/framework/"
			xmlns:cp="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/controls/presentation/"
			xmlns:cf="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/controls/framework/"
			xmlns:dbg="http://developer.cognos.com/schemas/xts/logicsheets/xslt/debug/"
			xmlns:qsdlg="http://developer.cognos.com/schemas/xts/logicsheets/xslt/qs/dialog/"
			xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt"
			exclude-result-prefixes="clcdlg xsl xts lyt pf dp df cp cf dbg qsdlg xtsext">

            <xsl:output method="html" version="1.0" encoding="UTF-8" indent="no"/>

            <!-- add any theme variables -->
            <df:variables/>
            <pf:variables/>

			<!-- start the output -->
            <xsl:template match="/root">
                <dp:page>
                    <dp:script>


                        <script type="text/javascript">
                        	<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/qs/layout.js</xsl:attribute>
                        	<xsl:text/>//<xsl:text/>
                        </script>
                        <script type="text/javascript">
							<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/qs/classes/CDialogManager.js</xsl:attribute>
							<xsl:text/>//<xsl:text/>
						</script>
						<script type="text/javascript">
							<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/qs/classes/CWindowManager.js</xsl:attribute>
							<xsl:text/>//<xsl:text/>
						</script>
                        <script type="text/javascript">&lt;!--
var goDialogManager = new CDialogManager();
                            <clcdlg:jvs/>
var expression = new Array();
var detailAggs = new Array();
var footerAggs = new Array();
var calculatedExpression = new Array();
var cf = getConfigFrame();
var calcType = cf.dlgGlobalGetParm('xxCalcType');
var calcParentIds = new Array();
var calcParentLabels = new Array();
var groupsInfoValid = true;

function execute()
{
	var oMQMgr = goDialogManager.getMiniQueryManager();
	var before_col_id = cf.dlgGlobalGetParm('xxInsBeforeColid');
	var calcBy = "none";
	var calcExpr = "generated";
	var calcBase = expression[document.f.repSel.options.selectedIndex];

    var detailAgg = detailAggs[document.f.repSel.options.selectedIndex];
	var detailAgg_ = detailAgg;
	var detailAggDistinct = "";

	if ( detailAgg == "countDistinct" )
	{
		detailAgg_ = "count";
		detailAggDistinct = "distinct ";
	}

    var footerAgg = footerAggs[document.f.repSel.options.selectedIndex];
	var footerAggDistinct = "";

	if ( footerAgg == "countDistinct" )
	{
		footerAgg = "count";
		footerAggDistinct = "distinct ";
	}

	var cType = -1;
	var cUsage = -1;
	var regularAgg = -1;

	if (cf.dlgGlobalGetParm('xxGroupedColInfo') != null &amp;&amp; document.f.basedOn[1].checked &amp;&amp; groupsInfoValid)
		calcBy = " for " + document.f.repGroups.options[document.f.repGroups.options.selectedIndex].value;
	else
		calcBy = " for report";

	var calculationExpression;

	var norm = detailAgg_ + "(" + detailAggDistinct + calcBase + ")";

	var denorm = footerAgg + "(" + footerAggDistinct + calcBase + calcBy + ")";

	if ( footerAgg == "total" )
	{
		// execute like % of total
		denorm = footerAgg + "(" + norm + calcBy + ")";
	}

	calculationExpression  = norm + "/" + denorm;

	calcBy = "none";

	var calcName = getCalcName();
	var queryId = -1;
	for (var i = 0; i &lt; calcParentLabels.length; i++)
	{
		if (calcParentLabels[i] == document.f.repSel.options[document.f.repSel.options.selectedIndex].text)
		{
			queryId = i;
			break;
		}
	}
	if (queryId &lt; 0)
		return;

	for (var j = 0; j &lt; oMQMgr.getAllColumns().length; j++)
	{
		if (calcParentIds[queryId] == oMQMgr.getColumnId(j))
		{
			queryId = oMQMgr.isMeasure(j);
			break;
		}
	}
	if (queryId &lt; 0)
		return;
	else if (queryId == false)
	{
		cType = 21;
		cUsage = 2;
		detailAgg = "none";
		regularAgg = "none";
	}

	getConfigFrame().addCalcColumn(before_col_id, calculationExpression, calculationExpression, calcName, calcBy, "percentTotal", calcBase, -1, cType, cUsage, "automatic", -1, "automatic");
}

function generateName (withQuotes)
{
	var calcName = "";
	var first = document.f.repSel.options[document.f.repSel.options.selectedIndex].text;
	if (withQuotes)	{
		if (document.f.basedOn &amp;&amp; document.f.basedOn[1].checked &amp;&amp; groupsInfoValid)
			calcName = '<xts:string id="CALCULATION_PERCENT_FOOTER_GROUP_EQUATION" encode="javascript"/>';
		else
			calcName = '<xts:string id="CALCULATION_PERCENT_FOOTER_EQUATION" encode="javascript"/>';
	}
	else
		calcName = '<xts:string id="CALCULATION_PERCENT_FOOTER_SIMPLE" encode="javascript"/>';
	calcName = stringReplace (calcName, "\\^0", first);

	if (cf.dlgGlobalGetParm('xxGroupedColInfo') != null &amp;&amp; document.f.repGroups &amp;&amp; document.f.repGroups.options)
		calcName = stringReplace (calcName, "\\^1", document.f.repGroups.options[document.f.repGroups.options.selectedIndex].text);
	return calcName;
}

function init()
{
	attachMouseEvents();

	for (var i = 0; i &lt; cf.dlgGlobalSize('xxCalcParentIds'); i++)
	{
		var label = cf.dlgGlobalGetParmAt('xxCalcParentIds', i);
		calcParentIds[i] = label[0];
		calcParentLabels[i] = label[1];
	}
	for (var i = 0; i &lt; cf.dlgGlobalSize('xxColInfo'); i++)
	{
		var colInfo = cf.dlgGlobalGetParmAt('xxColInfo', i);
		expression[i] = colInfo[1];
		calculatedExpression[i] = colInfo[1];
		document.f.repSel.options[document.f.repSel.options.length] = new Option(colInfo[0], i);
	}
	for (var i = 0; i &lt; cf.dlgGlobalSize('xxAggs'); i++)
	{
		var aggs = cf.dlgGlobalGetParmAt('xxAggs', i);
		detailAggs[i] = aggs[0];
		footerAggs[i] = aggs[1];
	}

	if (cf.dlgGlobalGetParm('xxGroupedColInfo') != null)
	{
		// populate list of grouped columns menu
		for (var i = 0; i &lt; cf.dlgGlobalSize('xxGroupedColInfo'); i++)
		{
			var label = cf.dlgGlobalGetParmAt('xxGroupedColInfo', i);
			document.f.repGroups.options[document.f.repGroups.options.length] = new Option(label[0], label[1]);
		}
		document.getElementById("displayBasedOn").style.display = "inline";
	}

	var validCalcs = new Array();
	for (var i = 0; i &lt; cf.dlgGlobalSize('xxValidCalcItem'); i++)
		validCalcs[validCalcs.length] = cf.dlgGlobalGetParmAt('xxValidCalcItem', i);

	if (cf.dlgGlobalGetParm('xxCalcSubTypeIdx') == 1)
		populateCalculationList(calcType, validCalcs, "percentage");
	else
		populateCalculationList(calcType, validCalcs, "analytic");

	// select calculation
	document.f.calcList.selectedIndex = cf.dlgGlobalGetParm('xxCalcTypeIdx');
    document.f.calcNumberList.selectedIndex = cf.dlgGlobalGetParm('xxCalcSubTypeIdx');
	if (cf.dlgGlobalGetParm('xxGroupedColInfo') != null)
	{
		document.f.basedOn[0].checked = true;
		document.f.repGroups.disabled = true;
	}

	updateRepItemSelection();
	loadHint();
	setGlobals(calcType, false);
	addInsert();
}

function toggleRepGroupsState()
{
	if (document.f.basedOn[0].checked)
		document.f.repGroups.disabled = true;
	else
		document.f.repGroups.disabled = false;
}

function updateRepItemSelection()
{
	if (cf.dlgGlobalGetParm('xxGroupedColInfo') == null)
	{
		document.getElementById("displayBasedOn").style.display = "none";
		groupsInfoValid = false;
	}
	else
	{
		document.getElementById("displayBasedOn").style.display = "inline";
		groupsInfoValid = true;
	}
	loadHint();
}
                        //--&gt;</script>
                    </dp:script>
					<form style="margin:0px" name="f" method="POST" onsubmit="execute();return false;">
						<table border="0" cellspacing="0" cellpadding="0" height="100%" width="100%">
							<tr>
								<td width="100%" height="0%">
									<!-- dialog header -->
									<clcdlg:basic_header/>
								</td>
							</tr>
							<tr>
								<td width="100%" height="100%" valign="top">
									<lyt:layout style="2" border="no">
										<lyt:section>
											<clcdlg:calculationsType/>
											<clcdlg:calculations/>
											<dp:input>
												<dp:section1>
													<xts:string id="CALCULATION_REP_ITEM"/>
												</dp:section1>
												<dp:section2>
													<select name="repSel" size="1" style="width:260" onChange="javascript:updateRepItemSelection();"/>
												</dp:section2>
											</dp:input>
											<div id="displayBasedOn" style="display:none">
												<dp:choice title="CALCULATION_BASED_ON_LABEL">
													<dp:section1>
														<input type="radio" name="basedOn" onClick="javascript:onSelOperation();toggleRepGroupsState();"/>
													</dp:section1>
													<dp:section2>
														<xts:string id="CALCULATION_PERCENT_TOTAL_BASEDON_TOTAL"/>
													</dp:section2>
													<dp:section1>
														<input type="radio" name="basedOn" onClick="javascript:onSelOperation();toggleRepGroupsState();"/>
													</dp:section1>
													<dp:section2>
														<xts:string id="CALCULATION_PERCENT_TOTAL_BASEDON_GROUP"/>
													</dp:section2>
													<dp:section3>
														<select name="repGroups" size="1" style="width:260" onChange="javascript:onSelOperation();"/>
													</dp:section3>
												</dp:choice>
											</div>
										</lyt:section>
										<lyt:section>
											<clcdlg:calc_hint/>
										</lyt:section>
									</lyt:layout>
								</td>
							</tr>
							<tr>
								<td width="100%" height="0%">
									<!-- Use default buttons [ OK = execute() and CANCEL = hideDialogFrame() ] -->
									<clcdlg:buttons/>
								</td>
							</tr>
							<!-- <dbg:dumpxml select="/"/> -->
						</table>
					</form>
				</dp:page>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
</xts:morphlet>