2012-10-15 11:06:59,938 WARN  [org.pentaho.hadoop.shim.HadoopConfigurationLocator] Unable to load Hadoop Configuration from "file:///Applications/pentaho48/server/biserver-ee/pentaho-solutions/system/kettle/plugins/pentaho-big-data-plugin/hadoop-configurations/mapr". For more information enable debug logging.
2012-10-15 11:07:04,711 WARN  [org.pentaho.reporting.libraries.base.boot.PackageManager] Unresolved dependency for package: org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaModule
2012-10-15 11:07:04,743 WARN  [org.pentaho.reporting.libraries.base.boot.PackageSorter] A dependent module was not found in the list of known modules.
2012-10-15 11:08:46,168 WARN  [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
2012-10-15 11:08:46,268 WARN  [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public boolean areEquivalentTypes(java.lang.String,java.lang.String)]
2012-10-15 11:09:07,811 ERROR [mondrian.rolap.agg.AggregationManager] Property mondrian.rolap.agg.enableCacheHitCounters is obsolete; ignored.
2012-10-15 11:09:10,240 DEBUG [mondrian.rolap.RolapUtil] // Request ID: 459fd3b3-16da-11e2-a9a2-a3703d4afae8 - RUN_REPORT
 With
 Set [*NATIVE_CJ_SET] as 'Filter([*BASE_MEMBERS_Markets], Not IsEmpty ([Measures].[Quantity]))'
 Set [*SORTED_ROW_AXIS] as 'Order([*CJ_ROW_AXIS],[Markets].CurrentMember.OrderKey,BASC)'
 Set [*BASE_MEMBERS_Markets] as '[Markets].[Territory].Members'
 Set [*BASE_MEMBERS_Measures] as '{[Measures].[*FORMATTED_MEASURE_0]}'
 Set [*CJ_ROW_AXIS] as 'Generate([*NATIVE_CJ_SET], {([Markets].currentMember)})'
 Set [*CJ_COL_AXIS] as '[*NATIVE_CJ_SET]'
 Member [Measures].[*FORMATTED_MEASURE_0] as '[Measures].[Quantity]', FORMAT_STRING = '#,###', SOLVE_ORDER=400
 Select
 [*BASE_MEMBERS_Measures] on columns,
 [*SORTED_ROW_AXIS] on rows
 From [SteelWheelsSales]
2012-10-15 11:09:10,480 DEBUG [mondrian.rolap.RolapUtil] Query Plan: Axis (COLUMNS):
1(name=1, class=class mondrian.mdx.NamedSetExpr$1, type=SetType<MemberType<member=[Measures].[*FORMATTED_MEASURE_0]>>, resultStyle=ITERABLE)

Axis (ROWS):
1(name=1, class=class mondrian.mdx.NamedSetExpr$1, type=SetType<MemberType<hierarchy=[Markets]>>, resultStyle=ITERABLE)


2012-10-15 11:09:10,536 DEBUG [mondrian.mdx] 44: with set [*NATIVE_CJ_SET] as 'Filter([*BASE_MEMBERS_Markets], (NOT IsEmpty([Measures].[Quantity])))'
  set [*SORTED_ROW_AXIS] as 'Order([*CJ_ROW_AXIS], [Markets].CurrentMember.OrderKey, BASC)'
  set [*BASE_MEMBERS_Markets] as '[Markets].[Territory].Members'
  set [*BASE_MEMBERS_Measures] as '{[Measures].[*FORMATTED_MEASURE_0]}'
  set [*CJ_ROW_AXIS] as 'Generate([*NATIVE_CJ_SET], {[Markets].CurrentMember})'
  set [*CJ_COL_AXIS] as '[*NATIVE_CJ_SET]'
  member [Measures].[*FORMATTED_MEASURE_0] as '[Measures].[Quantity]', FORMAT_STRING = "#,###", SOLVE_ORDER = 400
select [*BASE_MEMBERS_Measures] ON COLUMNS,
  [*SORTED_ROW_AXIS] ON ROWS
from [SteelWheelsSales]

2012-10-15 11:09:10,720 DEBUG [mondrian.sql] 0: HighCardSqlTupleReader.readTuples [[Markets].[Territory]]: executing sql [select "CUSTOMER_W_TER"."TERRITORY" as "c0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" group by "CUSTOMER_W_TER"."TERRITORY" having NOT((sum("ORDERFACT"."QUANTITYORDERED") is null))  order by CASE WHEN "CUSTOMER_W_TER"."TERRITORY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."TERRITORY" ASC]
2012-10-15 11:09:10,851 DEBUG [mondrian.sql] 0: , exec 123 ms
2012-10-15 11:09:10,851 DEBUG [mondrian.rolap.RolapUtil] HighCardSqlTupleReader.readTuples [[Markets].[Territory]]: executing sql [select "CUSTOMER_W_TER"."TERRITORY" as "c0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" group by "CUSTOMER_W_TER"."TERRITORY" having NOT((sum("ORDERFACT"."QUANTITYORDERED") is null))  order by CASE WHEN "CUSTOMER_W_TER"."TERRITORY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."TERRITORY" ASC], exec 123 ms
2012-10-15 11:09:10,870 DEBUG [mondrian.sql] 0: , exec+fetch 148 ms, 4 rows
2012-10-15 11:09:10,871 DEBUG [mondrian.rolap.RolapUtil] HighCardSqlTupleReader.readTuples [[Markets].[Territory]]: done executing sql [select "CUSTOMER_W_TER"."TERRITORY" as "c0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" group by "CUSTOMER_W_TER"."TERRITORY" having NOT((sum("ORDERFACT"."QUANTITYORDERED") is null))  order by CASE WHEN "CUSTOMER_W_TER"."TERRITORY" IS NULL THEN 1 ELSE 0 END, "CUSTOMER_W_TER"."TERRITORY" ASC], exec+fetch 148 ms, 4 rows, ex=1, close=1, open=[]
2012-10-15 11:09:10,962 DEBUG [mondrian.sql] 1: SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "TERRITORY") from "CUSTOMER_W_TER"]
2012-10-15 11:09:10,981 DEBUG [mondrian.sql] 1: , exec 12 ms
2012-10-15 11:09:10,981 DEBUG [mondrian.rolap.RolapUtil] SqlStatisticsProvider.getColumnCardinality: executing sql [select count(distinct "TERRITORY") from "CUSTOMER_W_TER"], exec 12 ms
2012-10-15 11:09:10,997 DEBUG [mondrian.sql] 1: , exec+fetch 30 ms, 1 rows
2012-10-15 11:09:10,997 DEBUG [mondrian.rolap.RolapUtil] SqlStatisticsProvider.getColumnCardinality: done executing sql [select count(distinct "TERRITORY") from "CUSTOMER_W_TER"], exec+fetch 30 ms, 1 rows, ex=2, close=2, open=[]
2012-10-15 11:09:11,116 DEBUG [mondrian.sql] 2: Segment.load: executing sql [select "CUSTOMER_W_TER"."TERRITORY" as "c0", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" group by "CUSTOMER_W_TER"."TERRITORY"]
2012-10-15 11:09:11,297 DEBUG [mondrian.sql] 2: , exec 169 ms
2012-10-15 11:09:11,297 DEBUG [mondrian.rolap.RolapUtil] Segment.load: executing sql [select "CUSTOMER_W_TER"."TERRITORY" as "c0", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" group by "CUSTOMER_W_TER"."TERRITORY"], exec 169 ms
2012-10-15 11:09:11,335 DEBUG [mondrian.sql] 2: , exec+fetch 208 ms, 4 rows
2012-10-15 11:09:11,335 DEBUG [mondrian.rolap.RolapUtil] Segment.load: done executing sql [select "CUSTOMER_W_TER"."TERRITORY" as "c0", sum("ORDERFACT"."QUANTITYORDERED") as "m0" from "CUSTOMER_W_TER" as "CUSTOMER_W_TER", "ORDERFACT" as "ORDERFACT" where "ORDERFACT"."CUSTOMERNUMBER" = "CUSTOMER_W_TER"."CUSTOMERNUMBER" group by "CUSTOMER_W_TER"."TERRITORY"], exec+fetch 208 ms, 4 rows, ex=3, close=3, open=[]
2012-10-15 11:09:11,340 DEBUG [mondrian.mdx] 44: exec: 801 ms
2012-10-15 11:09:11,478 DEBUG [mondrian.rolap.RolapUtil] Request ID: 459fd3b3-16da-11e2-a9a2-a3703d4afae8 - RUN_REPORT ****** Started: 11:09:10 AM ****** SetupAxis: 44ms ****** GeneratedMDX: 46ms ****** ParsedMondrian: 243ms ****** ExecutedMondrian: 863ms ****** Sorted: 24ms ****** Rendered: 102ms ****** Total: 1322ms
2012-10-15 11:10:40,667 DEBUG [mondrian.mdx] 102: with set [*NATIVE_CJ_SET] as 'Filter([*BASE_MEMBERS_Markets], (NOT IsEmpty([Measures].[Quantity])))'
  set [*SORTED_ROW_AXIS] as 'Order([*CJ_ROW_AXIS], [Markets].CurrentMember.OrderKey, BASC)'
  set [*BASE_MEMBERS_Markets] as '[Markets].[Territory].Members'
  set [*BASE_MEMBERS_Measures] as '{[Measures].[*FORMATTED_MEASURE_0]}'
  set [*CJ_ROW_AXIS] as 'Generate([*NATIVE_CJ_SET], {[Markets].CurrentMember})'
  set [*CJ_COL_AXIS] as '[*NATIVE_CJ_SET]'
  member [Measures].[*FORMATTED_MEASURE_0] as '[Measures].[Quantity]', FORMAT_STRING = "#,###", SOLVE_ORDER = 400
select [*BASE_MEMBERS_Measures] ON COLUMNS,
  [*SORTED_ROW_AXIS] ON ROWS
from [SteelWheelsSales]

2012-10-15 11:10:40,675 DEBUG [mondrian.mdx] 102: exec: 8 ms