GlobalCube
/
analytics


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200
							<!-- 
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; }

			.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_divTestSuite = document.getElementById( "testSuite" );
				
				for( var i = 0; i < v_divTestSuite.children.length; ++i )
				{
					var v_divTest = v_divTestSuite.children[i];
					var v_sText = v_divTest.children[0].innerText;
					var v_xmlResult = v_oSQLParser.F_TransformToXML( v_sText, v_divTest.type );

					var v_divFormatted = document.createElement( "div" );
					v_divFormatted.className = "formatted";

//					v_divFormatted.innerHTML = v_oSQLParser.F_TransformToHTML( v_xmlResult );
					v_divFormatted.innerHTML = v_oSQLParser.F_TransformBlockToHTML( v_xmlResult );

					if( v_divTest.type == "MDX" )
						v_divFormatted.onclick = 
							function() { G_QanPrettyPrint.F_OnClick(event.srcElement, null, "MDX"); };
					else
						v_divFormatted.onclick = 
							function() { G_QanPrettyPrint.F_OnClick(event.srcElement); };
					
					
					v_divTest.appendChild( v_divFormatted ); 

					var v_divResult = document.createElement( "div" );
					v_divResult.className = "result";
					v_divResult.innerText = v_xmlResult.xml;
					v_divTest.appendChild( v_divResult ); 
					
				}
			}
		
		 </script>

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

		<div class="test">
			<div class="input">Select A from T where a=b and b=c and c=d</div>
		</div>	


		<div class="test" type="MDX">
			<div class="input" >
				WITH MEMBER [ZQ1AUTCTR].[COG_OQP_INT_t1] AS '1', SOLVE_ORDER = 65535, MEMBER_CAPTION = '' MEMBER [ZQ1AUTCTR].[COG_OQP_INT_t2] AS '1', SOLVE_ORDER = 65535, MEMBER_CAPTION = '' MEMBER [ZQ1AUTCTR].[COG_OQP_INT_t3] AS '1', SOLVE_ORDER = 65535, MEMBER_CAPTION = '' MEMBER [ZQ1AUTCTR].[COG_OQP_INT_umg1] AS '([ZQ1AUTCTR].[All])', SOLVE_ORDER = 4, MEMBER_CAPTION = 'Aggregate(Country)' MEMBER [ZQ1AUTCTR].[COG_OQP_INT_umg2] AS '([ZQ1AUTCTR].[All])', SOLVE_ORDER = 4, MEMBER_CAPTION = 'Aggregate(Country (All))' SELECT {[Measures].[ZQ1AUTCOS]} DIMENSION PROPERTIES PARENT_LEVEL, CHILDREN_CARDINALITY ON AXIS(0), 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 ON AXIS(1) FROM [$ZQ1AUTC01]
			</div>
		</div>	

		<div class="test" type="MDX">
			<div class="input" >
				SELECT	{[Measures].[ZQ1AUTCOS]} DIMENSION PROPERTIES PARENT_LEVEL,	CHILDREN_CARDINALITY ON AXIS(0),
						[ZQ1AUTCNT].[LEVEL01].MEMBERS DIMENSION PROPERTIES PARENT_LEVEL, CHILDREN_CARDINALITY ON AXIS(1)
				FROM [$ZQ1AUTC01]
			</div>
		</div>	

		<div class="test">
			<div class="input">Select (T1.C)as "D""C" from T join (Select 4 from D3) T1 on T1.A = T.C</div>
		</div>	

		<div class="test">
			<div class="input">Select T.A as V, "A"+T.B as "AA""CC", T1.C as "D" from T join (Select 4 from D3) T1 on T1.A = T.C</div>
		</div>	

		<div class="test">
			<div class="input">Select T.*, "A"+T.B, T1.C as "D" from T join (Select 4 from D3) T1 on T1.A = T.C</div>
		</div>	

		<div class="test">
			<div class="input">Select (A from B) from T where A=1</div>
		</div>	

		<div class="test">
			<div class="input">
				with Time_dimension6 as (select TIME_DIMENSION.DAY_KEY, TIME_DIMENSION.DAY_DATE, TIME_DIMENSION.MONTH_KEY, TIME_DIMENSION.CURRENT_MONTH, TIME_DIMENSION.QUARTER_KEY, TIME_DIMENSION.CURRENT_QUARTER, TIME_DIMENSION.CURRENT_YEAR, TIME_DIMENSION.DAY_OF_WEEK, TIME_DIMENSION.DAY_OF_MONTH, TIME_DIMENSION.DAYS_IN_MONTH, TIME_DIMENSION.DAY_OF_YEAR, TIME_DIMENSION.WEEK_OF_MONTH, TIME_DIMENSION.WEEK_OF_QUARTER, TIME_DIMENSION.WEEK_OF_YEAR, TIME_DIMENSION.WEEKDAY_EN as WEEKDAY, TIME_DIMENSION.MONTH_EN as MONTH1 from gosales...TIME_DIMENSION), Sales__model_ as (select (((extract(year from Order_header8.ORDER_DATE) * 10000) + (extract(month from Order_header8.ORDER_DATE) * 100)) + extract(day from Order_header8.ORDER_DATE)) as Day_key__order_date_, (Order_details7.QUANTITY * Order_details7.UNIT_SALE_PRICE) as Revenue from gosales...ORDER_DETAILS Order_details7, gosales...ORDER_HEADER Order_header8 where (Order_header8.ORDER_NUMBER = Order_details7.ORDER_NUMBER) ) select cast(Time_dimension9.CURRENT_YEAR as character (4)) as Yearkey, XSUM(Sales__model_.Revenue for cast(Time_dimension9.CURRENT_YEAR as character (4)) ) as Revenue from Time_dimension6 Time_dimension9, Sales__model_ where (Time_dimension9.DAY_KEY = Sales__model_.Day_key__order_date_) group by cast(Time_dimension9.CURRENT_YEAR as character (4))
			</div>
		</div>	

		<div class="test">
			<div class="input">
				select distinct 
					PRODUCTLINE.PRODUCTLINE  as  PRODUCTLINE
				from 
					GOSALES_ORACLE..GOSALES.PRODUCTLINE PRODUCTLINE
       		</div>
		</div>	
		<div class="test">
			<div class="input">
				select distinct 
					PRODUCTLINE.PRODUCTLINE  as  PRODUCTLINE,
					PRODUCTTYPE.PRODUCTTYPE  as  PRODUCTTYPE
				from 
					GOSALES_ORACLE..GOSALES.PRODUCTLINE PRODUCTLINE,
					GOSALES_ORACLE..GOSALES.PRODUCTTYPE PRODUCTTYPE
				where 
					(PRODUCTLINE.PRODUCTLINECODE = PRODUCTTYPE.PRODUCTLINECODE)
				order by 
					PRODUCTLINE asc
       		</div>
		</div>	
		
		
		<div class="test">
			<div class="input">
				select
				"Product_line13"."PRODUCT_LINE_CODE" AS "memberUniqueName2",
				min("Product_line13"."PRODUCT_LINE")AS "Product_line",
				sum("coguda10"."QUANTITY" * "coguda10"."UNIT_SALE_PRICE")AS "Revenue" 
				from
				( 
				select
				"PRODUCT_LINE"."PRODUCT_LINE_CODE" AS "PRODUCT_LINE_CODE",
				min("PRODUCT_LINE"."PRODUCT_LINE_EN")AS "PRODUCT_LINE" 
				from
				"PRODUCT_LINE" 
				group by
				"PRODUCT_LINE"."PRODUCT_LINE_CODE"
				)"Product_line13",
				"ORDER_DETAILS" "coguda10",
				"ORDER_HEADER" "coguda11",
				( 
				select
				"PRODUCT"."PRODUCT_NUMBER" AS "PRODUCT_NUMBER",
				min("PRODUCT"."PRODUCT_TYPE_CODE")AS "PRODUCT_TYPE_CODE" 
				from
				"PRODUCT" 
				group by
				"PRODUCT"."PRODUCT_NUMBER"
				)"Product15",
				( 
				select
				"PRODUCT_TYPE"."PRODUCT_TYPE_CODE" AS "PRODUCT_TYPE_CODE",
				min("PRODUCT_TYPE"."PRODUCT_LINE_CODE")AS "PRODUCT_LINE_CODE" 
				from
				"PRODUCT_TYPE" 
				group by
				"PRODUCT_TYPE"."PRODUCT_TYPE_CODE"
				)"Product_type16" 
				where
				"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" 
				group by
				"Product_line13"."PRODUCT_LINE_CODE"		
       		</div>
		</div>	
		
	</div>	
	
	
		<script><!--
		G_HAL.F_Include( "../../hal/D_XmlError.js" );
		// --></script>
		<script><!--
			G_HAL.F_WriteHtml();
		--></script>

</body>
</html>