GlobalCube
/
analytics


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071
							<?xml version="1.0" encoding="UTF-8"?>
<!-- 

Licensed Materials - Property of IBM 

 

BI and PM: QFW

© Copyright IBM Corp. 2005, 2010

US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 
 

-->

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:qs="qs" xmlns:SOAP="soap"  xmlns:md="md" xmlns:x="x">
	<xsl:template match="processing-instruction()" mode="extractPath">
		<xsl:variable name="xslRefSpec" select="."/>
		<xsl:value-of select="substring-before(substring-after($xslRefSpec, 'href=&quot;' ), '\..\templates\qfw\QFLogFormatting.xsl' )"/>
	</xsl:template>
	<xsl:template match="*" mode="extractPath">
   </xsl:template>
	<xsl:template match="/">
		<HTML>
			<head>
				<xsl:text disable-output-escaping="yes">&lt;link href=&quot;</xsl:text>
				<xsl:apply-templates select="/." mode="extractPath"/>
				<xsl:text disable-output-escaping="yes">\..\webcontent\qfw\QFLogFormatting.css&quot;  type=&quot;text/css&quot; rel=&quot;stylesheet&quot; /&gt;</xsl:text>

				<xsl:text disable-output-escaping="yes">&lt;script type="text/javascript" src=&quot;</xsl:text>
				<xsl:apply-templates select="/." mode="extractPath"/>
				<xsl:text disable-output-escaping="yes">\..\templates\qfw\QFLogTree.js&quot; &gt; &lt;/script&gt;</xsl:text>
				<xsl:text disable-output-escaping="yes">&lt;script type="text/javascript" src=&quot;</xsl:text>
				<xsl:apply-templates select="/." mode="extractPath"/>
				<xsl:text disable-output-escaping="yes">\..\templates\qfw\QFLogFormatting.js&quot;  &gt; &lt;/script&gt;</xsl:text>
				<xsl:text disable-output-escaping="yes">&lt;xml:namespace ns="urn:schemas-microsoft-com:vml" prefix="v"/&gt;</xsl:text>
				<style>v\:*{ behavior:url(#default#VML);}</style>
				<xsl:text disable-output-escaping="yes">&lt;link href=&quot;</xsl:text>
				<xsl:apply-templates select="/." mode="extractPath"/>
				<xsl:text disable-output-escaping="yes">\..\webcontent\qfw\../skins/corporate/portal/default.css&quot;  type=&quot;text/css&quot; rel=&quot;stylesheet&quot; /&gt;</xsl:text>
				<xsl:text disable-output-escaping="yes">&lt;link href=&quot;</xsl:text>
				<xsl:apply-templates select="/." mode="extractPath"/>
				<xsl:text disable-output-escaping="yes">\..\templates\qfw\QF_Logging_preferences.css&quot;  type=&quot;text/css&quot; rel=&quot;stylesheet&quot; /&gt;</xsl:text>
			</head>
			<BODY style="border-width: 0;" onclick="globalEventHandler();">
				<div id="binFolder" style="display:none">
					<xsl:apply-templates select="/." mode="extractPath"/>
				</div>
				<script>if( !document.body.client || document.body.client != 'CRN' ) loadANDapplyPreferences(document);</script>
				<div class="method">
					<div class="methodInfo">
						<div class="fullXML" style="display:block">
							<div class="tree" style="display:block">
								<xsl:text disable-output-escaping="yes">&lt;v:group style="position:absolute" id="tempTreeContainer"&gt; &lt;/v:group&gt; </xsl:text>
							</div>	
						</div>
					</div>
				</div>
				<TABLE class="mainHeader1" style="WIDTH: auto" cellSpacing="0" cellPadding="0" border="0">
					<TBODY>
						<TR>
							<TD class="headerTitle" id="applicationCaption" noWrap="">Query Analyzer</TD>
							<TD class="mainHeader1Middle"/>
						</TR>
					</TBODY>
				</TABLE>
				<xsl:if test="QFSScript">
					<div class="menu">
						<u onclick="allParametersFoldingCall(document.body);" class="menuitem">Show query trees</u>
						<u onclick="allErrorsFoldingCall(document.body);" class="menuitem">Show all errors</u>
						<u onclick="allPreferencesFoldingCall(document);" class="menuitem">Show preferences</u>
						<xsl:text disable-output-escaping="yes">&amp;nbsp;</xsl:text>
						<xsl:call-template name="preferencies"/>
					</div>
					<xsl:apply-templates select="QFSScript"/>
				</xsl:if>
				<xsl:if test="querySet">
					<xsl:apply-templates select="querySet" mode="ExecPlan"/>
				</xsl:if>
				<xsl:if test="QFSFeedbackList">
					<xsl:apply-templates select="QFSFeedbackList"/>
				</xsl:if>
			</BODY>
		</HTML>
	</xsl:template>
	<xsl:template match="QFSFeedbackList">
		<div class="menu">
			<u onclick="openPreferencesDialog();" class="menuitem">Preferences</u>
			<u onclick="allParametersFoldingCall(document.body);" class="menuitem">Show query trees</u>
			<xsl:text disable-output-escaping="yes">&amp;nbsp;</xsl:text>
			<xsl:call-template name="preferencies"/>
		</div>
		<xsl:for-each select="QFSFeedbackItem">
			<div class="logItemContainer">
				<xsl:attribute name="id">log_<xsl:value-of select="@logId"/></xsl:attribute>
				<span class="logItemHeader">
					<img src="..\common\images\show_area.gif" class="logItemImg"> </img>
					<b><xsl:value-of select="@queryNames"/></b>
					<!--xsl:for-each select="QFSScript/QFSSession[@method='DoRequest' or @method='DoRequest1' or @method='DoRequest2']/parm[@type='input']/*/*[querySet]">
						<b>
							<xsl:value-of select="retrieveDataset/@value"/>
						</b>
					</xsl:for-each-->
				</span>
				<div class="logItemMenu">
					<u class="menuitem">Full Log</u>
					<u class="menuitem">Execution Plan</u>
					<u class="menuitem">Data Flow</u>
					<xsl:text disable-output-escaping="yes">&amp;nbsp;</xsl:text>
				</div>
				<!--div class="logItem" presentation="Full Log">
					<xsl:apply-templates select="QFSScript"/>
				</div-->
			</div>
		</xsl:for-each>
	</xsl:template>
	<xsl:template match="querySet" mode="ExecPlan">
		<div class="fullXML">
			<b class="paramType">Execution Plan:</b>
			<xsl:if test=".//providerQuery">
				<u>XML</u>
				<u>Tree</u>
				<u>Plan</u>
			</xsl:if>
			<xsl:apply-templates select="." mode="printXML"/>
		</div>
	</xsl:template>
	<xsl:template match="QFSScript">
		<xsl:for-each select="*">
			<xsl:apply-templates select="." mode="methodPrint"/>
		</xsl:for-each>
	</xsl:template>
	<xsl:template match="*" mode="methodPrint">
		<DIV class="method">
			<div class="methodInfo">
				<xsl:choose>
					<xsl:when test="@method [. = 'DoRequest' or . = 'DoRequest1' or . = 'QueryExecute' or . = 'QueryExecute1' or . = 'QueryExecute2' or . = 'QueryPrepare' or . = 'QueryValidate' or . = 'QueryValidate1' or . = 'QueryValidate2'  or . = 'QueryGetParameters1'  or . = 'QueryGetParameters2']">
						<xsl:attribute name="class">methodInfo <xsl:value-of select="@_provider"/></xsl:attribute>
					</xsl:when>
					<xsl:otherwise>
						<xsl:attribute name="class">methodInfo nHL <xsl:value-of select="@_provider"/></xsl:attribute>
					</xsl:otherwise>
				</xsl:choose>
				<xsl:attribute name="objId"><xsl:value-of select="@id"/></xsl:attribute>
				<span class="methodHeader">
					<xsl:if test="*[name() != 'parm' and name() != 'info']">
						<span class="nestingSwitch" onclick="mainMethodOnClick();">(-)</span>
					</xsl:if>
					<xsl:choose>
						<xsl:when test="@method [. = 'DoRequest' or . = 'DoRequest1' or . = 'QueryExecute' or . = 'QueryExecute1' or . = 'QueryExecute2' or . = 'QueryPrepare' or . = 'QueryValidate' or . = 'QueryValidate1' or . = 'QueryValidate2'  or . = 'QueryGetParameters1'  or . = 'QueryGetParameters2']">
							<span>
								<xsl:attribute name="class">providerName HL</xsl:attribute>
								<xsl:value-of select="@_provider"/>
							</span>
							<xsl:value-of select="name()"/>::<span class="methodName HL">
								<xsl:value-of select="@method"/>
							</span>
							<span class="timeStamp">
								<xsl:value-of select="@time"/>
							</span>
						</xsl:when>
						<xsl:otherwise>
							<span>
								<xsl:attribute name="class">providerName</xsl:attribute>
								<xsl:value-of select="@_provider"/>
							</span>
							<xsl:value-of select="name()"/>::<span class="methodName">
								<xsl:value-of select="@method"/>
							</span>
							<span class="nHLtimeStamp">
								<xsl:value-of select="@time"/>
							</span>
						</xsl:otherwise>
					</xsl:choose>
					<xsl:if test="info[@timeElapsed and @timeElapsed != '00:00:00.000']">
						<small>
							<xsl:value-of select="info/@timeElapsed"/>
						</small>
					</xsl:if>
					<xsl:if test="info[@memoryDiff]">
						<em>
							MemoryDiff: <xsl:value-of select="info/@memoryDiff"/>
						</em>
					</xsl:if>
					<xsl:apply-templates select="parm" mode="shortParameterInfo"/>
				</span>
				<xsl:apply-templates select="parm" mode="fullParameterInfo"/>
			</div>
			<xsl:if test="*[name() != 'parm' and name() != 'info']">
				<DIV class="nesting">
					<xsl:for-each select="*[name() != 'parm' and name() != 'info']">
						<xsl:apply-templates select="." mode="methodPrint"/>
					</xsl:for-each>
				</DIV>
			</xsl:if>
		</DIV>
	</xsl:template>
	<xsl:template match="parm" mode="shortParameterInfo">
		 [<b class="plus">+</b>
		<xsl:choose>
			<xsl:when test="@type = 'error'">
				<u class="err" onclick="parameterFolding();">
					<xsl:value-of select="@type"/>
				</u>
			</xsl:when>
			<xsl:otherwise>
				<u onclick="parameterFolding();">
					<xsl:value-of select="@type"/>
				</u>
			</xsl:otherwise>
		</xsl:choose> ]
	</xsl:template>
	<xsl:template match="parm" mode="fullParameterInfo">
		<div class="fullXML">
			<xsl:if test="../@method = 'ConnectionConnect'">
				<xsl:attribute name="id"><xsl:value-of select="../@id"/>_connect</xsl:attribute>
			</xsl:if>
			<xsl:choose>
				<xsl:when test="@type = 'error'">
					<b class="err">
						<xsl:value-of select="@type"/>:
					</b>
				</xsl:when>
				<xsl:otherwise>
					<b class="paramType">
						<xsl:value-of select="@type"/>:
					</b>
				</xsl:otherwise>
			</xsl:choose>
			<xsl:if test=".//querySet">
				<u>XML</u>
				<u>Tree</u>
			</xsl:if>
			<xsl:if test="*[( name() = 'command' or  name() = 'qs:command' or name()='execute' or name()='validate' ) and (../../@_provider='QFS' or ../../@_provider='CoordinationPlanner' or ../../@_provider='RelationalQueryProvider' or ../../@_provider='OlapQueryProvider' ) and  not( .//Metadata ) and not( .//providerQuery ) ]">
				<a onclick="executeOnClick();" class="action">execute</a>
			</xsl:if>
			<xsl:for-each select="QFSQuery">
				<QFSQuery>
					<xsl:attribute name="id"><xsl:value-of select="@id"/></xsl:attribute>
					<xsl:attribute name="connectId"><xsl:value-of select="../../@id"/></xsl:attribute>
				</QFSQuery>
			</xsl:for-each>
			<!--xsl:apply-templates select="node()" mode="printXML"/-->
			<div class="xmltext">
				<xsl:apply-templates select="node()" mode="printXMLasCopy"/>
			</div>
		</div>
	</xsl:template>
	<!--xsl:template match="*[not(contains(name(),':'))]" mode="printXMLasCopy"-->
	<xsl:template match="*" mode="printXMLasCopy">
		<xsl:element name="x:el">
			<xsl:attribute name="en"><xsl:value-of select="name()"/></xsl:attribute>
			<xsl:apply-templates select="@*" mode="printXMLasCopy"/>
			<xsl:apply-templates select="*|text()" mode="printXMLasCopy"/>
		</xsl:element>
	</xsl:template>
	<!--xsl:template match="*[contains(name(),':')]" mode="printXMLasCopy">
		<xsl:element name="{name()}">
			<xsl:apply-templates select="@*" mode="printXMLasCopy"/>
			<xsl:apply-templates select="*|text()" mode="printXMLasCopy"/>
		</xsl:element>
	</xsl:template-->
	<xsl:template match="@*" mode="printXMLasCopy">
		<xsl:element name="x:at">
			<xsl:attribute name="n"><xsl:value-of select="name()"/></xsl:attribute>
			<xsl:value-of select="."/>
			<!--xsl:attribute name="v"><xsl:value-of select="."/></xsl:attribute-->
		</xsl:element>
		<!--xsl:copy-of select="."/-->
	</xsl:template>
	<xsl:template match="text()" mode="printXMLasCopy">
		<xsl:copy-of select="."/>
	</xsl:template>

	<xsl:template match="text()" mode="printXML">
		<B class="t">
			<xsl:value-of select="."/>
		</B>
	</xsl:template>
	<xsl:template match="comment()" mode="printXML">
		<DIV class="k">
			<PRE>&lt;!--<xsl:value-of select="."/>--&gt;</PRE>
		</DIV>
	</xsl:template>
	<xsl:template match="*" mode="printXML">
		<DIV class="e">&lt;<xsl:value-of select="name(.)"/>
			<xsl:apply-templates select="@*" mode="printXML"/>/&gt;</DIV>
	</xsl:template>
	<xsl:template match="*[node()]" mode="printXML">
		<DIV class="e">
			<DIV class="c" ondblclick="toggleXmlContent();">
				&lt;<xsl:value-of select="name(.)"/>
				<xsl:apply-templates select="@*" mode="printXML"/>&gt;
			</DIV>
			<DIV>
				<xsl:apply-templates mode="printXML"/>
				<DIV>
					&lt;/<xsl:value-of select="name(.)"/>&gt;
				</DIV>
			</DIV>
		</DIV>
	</xsl:template>
	<xsl:template name="printText">
		<xsl:param name="text"/>
		<xsl:choose>
			<xsl:when test="contains( $text, '&gt;') or contains( $text, '&lt;') or contains( $text, '&amp;') or contains( $text, '&quot;')">
				<xsl:call-template name="printTextChar">
					<xsl:with-param name="i">
						<xsl:value-of select="1"/>
					</xsl:with-param>
					<xsl:with-param name="count">
						<xsl:value-of select="string-length($text)"/>
					</xsl:with-param>
					<xsl:with-param name="text">
						<xsl:value-of select="."/>
					</xsl:with-param>
				</xsl:call-template>
			</xsl:when>
			<xsl:otherwise>
				<xsl:value-of select="$text"/>
			</xsl:otherwise>
		</xsl:choose>
	</xsl:template>
	<xsl:template name="printTextChar">
		<xsl:param name="i"/>
		<xsl:param name="count"/>
		<xsl:param name="text"/>
		<xsl:if test="$i &lt;= $count">
			<xsl:variable name="ch" select="substring( $text, $i, 1 )"/>
			<xsl:choose>
				<xsl:when test="$ch = '&gt;'">
					<xsl:text disable-output-escaping="no">&amp;gt;</xsl:text>
				</xsl:when>
				<xsl:when test="$ch = '&lt;' ">
					<xsl:text disable-output-escaping="no">&amp;lt;</xsl:text>
				</xsl:when>
				<xsl:when test="$ch = '&amp;'">
					<xsl:text disable-output-escaping="no">&amp;amp;</xsl:text>
				</xsl:when>
				<xsl:when test="$ch = '&quot;'">
					<xsl:text disable-output-escaping="no">&amp;quot;</xsl:text>
				</xsl:when>
				<xsl:otherwise>
					<xsl:value-of select="$ch"/>
				</xsl:otherwise>
			</xsl:choose>
			<xsl:call-template name="printTextChar">
				<xsl:with-param name="i">
					<xsl:value-of select="$i + 1"/>
				</xsl:with-param>
				<xsl:with-param name="count">
					<xsl:value-of select="$count"/>
				</xsl:with-param>
				<xsl:with-param name="text">
					<xsl:value-of select="$text"/>
				</xsl:with-param>
			</xsl:call-template>
		</xsl:if>
	</xsl:template>
	<xsl:template match="*[text() and not (comment())]" mode="printXML">
		<DIV class="e" ondblclick="toggleXmlContent();">
			<DIV>
				&lt;<xsl:value-of select="name(.)"/>
				<xsl:apply-templates select="@*" mode="printXML"/>&gt;<b class="t">
					<xsl:call-template name="printText">
						<xsl:with-param name="text">
							<xsl:value-of select="."/>
						</xsl:with-param>
					</xsl:call-template>
				</b>&lt;/<xsl:value-of select="name(.)"/>&gt;
				<!--xsl:value-of select="replace(replace(replace(.,'&gt;','&amp;gt;'),'&lt;','&amp;lt;'),'&quot;','&amp;quot;')"/>&lt;/<xsl:value-of select="name(.)"/>&gt; -->
			</DIV>
		</DIV>
	</xsl:template>
	<xsl:template match="*[*]" mode="printXML">
		<DIV class="e">
			<DIV class="c" ondblclick="toggleXmlContent();">
				&lt;<xsl:value-of select="name(.)"/>
				<xsl:apply-templates select="@*" mode="printXML"/>&gt;
			</DIV>
			<DIV>
				<xsl:apply-templates mode="printXML"/>
				<DIV>
					&lt;/<xsl:value-of select="name(.)"/>&gt;
				</DIV>
			</DIV>
		</DIV>
	</xsl:template>
	<xsl:template match="@*" mode="printXML">
		<xsl:text> </xsl:text>
		<xsl:value-of select="name(.)"/>="<B>
			<xsl:call-template name="printText">
				<xsl:with-param name="text">
					<xsl:value-of select="."/>
				</xsl:with-param>
			</xsl:call-template>
		</B>"</xsl:template>

	<xsl:template name="preferencies">

						<div class="preferences">
							Preferences:
							<br/>
							<br/>
							<div class="preference" id="timestamp">Timestamp:
								<select>
									<option value="inline, inline">
										<span class="preferenceOption" onclick="preferenceSelect();">
												All
											</span>
									</option>
									<option value="inline, none">
										<span class="preferenceOption" onclick="preferenceSelect();">
												Main
											</span>
									</option>
									<option value="none, none" selected="selected">
										<span class="preferenceOption" onclick="preferenceSelect()">
												None
											</span>
									</option>
								</select>
							</div>
							<br/>
							<div class="preference" id="minors">Show Minor Operations:
								<select>
									<option value="block">
										<span class="preferenceOption" onclick="preferenceSelect();">
											Yes
										</span>
									</option>
									<option value="none" selected="">
										<span class="preferenceOption" onclick="preferenceSelect();">
											No
										</span>
									</option>
								</select>
							</div>
							<br/>
							<div class="preference" id="providers">Provider Display:
								<br/>
								<span class="preferenceOption" providerClass=".QFS">
									QFS:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".CoordinationPlanner">
									Coordination Planner:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".RefinerProvider">
									Refiner Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".ZeroSuppressProvider">
									Zero Suppression Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".MDOperationProvider">
									MD Operation Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".CubeBuildProvider">
									Cube Build Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".NoDataModeProvider">
									No Data Mode Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".ReporterModeProvider">
									Reporter Mode Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".TabularFuncProvider">
									Tabular Function Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".TabularOperationProvider">
									Tabular Operation Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".RelationalQueryProvider">
									Relational Query Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".OlapQueryProvider">
									Olap Query Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".PowerCubeODP">
									Power Cube ODP:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".MSAnalysisODP">
									MS Analysis ODP:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
								<br/>
								<span class="preferenceOption" providerClass=".MasterDetailProvider">
									Master Detail Provider:
									<select>
										<option value="red">
												Red
										</option>
										<option value="orange">
												Orange
										</option>
										<option value="yellow">
												Yellow
										</option>
										<option value="green">
												Green
										</option>
										<option value="cyan">
												Cyan
										</option>
										<option value="blue">
												Blue
										</option>
										<option value="purple">
												Purple
										</option>
										<option value="pink">
												Pink
										</option>
										<option value="grey">
												Grey
										</option>
										<option value="none" selected="selected">
												None
										</option>
										<option value="hide">
												Hide
										</option>
									</select>
								</span>
							</div>
							<br/>
							<div class="preference" id="color">Color Scheme:
								<select>
									<option value="red">
											Red
									</option>
									<option value="orange">
											Orange
									</option>
									<option value="yellow">
											Yellow
									</option>
									<option value="green">
											Green
									</option>
									<option value="cyan">
											Cyan
									</option>
									<option value="blue" selected="selected">
											Blue
									</option>
									<option value="purple">
											Purple
									</option>
									<option value="pink">
											Pink
									</option>
									<option value="grey">
											Grey
									</option>
								</select>
							</div>
							<br/>
							<u onclick="saveANDapplyPreferences(document); allPreferencesFoldingCall(document);"> Save and Apply Preferences</u>
							<br/>
							<u onclick="inputPreferences(document); applyPreferences(document);">Apply Preferences</u>
							<!--br/>
							<u onclick="verifyPrefs(document)">Verify Preferences</u-->
							<br/>
							<u onclick="setDefaults(document); setSelections(document); saveANDapplyPreferences(document)">Reset to Default Preferences</u>
						</div>

</xsl:template>
</xsl:stylesheet>