analytics/templates/ccs/xslt/crn/rds_formatted.xsl

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

  IBM Cognos Products: CCS

  (c) 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 xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:ccs="http://developer.cognos.com/rds/1">
	<xsl:output method="xml" omit-xml-declaration="yes" encoding="UTF-8" version="1.0"/>
	<xsl:param name="dataFmt">formattedData</xsl:param>
	<xsl:template match="/">
		<ccs:reportData>
			<!-- The root object may or may not exist-->
			<xsl:for-each select="root/Document/DATA/PAGE">
				<xsl:apply-templates select="."/>
			</xsl:for-each>
			<xsl:for-each select="Document/DATA/PAGE">
				<xsl:apply-templates select="."/>
			</xsl:for-each>
		</ccs:reportData>
	</xsl:template>
	<xsl:template match="LIST">
		<xsl:param name="locid"/>
		<xsl:param name="reloc"/>
		<xsl:if test="@layoutClass = 'list' ">
			<xsl:element name="{$reloc}">
				<ccs:id>
					<xsl:choose>
						<xsl:when test="@name">
							<xsl:value-of select="@name"/>
						</xsl:when>
						<xsl:otherwise>
							<xsl:value-of select="$locid"/>
						</xsl:otherwise>
					</xsl:choose>
				</ccs:id>
				<ccs:locid>
					<xsl:value-of select="$locid"/>
				</ccs:locid>
				<ccs:style/>
				<ccs:name>
					<xsl:value-of select="@name"/>
				</ccs:name>
				<ccs:type>Table</ccs:type>
				<ccs:content>
					<ccs:table>
						<xsl:apply-templates select="DR"/>
					</ccs:table>
				</ccs:content>
			</xsl:element>
		</xsl:if>
		<xsl:if test="@layoutClass = 'crosstab' ">
			<xsl:element name="{$reloc}">
				<ccs:id>
					<xsl:choose>
						<xsl:when test="@name">
							<xsl:value-of select="@name"/>
						</xsl:when>
						<xsl:otherwise>
							<xsl:value-of select="$locid"/>
						</xsl:otherwise>
					</xsl:choose>
				</ccs:id>
				<ccs:locid>
					<xsl:value-of select="$locid"/>
				</ccs:locid>
				<ccs:style/>
				<ccs:name>
					<xsl:value-of select="@name"/>
				</ccs:name>
				<ccs:type>Table</ccs:type>
				<ccs:content>
					<ccs:table>
						<xsl:apply-templates select="DR"/>
					</ccs:table>
				</ccs:content>
			</xsl:element>
		</xsl:if>
		<xsl:if test="@layoutClass = 'table' ">
			<xsl:for-each select="DR/DRI/*[local-name() != 'OMAP']">
				<xsl:apply-templates select=".">
					<xsl:with-param name="locid">
						<xsl:value-of select="concat($locid,'T',position())"/>
					</xsl:with-param>
					<xsl:with-param name="reloc">
						<xsl:value-of select="$reloc"/>
					</xsl:with-param>
				</xsl:apply-templates>
			</xsl:for-each>
			<xsl:for-each select="OTR/DRI/*[local-name() != 'OMAP']">
				<xsl:apply-templates select=".">
					<xsl:with-param name="locid">
						<xsl:value-of select="concat($locid,'T',position())"/>
					</xsl:with-param>
					<xsl:with-param name="reloc">
						<xsl:value-of select="$reloc"/>
					</xsl:with-param>
				</xsl:apply-templates>
			</xsl:for-each>
		</xsl:if>
		<xsl:if test="@layoutClass = 'repeaterTable'">
			<xsl:for-each select="UNKNOWN/DRI">
				<xsl:call-template name="repeaterRow">
					<xsl:with-param name="locid">
						<xsl:value-of select="$locid"/>
					</xsl:with-param>
					<xsl:with-param name="reloc">
						<xsl:value-of select="$reloc"/>
					</xsl:with-param>
				</xsl:call-template>
			</xsl:for-each>
			<!--
			<xsl:for-each select="UNKNOWN/DRI/*[local-name() != 'OMAP']">
				<xsl:apply-templates select=".">
					<xsl:with-param name="locid">
						<xsl:value-of select="concat($locid,'RT',position())"/>
					</xsl:with-param>
					<xsl:with-param name="reloc">
						<xsl:value-of select="$reloc"/>
					</xsl:with-param>
				</xsl:apply-templates>
			</xsl:for-each>
