GlobalCube
/
analytics


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373
							<!-- 
Licensed Materials - Property of IBM 
BI and PM: QFW 
© Copyright IBM Corp. 2005, 2014
US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 
-->
<html xmlns:v="urn:schemas-microsoft-com:vml">
<head>
		<meta name=vs_targetSchema content="http://schemas.microsoft.com/intellisense/ie5">
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
		<meta name="Copyright" content="Copyright IBM Corp. 2005, 2014" />		

		<link rel="stylesheet" type="text/css" href="../QFLogFormatting.css"/>


		<style>
			.test { border: black 1px solid;  color: black; margin: 5px; font-size: 100%; background-color: white; }
			.input { padding-left: 10px; }
			.result { padding-left: 10px; color: darkblue; }
			.log { padding-left: 10px; color: darkgreen; }

			.formatted i { background-color: white; FONT-WEIGHT: normal;  FONT-STYLE: normal }
			.formatted b { background-color: cyan; FONT-WEIGHT: normal; FONT-STYLE: normal }

		</style>


		<script> G_HALOptions = {"isApplication": true, "path": "../../"}; </script>
		<!--script src="../../hal/hal.js"></script>
		<script src="../../cchl/cchl.js"></script-->

		<script src="C_QanParser.js" > </script>
		<script src="G_QanPrettyPrint.js" > </script>
		
		<script> 
			function testApplyTransformations()
			{
				var v_oSQLParser = new C_QanParser();
				
				var v_oDate; 
				
				var v_divTestSuite = document.getElementById( "testSuite" );
				
				for( var i = 0; i < v_divTestSuite.children.length; ++i )
				{
					var v_divTest = v_divTestSuite.children[i];
					if( !v_divTest.children[0] )
						continue;
						
					v_oDate = new Date();
					var v_iTime = v_oDate.getTime();
					
					var v_sText = v_divTest.children[0].innerText;
					var v_sRootRule = ( v_divTest.root )? v_divTest.root: "expr"; 
					var v_sLang = ( v_divTest.type )? v_divTest.type: "SQL"; 
					var v_xmlResult = v_oSQLParser.F_TransformBlockToXML( v_sText, v_sRootRule, v_sLang );

					v_oDate = new Date();
					var v_iTimeAfterParse = v_oDate.getTime();
					
					var v_divFormatted = document.createElement( "div" );
					v_divFormatted.className = "formatted";

					v_divFormatted.innerHTML = v_oSQLParser.F_TransformBlockToHTML( v_xmlResult );

					v_oDate = new Date();
					var v_iTimeAfterFormat = v_oDate.getTime();
										
					v_divFormatted.onclick = 
							function() { G_QanPrettyPrint.F_BlockOnClick(event.srcElement); };
					
					v_divFormatted.onmouseover = 
							function() { G_QanPrettyPrint.F_BlockOnMouseOver(event.srcElement); };
					
					v_divFormatted.onmouseout = 
							function() { G_QanPrettyPrint.F_BlockOnMouseOut(event.srcElement); };
					
					
					v_divTest.appendChild( v_divFormatted ); 

					var v_divTime = document.createElement( "div" );
					v_divTime.style.backgroundColor = "#FFDDFF";
					v_divTest.appendChild( v_divTime );
					v_divTime.innerHTML = "Parse: " + (v_iTimeAfterParse-v_iTime) + 
											"ms;  Tokens: " + v_oSQLParser.m_reTokens.length + 
											";  Misses/Token: " + v_oSQLParser.m_iMisses/v_oSQLParser.m_reTokens.length + 
											";  Parse/Token: " + (v_iTimeAfterParse-v_iTime)/v_oSQLParser.m_reTokens.length + 
											"ms;  Format: " + (v_iTimeAfterFormat-v_iTimeAfterParse) + "ms"; 


					var v_divResult = document.createElement( "div" );
					v_divResult.className = "result";
					v_divResult.innerText = (v_xmlResult.xml)? v_xmlResult.xml: v_xmlResult;
					v_divTest.appendChild( v_divResult ); 
	
	
					if( v_oSQLParser.m_logDoc )
					{
						var v_divLog = document.createElement( "div" );
						v_divLog.className = "log";
						v_divLog.innerText = v_oSQLParser.m_logDoc.xml;
						v_divTest.appendChild( v_divLog ); 
										
					}					

					
				}
			}
		
		 </script>

