Home Explore Help
Register Sign In
GlobalCube
/
analytics
3
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
analytics
/
templates
/
ps
/
ags
/
async
/
selectValuesRequest.xts

selectValuesRequest.xts 18 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263 
  1. <?xml version="1.0" encoding="UTF-8"?>
    2. 

  2. <!--
    3. 

  3. Licensed Materials - Property of IBM
    4. 

  4. 

  5. IBM Cognos Products: AGS
    6. 

  6. 

  7. (C) Copyright IBM Corp. 2005, 2017
    8. 

  8. 

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

  10. -->
    11. 

  11. <xts:morphlet resolverBase="prompting" xmlns:xts="http://developer.cognos.com/schemas/xts/" messageBase="messages/portal.xml" requiredCapability="canUseEventStudio">
    12. 

  12.     <!--
    13. 

  13.    ===============================================================================================
    14. 

  14. 	Pull the report spec out into the DOM
    15. 

  15.    ===============================================================================================
    16. 

  16.    -->
    17. 

  17.     <xts:block id="buildSpecification" processor="XSLT" type="exec">
    18. 

  18.         <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt">
    19. 

  19.             <xsl:template match="/">
    20. 

  20.                 <xts:sequence>
    21. 

  21.                     <xts:append>
    22. 

  22.                         <specification>
    23. 

  23.                             <xsl:choose>
    24. 

  24.                                 <xsl:when test="/root/env/param[@name='memberRequest'] and /root/env/param[@name='memberRequest'] = '2'">
    25. 

  25. 								 &lt;metadataRequest connection=&quot;<xsl:value-of select="xtsext:xmlencode(string(/root/env/param[@name='model']))"/>&quot;&gt;
    26. 

  26. 			&lt;Metadata authoringLocale=&quot;<xsl:value-of select="/root/env/param[@name='el']"/>&quot; xml:lang=&quot;<xsl:value-of select="/root/env/param[@name='pl']"/>&quot; Depth=&quot;2&quot; start_atPath=&quot;<xsl:value-of select="xtsext:xmlencode(string(/root/env/param[@name='startAtPath']))"/>&quot; ResultStart=&quot;<xsl:value-of select="/root/env/param[@name='start_pos']"/>&quot; ResultCount=&quot;21&quot;&gt;
    27. 

  27. 				&lt;Properties&gt;
    28. 

  28. 					&lt;Property name=&quot;./dimension&quot;/&gt;
    29. 

  29. 					&lt;Property name=&quot;./hierarchy&quot;/&gt;
    30. 

  30. 					&lt;Property name=&quot;./level&quot;/&gt;
    31. 

  31. 					&lt;Property name=&quot;./member&quot;/&gt;
    32. 

  32. 					&lt;Property name=&quot;./folder&quot;/&gt;
    33. 

  33. 					&lt;Property name=&quot;./@_RootMembers&quot;/&gt;
    34. 

  34. 					&lt;Property name=&quot;*/@name&quot;/&gt;
    35. 

  35. 					&lt;Property name=&quot;*/@_path&quot;/&gt;
    36. 

  36. 					&lt;Property name=&quot;*/@_ref&quot;/&gt;
    37. 

  37. 					&lt;Property name=&quot;*/@memberUniqueName&quot;/&gt;
    38. 

  38. 					&lt;Property name=&quot;*/@memberCaption&quot;/&gt;
    39. 

  39. 					&lt;Property name=&quot;*/@levelUniqueName&quot;/&gt;
    40. 

  40. 					&lt;Property name=&quot;*/@levelNumber&quot;/&gt;
    41. 

  41. 					&lt;Property name=&quot;*/@levelLabel&quot;/&gt;
    42. 

  42. 					&lt;Property name=&quot;*/@parentUniqueName&quot;/&gt;
    43. 

  43. 					&lt;Property name=&quot;*/@currencyCode&quot;/&gt;
    44. 

  44. 				&lt;/Properties&gt;
    45. 

  45. 				<!-- build the filter if there is one -->
    46. 

  46.                                     <xsl:if test="/root/env/param[@name='filter'] and not(/root/env/param[@name='filter'] = '')">
    47. 

  47. 				&lt;Constraints&gt;
    48. 

  48. 					<xsl:choose>
    49. 

  49.                                             <xsl:when test="/root/env/param[@name='filter_type'] = 'equals' ">
    50. 

  50. 					&lt;Constraint Condition=&quot;[@memberCaption=&apos;<xsl:value-of select="/root/env/param[@name='filter']"/>&apos;]&quot; CaseSensitive=&quot;false&quot;/&gt;
    51. 

  51. 						</xsl:when>
    52. 

  52.                                             <xsl:otherwise>
    53. 

  53. 					&lt;Constraint Condition=&quot;[<xsl:value-of select="/root/env/param[@name='filter_type']"/>(@memberCaption,&apos;<xsl:value-of select="/root/env/param[@name='filter']"/>&apos;)]&quot; CaseSensitive=&quot;false&quot;/&gt;
    54. 

  54. 						</xsl:otherwise>
    55. 

  55.                                         </xsl:choose>
    56. 

  56. 				&lt;/Constraints&gt;
    57. 

  57. 				</xsl:if>
    58. 

  58. 			&lt;/Metadata&gt;
    59. 

  59. 		&lt;/metadataRequest&gt;
    60. 

  60. 						</xsl:when>
    61. 

  61.                                 <xsl:otherwise>
    62. 

  62.                                     <!-- get the expression locale -->
    63. 

  63.                                     <xsl:variable name="el">
    64. 

  64.                                         <xsl:value-of select="/root/env/param[@name='el']"/>
    65. 

  65.                                     </xsl:variable>
    66. 

  66.                                     <xsl:variable name="di1" select="xtsext:xmlencode(string(/root/env/param[@name='queryRef']))"/>
    67. 

  67.                                     <xsl:variable name="qi1">
    68. 

  68.                                         <xsl:choose>
    69. 

  69.                                             <xsl:when test="/root/env/param[@name='memberRequest']='1'">
    70. 

  70.                                                 <xsl:text>caption([</xsl:text>
    71. 

  71.                                                 <xsl:value-of select="$di1"/>
    72. 

  72.                                                 <xsl:text>])</xsl:text>
    73. 

  73.                                             </xsl:when>
    74. 

  74.                                             <xsl:otherwise>
    75. 

  75.                                                 <xsl:text>[</xsl:text>
    76. 

  76.                                                 <xsl:value-of select="$di1"/>
    77. 

  77.                                                 <xsl:text>]</xsl:text>
    78. 

  78.                                             </xsl:otherwise>
    79. 

  79.                                         </xsl:choose>
    80. 

  80.                                     </xsl:variable>
    81. 

  81. 											&lt;report expressionLocale=&quot;<xsl:value-of select="$el"/>&quot; xmlns=&quot;http://developer.cognos.com/schemas/report/14.0/&quot;&gt;
    82. 

  82.                                                 &lt;modelPath&gt;<xsl:value-of select="xtsext:xmlencode(string(/root/env/param[@name='model']))"/>&lt;/modelPath&gt;
    83. 

  83.                                                 &lt;XMLAttributes&gt;
    84. 

  84. 													&lt;XMLAttribute name='contextItemFormat' value='XMLFormat'/&gt;
    85. 

  85. 												&lt;/XMLAttributes&gt;
    86. 

  86. 												&lt;queries&gt;
    87. 

  87. 													&lt;query name=&quot;q1&quot;&gt;
    88. 

  88. 														&lt;source&gt;
    89. 

  89. 															&lt;model/&gt;
    90. 

  90. 														&lt;/source&gt;
    91. 

  91. 														&lt;selection&gt;
    92. 

  92. 														<!-- send in the data items, these have already been encoded-->
    93. 

  93.                                     <xsl:if test="/root/env/param[@name='queryItems']">
    94. 

  94.                                         <xsl:value-of select="/root/env/param[@name='queryItems']"/>
    95. 

  95.                                     </xsl:if>
    96. 

  96. 														&lt;/selection&gt;
    97. 

  97. 														<!-- build the filter if there is one -->
    98. 

  98.                                     <xsl:if test="/root/env/param[@name='filter'] and not(/root/env/param[@name='filter'] = '')">
    99. 

  99.                                         <xsl:variable name="filter">
    100. 

  100.                                             <xsl:choose>
    101. 

  101.                                                 <xsl:when test="/root/env/param[@name='filter_type'] = 'contains' ">
    102. 

  102.                                                     <!-- [di1] CONTAINS &apos;Jame&apos; -->
    103. 

  103.                                                     <xsl:value-of select="$qi1"/>
    104. 

  104.                                                     <xsl:text> CONTAINS '</xsl:text>
    105. 

  105.                                                     <xsl:value-of select="xtsext:xmlencode(string(/root/env/param[@name='filter']))"/>
    106. 

  106.                                                     <xsl:text>'</xsl:text>
    107. 

  107.                                                 </xsl:when>
    108. 

  108.                                                 <xsl:when test="/root/env/param[@name='filter_type'] = 'starts-with' ">
    109. 

  109.                                                     <!-- [di1] STARTS WITH &apos;Jame&apos; -->
    110. 

  110.                                                     <xsl:value-of select="$qi1"/>
    111. 

  111.                                                     <xsl:text> STARTS WITH '</xsl:text>
    112. 

  112.                                                     <xsl:value-of select="xtsext:xmlencode(string(/root/env/param[@name='filter']))"/>
    113. 

  113.                                                     <xsl:text>'</xsl:text>
    114. 

  114.                                                 </xsl:when>
    115. 

  115.                                                 <xsl:when test="/root/env/param[@name='filter_type'] = 'equals' ">
    116. 

  116.                                                     <!-- [di1] = &apos;Jame&apos; -->
    117. 

  117.                                                     <xsl:value-of select="$qi1"/>
    118. 

  118.                                                     <xsl:text> = '</xsl:text>
    119. 

  119.                                                     <xsl:value-of select="xtsext:xmlencode(string(/root/env/param[@name='filter']))"/>
    120. 

  120.                                                     <xsl:text>'</xsl:text>
    121. 

  121.                                                 </xsl:when>
    122. 

  122.                                             </xsl:choose>
    123. 

  123.                                         </xsl:variable>
    124. 

  124. 														&lt;detailFilters&gt;
    125. 

  125. 														&lt;detailFilter use=&quot;required&quot; postAutoAggregation=&quot;false&quot;&gt; 
    126. 

  126. 														&lt;filterExpression&gt;<xsl:value-of select="$filter"/>&lt;/filterExpression&gt;
    127. 

  127. 														&lt;/detailFilter&gt;
    128. 

  128. 													&lt;/detailFilters&gt;                            
    129. 

  129. 											</xsl:if>
    130. 

  130. 													&lt;/query&gt;
    131. 

  131. 												&lt;/queries&gt;
    132. 

  132. 												&lt;layouts&gt;
    133. 

  133. 													&lt;layout&gt;
    134. 

  134. 														&lt;defaultDataFormats&gt;
    135. 

  135. 															&lt;numberFormat useGrouping=&quot;false&quot;/&gt;
    136. 

  136. 															&lt;currencyFormat useGrouping=&quot;false&quot; currencySymbol=&quot;&quot;/&gt;
    137. 

  137. 															&lt;dateFormat dateSeparator=&quot;-&quot; displayOrder=&quot;YMD&quot; showEra=&quot;false&quot; showYears=&quot;showCentury&quot; showMonths=&quot;2-digits&quot; showWeekday=&quot;false&quot; showDays=&quot;2-digits&quot;/&gt;
    138. 

  138. 															&lt;timeFormat timeSeparator=&quot;:&quot; showAmPm=&quot;false&quot; showTimeZone=&quot;false&quot; showHours=&quot;2-digits&quot; showMinutes=&quot;2-digits&quot; showSeconds=&quot;2-digits&quot; showMilliseconds=&quot;3-digits&quot; decimalDelimiter=&quot;.&quot;/&gt;
    139. 

  139. 															&lt;dateTimeFormat dateSeparator=&quot;-&quot; displayOrder=&quot;YMD&quot; showEra=&quot;false&quot; showYears=&quot;showCentury&quot; showMonths=&quot;2-digits&quot; showWeekday=&quot;false&quot; showDays=&quot;2-digits&quot; timeSeparator=&quot;:&quot; showAmPm=&quot;false&quot; showTimeZone=&quot;false&quot; showHours=&quot;2-digits&quot; showMinutes=&quot;2-digits&quot; showSeconds=&quot;2-digits&quot; showMilliseconds=&quot;3-digits&quot; decimalDelimiter=&quot;.&quot;/&gt;
    140. 

  140. 															&lt;intervalFormat dateSeparator=&quot;-&quot; showYears=&quot;false&quot; showMonths=&quot;false&quot; showDays=&quot;true&quot; timeSeparator=&quot;:&quot; showHours=&quot;2-digits&quot; showMinutes=&quot;2-digits&quot; showSeconds=&quot;2-digits&quot; showMilliseconds=&quot;3-digits&quot; decimalSize=&quot;3&quot; decimalDelimiter=&quot;.&quot; sign=&quot;-&quot; useTrailingSign=&quot;false&quot; useGrouping=&quot;false&quot; units=&quot;time&quot; whenZero=&quot;000 00:00:00.000&quot;/&gt;
    141. 

  141. 														&lt;/defaultDataFormats&gt;
    142. 

  142. 														&lt;reportPages&gt;
    143. 

  143. 															&lt;page name=&quot;p1&quot;&gt;
    144. 

  144.                                                                 &lt;style&gt;&lt;defaultStyles&gt;&lt;defaultStyle refStyle="pg"/&gt;&lt;/defaultStyles&gt;&lt;/style&gt;
    145. 

  145. 																&lt;pageBody &gt;
    146. 

  146.                                                                      &lt;style&gt;&lt;defaultStyles&gt;&lt;defaultStyle refStyle="pb"/&gt;&lt;/defaultStyles&gt;&lt;/style&gt;
    147. 

  147. 																	&lt;contents&gt;
    148. 

  148. 																		&lt;list refQuery=&quot;q1&quot; rowsPerPage=&quot;23&quot;&gt;
    149. 

  149. 																			&lt;style&gt;&lt;defaultStyles&gt;&lt;defaultStyle refStyle="ls"/&gt;&lt;/defaultStyles&gt;&lt;/style&gt;
    150. 

  150. 																			&lt;listColumns&gt;
    151. 

  151. 																				&lt;listColumn&gt;
    152. 

  152. 																					&lt;listColumnTitle &gt;
    153. 

  153.                                                                                         &lt;style&gt;&lt;defaultStyles&gt;&lt;defaultStyle refStyle="lt"/&gt;&lt;/defaultStyles&gt;&lt;/style&gt;
    154. 

  154. 																						&lt;contents/&gt;
    155. 

  155. 																					&lt;/listColumnTitle&gt;
    156. 

  156. 																					&lt;listColumnBody &gt;
    157. 

  157.                                                                                         &lt;style&gt;&lt;defaultStyles&gt;&lt;defaultStyle refStyle="lc"/&gt;&lt;/defaultStyles&gt;&lt;/style&gt;
    158. 

  158. 																						&lt;contents&gt;
    159. 

  159. 																							&lt;textItem&gt;
    160. 

  160. 																								&lt;dataSource&gt;
    161. 

  161. 																									&lt;dataItemValue refDataItem=&quot;<xsl:value-of select="$di1"/>&quot;/&gt;
    162. 

  162. 																								&lt;/dataSource&gt;
    163. 

  163. 																							&lt;/textItem&gt;
    164. 

  164. 																						&lt;/contents&gt;
    165. 

  165. 																					&lt;/listColumnBody&gt;
    166. 

  166. 																				&lt;/listColumn&gt;
    167. 

  167. 																			&lt;/listColumns&gt;
    168. 

  168. 																			<xsl:choose>
    169. 

  169.                                                                                 <xsl:when test="/root/env/param[@name='sort']!='none'">
    170. 

  170. 																			&lt;listGroups&gt;
    171. 

  171.                                                                                 &lt;listGroup refDataItem=&quot;<xsl:value-of select="$di1"/>&quot;&gt;
    172. 

  172.                                                                                     &lt;sortList&gt;
    173. 

  173.                                                                                         &lt;sortItem refDataItem=&quot;<xsl:value-of select="$di1"/>&quot; sortOrder=&quot;<xsl:value-of select="/root/env/param[@name='sort']"/>&quot;/&gt;
    174. 

  174.                                                                                     &lt;/sortList&gt;
    175. 

  175.                                                                                 &lt;/listGroup&gt;
    176. 

  176. 																			&lt;/listGroups&gt;
    177. 

  177.                                                                                 </xsl:when>
    178. 

  178.                                                                                 <xsl:otherwise>
    179. 

  179. 																			&lt;listGroups&gt;
    180. 

  180. 																				&lt;listGroup refDataItem=&quot;<xsl:value-of select="$di1"/>&quot;/&gt;
    181. 

  181. 																			&lt;/listGroups&gt;
    182. 

  182.                                                                                 </xsl:otherwise>
    183. 

  183. 																			</xsl:choose>
    184. 

  184. 																		&lt;/list&gt;
    185. 

  185. 																	&lt;/contents&gt;
    186. 

  186. 																&lt;/pageBody&gt;
    187. 

  187. 															&lt;/page&gt;
    188. 

  188. 														&lt;/reportPages&gt;
    189. 

  189. 													&lt;/layout&gt;
    190. 

  190. 												&lt;/layouts&gt;
    191. 

  191. 											&lt;/report&gt;
    192. 

  192. 		</xsl:otherwise>
    193. 

  193.                             </xsl:choose>
    194. 

  194.                         </specification>
    195. 

  195.                     </xts:append>
    196. 

  196.                 </xts:sequence>
    197. 

  197.             </xsl:template>
    198. 

  198.         </xsl:stylesheet>
    199. 

  199.     </xts:block>
    200. 

  200.     <!-- call the getExternalRequest to see if the request came from the /ext entry point -->
    201. 

  201.     <xts:block id="getExternalRequest" dependency="buildSpecification" processor="XSLT" type="exec">
    202. 

  202.         <xts:logicsheet path="logicsheets/portal.xsl"/>
    203. 

  203.         <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt" xmlns:pf="http://developer.cognos.com/schemas/xts/pf" exclude-result-prefixes="pf">
    204. 

  204.             <pf:variables/>
    205. 

  205.             <xsl:template match="/">
    206. 

  206.                 <xts:sequence>
    207. 

  207.                     <xts:append>
    208. 

  208.                         <externalRequest>
    209. 

  209.                             <xts:function name="getRequestExternal" xmlns:xts="http://developer.cognos.com/schemas/xts/">
    210. 

  210.                                 <xts:param name="passport">
    211. 

  211.                                     <xsl:value-of select="$passport"/>
    212. 

  212.                                 </xts:param>
    213. 

  213.                                 <xts:param name="secureState">
    214. 

  214.                                     <xsl:value-of select="/root/header/*[local-name()='biBusHeader']/*[local-name()='CAF']/*[local-name()='secureState']"/>
    215. 

  215.                                 </xts:param>
    216. 

  216.                             </xts:function>
    217. 

  217.                         </externalRequest>
    218. 

  218.                     </xts:append>
    219. 

  219.                 </xts:sequence>
    220. 

  220.             </xsl:template>
    221. 

  221.         </xsl:stylesheet>
    222. 

  222.     </xts:block>
    223. 

  223.     <!-- depending on the output of the getExternalRequest request - sign the request -->
    224. 

  224.     <xts:block id="signSpecification" dependency="getExternalRequest" processor="XSLT" type="exec">
    225. 

  225.         <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt">
    226. 

  226.             <xsl:template match="/">
    227. 

  227.                 <xts:sequence>
    228. 

  228.                     <xts:append>
    229. 

  229.                         <signedSpec>
    230. 

  230.                             <xsl:choose>
    231. 

  231.                                 <xsl:when test="/root/getRequestExternalResponse">
    232. 

  232.                                     <xts:function name="signReportSpec" xmlns:xts="http://developer.cognos.com/schemas/xts/">
    233. 

  233.                                         <xts:param name="source">
    234. 

  234.                                             <xsl:value-of select="/root/specification"/>
    235. 

  235.                                         </xts:param>
    236. 

  236.                                     </xts:function>
    237. 

  237.                                 </xsl:when>
    238. 

  238.                                 <xsl:otherwise>
    239. 

  239.                                     <xsl:value-of select="/root/specification"/>
    240. 

  240.                                 </xsl:otherwise>
    241. 

  241.                             </xsl:choose>
    242. 

  242.                         </signedSpec>
    243. 

  243.                     </xts:append>
    244. 

  244.                 </xts:sequence>
    245. 

  245.             </xsl:template>
    246. 

  246.         </xsl:stylesheet>
    247. 

  247.     </xts:block>
    248. 

  248.     <!-- build the output we want with the signed request -->
    249. 

  249.     <xts:block id="makeRequest" dependency="signSpecification" mode="output" mimeType="text/xml" processor="XSLT" type="exec">
    250. 

  250.         <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt">
    251. 

  251.             <xsl:output method="xml" version="1.0" encoding="UTF-8"/>
    252. 

  252.             <!-- build the metadata request -->
    253. 

  253.             <xsl:template match="/">
    254. 

  254.                 <xsl:call-template name="buildSpec"/>
    255. 

  255.             </xsl:template>
    256. 

  256.             <xsl:template name="buildSpec">
    257. 

  257.                 <bus:value xsi:type="bus:specification" xmlns:bus="http://developer.cognos.com/schemas/bibus/3/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    258. 

  258.                     <xsl:value-of select="/root/signedSpec"/>
    259. 

  259.                 </bus:value>
    260. 

  260.             </xsl:template>
    261. 

  261.         </xsl:stylesheet>
    262. 

  262.     </xts:block>
    263. 

  263. </xts:morphlet>
    264.