-->
		</xsl:if>
	</xsl:template>
	<xsl:template name="repeaterRow">
		<xsl:param name="locid"/>
		<xsl:param name="reloc"/>
		<xsl:for-each select="./*[local-name() != 'OMAP']">
			<xsl:apply-templates select=".">
				<xsl:with-param name="locid">
					<xsl:value-of select="concat($locid,'RT',position())"/>
				</xsl:with-param>
				<xsl:with-param name="reloc">
					<xsl:value-of select="$reloc"/>
				</xsl:with-param>
			</xsl:apply-templates>
		</xsl:for-each>
	</xsl:template>
	<!-- Just in case the UNKNOWN element reappears again.
	<xsl:template match="UNKNOWN[@layoutClass='table']">
		<xsl:param name="locid"/>
		<xsl:param name="reloc"/>
		<xsl:for-each select="OTR/DRI/*">
			<xsl:apply-templates select=".">
				<xsl:with-param name="locid">
					<xsl:value-of select="concat($locid,'T',position())"/>
				</xsl:with-param>
				<xsl:with-param name="reloc">
					<xsl:value-of select="$reloc"/>
				</xsl:with-param>
			</xsl:apply-templates>
		</xsl:for-each>
	</xsl:template>
-->
	<xsl:template match="OFLDSET">
		<xsl:param name="locid"/>
		<xsl:param name="reloc"/>
		<xsl:for-each select="*[local-name() != 'OCAPTION']">
			<xsl:apply-templates select=".">
				<xsl:with-param name="locid">
					<xsl:value-of select="concat($locid,'P',position())"/>
				</xsl:with-param>
				<xsl:with-param name="reloc">
					<xsl:value-of select="$reloc"/>
				</xsl:with-param>
			</xsl:apply-templates>
		</xsl:for-each>
	</xsl:template>
	<xsl:template match="FORM|OTD">
		<xsl:param name="locid"/>
		<xsl:param name="reloc"/>
		<xsl:if test="@layoutClass = 'block' ">
			<xsl:for-each select="./*[local-name() != 'OMAP']">
				<xsl:apply-templates select=".">
					<xsl:with-param name="locid">
						<xsl:value-of select="concat($locid,'P',position())"/>
					</xsl:with-param>
					<xsl:with-param name="reloc">
						<xsl:value-of select="$reloc"/>
					</xsl:with-param>
				</xsl:apply-templates>
			</xsl:for-each>
		</xsl:if>
		<xsl:if test="@layoutClass = 'pageHeader' ">
			<xsl:for-each select="LIST[@layoutClass='table']/DR/DRI/*[local-name() != 'OMAP'] | LIST[@layoutClass='list'] | LIST[@layoutClass='repeaterTable'] | LIST[@layoutClass='crosstab'] | OTI | OIMG | FORM |LIST[@layoutClass='table']/OTR/DRI/*[local-name() != 'OMAP']|OCHART|OFLDSET">
				<xsl:apply-templates select=".">
					<xsl:with-param name="locid">
						<xsl:value-of select="concat($locid,':H',position())"/>
					</xsl:with-param>
					<xsl:with-param name="reloc">ccs:headerElements</xsl:with-param>
				</xsl:apply-templates>
			</xsl:for-each>
		</xsl:if>
		<xsl:if test="@layoutClass = 'pageBody'">
			<xsl:for-each select="LIST[@layoutClass='table']/DR/DRI/*[local-name() != 'OMAP'] | LIST[@layoutClass='list'] | LIST[@layoutClass='crosstab'] | LIST[@layoutClass='repeaterTable'] | OTI | OIMG | FORM |LIST[@layoutClass='table']/OTR/DRI/*[local-name() != 'OMAP']|OCHART|OFLDSET">
				<xsl:apply-templates select=".">
					<xsl:with-param name="locid">
						<xsl:value-of select="concat($locid,':B',position())"/>
					</xsl:with-param>
					<xsl:with-param name="reloc">ccs:bodyElements</xsl:with-param>
				</xsl:apply-templates>
			</xsl:for-each>
		</xsl:if>
		<xsl:if test="@layoutClass = 'pageFooter'">
			<xsl:for-each select="LIST[@layoutClass='table']/DR/DRI/*[local-name() != 'OMAP'] | LIST[@layoutClass='list'] | LIST[@layoutClass='repeaterTable'] | LIST[@layoutClass='crosstab'] | OTI | OIMG | FORM |LIST[@layoutClass='table']/OTR/DRI/*[local-name() != 'OMAP']|OCHART|OFLDSET">
				<xsl:apply-templates select=".">
					<xsl:with-param name="locid">
						<xsl:value-of select="concat($locid,':F',position())"/>
					</xsl:with-param>
					<xsl:with-param name="reloc">ccs:footerElements</xsl:with-param>
				</xsl:apply-templates>
			</xsl:for-each>
		</xsl:if>
	</xsl:template>
	<xsl:template match="PAGE">
		<xsl:variable name="locid">
			<xsl:choose>
				<xsl:when test="@name">
					<xsl:value-of select="@name"/>
				</xsl:when>
				<xsl:otherwise>
					<xsl:value-of select="concat('page_',position())"/>
				</xsl:otherwise>
			</xsl:choose>
		</xsl:variable>
		<ccs:pages>
			<ccs:id>
				<xsl:value-of select="$locid"/>
			</ccs:id>
			<ccs:name>
				<xsl:if test="@name">
					<xsl:value-of select="$locid"/>
				</xsl:if>
			</ccs:name>
			<ccs:type>Page</ccs:type>
			<ccs:content>
				<ccs:page>
					<xsl:apply-templates>
						<xsl:with-param name="locid">
							<xsl:value-of select="$locid"/>
						</xsl:with-param>
					</xsl:apply-templates>
				</ccs:page>
			</ccs:content>
			<xsl:if test="../../styleOptions/cssUrl">
				<ccs:unprocessedStyle>
					<xsl:value-of select="../../styleOptions/cssUrl"/>
				</ccs:unprocessedStyle>
			</xsl:if>
		</ccs:pages>
	</xsl:template>
	<xsl:template match="DR">
		<ccs:row>
			<xsl:variable name="isCrosstabHeader">
				<xsl:choose>
					<xsl:when test="@layoutClass = 'crosstabColumns'">1</xsl:when>
					<xsl:otherwise>0</xsl:otherwise>
				</xsl:choose>
			</xsl:variable>
			<ccs:type>
				<xsl:variable name="rowtype">
					<xsl:value-of select="@type"/>
				</xsl:variable>
				<xsl:choose>
					<xsl:when test="$isCrosstabHeader = '1'">Header</xsl:when>
					<xsl:when test="$rowtype = 'header'">Header</xsl:when>
					<xsl:when test="$rowtype = 'footer'">Footer</xsl:when>
					<xsl:otherwise>Detail</xsl:otherwise>
				</xsl:choose>
			</ccs:type>
			<xsl:for-each select="DRI">
				<ccs:cells>
					<!-- for an empty crosstab corner, create a textframe, with the spans and styles of the corner -->
					<xsl:if test="@layoutClass = 'crosstabCorner' and count(*) = 0">
						<ccs:parts>
							<ccs:id/>
							<xsl:if test="@rowspan">
								<ccs:rowspan>
									<xsl:value-of select="@rowspan"/>
								</ccs:rowspan>
							</xsl:if>
							<xsl:if test="@colspan">
								<ccs:colspan>
									<xsl:value-of select="@colspan"/>
								</ccs:colspan>
							</xsl:if>
							<ccs:type>TextFrame</ccs:type>
							<ccs:content>
								<ccs:textFrame>
									<ccs:value/>
									<ccs:dataFormat/>
									<ccs:valueType>text</ccs:valueType>
								</ccs:textFrame>
							</ccs:content>
							<xsl:call-template name="styles"/>
						</ccs:parts>
					</xsl:if>
					<xsl:for-each select="*">
						<xsl:apply-templates select=".">
							<xsl:with-param name="reloc">ccs:parts</xsl:with-param>
						</xsl:apply-templates>
					</xsl:for-each>
				</ccs:cells>
			</xsl:for-each>
		</ccs:row>
	</xsl:template>
	<xsl:template match="OIMG ">
		<xsl:param name="locid"/>
		<xsl:param name="reloc"/>
		<!-- temp fix for handling QS sort indicator images in COC -->
		<xsl:if test="$reloc != 'parts' or count(../*) &lt; 2">
			<xsl:element name="{$reloc}">
				<ccs:id>
					<xsl:choose>
						<xsl:when test="@name">
							<xsl:value-of select="@name"/>
						</xsl:when>
						<xsl:otherwise>
							<xsl:value-of select="$locid"/>
						</xsl:otherwise>
					</xsl:choose>
				</ccs:id>
				<ccs:locid>
					<xsl:value-of select="$locid"/>
				</ccs:locid>
				<ccs:type>Image</ccs:type>
				<ccs:content>
					<ccs:image>
						<ccs:url>
							<xsl:choose>
								<xsl:when test="starts-with(@src,'http')">
									<xsl:value-of select="@src"/>
								</xsl:when>
								<xsl:otherwise>
									<ccs:unprocessedGateway>
										<xsl:choose>
											<xsl:when test="starts-with(@src,'?')">
												<xsl:value-of select="@src"/>
											</xsl:when>
											<xsl:otherwise>
												<xsl:value-of select="concat('/../', @src)"/>
											</xsl:otherwise>
										</xsl:choose>
									</ccs:unprocessedGateway>
								</xsl:otherwise>
							</xsl:choose>
						</ccs:url>
					</ccs:image>
					<ccs:style/>
				</ccs:content>
			</xsl:element>
		</xsl:if>
	</xsl:template>
	<xsl:template match="OCHART">
		<xsl:param name="locid"/>
		<xsl:param name="reloc"/>
		<xsl:element name="{$reloc}">
			<ccs:id>
				<xsl:choose>
					<xsl:when test="@name">
						<xsl:value-of select="@name"/>
					</xsl:when>
					<xsl:otherwise>
						<xsl:value-of select="$locid"/>
					</xsl:otherwise>
				</xsl:choose>
			</ccs:id>
			<ccs:locid>
				<xsl:value-of select="$locid"/>
			</ccs:locid>
			<ccs:type>Chart</ccs:type>
			<ccs:content>
				<ccs:chart>
					<ccs:imageUrl>
						<xsl:choose>
							<xsl:when test="starts-with(@src,'http')">
								<xsl:value-of select="@src"/>
							</xsl:when>
							<xsl:otherwise>
								<ccs:unprocessedGateway>
									<xsl:choose>
										<xsl:when test="starts-with(@src,'?')">
											<xsl:value-of select="@src"/>
										</xsl:when>
										<xsl:otherwise>
											<xsl:value-of select="concat('/../', @src)"/>
										</xsl:otherwise>
									</xsl:choose>
								</ccs:unprocessedGateway>
							</xsl:otherwise>
						</xsl:choose>
					</ccs:imageUrl>
				</ccs:chart>
				<ccs:style/>
			</ccs:content>
		</xsl:element>
	</xsl:template>
	<xsl:template match="OTR">
		<xsl:param name="locid"/>
		<xsl:param name="reloc"/>
		<xsl:for-each select="*">
			<xsl:apply-templates select=".">
				<xsl:with-param name="locid">
					<xsl:value-of select="$locid"/>
				</xsl:with-param>
				<xsl:with-param name="reloc">
					<xsl:value-of select="$reloc"/>
				</xsl:with-param>
			</xsl:apply-templates>
		</xsl:for-each>
	</xsl:template>
	<xsl:template match="drillTargets">
		<xsl:param name="locid"/>
		<xsl:param name="reloc"/>
		<xsl:for-each select="OTI">
			<xsl:apply-templates select=".">
				<xsl:with-param name="reloc">
					<xsl:value-of select="$reloc"/>
				</xsl:with-param>
				<xsl:with-param name="isDrillTarget">true</xsl:with-param>
			</xsl:apply-templates>
		</xsl:for-each>
	</xsl:template>
	<xsl:template match="OCAPTION">
		<!-- Do nothing with fieldset captions-->
	</xsl:template>
	<xsl:template match="OTI">
		<xsl:param name="locid"/>
		<xsl:param name="reloc"/>
		<xsl:param name="isDrillTarget">false</xsl:param>
		<xsl:if test="not(@style = 'visibility:hidden')">
			<xsl:element name="{$reloc}">
				<ccs:id>
					<xsl:choose>
						<xsl:when test="@name">
							<xsl:value-of select="@name"/>
						</xsl:when>
						<xsl:otherwise>
							<xsl:value-of select="$locid"/>
						</xsl:otherwise>
					</xsl:choose>
				</ccs:id>
				<ccs:locid>
					<xsl:value-of select="$locid"/>
				</ccs:locid>
				<xsl:choose>
					<xsl:when test="$isDrillTarget = 'true'">
						<xsl:if test="../../@rowspan">
							<ccs:rowspan>
								<xsl:value-of select="../../@rowspan"/>
							</ccs:rowspan>
						</xsl:if>
					</xsl:when>
					<xsl:when test="../../../../@rowspan and ../../../@layoutClass='table'">
						<ccs:rowspan>
							<xsl:value-of select="../../../../@rowspan"/>
						</ccs:rowspan>
					</xsl:when>
					<xsl:when test="../@rowspan">
						<ccs:rowspan>
							<xsl:value-of select="../@rowspan"/>
						</ccs:rowspan>
					</xsl:when>
				</xsl:choose>
				<xsl:choose>
					<xsl:when test="$isDrillTarget = 'true'">
						<xsl:choose>
							<xsl:when test="../../@colspan">
								<ccs:colspan>
									<xsl:value-of select="../../@colspan"/>
								</ccs:colspan>
							</xsl:when>
							<xsl:when test="../../@colSpan">
								<ccs:colspan>
									<xsl:value-of select="../../@colSpan"/>
								</ccs:colspan>
							</xsl:when>
						</xsl:choose>
					</xsl:when>
					<xsl:when test="../../../../@colspan and ../../../@layoutClass='table'">
						<ccs:colspan>
							<xsl:value-of select="../../../../@colspan"/>
						</ccs:colspan>
					</xsl:when>
					<xsl:when test="../@colspan">
						<ccs:colspan>
							<xsl:value-of select="../@colspan"/>
						</ccs:colspan>
					</xsl:when>
					<xsl:when test="../@colSpan">
						<colspan>
							<xsl:value-of select="../@colSpan"/>
						</colspan>
					</xsl:when>
				</xsl:choose>
				<ccs:type>TextFrame</ccs:type>
				<ccs:content>
					<ccs:textFrame>
						<ccs:value>
							<xsl:choose>
								<xsl:when test="($dataFmt='formattedData') or (string-length(@RawXML) = 0 )">
									<xsl:value-of select="."/>
								</xsl:when>
								<xsl:otherwise>
									<xsl:choose>
										<xsl:when test="@valueType = 'number' ">
											<xsl:value-of select="translate(@RawXML, ',', '.')"/>
										</xsl:when>
										<xsl:when test="@valueType = 'currency' ">
											<xsl:value-of select="translate(@RawXML, ',', '.')"/>
										</xsl:when>
										<xsl:when test="@valueType = 'percent' ">
											<xsl:value-of select="translate(@RawXML, ',', '.')"/>
										</xsl:when>
										<xsl:otherwise>
											<xsl:value-of select="@RawXML"/>
										</xsl:otherwise>
									</xsl:choose>
								</xsl:otherwise>
							</xsl:choose>
						</ccs:value>
						<ccs:dataFormat>
							<xsl:value-of select="@formatPatternExcel"/>
						</ccs:dataFormat>
						<ccs:valueType>
							<xsl:value-of select="@valueType"/>
						</ccs:valueType>
					</ccs:textFrame>
				</ccs:content>
				<xsl:call-template name="styles"/>
			</xsl:element>
		</xsl:if>
	</xsl:template>
	<xsl:template name="styles">
		<xsl:if test="string-length(../../../@class) &gt;  0">
			<ccs:preProcessedStyle>
				<xsl:value-of select="../../../@class"/>
			</ccs:preProcessedStyle>
		</xsl:if>
		<xsl:if test="string-length(../../../@style) &gt;  0">
			<ccs:unprocessedStyle>
				<xsl:value-of select="../../../@style"/>
			</ccs:unprocessedStyle>
		</xsl:if>
		<xsl:if test="string-length(../../@class) &gt;  0">
			<ccs:preProcessedStyle>
				<xsl:value-of select="../../@class"/>
			</ccs:preProcessedStyle>
		</xsl:if>
		<xsl:if test="string-length(../../@style) &gt;  0">
			<ccs:unprocessedStyle>
				<xsl:value-of select="../../@style"/>
			</ccs:unprocessedStyle>
		</xsl:if>
		<xsl:if test="string-length(../@class) &gt;  0">
			<ccs:preProcessedStyle>
				<xsl:value-of select="../@class"/>
			</ccs:preProcessedStyle>
		</xsl:if>
		<xsl:if test="string-length(../@style) &gt;  0">
			<ccs:unprocessedStyle>
				<xsl:value-of select="../@style"/>
			</ccs:unprocessedStyle>
		</xsl:if>
		<xsl:if test="string-length(@class) &gt;  0">
			<ccs:preProcessedStyle>
				<xsl:value-of select="@class"/>
			</ccs:preProcessedStyle>
		</xsl:if>
		<xsl:if test="string-length(@style) &gt;  0">
			<ccs:unprocessedStyle>
				<xsl:value-of select="@style"/>
			</ccs:unprocessedStyle>
		</xsl:if>
	</xsl:template>
</xsl:stylesheet>