</head>
<body style="OVERFLOW: auto; WIDTH: 100%" onload="testApplyTransformations();" >
	<div id="testSuite">

		<div class="test"  type="MDX" root="axisDef">
			<div class="input">
				[ZQ1AUTCTR].[COG_OQP_INT_t3]
			 </div>
		</div>	

		<div class="test" type="MDX" root="axisDef">
			<div class="input">
				[ZQ1AUTCTR].[COG_OQP_INT_umg2]
				DIMENSION PROPERTIES PARENT_LEVEL, CHILDREN_CARDINALITY
			 </div>
		</div>	

		<div class="test" type="MDX" root="expr">
			<div class="input">
				union( [ZQ1AUTCTR].[COG_OQP_INT_t1], [ZQ1AUTCTR].[COG_OQP_INT_t1], ALL )
			</div>
		</div>	

		<div class="test" type="MDX" root="expr">
			<div class="input">
				{ [ZQ1AUTCTR].[LEVEL01].MEMBERS, [].[] }
			</div>
		</div>	

		<div class="test" type="MDX" root="expr">
			<div class="input">
				[ZQ1AUTCTR].[LEVEL01].MEMBERS
			</div>
		</div>	

		<div class="test" type="MDX" root="expr">
			<div class="input">
				union( [ZQ1AUTCTR].[COG_OQP_INT_t1], [ZQ1AUTCTR].[COG_OQP_INT_t1] )
			</div>
		</div>	

		<div class="test" type="MDX" root="expr">
			<div class="input">
				UNION(UNION(UNION(UNION(UNION(UNION([ZQ1AUTCTR].[LEVEL01].MEMBERS, 
				{([ZQ1AUTCTR].[COG_OQP_INT_t1])}, ALL), {[ZQ1AUTCTR].[COG_OQP_INT_umg1]}, ALL), 
				{([ZQ1AUTCTR].[COG_OQP_INT_t2])}, ALL), [ZQ1AUTCTR].[LEVEL00].MEMBERS, ALL), 
				{([ZQ1AUTCTR].[COG_OQP_INT_t3])}, ALL), {[ZQ1AUTCTR].[COG_OQP_INT_umg2]}, ALL)
			 </div>
		</div>	

		<div class="test" type="MDX" root="axisDef">
			<div class="input">
				UNION(UNION(UNION(UNION(UNION(UNION([ZQ1AUTCTR].[LEVEL01].MEMBERS, 
				{([ZQ1AUTCTR].[COG_OQP_INT_t1])}, ALL), {[ZQ1AUTCTR].[COG_OQP_INT_umg1]}, ALL), 
				{([ZQ1AUTCTR].[COG_OQP_INT_t2])}, ALL), [ZQ1AUTCTR].[LEVEL00].MEMBERS, ALL), 
				{([ZQ1AUTCTR].[COG_OQP_INT_t3])}, ALL), {[ZQ1AUTCTR].[COG_OQP_INT_umg2]}, ALL)
				DIMENSION PROPERTIES PARENT_LEVEL, CHILDREN_CARDINALITY
			 </div>
		</div>	

		<div class="test" root="expr">
			<div class="input">2 * 4  </div>
		</div>	
		<div class="test" root="expr">
			<div class="input">f(2)  </div>
		</div>	

