GlobalCube
/
analytics


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188
							<?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">

	<xsl:template match="/">
		<HTML><BODY>
		 <xsl:apply-templates select="querySet/masterDataset"/>
		 <xsl:apply-templates select="QSAPIScript/QSMasterDataset[@command='Printout']"/>
		</BODY></HTML>
	</xsl:template>

	<xsl:template match="QSMasterDataset">
		<h4> Script Dataset: <xsl:value-of select="@qsID"/> </h4> <br/>
		 <xsl:apply-templates select="masterDataset"/>
	</xsl:template>

	<xsl:template match="columns" mode="firstRow">
		<xsl:apply-templates select="." mode="allRows"/>
	</xsl:template>
	
	<xsl:template match="columns" mode="allRows">
		<TR>
			<xsl:for-each select="column">
					       <TD> <FONT size="-2"> <B> <xsl:value-of select="@name"/>  </B> </FONT> </TD>
			</xsl:for-each>
		</TR>
	</xsl:template>
	
	<xsl:template match="row" mode="firstRow">
		<xsl:apply-templates select="." mode="allRows"/>
	</xsl:template>
	
	<xsl:template match="row" mode="allRows">

				<xsl:if test="preceding-sibling::row | parent::edgeIterator"> <xsl:text disable-output-escaping="yes">&lt;TR valign="top"&gt;</xsl:text>  </xsl:if>
					
					<xsl:attribute name="valign">top</xsl:attribute>

					<xsl:for-each select="value | noValue"> 
						  <xsl:element name="TD"> 
							<xsl:if test="../rowSpan"> 
								<xsl:attribute name="rowSpan"> <xsl:value-of select="../rowSpan/@v"/> </xsl:attribute> 
							</xsl:if>
							<xsl:if  test="@span">
									<xsl:attribute name="colSpan">   
									 	<xsl:value-of select="@span"/> 
									</xsl:attribute>
							</xsl:if>
					       	<xsl:choose>
								<xsl:when test="@v"> <xsl:value-of select="@v"/> </xsl:when>
								<xsl:when test="masterDataset"> <xsl:apply-templates/> </xsl:when>
								<xsl:when test="@f"> <i> <font size="-1"> <xsl:value-of select="@f"/> </font> </i>  </xsl:when>
								<xsl:otherwise> <xsl:text disable-output-escaping="yes">&amp;nbsp;</xsl:text> </xsl:otherwise>
							</xsl:choose>  
						 </xsl:element>
					</xsl:for-each>

					<xsl:for-each select="rowCells/*"> 
					
						  <xsl:element name="TD"> 
							<xsl:if  test="@span">
									<xsl:attribute name="colSpan">   
									 	<xsl:value-of select="@span"/> 
									</xsl:attribute>
							</xsl:if>
					       	<xsl:choose>
								<xsl:when test="name()='cell'"> <xsl:value-of select="@v"/> </xsl:when>
								<xsl:otherwise> <xsl:text disable-output-escaping="yes">&amp;nbsp;</xsl:text> </xsl:otherwise>
							</xsl:choose>  
						 </xsl:element>
					</xsl:for-each>
					
				<xsl:if test="count( row ) = 0"> <xsl:text disable-output-escaping="yes">&lt;/TR&gt;</xsl:text>  </xsl:if>

					<xsl:for-each select="row"> 
						<xsl:apply-templates select="." mode="allRows"/>
					</xsl:for-each>
				
	</xsl:template>


	<xsl:template match="value">
		<xsl:choose>
			<xsl:when test="../../../@f[. = 'childIterator']">   
				<xsl:apply-templates select="../../../../value[2]"/> 
				<xsl:value-of select="../../../../value[2]/@v"/> | 
			</xsl:when>
			<xsl:when test="../../../../value"> 
				<xsl:apply-templates select="../../../../value[2]"/>
				<xsl:value-of select="../../../../value[2]/@v"/>:
			</xsl:when>
		</xsl:choose>

		 <!-- <xsl:value-of select="@v"/> -->
	</xsl:template>


	<xsl:template match="masterDataset">
	
	 <xsl:if test="datasetInfo/@numEdges > 1">
	 
  	    <CENTER>
	
		<TABLE BORDER="1" cellpadding="1" cellspacing="0">
			<xsl:for-each select="partialDataset[1]/edgeIterator[@type='columns']">
				<xsl:variable name="currentIterator" select="."/>  
				
				<xsl:for-each select="columns[1]/column">
					<xsl:variable name="currentColumn" select="."/>  

					<TR>  
					
					   <xsl:if test="$currentColumn/@d = 0">
					    		<xsl:element name="TD">
					    			<xsl:attribute name="colSpan">
					    				<xsl:value-of select="count( $currentIterator/../edgeIterator[@type='rows']/columns/column )"/>
					    			</xsl:attribute>
					    			<xsl:attribute name="rowSpan">
					    				<xsl:value-of select="count( ../column )"/>
					    			</xsl:attribute>
					    		</xsl:element>
					    </xsl:if>
					    
						<xsl:for-each select="$currentIterator//*[(name()='value' or name()='noValue' or name()='column') and (@d = $currentColumn/@d) ]">
								<xsl:element name="TD">
									<xsl:if test="../rowSpan"> 
										<xsl:attribute name="colSpan"> <xsl:value-of select="../rowSpan/@v"/> </xsl:attribute> 
									</xsl:if>
									<xsl:if  test="@span">
										<xsl:attribute name="rowSpan">   
										 	<xsl:value-of select="@span"/> 
										</xsl:attribute>
									</xsl:if>
 
							       	<xsl:choose>
										<xsl:when test="name()='column'"> <B> <font size="-2"> <xsl:value-of select="@name"/> </font> </B> </xsl:when>
										<xsl:when test="name()='value'"><CENTER> <xsl:value-of select="@v"/> </CENTER> </xsl:when>
										<xsl:otherwise> <xsl:text disable-output-escaping="yes">&amp;nbsp;</xsl:text> </xsl:otherwise>
									</xsl:choose> 
									
								</xsl:element>
						</xsl:for-each>
					</TR>
				</xsl:for-each>
			</xsl:for-each>
			

			<xsl:for-each select="partialDataset/edgeIterator[@type='rows']">
				<xsl:apply-templates select="row | columns" mode="allRows"/>
			</xsl:for-each>
			
			
		</TABLE><br/>

		</CENTER>

	</xsl:if>


	 <xsl:if test="datasetInfo/@numEdges = 1">

		<CENTER>
		<TABLE BORDER="1" cellpadding="1" cellspacing="0">
			<xsl:for-each select="partialDataset/edgeIterator[position()=1]">
				<xsl:apply-templates select="row | columns" mode="allRows"/>
			</xsl:for-each>
		</TABLE> 
		</CENTER>

        </xsl:if>

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