<!--		<div class="test">
			<div class="input"> cast( T.A as integer(1) ) </div>
		</div>	

		<div class="test" root="fromList">
			<div class="input"> D24 full outer join D23 on ((D24.sc2 = D23.sc) and (D24.sc5 = D23.sc2))  full outer join D25 on ((((((((D24.sc = D25.sc) and (coalesce(D24.sc2,D23.sc) = D25.sc2)) and (D24.sc3 = D25.sc3)) and (D24.sc4 = D25.sc4)) and (coalesce(D24.sc5,D23.sc2) = D25.sc5)) and (D24.sc6 = D25.sc6)) and (D24.sc7 = D25.sc7)) and (D24.sc10 = D25.sc10))  full outer join D26 on ((((((((coalesce(D24.sc,D25.sc) = D26.sc) and (coalesce(D24.sc2,D23.sc,D25.sc2) = D26.sc2)) and (coalesce(D24.sc3,D25.sc3) = D26.sc3)) and (coalesce(D24.sc4,D25.sc4) = D26.sc4)) and (coalesce(D24.sc5,D23.sc2,D25.sc5) = D26.sc5)) and (coalesce(D24.sc6,D25.sc6) = D26.sc6)) and (coalesce(D24.sc7,D25.sc7) = D26.sc7)) and (coalesce(D24.sc10,D25.sc10) = D26.sc10)) </div>
		</div>	


		<div class="test" root="expr">
			<div class="input">RSUM(1 local) </div>
		</div>	

		<div class="test" root="expr">
			<div class="input"> 2 * 4 / 5 * 5 </div>
		</div>	

		<div class="test" root="expr">
			<div class="input">RSUM(1 order by Country38.COUNTRY_CODE ) </div>
		</div>	

		<div class="test" root="expr">
			<div class="input">RSUM(1 order by Country38.COUNTRY_CODE asc,Product45.PRODUCT_NUMBER asc local) </div>
		</div>	

		<div class="test" root="expr">
			<div class="input">RSUM(1 at Country38.COUNTRY_CODE,Product45.PRODUCT_NUMBER) </div>
		</div>	

		<div class="test" root="expr">
			<div class="input">RSUM(1 at Country38.COUNTRY_CODE,Product45.PRODUCT_NUMBER,Sales_staff46.SALES_STAFF_CODE,Sales_branch.SALES_BRANCH_CODE,Time_dimension47.DAY_KEY,Country42.COUNTRY_CODE,Sales_territory43.SALES_TERRITORY_CODE,Sales_territory43.SALES_TERRITORY_CODE for Country38.COUNTRY_CODE,Product45.PRODUCT_NUMBER,Sales_staff46.SALES_STAFF_CODE,Sales_branch.SALES_BRANCH_CODE,Time_dimension47.DAY_KEY,Country42.COUNTRY_CODE,Sales_territory43.SALES_TERRITORY_CODE order by Country38.COUNTRY_CODE asc,Product45.PRODUCT_NUMBER asc,Sales_staff46.SALES_STAFF_CODE asc,Sales_branch.SALES_BRANCH_CODE asc,Time_dimension47.DAY_KEY asc,Country42.COUNTRY_CODE asc,Sales_territory43.SALES_TERRITORY_CODE asc,Sales_territory43.SALES_TERRITORY_CODE asc local) </div>
		</div>	

		<div class="test" root="fromList">
			<div class="input"> "DD"."DDD"."CCCC" T inner join "AAAAA" T1 left outer join T3 on T3.A = T.B on T1.A = T2.B </div>
		</div>	

		<div class="test" root="fromList">
			<div class="input"> T inner join T1 on T1.A = T2.B left outer join T3 on T3.A = T.B </div>
		</div>	

		<div class="test" root="fromList">
			<div class="input"> T inner join T1 on T1.A = T2.B</div>
		</div>	

		<div class="test" root="fromList">
			<div class="input"> T, T1, T23 </div>
		</div>	

		<div class="test" root="fromList">
			<div class="input"> "GOSALES"."DB"."T" </div>
		</div>	

		<div class="test" root="fromList">
			<div class="input"> T </div>
		</div>	

		<div class="test">
			<div class="input"> A LIKE '%AAA%' </div>
		</div>	

		<div class="test">
			<div class="input"> '%AAA%' </div>
		</div>	

		<div class="test">
			<div class="input"> A like '%AAA%' escape '&'</div>
		</div>	

		<div class="test">
			<div class="input"> A between 2 and 4 </div>
		</div>	

		<div class="test">
			<div class="input"> A between 2 and 4 + 1 and B + 3 = 1</div>
		</div>	

		<div class="test">
			<div class="input">1 * 2 + 1 * 3</div>
		</div>	

		<div class="test">
			<div class="input">A * B + C1 * D</div>
		</div>	

	
		<div class="test">
			<div class="input"> 1 + - A </div>
		</div>	

		<div class="test">
			<div class="input"> - A </div>
		</div>	

		<div class="test">
			<div class="input"> "coguda11"."ORDER_NUMBER" = "coguda10"."ORDER_NUMBER" and "Product_line13"."PRODUCT_LINE_CODE" = "Product_type16"."PRODUCT_LINE_CODE" and "Product_type16"."PRODUCT_TYPE_CODE" = "Product15"."PRODUCT_TYPE_CODE" and "Product15"."PRODUCT_NUMBER" = "coguda10"."PRODUCT_NUMBER" </div>
		</div>	

		<div class="test">
			<div class="input"> T.A = 1 and B = 4 </div>
		</div>	

		<div class="test">
			<div class="input"> cast( T.A as integer(1) ) </div>
		</div>	

		<div class="test">
			<div class="input"> T.A </div>
		</div>	

		<div class="test">
			<div class="input"> xsum( exp(3/4) for a )  </div>
		</div>	

		<div class="test">
			<div class="input"> xsum( 1 for a )  </div>
		</div>	

		<div class="test">
			<div class="input"> count( distinct A )  </div>
		</div>	

		<div class="test">
			<div class="input"> count( ALL b )  </div>
		</div>	

		<div class="test">
			<div class="input"> exp( 1, a + 2 )  </div>
		</div>	

		<div class="test">
			<div class="input"> exp( 1 )  </div>
		</div>	

		<div class="test">
			<div class="input"> current_time()  </div>
		</div>	

		<div class="test">
			<div class="input"> CASE 1 WHEN 1 THEN 2 WHEN 3 THEN 4 ELSE 8 END </div>
		</div>	

		<div class="test">
			<div class="input"> CASE  WHEN A=1 THEN 2 WHEN B=3 THEN 4  END </div>
		</div>	

		<div class="test">
			<div class="input"> CASE 1 WHEN 1 THEN 2 END </div>
		</div>	

		<div class="test">
			<div class="input"> + 1</div>
		</div>	

		<div class="test">
			<div class="input">(A) + 1</div>
		</div>	

		<div class="test">
			<div class="input">A + 1</div>
		</div>	

		<div class="test">
			<div class="input">( ( 1 ) )</div>
		</div>	

		<div class="test">
			<div class="input">( 1 )</div>
		</div>	


		<div class="test">
			<div class="input">A</div>
		</div>	

		<div class="test">
			<div class="input">1</div>
		</div>	
-->
		
	</div>	
	
	
		<script><!--
		G_HAL.F_Include( "../../hal/D_XmlError.js" );
		// --></script>
		<script><!--
			G_HAL.F_WriteHtml();
		--></script>

</body>
</html>