Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- log4j: Threshold ="null".
- log4j: Retreiving an instance of org.apache.log4j.Logger.
- log4j: Setting [org.apache] additivity to [true].
- log4j: Level value for org.apache is [INFO].
- log4j: org.apache level set to INFO
- log4j: Retreiving an instance of org.apache.log4j.Logger.
- log4j: Setting [mondrian.gui] additivity to [true].
- log4j: Level value for mondrian.gui is [DEBUG].
- log4j: mondrian.gui level set to DEBUG
- log4j: Retreiving an instance of org.apache.log4j.Logger.
- log4j: Setting [mondrian] additivity to [true].
- log4j: Level value for mondrian is [DEBUG].
- log4j: mondrian level set to DEBUG
- log4j: Class name: [org.apache.log4j.ConsoleAppender]
- log4j: Setting property [target] to [System.out].
- log4j: Setting property [threshold] to [DEBUG].
- log4j: Parsing layout of class: "org.apache.log4j.PatternLayout"
- log4j: Setting property [conversionPattern] to [%d{ABSOLUTE} %-5p [%c{1}] %m%n].
- log4j: Adding appender named [CONSOLE] to category [root].
- log4j: Class name: [org.apache.log4j.RollingFileAppender]
- log4j: Setting property [file] to [/home/pds/.schemaWorkbench/workbench.log].
- log4j: Setting property [append] to [false].
- log4j: Setting property [maxFileSize] to [500KB].
- log4j: Setting property [maxBackupIndex] to [1].
- log4j: Parsing layout of class: "org.apache.log4j.PatternLayout"
- log4j: Setting property [conversionPattern] to [%d %-5p [%c] %m%n].
- log4j: setFile called: /home/pds/.schemaWorkbench/workbench.log, false
- log4j: setFile ended
- log4j: Adding appender named [FILE] to category [root].
- 16:26:36,087 WARN [MondrianProperties] mondrian.properties can't be found under '/home/pds/work/enki-nl/runMDXOlap4j/.' or classloader
- 16:26:36,087 INFO [MondrianProperties] Mondrian: loaded 0 system properties
- 16:26:36,125 INFO [RolapUtil] Mondrian: JDBC driver nl.cwi.monetdb.jdbc.MonetDriver loaded successfully
- 16:26:36,125 INFO [RolapUtil] Mondrian: JDBC driver sun.jdbc.odbc.JdbcOdbcDriver loaded successfully
- 16:26:36,125 WARN [RolapUtil] Mondrian: Warning: JDBC driver org.hsqldb.jdbcDriver not found
- 16:26:36,125 WARN [RolapUtil] Mondrian: Warning: JDBC driver oracle.jdbc.OracleDriver not found
- 16:26:36,125 INFO [RolapUtil] Mondrian: JDBC driver com.mysql.jdbc.Driver loaded successfully
- 16:26:36,626 INFO [DefaultFileReplicator] Using "/tmp/vfs_cache" as temporary files store.
- 16:26:36,763 DEBUG [RolapSchema] RolapSchema.load: content:
- <?xml version="1.0"?>
- <Schema name="FoodMart">
- <!--
- == $Id: //open/mondrian-release/3.2/demo/FoodMart.xml#2 $
- == This software is subject to the terms of the Eclipse Public License v1.0
- == Agreement, available at the following URL:
- == http://www.eclipse.org/legal/epl-v10.html.
- == Copyright (C) 2000-2002 Kana Software, Inc.
- == Copyright (C) 2002-2009 Julian Hyde and others
- == All Rights Reserved.
- == You must accept the terms of that agreement to use this software.
- -->
- <!-- Shared dimensions -->
- <Dimension name="Store">
- <Hierarchy hasAll="true" primaryKey="store_id">
- <Table name="store"/>
- <Level name="Store Country" column="store_country" uniqueMembers="true"/>
- <Level name="Store State" column="store_state" uniqueMembers="true"/>
- <Level name="Store City" column="store_city" uniqueMembers="false"/>
- <Level name="Store Name" column="store_name" uniqueMembers="true">
- <Property name="Store Type" column="store_type"/>
- <Property name="Store Manager" column="store_manager"/>
- <Property name="Store Sqft" column="store_sqft" type="Numeric"/>
- <Property name="Grocery Sqft" column="grocery_sqft" type="Numeric"/>
- <Property name="Frozen Sqft" column="frozen_sqft" type="Numeric"/>
- <Property name="Meat Sqft" column="meat_sqft" type="Numeric"/>
- <Property name="Has coffee bar" column="coffee_bar" type="Boolean"/>
- <Property name="Street address" column="store_street_address" type="String"/>
- </Level>
- </Hierarchy>
- </Dimension>
- <Dimension name="Store Size in SQFT">
- <Hierarchy hasAll="true" primaryKey="store_id">
- <Table name="store"/>
- <Level name="Store Sqft" column="store_sqft" type="Numeric" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Store Type">
- <Hierarchy hasAll="true" primaryKey="store_id">
- <Table name="store"/>
- <Level name="Store Type" column="store_type" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Time" type="TimeDimension">
- <Hierarchy hasAll="false" primaryKey="time_id">
- <Table name="time_by_day"/>
- <Level name="Year" column="the_year" type="Numeric" uniqueMembers="true"
- levelType="TimeYears"/>
- <Level name="Quarter" column="quarter" uniqueMembers="false"
- levelType="TimeQuarters"/>
- <Level name="Month" column="month_of_year" uniqueMembers="false" type="Numeric"
- levelType="TimeMonths"/>
- </Hierarchy>
- <Hierarchy hasAll="true" name="Weekly" primaryKey="time_id">
- <Table name="time_by_day"/>
- <Level name="Year" column="the_year" type="Numeric" uniqueMembers="true"
- levelType="TimeYears"/>
- <Level name="Week" column="week_of_year" type="Numeric" uniqueMembers="false"
- levelType="TimeWeeks"/>
- <Level name="Day" column="day_of_month" uniqueMembers="false" type="Numeric"
- levelType="TimeDays"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Product">
- <Hierarchy hasAll="true" primaryKey="product_id" primaryKeyTable="product">
- <Join leftKey="product_class_id" rightKey="product_class_id">
- <Table name="product"/>
- <Table name="product_class"/>
- </Join>
- <!--
- <Query>
- <SQL dialect="generic">
- SELECT *
- FROM "product", "product_class"
- WHERE "product"."product_class_id" = "product_class"."product_class_id"
- </SQL>
- </Query>
- <Level name="Product Family" column="product_family" uniqueMembers="true"/>
- <Level name="Product Department" column="product_department" uniqueMembers="false"/>
- <Level name="Product Category" column="product_category" uniqueMembers="false"/>
- <Level name="Product Subcategory" column="product_subcategory" uniqueMembers="false"/>
- <Level name="Brand Name" column="brand_name" uniqueMembers="false"/>
- <Level name="Product Name" column="product_name" uniqueMembers="true"/>
- -->
- <Level name="Product Family" table="product_class" column="product_family"
- uniqueMembers="true"/>
- <Level name="Product Department" table="product_class" column="product_department"
- uniqueMembers="false"/>
- <Level name="Product Category" table="product_class" column="product_category"
- uniqueMembers="false"/>
- <Level name="Product Subcategory" table="product_class" column="product_subcategory"
- uniqueMembers="false"/>
- <Level name="Brand Name" table="product" column="brand_name" uniqueMembers="false"/>
- <Level name="Product Name" table="product" column="product_name"
- uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Warehouse">
- <Hierarchy hasAll="true" primaryKey="warehouse_id">
- <Table name="warehouse"/>
- <Level name="Country" column="warehouse_country" uniqueMembers="true"/>
- <Level name="State Province" column="warehouse_state_province"
- uniqueMembers="true"/>
- <Level name="City" column="warehouse_city" uniqueMembers="false"/>
- <Level name="Warehouse Name" column="warehouse_name" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <!-- Sales -->
- <Cube name="Sales" defaultMeasure="Unit Sales">
- <Table name="sales_fact_1997">
- <!--
- <AggExclude name="agg_l_03_sales_fact_1997" />
- <AggExclude name="agg_ll_01_sales_fact_1997" />
- <AggExclude name="agg_pl_01_sales_fact_1997" />
- <AggExclude name="agg_l_05_sales_fact_1997" />
- -->
- <AggExclude name="agg_c_special_sales_fact_1997" />
- <!--
- <AggExclude name="agg_c_14_sales_fact_1997" />
- -->
- <AggExclude name="agg_lc_100_sales_fact_1997" />
- <AggExclude name="agg_lc_10_sales_fact_1997" />
- <AggExclude name="agg_pc_10_sales_fact_1997" />
- <AggName name="agg_c_special_sales_fact_1997">
- <AggFactCount column="FACT_COUNT"/>
- <AggIgnoreColumn column="foo"/>
- <AggIgnoreColumn column="bar"/>
- <AggForeignKey factColumn="product_id" aggColumn="PRODUCT_ID" />
- <AggForeignKey factColumn="customer_id" aggColumn="CUSTOMER_ID" />
- <AggForeignKey factColumn="promotion_id" aggColumn="PROMOTION_ID" />
- <AggForeignKey factColumn="store_id" aggColumn="STORE_ID" />
- <!--
- <AggMeasure name="[Measures].[Avg Unit Sales]" column="UNIT_SALES_AVG"/>
- -->
- <AggMeasure name="[Measures].[Unit Sales]" column="UNIT_SALES_SUM" />
- <AggMeasure name="[Measures].[Store Cost]" column="STORE_COST_SUM" />
- <AggMeasure name="[Measures].[Store Sales]" column="STORE_SALES_SUM" />
- <AggLevel name="[Time].[Year]" column="TIME_YEAR" />
- <AggLevel name="[Time].[Quarter]" column="TIME_QUARTER" />
- <AggLevel name="[Time].[Month]" column="TIME_MONTH" />
- </AggName>
- </Table>
- <DimensionUsage name="Store" source="Store" foreignKey="store_id"/>
- <DimensionUsage name="Store Size in SQFT" source="Store Size in SQFT"
- foreignKey="store_id"/>
- <DimensionUsage name="Store Type" source="Store Type" foreignKey="store_id"/>
- <DimensionUsage name="Time" source="Time" foreignKey="time_id"/>
- <DimensionUsage name="Product" source="Product" foreignKey="product_id"/>
- <Dimension name="Promotion Media" foreignKey="promotion_id">
- <Hierarchy hasAll="true" allMemberName="All Media" primaryKey="promotion_id" defaultMember="All Media">
- <Table name="promotion"/>
- <Level name="Media Type" column="media_type" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Promotions" foreignKey="promotion_id">
- <Hierarchy hasAll="true" allMemberName="All Promotions" primaryKey="promotion_id" defaultMember="[All Promotions]">
- <Table name="promotion"/>
- <Level name="Promotion Name" column="promotion_name" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Customers" foreignKey="customer_id">
- <Hierarchy hasAll="true" allMemberName="All Customers" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Country" column="country" uniqueMembers="true"/>
- <Level name="State Province" column="state_province" uniqueMembers="true"/>
- <Level name="City" column="city" uniqueMembers="false"/>
- <Level name="Name" column="customer_id" type="Numeric" uniqueMembers="true">
- <NameExpression>
- <SQL dialect="oracle">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="hsqldb">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="access">
- fname + ' ' + lname
- </SQL>
- <SQL dialect="postgres">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="mysql">
- CONCAT(`customer`.`fname`, ' ', `customer`.`lname`)
- </SQL>
- <SQL dialect="mssql">
- fname + ' ' + lname
- </SQL>
- <SQL dialect="derby">
- "customer"."fullname"
- </SQL>
- <SQL dialect="db2">
- CONCAT(CONCAT("customer"."fname", ' '), "customer"."lname")
- </SQL>
- <SQL dialect="luciddb">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="neoview">
- "customer"."fullname"
- </SQL>
- <SQL dialect="teradata">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="generic">
- fullname
- </SQL>
- </NameExpression>
- <OrdinalExpression>
- <SQL dialect="oracle">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="hsqldb">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="access">
- fname + ' ' + lname
- </SQL>
- <SQL dialect="postgres">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="mysql">
- CONCAT(`customer`.`fname`, ' ', `customer`.`lname`)
- </SQL>
- <SQL dialect="mssql">
- fname + ' ' + lname
- </SQL>
- <SQL dialect="neoview">
- "customer"."fullname"
- </SQL>
- <SQL dialect="derby">
- "customer"."fullname"
- </SQL>
- <SQL dialect="db2">
- CONCAT(CONCAT("customer"."fname", ' '), "customer"."lname")
- </SQL>
- <SQL dialect="luciddb">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="generic">
- fullname
- </SQL>
- </OrdinalExpression>
- <Property name="Gender" column="gender"/>
- <Property name="Marital Status" column="marital_status"/>
- <Property name="Education" column="education"/>
- <Property name="Yearly Income" column="yearly_income"/>
- </Level>
- </Hierarchy>
- </Dimension>
- <Dimension name="Education Level" foreignKey="customer_id">
- <Hierarchy hasAll="true" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Education Level" column="education" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Gender" foreignKey="customer_id">
- <Hierarchy hasAll="true" allMemberName="All Gender" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Gender" column="gender" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Marital Status" foreignKey="customer_id">
- <Hierarchy hasAll="true" allMemberName="All Marital Status" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Marital Status" column="marital_status" uniqueMembers="true" approxRowCount="111"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Yearly Income" foreignKey="customer_id">
- <Hierarchy hasAll="true" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Yearly Income" column="yearly_income" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Measure name="Unit Sales" column="unit_sales" aggregator="sum"
- formatString="Standard"/>
- <Measure name="Store Cost" column="store_cost" aggregator="sum"
- formatString="#,###.00"/>
- <Measure name="Store Sales" column="store_sales" aggregator="sum"
- formatString="#,###.00"/>
- <Measure name="Sales Count" column="product_id" aggregator="count"
- formatString="#,###"/>
- <Measure name="Customer Count" column="customer_id"
- aggregator="distinct-count" formatString="#,###"/>
- <Measure name="Promotion Sales" aggregator="sum" formatString="#,###.00">
- <MeasureExpression>
- <SQL dialect="access">
- Iif("sales_fact_1997"."promotion_id" = 0, 0, "sales_fact_1997"."store_sales")
- </SQL>
- <SQL dialect="oracle">
- (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)
- </SQL>
- <SQL dialect="hsqldb">
- (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)
- </SQL>
- <SQL dialect="postgres">
- (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)
- </SQL>
- <SQL dialect="mysql">
- (case when `sales_fact_1997`.`promotion_id` = 0 then 0 else `sales_fact_1997`.`store_sales` end)
- </SQL>
- <!-- Workaround the fact that Infobright does not have a CASE operator.
- The simpler expression gives wrong results, so some tests are
- disabled. -->
- <SQL dialect="neoview">
- (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)
- </SQL>
- <SQL dialect="infobright">
- `sales_fact_1997`.`store_sales`
- </SQL>
- <SQL dialect="derby">
- (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)
- </SQL>
- <SQL dialect="luciddb">
- (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)
- </SQL>
- <SQL dialect="db2">
- (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)
- </SQL>
- <SQL dialect="generic">
- (case when sales_fact_1997.promotion_id = 0 then 0 else sales_fact_1997.store_sales end)
- </SQL>
- </MeasureExpression>
- </Measure>
- <CalculatedMember
- name="Profit"
- dimension="Measures">
- <Formula>[Measures].[Store Sales] - [Measures].[Store Cost]</Formula>
- <CalculatedMemberProperty name="FORMAT_STRING" value="$#,##0.00"/>
- </CalculatedMember>
- <CalculatedMember
- name="Profit last Period"
- dimension="Measures"
- formula="COALESCEEMPTY((Measures.[Profit], [Time].[Time].PREVMEMBER), Measures.[Profit])"
- visible="false">
- <CalculatedMemberProperty name="FORMAT_STRING" value="$#,##0.00"/>
- <CalculatedMemberProperty name="MEMBER_ORDINAL" value="18"/>
- </CalculatedMember>
- <CalculatedMember
- name="Profit Growth"
- dimension="Measures"
- formula="([Measures].[Profit] - [Measures].[Profit last Period]) / [Measures].[Profit last Period]"
- visible="true"
- caption="Gewinn-Wachstum">
- <CalculatedMemberProperty name="FORMAT_STRING" value="0.0%"/>
- </CalculatedMember>
- </Cube>
- <Cube name="Warehouse">
- <Table name="inventory_fact_1997"/>
- <DimensionUsage name="Store" source="Store" foreignKey="store_id"/>
- <DimensionUsage name="Store Size in SQFT" source="Store Size in SQFT"
- foreignKey="store_id"/>
- <DimensionUsage name="Store Type" source="Store Type" foreignKey="store_id"/>
- <DimensionUsage name="Time" source="Time" foreignKey="time_id"/>
- <DimensionUsage name="Product" source="Product" foreignKey="product_id"/>
- <DimensionUsage name="Warehouse" source="Warehouse" foreignKey="warehouse_id"/>
- <Measure name="Store Invoice" column="store_invoice" aggregator="sum"/>
- <Measure name="Supply Time" column="supply_time" aggregator="sum"/>
- <Measure name="Warehouse Cost" column="warehouse_cost" aggregator="sum"/>
- <Measure name="Warehouse Sales" column="warehouse_sales" aggregator="sum"/>
- <Measure name="Units Shipped" column="units_shipped" aggregator="sum" formatString="#.0"/>
- <Measure name="Units Ordered" column="units_ordered" aggregator="sum" formatString="#.0"/>
- <Measure name="Warehouse Profit" aggregator="sum">
- <MeasureExpression>
- <SQL dialect="mysql">
- `warehouse_sales` - `inventory_fact_1997`.`warehouse_cost`
- </SQL>
- <SQL dialect="infobright">
- `warehouse_sales` - `inventory_fact_1997`.`warehouse_cost`
- </SQL>
- <SQL dialect="generic">
- "warehouse_sales" - "inventory_fact_1997"."warehouse_cost"
- </SQL>
- </MeasureExpression>
- </Measure>
- <CalculatedMember
- name="Average Warehouse Sale"
- dimension="Measures">
- <Formula>[Measures].[Warehouse Sales] / [Measures].[Warehouse Cost]</Formula>
- <CalculatedMemberProperty name="FORMAT_STRING" value="$#,##0.00"/>
- </CalculatedMember>
- <NamedSet name="Top Sellers">
- <Formula>TopCount([Warehouse].[Warehouse Name].MEMBERS, 5, [Measures].[Warehouse Sales])</Formula>
- </NamedSet>
- </Cube>
- <!-- Test a cube based upon a single table. -->
- <Cube name="Store">
- <Table name="store"/>
- <!-- We could have used the shared dimension "Store Type", but we
- want to test private dimensions without primary key. -->
- <Dimension name="Store Type">
- <Hierarchy hasAll="true">
- <Level name="Store Type" column="store_type" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <!-- We don't have to specify primary key or foreign key since the shared
- dimension "Store" has the same underlying table as the cube. -->
- <DimensionUsage name="Store" source="Store"/>
- <Dimension name="Has coffee bar">
- <Hierarchy hasAll="true">
- <Level name="Has coffee bar" column="coffee_bar" uniqueMembers="true"
- type="Boolean"/>
- </Hierarchy>
- </Dimension>
- <Measure name="Store Sqft" column="store_sqft" aggregator="sum"
- formatString="#,###"/>
- <Measure name="Grocery Sqft" column="grocery_sqft" aggregator="sum"
- formatString="#,###"/>
- </Cube>
- <Cube name="HR">
- <Table name="salary"/>
- <!-- Use private "Time" dimension because key is different than public
- "Time" dimension. -->
- <Dimension name="Time" type="TimeDimension" foreignKey="pay_date">
- <Hierarchy hasAll="false" primaryKey="the_date">
- <Table name="time_by_day"/>
- <Level name="Year" column="the_year" type="Numeric" uniqueMembers="true"
- levelType="TimeYears"/>
- <Level name="Quarter" column="quarter" uniqueMembers="false"
- levelType="TimeQuarters"/>
- <!-- Use the_month as source for the name, so members look like
- [Time].[1997].[Q1].[Jan] rather than [Time].[1997].[Q1].[1]. -->
- <Level name="Month" column="month_of_year" nameColumn="the_month"
- uniqueMembers="false" type="Numeric" levelType="TimeMonths"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Store" foreignKey="employee_id" >
- <Hierarchy hasAll="true" primaryKey="employee_id"
- primaryKeyTable="employee">
- <Join leftKey="store_id" rightKey="store_id">
- <Table name="employee"/>
- <Table name="store"/>
- </Join>
- <Level name="Store Country" table="store" column="store_country"
- uniqueMembers="true"/>
- <Level name="Store State" table="store" column="store_state"
- uniqueMembers="true"/>
- <Level name="Store City" table="store" column="store_city"
- uniqueMembers="false"/>
- <Level name="Store Name" table="store" column="store_name"
- uniqueMembers="true">
- <Property name="Store Type" column="store_type"/>
- <Property name="Store Manager" column="store_manager"/>
- <Property name="Store Sqft" column="store_sqft" type="Numeric"/>
- <Property name="Grocery Sqft" column="grocery_sqft" type="Numeric"/>
- <Property name="Frozen Sqft" column="frozen_sqft" type="Numeric"/>
- <Property name="Meat Sqft" column="meat_sqft" type="Numeric"/>
- <Property name="Has coffee bar" column="coffee_bar" type="Boolean"/>
- <Property name="Street address" column="store_street_address"
- type="String"/>
- </Level>
- </Hierarchy>
- </Dimension>
- <Dimension name="Pay Type" foreignKey="employee_id">
- <Hierarchy hasAll="true" primaryKey="employee_id"
- primaryKeyTable="employee">
- <Join leftKey="position_id" rightKey="position_id">
- <Table name="employee"/>
- <Table name="position"/>
- </Join>
- <Level name="Pay Type" table="position" column="pay_type"
- uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Store Type" foreignKey="employee_id">
- <Hierarchy hasAll="true" primaryKeyTable="employee" primaryKey="employee_id">
- <Join leftKey="store_id" rightKey="store_id">
- <Table name="employee"/>
- <Table name="store"/>
- </Join>
- <Level name="Store Type" table="store" column="store_type"
- uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Position" foreignKey="employee_id">
- <Hierarchy hasAll="true" allMemberName="All Position"
- primaryKey="employee_id">
- <Table name="employee"/>
- <Level name="Management Role" uniqueMembers="true"
- column="management_role"/>
- <Level name="Position Title" uniqueMembers="false"
- column="position_title" ordinalColumn="position_id"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Department" foreignKey="department_id">
- <Hierarchy hasAll="true" primaryKey="department_id">
- <Table name="department"/>
- <Level name="Department Description" type="Numeric" uniqueMembers="true"
- column="department_id"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Employees" foreignKey="employee_id">
- <Hierarchy hasAll="true" allMemberName="All Employees"
- primaryKey="employee_id">
- <Table name="employee"/>
- <Level name="Employee Id" type="Numeric" uniqueMembers="true"
- column="employee_id" parentColumn="supervisor_id"
- nameColumn="full_name" nullParentValue="0">
- <Closure parentColumn="supervisor_id" childColumn="employee_id">
- <Table name="employee_closure"/>
- </Closure>
- <Property name="Marital Status" column="marital_status"/>
- <Property name="Position Title" column="position_title"/>
- <Property name="Gender" column="gender"/>
- <Property name="Salary" column="salary"/>
- <Property name="Education Level" column="education_level"/>
- <Property name="Management Role" column="management_role"/>
- </Level>
- </Hierarchy>
- </Dimension>
- <Measure name="Org Salary" column="salary_paid" aggregator="sum"
- formatString="Currency"/>
- <Measure name="Count" column="employee_id" aggregator="count"
- formatString="#,#"/>
- <Measure name="Number of Employees" column="employee_id"
- aggregator="distinct-count" formatString="#,#"/>
- <CalculatedMember name="Employee Salary" dimension="Measures"
- formatString="Currency"
- formula="([Employees].currentmember.datamember, [Measures].[Org Salary])"/>
- <CalculatedMember name="Avg Salary" dimension="Measures"
- formatString="Currency"
- formula="[Measures].[Org Salary]/[Measures].[Number of Employees]"/>
- </Cube>
- <!-- Cube with one ragged hierarchy (otherwise the same as the "Sales"
- cube). -->
- <Cube name="Sales Ragged">
- <Table name="sales_fact_1997">
- <AggExclude name="agg_pc_10_sales_fact_1997"/>
- <AggExclude name="agg_lc_10_sales_fact_1997"/>
- </Table>
- <Dimension name="Store" foreignKey="store_id">
- <Hierarchy hasAll="true" primaryKey="store_id">
- <Table name="store_ragged"/>
- <Level name="Store Country" column="store_country" uniqueMembers="true"
- hideMemberIf="Never"/>
- <Level name="Store State" column="store_state" uniqueMembers="true"
- hideMemberIf="IfParentsName"/>
- <Level name="Store City" column="store_city" uniqueMembers="false"
- hideMemberIf="IfBlankName"/>
- <Level name="Store Name" column="store_name" uniqueMembers="true"
- hideMemberIf="Never">
- <Property name="Store Type" column="store_type"/>
- <Property name="Store Manager" column="store_manager"/>
- <Property name="Store Sqft" column="store_sqft" type="Numeric"/>
- <Property name="Grocery Sqft" column="grocery_sqft" type="Numeric"/>
- <Property name="Frozen Sqft" column="frozen_sqft" type="Numeric"/>
- <Property name="Meat Sqft" column="meat_sqft" type="Numeric"/>
- <Property name="Has coffee bar" column="coffee_bar" type="Boolean"/>
- <Property name="Street address" column="store_street_address" type="String"/>
- </Level>
- </Hierarchy>
- </Dimension>
- <Dimension name="Geography" foreignKey="store_id">
- <Hierarchy hasAll="true" primaryKey="store_id">
- <Table name="store_ragged"/>
- <Level name="Country" column="store_country" uniqueMembers="true"
- hideMemberIf="Never"/>
- <Level name="State" column="store_state" uniqueMembers="true"
- hideMemberIf="IfParentsName"/>
- <Level name="City" column="store_city" uniqueMembers="false"
- hideMemberIf="IfBlankName"/>
- </Hierarchy>
- </Dimension>
- <DimensionUsage name="Store Size in SQFT" source="Store Size in SQFT"
- foreignKey="store_id"/>
- <DimensionUsage name="Store Type" source="Store Type" foreignKey="store_id"/>
- <DimensionUsage name="Time" source="Time" foreignKey="time_id"/>
- <DimensionUsage name="Product" source="Product" foreignKey="product_id"/>
- <Dimension name="Promotion Media" foreignKey="promotion_id">
- <Hierarchy hasAll="true" allMemberName="All Media" primaryKey="promotion_id">
- <Table name="promotion"/>
- <Level name="Media Type" column="media_type" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Promotions" foreignKey="promotion_id">
- <Hierarchy hasAll="true" allMemberName="All Promotions" primaryKey="promotion_id">
- <Table name="promotion"/>
- <Level name="Promotion Name" column="promotion_name" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Customers" foreignKey="customer_id">
- <Hierarchy hasAll="true" allMemberName="All Customers" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Country" column="country" uniqueMembers="true"/>
- <Level name="State Province" column="state_province" uniqueMembers="true"/>
- <Level name="City" column="city" uniqueMembers="false"/>
- <Level name="Name" uniqueMembers="true">
- <KeyExpression>
- <SQL dialect="oracle">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="hsqldb">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="access">
- fname + ' ' + lname
- </SQL>
- <SQL dialect="postgres">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="mysql">
- CONCAT(`customer`.`fname`, ' ', `customer`.`lname`)
- </SQL>
- <SQL dialect="mssql">
- fname + ' ' + lname
- </SQL>
- <SQL dialect="derby">
- "customer"."fullname"
- </SQL>
- <SQL dialect="db2">
- CONCAT(CONCAT("customer"."fname", ' '), "customer"."lname")
- </SQL>
- <SQL dialect="luciddb">
- "fname" || ' ' || "lname"
- </SQL>
- <SQL dialect="neoview">
- "customer"."fullname"
- </SQL>
- <SQL dialect="generic">
- fullname
- </SQL>
- </KeyExpression>
- <Property name="Gender" column="gender"/>
- <Property name="Marital Status" column="marital_status"/>
- <Property name="Education" column="education"/>
- <Property name="Yearly Income" column="yearly_income"/>
- </Level>
- </Hierarchy>
- </Dimension>
- <Dimension name="Education Level" foreignKey="customer_id">
- <Hierarchy hasAll="true" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Education Level" column="education" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Gender" foreignKey="customer_id">
- <Hierarchy hasAll="true" allMemberName="All Gender" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Gender" column="gender" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Marital Status" foreignKey="customer_id">
- <Hierarchy hasAll="true" allMemberName="All Marital Status" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Marital Status" column="marital_status" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Dimension name="Yearly Income" foreignKey="customer_id">
- <Hierarchy hasAll="true" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Yearly Income" column="yearly_income" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Measure name="Unit Sales" column="unit_sales" aggregator="sum"
- formatString="Standard"/>
- <Measure name="Store Cost" column="store_cost" aggregator="sum"
- formatString="#,###.00"/>
- <Measure name="Store Sales" column="store_sales" aggregator="sum"
- formatString="#,###.00"/>
- <Measure name="Sales Count" column="product_id" aggregator="count"
- formatString="#,###"/>
- <Measure name="Customer Count" column="customer_id" aggregator="distinct-count"
- formatString="#,###"/>
- </Cube>
- <!-- a simpler version of "Sales" (with MEMBER_ORDINAL-properties) -->
- <Cube name="Sales 2">
- <Table name="sales_fact_1997"/>
- <DimensionUsage name="Time" source="Time" foreignKey="time_id"/>
- <DimensionUsage name="Product" source="Product" foreignKey="product_id"/>
- <Dimension name="Gender" foreignKey="customer_id">
- <Hierarchy hasAll="true" allMemberName="All Gender" primaryKey="customer_id">
- <Table name="customer"/>
- <Level name="Gender" column="gender" uniqueMembers="true"/>
- </Hierarchy>
- </Dimension>
- <Measure name="Sales Count" column="product_id" aggregator="count" formatString="#,###">
- <CalculatedMemberProperty name="MEMBER_ORDINAL" value="1"/>
- </Measure>
- <Measure name="Unit Sales" column="unit_sales" aggregator="sum" formatString="Standard">
- <CalculatedMemberProperty name="MEMBER_ORDINAL" value="2"/>
- </Measure>
- <Measure name="Store Sales" column="store_sales" aggregator="sum" formatString="#,###.00">
- <CalculatedMemberProperty name="MEMBER_ORDINAL" value="3"/>
- </Measure>
- <Measure name="Store Cost" column="store_cost" aggregator="sum" formatString="#,###.00">
- <CalculatedMemberProperty name="MEMBER_ORDINAL" value="6"/>
- </Measure>
- <Measure name="Customer Count" column="customer_id" aggregator="distinct-count" formatString="#,###">
- <CalculatedMemberProperty name="MEMBER_ORDINAL" value="7"/>
- </Measure>
- <CalculatedMember
- name="Profit"
- dimension="Measures">
- <Formula>[Measures].[Store Sales] - [Measures].[Store Cost]</Formula>
- <CalculatedMemberProperty name="FORMAT_STRING" value="$#,##0.00"/>
- <CalculatedMemberProperty name="MEMBER_ORDINAL" value="4"/>
- </CalculatedMember>
- <CalculatedMember
- name="Profit last Period"
- dimension="Measures"
- formula="COALESCEEMPTY((Measures.[Profit], [Time].[Time].PREVMEMBER), Measures.[Profit])"
- visible="false">
- <CalculatedMemberProperty name="MEMBER_ORDINAL" value="5"/>
- </CalculatedMember>
- </Cube>
- <VirtualCube name="Warehouse and Sales" defaultMeasure="Store Sales">
- <VirtualCubeDimension cubeName="Sales" name="Customers"/>
- <VirtualCubeDimension cubeName="Sales" name="Education Level"/>
- <VirtualCubeDimension cubeName="Sales" name="Gender"/>
- <VirtualCubeDimension cubeName="Sales" name="Marital Status"/>
- <VirtualCubeDimension name="Product"/>
- <VirtualCubeDimension cubeName="Sales" name="Promotion Media"/>
- <VirtualCubeDimension cubeName="Sales" name="Promotions"/>
- <VirtualCubeDimension name="Store"/>
- <VirtualCubeDimension name="Time"/>
- <VirtualCubeDimension cubeName="Sales" name="Yearly Income"/>
- <VirtualCubeDimension cubeName="Warehouse" name="Warehouse"/>
- <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Sales Count]"/>
- <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Store Cost]"/>
- <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Store Sales]"/>
- <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Unit Sales]"/>
- <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Profit]"/>
- <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Profit Growth]"/>
- <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Store Invoice]"/>
- <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Supply Time]"/>
- <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Units Ordered]"/>
- <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Units Shipped]"/>
- <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Warehouse Cost]"/>
- <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Warehouse Profit]"/>
- <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Warehouse Sales]"/>
- <VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Average Warehouse Sale]"/>
- <!--
- <VirtualCubeMeasure cubeName="Sales" name="[Measures].[Store Sales Net]"/>
- -->
- <CalculatedMember name="Profit Per Unit Shipped" dimension="Measures">
- <Formula>[Measures].[Profit] / [Measures].[Units Shipped]</Formula>
- </CalculatedMember>
- </VirtualCube>
- <!-- A California manager can only see customers and stores in California.
- They cannot drill down on Gender. -->
- <Role name="California manager">
- <SchemaGrant access="none">
- <CubeGrant cube="Sales" access="all">
- <HierarchyGrant hierarchy="[Store]" access="custom"
- topLevel="[Store].[Store Country]">
- <MemberGrant member="[Store].[USA].[CA]" access="all"/>
- <MemberGrant member="[Store].[USA].[CA].[Los Angeles]" access="none"/>
- </HierarchyGrant>
- <HierarchyGrant hierarchy="[Customers]" access="custom"
- topLevel="[Customers].[State Province]" bottomLevel="[Customers].[City]">
- <MemberGrant member="[Customers].[USA].[CA]" access="all"/>
- <MemberGrant member="[Customers].[USA].[CA].[Los Angeles]" access="none"/>
- </HierarchyGrant>
- <HierarchyGrant hierarchy="[Gender]" access="none"/>
- </CubeGrant>
- </SchemaGrant>
- </Role>
- <Role name="No HR Cube">
- <SchemaGrant access="all">
- <CubeGrant cube="HR" access="none"/>
- </SchemaGrant>
- </Role>
- </Schema>
- 16:26:36,942 DEBUG [RolapSchema] RolapSchema.load: dump xmlschema
- Schema
- name = "FoodMart"
- description = null
- measuresCaption = null
- defaultRole = null
- annotations: null
- parameters: array of 0 values
- dimensions: array of 6 values
- dimensions[0]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = null
- highCardinality = "false"
- name = "Store"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "store_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "store"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 4 values
- levels[0]: Level
- approxRowCount = null
- name = "Store Country"
- visible = "true"
- table = null
- column = "store_country"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "Store State"
- visible = "true"
- table = null
- column = "store_state"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "Store City"
- visible = "true"
- table = null
- column = "store_city"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[3]: Level
- approxRowCount = null
- name = "Store Name"
- visible = "true"
- table = null
- column = "store_name"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 8 values
- properties[0]: Property
- name = "Store Type"
- column = "store_type"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[1]: Property
- name = "Store Manager"
- column = "store_manager"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[2]: Property
- name = "Store Sqft"
- column = "store_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[3]: Property
- name = "Grocery Sqft"
- column = "grocery_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[4]: Property
- name = "Frozen Sqft"
- column = "frozen_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[5]: Property
- name = "Meat Sqft"
- column = "meat_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[6]: Property
- name = "Has coffee bar"
- column = "coffee_bar"
- type = "Boolean"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[7]: Property
- name = "Street address"
- column = "store_street_address"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- memberReaderParameters: array of 0 values
- dimensions[1]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = null
- highCardinality = "false"
- name = "Store Size in SQFT"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "store_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "store"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Store Sqft"
- visible = "true"
- table = null
- column = "store_sqft"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Numeric"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[2]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = null
- highCardinality = "false"
- name = "Store Type"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "store_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "store"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Store Type"
- visible = "true"
- table = null
- column = "store_type"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[3]: Dimension
- type = "TimeDimension"
- usagePrefix = null
- visible = "true"
- foreignKey = null
- highCardinality = "false"
- name = "Time"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 2 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "false"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "time_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "time_by_day"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 3 values
- levels[0]: Level
- approxRowCount = null
- name = "Year"
- visible = "true"
- table = null
- column = "the_year"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Numeric"
- internalType = null
- uniqueMembers = "true"
- levelType = "TimeYears"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "Quarter"
- visible = "true"
- table = null
- column = "quarter"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "TimeQuarters"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "Month"
- visible = "true"
- table = null
- column = "month_of_year"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Numeric"
- internalType = null
- uniqueMembers = "false"
- levelType = "TimeMonths"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- hierarchies[1]: Hierarchy
- name = "Weekly"
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "time_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "time_by_day"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 3 values
- levels[0]: Level
- approxRowCount = null
- name = "Year"
- visible = "true"
- table = null
- column = "the_year"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Numeric"
- internalType = null
- uniqueMembers = "true"
- levelType = "TimeYears"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "Week"
- visible = "true"
- table = null
- column = "week_of_year"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Numeric"
- internalType = null
- uniqueMembers = "false"
- levelType = "TimeWeeks"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "Day"
- visible = "true"
- table = null
- column = "day_of_month"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Numeric"
- internalType = null
- uniqueMembers = "false"
- levelType = "TimeDays"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[4]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = null
- highCardinality = "false"
- name = "Product"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "product_id"
- primaryKeyTable = "product"
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Join
- leftAlias = null
- leftKey = "product_class_id"
- rightAlias = null
- rightKey = "product_class_id"
- left: Table
- name = "product"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- right: Table
- name = "product_class"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 6 values
- levels[0]: Level
- approxRowCount = null
- name = "Product Family"
- visible = "true"
- table = "product_class"
- column = "product_family"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "Product Department"
- visible = "true"
- table = "product_class"
- column = "product_department"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "Product Category"
- visible = "true"
- table = "product_class"
- column = "product_category"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[3]: Level
- approxRowCount = null
- name = "Product Subcategory"
- visible = "true"
- table = "product_class"
- column = "product_subcategory"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[4]: Level
- approxRowCount = null
- name = "Brand Name"
- visible = "true"
- table = "product"
- column = "brand_name"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[5]: Level
- approxRowCount = null
- name = "Product Name"
- visible = "true"
- table = "product"
- column = "product_name"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[5]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = null
- highCardinality = "false"
- name = "Warehouse"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "warehouse_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "warehouse"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 4 values
- levels[0]: Level
- approxRowCount = null
- name = "Country"
- visible = "true"
- table = null
- column = "warehouse_country"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "State Province"
- visible = "true"
- table = null
- column = "warehouse_state_province"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "City"
- visible = "true"
- table = null
- column = "warehouse_city"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[3]: Level
- approxRowCount = null
- name = "Warehouse Name"
- visible = "true"
- table = null
- column = "warehouse_name"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- cubes: array of 6 values
- cubes[0]: Cube
- name = "Sales"
- caption = null
- visible = "true"
- description = null
- defaultMeasure = "Unit Sales"
- cache = "true"
- enabled = "true"
- annotations: null
- fact: Table
- name = "sales_fact_1997"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 4 values
- aggExcludes[0]: AggExclude
- pattern = null
- name = "agg_c_special_sales_fact_1997"
- ignorecase = "true"
- aggExcludes[1]: AggExclude
- pattern = null
- name = "agg_lc_100_sales_fact_1997"
- ignorecase = "true"
- aggExcludes[2]: AggExclude
- pattern = null
- name = "agg_lc_10_sales_fact_1997"
- ignorecase = "true"
- aggExcludes[3]: AggExclude
- pattern = null
- name = "agg_pc_10_sales_fact_1997"
- ignorecase = "true"
- aggTables: array of 1 values
- aggTables[0]: AggName
- name = "agg_c_special_sales_fact_1997"
- approxRowCount = null
- ignorecase = "true"
- factcount: AggFactCount
- column = "FACT_COUNT"
- ignoreColumns: array of 2 values
- ignoreColumns[0]: AggIgnoreColumn
- column = "foo"
- ignoreColumns[1]: AggIgnoreColumn
- column = "bar"
- foreignKeys: array of 4 values
- foreignKeys[0]: AggForeignKey
- factColumn = "product_id"
- aggColumn = "PRODUCT_ID"
- foreignKeys[1]: AggForeignKey
- factColumn = "customer_id"
- aggColumn = "CUSTOMER_ID"
- foreignKeys[2]: AggForeignKey
- factColumn = "promotion_id"
- aggColumn = "PROMOTION_ID"
- foreignKeys[3]: AggForeignKey
- factColumn = "store_id"
- aggColumn = "STORE_ID"
- measures: array of 3 values
- measures[0]: AggMeasure
- column = "UNIT_SALES_SUM"
- name = "[Measures].[Unit Sales]"
- measures[1]: AggMeasure
- column = "STORE_COST_SUM"
- name = "[Measures].[Store Cost]"
- measures[2]: AggMeasure
- column = "STORE_SALES_SUM"
- name = "[Measures].[Store Sales]"
- levels: array of 3 values
- levels[0]: AggLevel
- column = "TIME_YEAR"
- name = "[Time].[Year]"
- levels[1]: AggLevel
- column = "TIME_QUARTER"
- name = "[Time].[Quarter]"
- levels[2]: AggLevel
- column = "TIME_MONTH"
- name = "[Time].[Month]"
- tableHints: array of 0 values
- dimensions: array of 12 values
- dimensions[0]: DimensionUsage
- source = "Store"
- level = null
- usagePrefix = null
- name = "Store"
- caption = null
- visible = "true"
- description = null
- foreignKey = "store_id"
- highCardinality = "false"
- annotations: null
- dimensions[1]: DimensionUsage
- source = "Store Size in SQFT"
- level = null
- usagePrefix = null
- name = "Store Size in SQFT"
- caption = null
- visible = "true"
- description = null
- foreignKey = "store_id"
- highCardinality = "false"
- annotations: null
- dimensions[2]: DimensionUsage
- source = "Store Type"
- level = null
- usagePrefix = null
- name = "Store Type"
- caption = null
- visible = "true"
- description = null
- foreignKey = "store_id"
- highCardinality = "false"
- annotations: null
- dimensions[3]: DimensionUsage
- source = "Time"
- level = null
- usagePrefix = null
- name = "Time"
- caption = null
- visible = "true"
- description = null
- foreignKey = "time_id"
- highCardinality = "false"
- annotations: null
- dimensions[4]: DimensionUsage
- source = "Product"
- level = null
- usagePrefix = null
- name = "Product"
- caption = null
- visible = "true"
- description = null
- foreignKey = "product_id"
- highCardinality = "false"
- annotations: null
- dimensions[5]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "promotion_id"
- highCardinality = "false"
- name = "Promotion Media"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Media"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "promotion_id"
- primaryKeyTable = null
- defaultMember = "All Media"
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "promotion"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Media Type"
- visible = "true"
- table = null
- column = "media_type"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[6]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "promotion_id"
- highCardinality = "false"
- name = "Promotions"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Promotions"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "promotion_id"
- primaryKeyTable = null
- defaultMember = "[All Promotions]"
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "promotion"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Promotion Name"
- visible = "true"
- table = null
- column = "promotion_name"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[7]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Customers"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Customers"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 4 values
- levels[0]: Level
- approxRowCount = null
- name = "Country"
- visible = "true"
- table = null
- column = "country"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "State Province"
- visible = "true"
- table = null
- column = "state_province"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "City"
- visible = "true"
- table = null
- column = "city"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[3]: Level
- approxRowCount = null
- name = "Name"
- visible = "true"
- table = null
- column = "customer_id"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Numeric"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: NameExpression
- expressions: array of 12 values
- expressions[0]: SQL
- dialect = "oracle"
- cdata: ""fname" || ' ' || "lname""
- expressions[1]: SQL
- dialect = "hsqldb"
- cdata: ""fname" || ' ' || "lname""
- expressions[2]: SQL
- dialect = "access"
- cdata: "fname + ' ' + lname"
- expressions[3]: SQL
- dialect = "postgres"
- cdata: ""fname" || ' ' || "lname""
- expressions[4]: SQL
- dialect = "mysql"
- cdata: "CONCAT(`customer`.`fname`, ' ', `customer`.`lname`)"
- expressions[5]: SQL
- dialect = "mssql"
- cdata: "fname + ' ' + lname"
- expressions[6]: SQL
- dialect = "derby"
- cdata: ""customer"."fullname""
- expressions[7]: SQL
- dialect = "db2"
- cdata: "CONCAT(CONCAT("customer"."fname", ' '), "customer"."lname")"
- expressions[8]: SQL
- dialect = "luciddb"
- cdata: ""fname" || ' ' || "lname""
- expressions[9]: SQL
- dialect = "neoview"
- cdata: ""customer"."fullname""
- expressions[10]: SQL
- dialect = "teradata"
- cdata: ""fname" || ' ' || "lname""
- expressions[11]: SQL
- dialect = "generic"
- cdata: "fullname"
- captionExp: null
- ordinalExp: OrdinalExpression
- expressions: array of 11 values
- expressions[0]: SQL
- dialect = "oracle"
- cdata: ""fname" || ' ' || "lname""
- expressions[1]: SQL
- dialect = "hsqldb"
- cdata: ""fname" || ' ' || "lname""
- expressions[2]: SQL
- dialect = "access"
- cdata: "fname + ' ' + lname"
- expressions[3]: SQL
- dialect = "postgres"
- cdata: ""fname" || ' ' || "lname""
- expressions[4]: SQL
- dialect = "mysql"
- cdata: "CONCAT(`customer`.`fname`, ' ', `customer`.`lname`)"
- expressions[5]: SQL
- dialect = "mssql"
- cdata: "fname + ' ' + lname"
- expressions[6]: SQL
- dialect = "neoview"
- cdata: ""customer"."fullname""
- expressions[7]: SQL
- dialect = "derby"
- cdata: ""customer"."fullname""
- expressions[8]: SQL
- dialect = "db2"
- cdata: "CONCAT(CONCAT("customer"."fname", ' '), "customer"."lname")"
- expressions[9]: SQL
- dialect = "luciddb"
- cdata: ""fname" || ' ' || "lname""
- expressions[10]: SQL
- dialect = "generic"
- cdata: "fullname"
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 4 values
- properties[0]: Property
- name = "Gender"
- column = "gender"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[1]: Property
- name = "Marital Status"
- column = "marital_status"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[2]: Property
- name = "Education"
- column = "education"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[3]: Property
- name = "Yearly Income"
- column = "yearly_income"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- memberReaderParameters: array of 0 values
- dimensions[8]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Education Level"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Education Level"
- visible = "true"
- table = null
- column = "education"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[9]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Gender"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Gender"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Gender"
- visible = "true"
- table = null
- column = "gender"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[10]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Marital Status"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Marital Status"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = "111"
- name = "Marital Status"
- visible = "true"
- table = null
- column = "marital_status"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[11]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Yearly Income"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Yearly Income"
- visible = "true"
- table = null
- column = "yearly_income"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- measures: array of 6 values
- measures[0]: Measure
- name = "Unit Sales"
- column = "unit_sales"
- datatype = null
- formatString = "Standard"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[1]: Measure
- name = "Store Cost"
- column = "store_cost"
- datatype = null
- formatString = "#,###.00"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[2]: Measure
- name = "Store Sales"
- column = "store_sales"
- datatype = null
- formatString = "#,###.00"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[3]: Measure
- name = "Sales Count"
- column = "product_id"
- datatype = null
- formatString = "#,###"
- aggregator = "count"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[4]: Measure
- name = "Customer Count"
- column = "customer_id"
- datatype = null
- formatString = "#,###"
- aggregator = "distinct-count"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[5]: Measure
- name = "Promotion Sales"
- column = null
- datatype = null
- formatString = "#,###.00"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: MeasureExpression
- expressions: array of 11 values
- expressions[0]: SQL
- dialect = "access"
- cdata: "Iif("sales_fact_1997"."promotion_id" = 0, 0, "sales_fact_1997"."store_sales")"
- expressions[1]: SQL
- dialect = "oracle"
- cdata: "(case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)"
- expressions[2]: SQL
- dialect = "hsqldb"
- cdata: "(case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)"
- expressions[3]: SQL
- dialect = "postgres"
- cdata: "(case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)"
- expressions[4]: SQL
- dialect = "mysql"
- cdata: "(case when `sales_fact_1997`.`promotion_id` = 0 then 0 else `sales_fact_1997`.`store_sales` end)"
- expressions[5]: SQL
- dialect = "neoview"
- cdata: "(case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)"
- expressions[6]: SQL
- dialect = "infobright"
- cdata: "`sales_fact_1997`.`store_sales`"
- expressions[7]: SQL
- dialect = "derby"
- cdata: "(case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)"
- expressions[8]: SQL
- dialect = "luciddb"
- cdata: "(case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)"
- expressions[9]: SQL
- dialect = "db2"
- cdata: "(case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end)"
- expressions[10]: SQL
- dialect = "generic"
- cdata: "(case when sales_fact_1997.promotion_id = 0 then 0 else sales_fact_1997.store_sales end)"
- cellFormatter: null
- memberProperties: array of 0 values
- calculatedMembers: array of 3 values
- calculatedMembers[0]: CalculatedMember
- name = "Profit"
- formatString = null
- caption = null
- description = null
- formula = null
- dimension = "Measures"
- hierarchy = null
- parent = null
- visible = null
- annotations: null
- formulaElement: Formula
- cdata: "[Measures].[Store Sales] - [Measures].[Store Cost]"
- cellFormatter: null
- memberProperties: array of 1 values
- memberProperties[0]: CalculatedMemberProperty
- name = "FORMAT_STRING"
- caption = null
- description = null
- expression = null
- value = "$#,##0.00"
- calculatedMembers[1]: CalculatedMember
- name = "Profit last Period"
- formatString = null
- caption = null
- description = null
- formula = "COALESCEEMPTY((Measures.[Profit], [Time].[Time].PREVMEMBER), Measures.[Profit])"
- dimension = "Measures"
- hierarchy = null
- parent = null
- visible = "false"
- annotations: null
- formulaElement: null
- cellFormatter: null
- memberProperties: array of 2 values
- memberProperties[0]: CalculatedMemberProperty
- name = "FORMAT_STRING"
- caption = null
- description = null
- expression = null
- value = "$#,##0.00"
- memberProperties[1]: CalculatedMemberProperty
- name = "MEMBER_ORDINAL"
- caption = null
- description = null
- expression = null
- value = "18"
- calculatedMembers[2]: CalculatedMember
- name = "Profit Growth"
- formatString = null
- caption = "Gewinn-Wachstum"
- description = null
- formula = "([Measures].[Profit] - [Measures].[Profit last Period]) / [Measures].[Profit last Period]"
- dimension = "Measures"
- hierarchy = null
- parent = null
- visible = "true"
- annotations: null
- formulaElement: null
- cellFormatter: null
- memberProperties: array of 1 values
- memberProperties[0]: CalculatedMemberProperty
- name = "FORMAT_STRING"
- caption = null
- description = null
- expression = null
- value = "0.0%"
- namedSets: array of 0 values
- cubes[1]: Cube
- name = "Warehouse"
- caption = null
- visible = "true"
- description = null
- defaultMeasure = null
- cache = "true"
- enabled = "true"
- annotations: null
- fact: Table
- name = "inventory_fact_1997"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- dimensions: array of 6 values
- dimensions[0]: DimensionUsage
- source = "Store"
- level = null
- usagePrefix = null
- name = "Store"
- caption = null
- visible = "true"
- description = null
- foreignKey = "store_id"
- highCardinality = "false"
- annotations: null
- dimensions[1]: DimensionUsage
- source = "Store Size in SQFT"
- level = null
- usagePrefix = null
- name = "Store Size in SQFT"
- caption = null
- visible = "true"
- description = null
- foreignKey = "store_id"
- highCardinality = "false"
- annotations: null
- dimensions[2]: DimensionUsage
- source = "Store Type"
- level = null
- usagePrefix = null
- name = "Store Type"
- caption = null
- visible = "true"
- description = null
- foreignKey = "store_id"
- highCardinality = "false"
- annotations: null
- dimensions[3]: DimensionUsage
- source = "Time"
- level = null
- usagePrefix = null
- name = "Time"
- caption = null
- visible = "true"
- description = null
- foreignKey = "time_id"
- highCardinality = "false"
- annotations: null
- dimensions[4]: DimensionUsage
- source = "Product"
- level = null
- usagePrefix = null
- name = "Product"
- caption = null
- visible = "true"
- description = null
- foreignKey = "product_id"
- highCardinality = "false"
- annotations: null
- dimensions[5]: DimensionUsage
- source = "Warehouse"
- level = null
- usagePrefix = null
- name = "Warehouse"
- caption = null
- visible = "true"
- description = null
- foreignKey = "warehouse_id"
- highCardinality = "false"
- annotations: null
- measures: array of 7 values
- measures[0]: Measure
- name = "Store Invoice"
- column = "store_invoice"
- datatype = null
- formatString = null
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[1]: Measure
- name = "Supply Time"
- column = "supply_time"
- datatype = null
- formatString = null
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[2]: Measure
- name = "Warehouse Cost"
- column = "warehouse_cost"
- datatype = null
- formatString = null
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[3]: Measure
- name = "Warehouse Sales"
- column = "warehouse_sales"
- datatype = null
- formatString = null
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[4]: Measure
- name = "Units Shipped"
- column = "units_shipped"
- datatype = null
- formatString = "#.0"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[5]: Measure
- name = "Units Ordered"
- column = "units_ordered"
- datatype = null
- formatString = "#.0"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[6]: Measure
- name = "Warehouse Profit"
- column = null
- datatype = null
- formatString = null
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: MeasureExpression
- expressions: array of 3 values
- expressions[0]: SQL
- dialect = "mysql"
- cdata: "`warehouse_sales` - `inventory_fact_1997`.`warehouse_cost`"
- expressions[1]: SQL
- dialect = "infobright"
- cdata: "`warehouse_sales` - `inventory_fact_1997`.`warehouse_cost`"
- expressions[2]: SQL
- dialect = "generic"
- cdata: ""warehouse_sales" - "inventory_fact_1997"."warehouse_cost""
- cellFormatter: null
- memberProperties: array of 0 values
- calculatedMembers: array of 1 values
- calculatedMembers[0]: CalculatedMember
- name = "Average Warehouse Sale"
- formatString = null
- caption = null
- description = null
- formula = null
- dimension = "Measures"
- hierarchy = null
- parent = null
- visible = null
- annotations: null
- formulaElement: Formula
- cdata: "[Measures].[Warehouse Sales] / [Measures].[Warehouse Cost]"
- cellFormatter: null
- memberProperties: array of 1 values
- memberProperties[0]: CalculatedMemberProperty
- name = "FORMAT_STRING"
- caption = null
- description = null
- expression = null
- value = "$#,##0.00"
- namedSets: array of 1 values
- namedSets[0]: NamedSet
- name = "Top Sellers"
- caption = null
- description = null
- formula = null
- annotations: null
- formulaElement: Formula
- cdata: "TopCount([Warehouse].[Warehouse Name].MEMBERS, 5, [Measures].[Warehouse Sales])"
- cubes[2]: Cube
- name = "Store"
- caption = null
- visible = "true"
- description = null
- defaultMeasure = null
- cache = "true"
- enabled = "true"
- annotations: null
- fact: Table
- name = "store"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- dimensions: array of 3 values
- dimensions[0]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = null
- highCardinality = "false"
- name = "Store Type"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = null
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: null
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Store Type"
- visible = "true"
- table = null
- column = "store_type"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[1]: DimensionUsage
- source = "Store"
- level = null
- usagePrefix = null
- name = "Store"
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- annotations: null
- dimensions[2]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = null
- highCardinality = "false"
- name = "Has coffee bar"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = null
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: null
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Has coffee bar"
- visible = "true"
- table = null
- column = "coffee_bar"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Boolean"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- measures: array of 2 values
- measures[0]: Measure
- name = "Store Sqft"
- column = "store_sqft"
- datatype = null
- formatString = "#,###"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[1]: Measure
- name = "Grocery Sqft"
- column = "grocery_sqft"
- datatype = null
- formatString = "#,###"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- calculatedMembers: array of 0 values
- namedSets: array of 0 values
- cubes[3]: Cube
- name = "HR"
- caption = null
- visible = "true"
- description = null
- defaultMeasure = null
- cache = "true"
- enabled = "true"
- annotations: null
- fact: Table
- name = "salary"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- dimensions: array of 7 values
- dimensions[0]: Dimension
- type = "TimeDimension"
- usagePrefix = null
- visible = "true"
- foreignKey = "pay_date"
- highCardinality = "false"
- name = "Time"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "false"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "the_date"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "time_by_day"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 3 values
- levels[0]: Level
- approxRowCount = null
- name = "Year"
- visible = "true"
- table = null
- column = "the_year"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Numeric"
- internalType = null
- uniqueMembers = "true"
- levelType = "TimeYears"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "Quarter"
- visible = "true"
- table = null
- column = "quarter"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "TimeQuarters"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "Month"
- visible = "true"
- table = null
- column = "month_of_year"
- nameColumn = "the_month"
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Numeric"
- internalType = null
- uniqueMembers = "false"
- levelType = "TimeMonths"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[1]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "employee_id"
- highCardinality = "false"
- name = "Store"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "employee_id"
- primaryKeyTable = "employee"
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Join
- leftAlias = null
- leftKey = "store_id"
- rightAlias = null
- rightKey = "store_id"
- left: Table
- name = "employee"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- right: Table
- name = "store"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 4 values
- levels[0]: Level
- approxRowCount = null
- name = "Store Country"
- visible = "true"
- table = "store"
- column = "store_country"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "Store State"
- visible = "true"
- table = "store"
- column = "store_state"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "Store City"
- visible = "true"
- table = "store"
- column = "store_city"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[3]: Level
- approxRowCount = null
- name = "Store Name"
- visible = "true"
- table = "store"
- column = "store_name"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 8 values
- properties[0]: Property
- name = "Store Type"
- column = "store_type"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[1]: Property
- name = "Store Manager"
- column = "store_manager"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[2]: Property
- name = "Store Sqft"
- column = "store_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[3]: Property
- name = "Grocery Sqft"
- column = "grocery_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[4]: Property
- name = "Frozen Sqft"
- column = "frozen_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[5]: Property
- name = "Meat Sqft"
- column = "meat_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[6]: Property
- name = "Has coffee bar"
- column = "coffee_bar"
- type = "Boolean"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[7]: Property
- name = "Street address"
- column = "store_street_address"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- memberReaderParameters: array of 0 values
- dimensions[2]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "employee_id"
- highCardinality = "false"
- name = "Pay Type"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "employee_id"
- primaryKeyTable = "employee"
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Join
- leftAlias = null
- leftKey = "position_id"
- rightAlias = null
- rightKey = "position_id"
- left: Table
- name = "employee"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- right: Table
- name = "position"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Pay Type"
- visible = "true"
- table = "position"
- column = "pay_type"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[3]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "employee_id"
- highCardinality = "false"
- name = "Store Type"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "employee_id"
- primaryKeyTable = "employee"
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Join
- leftAlias = null
- leftKey = "store_id"
- rightAlias = null
- rightKey = "store_id"
- left: Table
- name = "employee"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- right: Table
- name = "store"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Store Type"
- visible = "true"
- table = "store"
- column = "store_type"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[4]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "employee_id"
- highCardinality = "false"
- name = "Position"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Position"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "employee_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "employee"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 2 values
- levels[0]: Level
- approxRowCount = null
- name = "Management Role"
- visible = "true"
- table = null
- column = "management_role"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "Position Title"
- visible = "true"
- table = null
- column = "position_title"
- nameColumn = null
- ordinalColumn = "position_id"
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[5]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "department_id"
- highCardinality = "false"
- name = "Department"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "department_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "department"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Department Description"
- visible = "true"
- table = null
- column = "department_id"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "Numeric"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[6]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "employee_id"
- highCardinality = "false"
- name = "Employees"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Employees"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "employee_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "employee"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Employee Id"
- visible = "true"
- table = null
- column = "employee_id"
- nameColumn = "full_name"
- ordinalColumn = null
- parentColumn = "supervisor_id"
- nullParentValue = "0"
- type = "Numeric"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: Closure
- parentColumn = "supervisor_id"
- childColumn = "employee_id"
- table: Table
- name = "employee_closure"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- properties: array of 6 values
- properties[0]: Property
- name = "Marital Status"
- column = "marital_status"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[1]: Property
- name = "Position Title"
- column = "position_title"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[2]: Property
- name = "Gender"
- column = "gender"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[3]: Property
- name = "Salary"
- column = "salary"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[4]: Property
- name = "Education Level"
- column = "education_level"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[5]: Property
- name = "Management Role"
- column = "management_role"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- memberReaderParameters: array of 0 values
- measures: array of 3 values
- measures[0]: Measure
- name = "Org Salary"
- column = "salary_paid"
- datatype = null
- formatString = "Currency"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[1]: Measure
- name = "Count"
- column = "employee_id"
- datatype = null
- formatString = "#,#"
- aggregator = "count"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[2]: Measure
- name = "Number of Employees"
- column = "employee_id"
- datatype = null
- formatString = "#,#"
- aggregator = "distinct-count"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- calculatedMembers: array of 2 values
- calculatedMembers[0]: CalculatedMember
- name = "Employee Salary"
- formatString = "Currency"
- caption = null
- description = null
- formula = "([Employees].currentmember.datamember, [Measures].[Org Salary])"
- dimension = "Measures"
- hierarchy = null
- parent = null
- visible = null
- annotations: null
- formulaElement: null
- cellFormatter: null
- memberProperties: array of 0 values
- calculatedMembers[1]: CalculatedMember
- name = "Avg Salary"
- formatString = "Currency"
- caption = null
- description = null
- formula = "[Measures].[Org Salary]/[Measures].[Number of Employees]"
- dimension = "Measures"
- hierarchy = null
- parent = null
- visible = null
- annotations: null
- formulaElement: null
- cellFormatter: null
- memberProperties: array of 0 values
- namedSets: array of 0 values
- cubes[4]: Cube
- name = "Sales Ragged"
- caption = null
- visible = "true"
- description = null
- defaultMeasure = null
- cache = "true"
- enabled = "true"
- annotations: null
- fact: Table
- name = "sales_fact_1997"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 2 values
- aggExcludes[0]: AggExclude
- pattern = null
- name = "agg_pc_10_sales_fact_1997"
- ignorecase = "true"
- aggExcludes[1]: AggExclude
- pattern = null
- name = "agg_lc_10_sales_fact_1997"
- ignorecase = "true"
- aggTables: array of 0 values
- tableHints: array of 0 values
- dimensions: array of 13 values
- dimensions[0]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "store_id"
- highCardinality = "false"
- name = "Store"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "store_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "store_ragged"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 4 values
- levels[0]: Level
- approxRowCount = null
- name = "Store Country"
- visible = "true"
- table = null
- column = "store_country"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "Store State"
- visible = "true"
- table = null
- column = "store_state"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "IfParentsName"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "Store City"
- visible = "true"
- table = null
- column = "store_city"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "IfBlankName"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[3]: Level
- approxRowCount = null
- name = "Store Name"
- visible = "true"
- table = null
- column = "store_name"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 8 values
- properties[0]: Property
- name = "Store Type"
- column = "store_type"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[1]: Property
- name = "Store Manager"
- column = "store_manager"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[2]: Property
- name = "Store Sqft"
- column = "store_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[3]: Property
- name = "Grocery Sqft"
- column = "grocery_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[4]: Property
- name = "Frozen Sqft"
- column = "frozen_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[5]: Property
- name = "Meat Sqft"
- column = "meat_sqft"
- type = "Numeric"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[6]: Property
- name = "Has coffee bar"
- column = "coffee_bar"
- type = "Boolean"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[7]: Property
- name = "Street address"
- column = "store_street_address"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- memberReaderParameters: array of 0 values
- dimensions[1]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "store_id"
- highCardinality = "false"
- name = "Geography"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "store_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "store_ragged"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 3 values
- levels[0]: Level
- approxRowCount = null
- name = "Country"
- visible = "true"
- table = null
- column = "store_country"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "State"
- visible = "true"
- table = null
- column = "store_state"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "IfParentsName"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "City"
- visible = "true"
- table = null
- column = "store_city"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "IfBlankName"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[2]: DimensionUsage
- source = "Store Size in SQFT"
- level = null
- usagePrefix = null
- name = "Store Size in SQFT"
- caption = null
- visible = "true"
- description = null
- foreignKey = "store_id"
- highCardinality = "false"
- annotations: null
- dimensions[3]: DimensionUsage
- source = "Store Type"
- level = null
- usagePrefix = null
- name = "Store Type"
- caption = null
- visible = "true"
- description = null
- foreignKey = "store_id"
- highCardinality = "false"
- annotations: null
- dimensions[4]: DimensionUsage
- source = "Time"
- level = null
- usagePrefix = null
- name = "Time"
- caption = null
- visible = "true"
- description = null
- foreignKey = "time_id"
- highCardinality = "false"
- annotations: null
- dimensions[5]: DimensionUsage
- source = "Product"
- level = null
- usagePrefix = null
- name = "Product"
- caption = null
- visible = "true"
- description = null
- foreignKey = "product_id"
- highCardinality = "false"
- annotations: null
- dimensions[6]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "promotion_id"
- highCardinality = "false"
- name = "Promotion Media"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Media"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "promotion_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "promotion"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Media Type"
- visible = "true"
- table = null
- column = "media_type"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[7]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "promotion_id"
- highCardinality = "false"
- name = "Promotions"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Promotions"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "promotion_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "promotion"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Promotion Name"
- visible = "true"
- table = null
- column = "promotion_name"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[8]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Customers"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Customers"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 4 values
- levels[0]: Level
- approxRowCount = null
- name = "Country"
- visible = "true"
- table = null
- column = "country"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[1]: Level
- approxRowCount = null
- name = "State Province"
- visible = "true"
- table = null
- column = "state_province"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[2]: Level
- approxRowCount = null
- name = "City"
- visible = "true"
- table = null
- column = "city"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "false"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- levels[3]: Level
- approxRowCount = null
- name = "Name"
- visible = "true"
- table = null
- column = null
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: KeyExpression
- expressions: array of 11 values
- expressions[0]: SQL
- dialect = "oracle"
- cdata: ""fname" || ' ' || "lname""
- expressions[1]: SQL
- dialect = "hsqldb"
- cdata: ""fname" || ' ' || "lname""
- expressions[2]: SQL
- dialect = "access"
- cdata: "fname + ' ' + lname"
- expressions[3]: SQL
- dialect = "postgres"
- cdata: ""fname" || ' ' || "lname""
- expressions[4]: SQL
- dialect = "mysql"
- cdata: "CONCAT(`customer`.`fname`, ' ', `customer`.`lname`)"
- expressions[5]: SQL
- dialect = "mssql"
- cdata: "fname + ' ' + lname"
- expressions[6]: SQL
- dialect = "derby"
- cdata: ""customer"."fullname""
- expressions[7]: SQL
- dialect = "db2"
- cdata: "CONCAT(CONCAT("customer"."fname", ' '), "customer"."lname")"
- expressions[8]: SQL
- dialect = "luciddb"
- cdata: ""fname" || ' ' || "lname""
- expressions[9]: SQL
- dialect = "neoview"
- cdata: ""customer"."fullname""
- expressions[10]: SQL
- dialect = "generic"
- cdata: "fullname"
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 4 values
- properties[0]: Property
- name = "Gender"
- column = "gender"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[1]: Property
- name = "Marital Status"
- column = "marital_status"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[2]: Property
- name = "Education"
- column = "education"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- properties[3]: Property
- name = "Yearly Income"
- column = "yearly_income"
- type = "String"
- formatter = null
- caption = null
- description = null
- dependsOnLevelValue = null
- propertyFormatter: null
- memberReaderParameters: array of 0 values
- dimensions[9]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Education Level"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Education Level"
- visible = "true"
- table = null
- column = "education"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[10]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Gender"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Gender"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Gender"
- visible = "true"
- table = null
- column = "gender"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[11]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Marital Status"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Marital Status"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Marital Status"
- visible = "true"
- table = null
- column = "marital_status"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- dimensions[12]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Yearly Income"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = null
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Yearly Income"
- visible = "true"
- table = null
- column = "yearly_income"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- measures: array of 5 values
- measures[0]: Measure
- name = "Unit Sales"
- column = "unit_sales"
- datatype = null
- formatString = "Standard"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[1]: Measure
- name = "Store Cost"
- column = "store_cost"
- datatype = null
- formatString = "#,###.00"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[2]: Measure
- name = "Store Sales"
- column = "store_sales"
- datatype = null
- formatString = "#,###.00"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[3]: Measure
- name = "Sales Count"
- column = "product_id"
- datatype = null
- formatString = "#,###"
- aggregator = "count"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- measures[4]: Measure
- name = "Customer Count"
- column = "customer_id"
- datatype = null
- formatString = "#,###"
- aggregator = "distinct-count"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 0 values
- calculatedMembers: array of 0 values
- namedSets: array of 0 values
- cubes[5]: Cube
- name = "Sales 2"
- caption = null
- visible = "true"
- description = null
- defaultMeasure = null
- cache = "true"
- enabled = "true"
- annotations: null
- fact: Table
- name = "sales_fact_1997"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- dimensions: array of 3 values
- dimensions[0]: DimensionUsage
- source = "Time"
- level = null
- usagePrefix = null
- name = "Time"
- caption = null
- visible = "true"
- description = null
- foreignKey = "time_id"
- highCardinality = "false"
- annotations: null
- dimensions[1]: DimensionUsage
- source = "Product"
- level = null
- usagePrefix = null
- name = "Product"
- caption = null
- visible = "true"
- description = null
- foreignKey = "product_id"
- highCardinality = "false"
- annotations: null
- dimensions[2]: Dimension
- type = null
- usagePrefix = null
- visible = "true"
- foreignKey = "customer_id"
- highCardinality = "false"
- name = "Gender"
- caption = null
- description = null
- annotations: null
- hierarchies: array of 1 values
- hierarchies[0]: Hierarchy
- name = null
- visible = "true"
- hasAll = "true"
- allMemberName = "All Gender"
- allMemberCaption = null
- allLevelName = null
- primaryKey = "customer_id"
- primaryKeyTable = null
- defaultMember = null
- memberReaderClass = null
- caption = null
- description = null
- uniqueKeyLevelName = null
- annotations: null
- relation: Table
- name = "customer"
- schema = null
- alias = null
- filter: null
- aggExcludes: array of 0 values
- aggTables: array of 0 values
- tableHints: array of 0 values
- levels: array of 1 values
- levels[0]: Level
- approxRowCount = null
- name = "Gender"
- visible = "true"
- table = null
- column = "gender"
- nameColumn = null
- ordinalColumn = null
- parentColumn = null
- nullParentValue = null
- type = "String"
- internalType = null
- uniqueMembers = "true"
- levelType = "Regular"
- hideMemberIf = "Never"
- formatter = null
- caption = null
- description = null
- captionColumn = null
- annotations: null
- keyExp: null
- nameExp: null
- captionExp: null
- ordinalExp: null
- parentExp: null
- memberFormatter: null
- closure: null
- properties: array of 0 values
- memberReaderParameters: array of 0 values
- measures: array of 5 values
- measures[0]: Measure
- name = "Sales Count"
- column = "product_id"
- datatype = null
- formatString = "#,###"
- aggregator = "count"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 1 values
- memberProperties[0]: CalculatedMemberProperty
- name = "MEMBER_ORDINAL"
- caption = null
- description = null
- expression = null
- value = "1"
- measures[1]: Measure
- name = "Unit Sales"
- column = "unit_sales"
- datatype = null
- formatString = "Standard"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 1 values
- memberProperties[0]: CalculatedMemberProperty
- name = "MEMBER_ORDINAL"
- caption = null
- description = null
- expression = null
- value = "2"
- measures[2]: Measure
- name = "Store Sales"
- column = "store_sales"
- datatype = null
- formatString = "#,###.00"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 1 values
- memberProperties[0]: CalculatedMemberProperty
- name = "MEMBER_ORDINAL"
- caption = null
- description = null
- expression = null
- value = "3"
- measures[3]: Measure
- name = "Store Cost"
- column = "store_cost"
- datatype = null
- formatString = "#,###.00"
- aggregator = "sum"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 1 values
- memberProperties[0]: CalculatedMemberProperty
- name = "MEMBER_ORDINAL"
- caption = null
- description = null
- expression = null
- value = "6"
- measures[4]: Measure
- name = "Customer Count"
- column = "customer_id"
- datatype = null
- formatString = "#,###"
- aggregator = "distinct-count"
- formatter = null
- caption = null
- description = null
- visible = null
- annotations: null
- measureExp: null
- cellFormatter: null
- memberProperties: array of 1 values
- memberProperties[0]: CalculatedMemberProperty
- name = "MEMBER_ORDINAL"
- caption = null
- description = null
- expression = null
- value = "7"
- calculatedMembers: array of 2 values
- calculatedMembers[0]: CalculatedMember
- name = "Profit"
- formatString = null
- caption = null
- description = null
- formula = null
- dimension = "Measures"
- hierarchy = null
- parent = null
- visible = null
- annotations: null
- formulaElement: Formula
- cdata: "[Measures].[Store Sales] - [Measures].[Store Cost]"
- cellFormatter: null
- memberProperties: array of 2 values
- memberProperties[0]: CalculatedMemberProperty
- name = "FORMAT_STRING"
- caption = null
- description = null
- expression = null
- value = "$#,##0.00"
- memberProperties[1]: CalculatedMemberProperty
- name = "MEMBER_ORDINAL"
- caption = null
- description = null
- expression = null
- value = "4"
- calculatedMembers[1]: CalculatedMember
- name = "Profit last Period"
- formatString = null
- caption = null
- description = null
- formula = "COALESCEEMPTY((Measures.[Profit], [Time].[Time].PREVMEMBER), Measures.[Profit])"
- dimension = "Measures"
- hierarchy = null
- parent = null
- visible = "false"
- annotations: null
- formulaElement: null
- cellFormatter: null
- memberProperties: array of 1 values
- memberProperties[0]: CalculatedMemberProperty
- name = "MEMBER_ORDINAL"
- caption = null
- description = null
- expression = null
- value = "5"
- namedSets: array of 0 values
- virtualCubes: array of 1 values
- virtualCubes[0]: VirtualCube
- enabled = "true"
- name = "Warehouse and Sales"
- defaultMeasure = "Store Sales"
- caption = null
- visible = "true"
- description = null
- annotations: null
- cubeUsage: null
- dimensions: array of 11 values
- dimensions[0]: VirtualCubeDimension
- cubeName = "Sales"
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Customers"
- annotations: null
- dimensions[1]: VirtualCubeDimension
- cubeName = "Sales"
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Education Level"
- annotations: null
- dimensions[2]: VirtualCubeDimension
- cubeName = "Sales"
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Gender"
- annotations: null
- dimensions[3]: VirtualCubeDimension
- cubeName = "Sales"
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Marital Status"
- annotations: null
- dimensions[4]: VirtualCubeDimension
- cubeName = null
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Product"
- annotations: null
- dimensions[5]: VirtualCubeDimension
- cubeName = "Sales"
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Promotion Media"
- annotations: null
- dimensions[6]: VirtualCubeDimension
- cubeName = "Sales"
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Promotions"
- annotations: null
- dimensions[7]: VirtualCubeDimension
- cubeName = null
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Store"
- annotations: null
- dimensions[8]: VirtualCubeDimension
- cubeName = null
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Time"
- annotations: null
- dimensions[9]: VirtualCubeDimension
- cubeName = "Sales"
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Yearly Income"
- annotations: null
- dimensions[10]: VirtualCubeDimension
- cubeName = "Warehouse"
- caption = null
- visible = "true"
- description = null
- foreignKey = null
- highCardinality = "false"
- name = "Warehouse"
- annotations: null
- measures: array of 14 values
- measures[0]: VirtualCubeMeasure
- cubeName = "Sales"
- name = "[Measures].[Sales Count]"
- visible = null
- annotations: null
- measures[1]: VirtualCubeMeasure
- cubeName = "Sales"
- name = "[Measures].[Store Cost]"
- visible = null
- annotations: null
- measures[2]: VirtualCubeMeasure
- cubeName = "Sales"
- name = "[Measures].[Store Sales]"
- visible = null
- annotations: null
- measures[3]: VirtualCubeMeasure
- cubeName = "Sales"
- name = "[Measures].[Unit Sales]"
- visible = null
- annotations: null
- measures[4]: VirtualCubeMeasure
- cubeName = "Sales"
- name = "[Measures].[Profit]"
- visible = null
- annotations: null
- measures[5]: VirtualCubeMeasure
- cubeName = "Sales"
- name = "[Measures].[Profit Growth]"
- visible = null
- annotations: null
- measures[6]: VirtualCubeMeasure
- cubeName = "Warehouse"
- name = "[Measures].[Store Invoice]"
- visible = null
- annotations: null
- measures[7]: VirtualCubeMeasure
- cubeName = "Warehouse"
- name = "[Measures].[Supply Time]"
- visible = null
- annotations: null
- measures[8]: VirtualCubeMeasure
- cubeName = "Warehouse"
- name = "[Measures].[Units Ordered]"
- visible = null
- annotations: null
- measures[9]: VirtualCubeMeasure
- cubeName = "Warehouse"
- name = "[Measures].[Units Shipped]"
- visible = null
- annotations: null
- measures[10]: VirtualCubeMeasure
- cubeName = "Warehouse"
- name = "[Measures].[Warehouse Cost]"
- visible = null
- annotations: null
- measures[11]: VirtualCubeMeasure
- cubeName = "Warehouse"
- name = "[Measures].[Warehouse Profit]"
- visible = null
- annotations: null
- measures[12]: VirtualCubeMeasure
- cubeName = "Warehouse"
- name = "[Measures].[Warehouse Sales]"
- visible = null
- annotations: null
- measures[13]: VirtualCubeMeasure
- cubeName = "Warehouse"
- name = "[Measures].[Average Warehouse Sale]"
- visible = null
- annotations: null
- calculatedMembers: array of 1 values
- calculatedMembers[0]: CalculatedMember
- name = "Profit Per Unit Shipped"
- formatString = null
- caption = null
- description = null
- formula = null
- dimension = "Measures"
- hierarchy = null
- parent = null
- visible = null
- annotations: null
- formulaElement: Formula
- cdata: "[Measures].[Profit] / [Measures].[Units Shipped]"
- cellFormatter: null
- memberProperties: array of 0 values
- namedSets: array of 0 values
- namedSets: array of 0 values
- roles: array of 2 values
- roles[0]: Role
- name = "California manager"
- annotations: null
- schemaGrants: array of 1 values
- schemaGrants[0]: SchemaGrant
- access = "none"
- cubeGrants: array of 1 values
- cubeGrants[0]: CubeGrant
- cube = "Sales"
- access = "all"
- dimensionGrants: array of 0 values
- hierarchyGrants: array of 3 values
- hierarchyGrants[0]: HierarchyGrant
- hierarchy = "[Store]"
- topLevel = "[Store].[Store Country]"
- bottomLevel = null
- rollupPolicy = null
- access = "custom"
- memberGrants: array of 2 values
- memberGrants[0]: MemberGrant
- member = "[Store].[USA].[CA]"
- access = "all"
- memberGrants[1]: MemberGrant
- member = "[Store].[USA].[CA].[Los Angeles]"
- access = "none"
- hierarchyGrants[1]: HierarchyGrant
- hierarchy = "[Customers]"
- topLevel = "[Customers].[State Province]"
- bottomLevel = "[Customers].[City]"
- rollupPolicy = null
- access = "custom"
- memberGrants: array of 2 values
- memberGrants[0]: MemberGrant
- member = "[Customers].[USA].[CA]"
- access = "all"
- memberGrants[1]: MemberGrant
- member = "[Customers].[USA].[CA].[Los Angeles]"
- access = "none"
- hierarchyGrants[2]: HierarchyGrant
- hierarchy = "[Gender]"
- topLevel = null
- bottomLevel = null
- rollupPolicy = null
- access = "none"
- memberGrants: array of 0 values
- union: null
- roles[1]: Role
- name = "No HR Cube"
- annotations: null
- schemaGrants: array of 1 values
- schemaGrants[0]: SchemaGrant
- access = "all"
- cubeGrants: array of 1 values
- cubeGrants[0]: CubeGrant
- cube = "HR"
- access = "none"
- dimensionGrants: array of 0 values
- hierarchyGrants: array of 0 values
- union: null
- userDefinedFunctions: array of 0 values
- 16:26:37,259 DEBUG [RolapCube] RolapCube<init>: cube=Sales
- 16:26:37,279 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=Store, level=null, name=Store, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,288 DEBUG [RolapCube] RolapCube<init>: dimension=Store
- 16:26:37,288 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=Store, level=null, name=Store, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,288 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Store, usage=HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=Store, level=null, name=Store
- 16:26:37,288 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=Store, level=null, name=Store
- 16:26:37,289 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,290 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,291 DEBUG [RolapCube] RolapCube<init>: dimension=Store Size in SQFT
- 16:26:37,291 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,291 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Store Size in SQFT, usage=HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT
- 16:26:37,291 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT
- 16:26:37,291 DEBUG [RolapCube] RolapCube.getUsages: name=Store Size in SQFT
- 16:26:37,291 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,291 DEBUG [RolapCube] RolapCube<init>: dimension=Store Type
- 16:26:37,291 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,291 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Store Type, usage=HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type
- 16:26:37,292 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type
- 16:26:37,292 DEBUG [RolapCube] RolapCube.getUsages: name=Store Type
- 16:26:37,292 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,293 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,293 DEBUG [RolapCube] RolapCube<init>: dimension=Time
- 16:26:37,293 DEBUG [RolapCube] RolapCube<init>: hierarchy=Time
- 16:26:37,293 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,293 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Time, usage=HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time
- 16:26:37,293 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time
- 16:26:37,293 DEBUG [RolapCube] RolapCube<init>: hierarchy=Time.Weekly
- 16:26:37,293 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,293 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Time.Weekly, usage=HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time
- 16:26:37,293 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time
- 16:26:37,293 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,293 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,294 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,294 DEBUG [RolapCube] RolapCube<init>: dimension=Product
- 16:26:37,294 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,294 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Product, usage=HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product
- 16:26:37,294 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product
- 16:26:37,294 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,295 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Promotion Media, fullName=Promotion Media, foreignKey=promotion_id, source=null, level=null, name=Promotion Media, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,295 DEBUG [RolapCube] RolapCube<init>: dimension=Promotion Media
- 16:26:37,295 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Promotion Media, fullName=Promotion Media, foreignKey=promotion_id, source=null, level=null, name=Promotion Media, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,295 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Promotion Media, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Promotion Media, fullName=Promotion Media, foreignKey=promotion_id, source=null, level=null, name=Promotion Media
- 16:26:37,295 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Promotion Media, fullName=Promotion Media, foreignKey=promotion_id, source=null, level=null, name=Promotion Media
- 16:26:37,295 DEBUG [RolapCube] RolapCube.getUsages: name=Promotion Media
- 16:26:37,296 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Promotions, fullName=Promotions, foreignKey=promotion_id, source=null, level=null, name=Promotions, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,296 DEBUG [RolapCube] RolapCube<init>: dimension=Promotions
- 16:26:37,296 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Promotions, fullName=Promotions, foreignKey=promotion_id, source=null, level=null, name=Promotions, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,296 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Promotions, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Promotions, fullName=Promotions, foreignKey=promotion_id, source=null, level=null, name=Promotions
- 16:26:37,296 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Promotions, fullName=Promotions, foreignKey=promotion_id, source=null, level=null, name=Promotions
- 16:26:37,296 DEBUG [RolapCube] RolapCube.getUsages: name=Promotions
- 16:26:37,296 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Customers, fullName=Customers, foreignKey=customer_id, source=null, level=null, name=Customers, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,297 DEBUG [RolapCube] RolapCube<init>: dimension=Customers
- 16:26:37,297 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Customers, fullName=Customers, foreignKey=customer_id, source=null, level=null, name=Customers, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,297 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Customers, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Customers, fullName=Customers, foreignKey=customer_id, source=null, level=null, name=Customers
- 16:26:37,297 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Customers, fullName=Customers, foreignKey=customer_id, source=null, level=null, name=Customers
- 16:26:37,297 DEBUG [RolapCube] RolapCube.getUsages: name=Customers
- 16:26:37,297 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Education Level, fullName=Education Level, foreignKey=customer_id, source=null, level=null, name=Education Level, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,297 DEBUG [RolapCube] RolapCube<init>: dimension=Education Level
- 16:26:37,297 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Education Level, fullName=Education Level, foreignKey=customer_id, source=null, level=null, name=Education Level, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,297 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Education Level, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Education Level, fullName=Education Level, foreignKey=customer_id, source=null, level=null, name=Education Level
- 16:26:37,298 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Education Level, fullName=Education Level, foreignKey=customer_id, source=null, level=null, name=Education Level
- 16:26:37,298 DEBUG [RolapCube] RolapCube.getUsages: name=Education Level
- 16:26:37,298 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,298 DEBUG [RolapCube] RolapCube<init>: dimension=Gender
- 16:26:37,298 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,298 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Gender, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender
- 16:26:37,298 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender
- 16:26:37,298 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,299 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Marital Status, fullName=Marital Status, foreignKey=customer_id, source=null, level=null, name=Marital Status, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,299 DEBUG [RolapCube] RolapCube<init>: dimension=Marital Status
- 16:26:37,299 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Marital Status, fullName=Marital Status, foreignKey=customer_id, source=null, level=null, name=Marital Status, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,299 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Marital Status, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Marital Status, fullName=Marital Status, foreignKey=customer_id, source=null, level=null, name=Marital Status
- 16:26:37,299 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Marital Status, fullName=Marital Status, foreignKey=customer_id, source=null, level=null, name=Marital Status
- 16:26:37,299 DEBUG [RolapCube] RolapCube.getUsages: name=Marital Status
- 16:26:37,300 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Yearly Income, fullName=Yearly Income, foreignKey=customer_id, source=null, level=null, name=Yearly Income, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,300 DEBUG [RolapCube] RolapCube<init>: dimension=Yearly Income
- 16:26:37,300 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Yearly Income, fullName=Yearly Income, foreignKey=customer_id, source=null, level=null, name=Yearly Income, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,300 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales, hierarchy=Yearly Income, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Yearly Income, fullName=Yearly Income, foreignKey=customer_id, source=null, level=null, name=Yearly Income
- 16:26:37,300 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Yearly Income, fullName=Yearly Income, foreignKey=customer_id, source=null, level=null, name=Yearly Income
- 16:26:37,300 DEBUG [RolapCube] RolapCube.getUsages: name=Yearly Income
- 16:26:37,324 DEBUG [RolapSchema] Normal cardinality for [Store]
- 16:26:37,325 DEBUG [RolapSchema] Normal cardinality for [Store]
- 16:26:37,327 DEBUG [RolapSchema] Normal cardinality for [Store Size in SQFT]
- 16:26:37,327 DEBUG [RolapSchema] Normal cardinality for [Store Size in SQFT]
- 16:26:37,327 DEBUG [RolapSchema] Normal cardinality for [Store Type]
- 16:26:37,327 DEBUG [RolapSchema] Normal cardinality for [Store Type]
- 16:26:37,327 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,327 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,327 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,328 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,328 DEBUG [RolapSchema] Normal cardinality for [Product]
- 16:26:37,328 DEBUG [RolapSchema] Normal cardinality for [Product]
- 16:26:37,328 DEBUG [RolapSchema] Normal cardinality for [Promotion Media]
- 16:26:37,329 DEBUG [Util] Util.lookupCompound: parent.name=Promotion Media, category=member, names=[All Media]
- 16:26:37,331 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Promotion Media, childname=[All Media] returning elementname=All Media
- 16:26:37,331 DEBUG [Util] Util.lookupCompound: found child.name=All Media, child.class=mondrian.rolap.RolapMemberBase
- 16:26:37,331 DEBUG [RolapSchema] Normal cardinality for [Promotion Media]
- 16:26:37,331 DEBUG [RolapSchema] Normal cardinality for [Promotions]
- 16:26:37,333 DEBUG [Util] Util.lookupCompound: parent.name=Promotions, category=member, names=[All Promotions]
- 16:26:37,333 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Promotions, childname=[All Promotions] returning elementname=All Promotions
- 16:26:37,333 DEBUG [Util] Util.lookupCompound: found child.name=All Promotions, child.class=mondrian.rolap.RolapMemberBase
- 16:26:37,333 DEBUG [RolapSchema] Normal cardinality for [Promotions]
- 16:26:37,333 DEBUG [RolapSchema] Normal cardinality for [Customers]
- 16:26:37,333 DEBUG [RolapSchema] Normal cardinality for [Customers]
- 16:26:37,333 DEBUG [RolapSchema] Normal cardinality for [Education Level]
- 16:26:37,334 DEBUG [RolapSchema] Normal cardinality for [Education Level]
- 16:26:37,334 DEBUG [RolapSchema] Normal cardinality for [Gender]
- 16:26:37,334 DEBUG [RolapSchema] Normal cardinality for [Gender]
- 16:26:37,334 DEBUG [RolapSchema] Normal cardinality for [Marital Status]
- 16:26:37,334 DEBUG [RolapSchema] Normal cardinality for [Marital Status]
- 16:26:37,334 DEBUG [RolapSchema] Normal cardinality for [Yearly Income]
- 16:26:37,334 DEBUG [RolapSchema] Normal cardinality for [Yearly Income]
- 16:26:37,341 DEBUG [RolapConnection]
- WITH
- MEMBER [Measures].[Measures].[Profit]
- AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
- FORMAT_STRING = "$#,##0.00",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 6
- MEMBER [Measures].[Measures].[Profit last Period]
- AS 'COALESCEEMPTY((Measures.[Profit], [Time].[Time].PREVMEMBER), Measures.[Profit])',
- FORMAT_STRING = "$#,##0.00",
- MEMBER_ORDINAL = 18,
- [$member_scope] = 'CUBE'
- MEMBER [Measures].[Measures].[Profit Growth]
- AS '([Measures].[Profit] - [Measures].[Profit last Period]) / [Measures].[Profit last Period]',
- FORMAT_STRING = "0.0%",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 8
- SELECT FROM [Sales]
- 16:26:37,393 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,393 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,394 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,394 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,394 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,395 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,396 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=unknown, names=[Measures].[Store Sales]
- 16:26:37,396 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,396 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Store Sales] returning elementname=Store Sales
- 16:26:37,396 DEBUG [Util] Util.lookupCompound: found child.name=Store Sales, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,397 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=unknown, names=[Measures].[Store Cost]
- 16:26:37,397 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,397 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Store Cost] returning elementname=Store Cost
- 16:26:37,397 DEBUG [Util] Util.lookupCompound: found child.name=Store Cost, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,400 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=unknown, names=[Time].[Time]
- 16:26:37,400 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Time], status=hierUsage == shared returning elementname=Time
- 16:26:37,411 DEBUG [sql] 0: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC]
- 16:26:37,438 DEBUG [sql] 0: , exec 25 ms
- 16:26:37,438 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec 25 ms
- 16:26:37,439 DEBUG [sql] 0: , exec+fetch 28 ms, 2 rows
- 16:26:37,439 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: done executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec+fetch 28 ms, 2 rows
- 16:26:37,440 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Time, childname=[Time] returning null
- 16:26:37,440 DEBUG [Util] Util.lookupCompound: found child.name=Time, child.class=mondrian.rolap.RolapCubeHierarchy
- 16:26:37,456 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,458 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,458 DEBUG [RolapCube] RolapCube.getUsages: name=Store Size in SQFT
- 16:26:37,458 DEBUG [RolapCube] RolapCube.getUsages: name=Store Type
- 16:26:37,458 DEBUG [sql] 1: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC]
- 16:26:37,461 DEBUG [sql] 1: , exec 3 ms
- 16:26:37,461 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec 3 ms
- 16:26:37,461 DEBUG [sql] 1: , exec+fetch 3 ms, 2 rows
- 16:26:37,462 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: done executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec+fetch 3 ms, 2 rows
- 16:26:37,462 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,462 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,463 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,463 DEBUG [RolapCube] RolapCube.getUsages: name=Promotion Media
- 16:26:37,463 DEBUG [RolapCube] RolapCube.getUsages: name=Promotions
- 16:26:37,463 DEBUG [RolapCube] RolapCube.getUsages: name=Customers
- 16:26:37,464 DEBUG [RolapCube] RolapCube.getUsages: name=Education Level
- 16:26:37,464 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,465 DEBUG [RolapCube] RolapCube.getUsages: name=Marital Status
- 16:26:37,465 DEBUG [RolapCube] RolapCube.getUsages: name=Yearly Income
- 16:26:37,504 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,513 DEBUG [ExplicitRules]
- ExplicitRules.Group:
- name=sales_fact_1997
- TableDefs: [
- ExplicitRules.NameTableDef:
- id=0
- ignoreCase=true
- Levels: [
- Level:
- name=[Time].[Year]
- columnName=TIME_YEAR
- Level:
- name=[Time].[Quarter]
- columnName=TIME_QUARTER
- Level:
- name=[Time].[Month]
- columnName=TIME_MONTH
- ]
- Measures: [
- Measure:
- name=[Measures].[Unit Sales]
- column=UNIT_SALES_SUM
- Measure:
- name=[Measures].[Store Cost]
- column=STORE_COST_SUM
- Measure:
- name=[Measures].[Store Sales]
- column=STORE_SALES_SUM
- ]
- name=agg_c_special_sales_fact_1997
- ]
- 16:26:37,513 DEBUG [RolapCube] RolapCube<init>: cube=Warehouse
- 16:26:37,513 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=Store, level=null, name=Store, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,514 DEBUG [RolapCube] RolapCube<init>: dimension=Store
- 16:26:37,514 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=Store, level=null, name=Store, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,514 DEBUG [RolapCube] RolapCube.createUsage: cube=Warehouse, hierarchy=Store, usage=HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=Store, level=null, name=Store
- 16:26:37,514 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=Store, level=null, name=Store
- 16:26:37,514 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,514 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,514 DEBUG [RolapCube] RolapCube<init>: dimension=Store Size in SQFT
- 16:26:37,515 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,515 DEBUG [RolapCube] RolapCube.createUsage: cube=Warehouse, hierarchy=Store Size in SQFT, usage=HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT
- 16:26:37,515 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT
- 16:26:37,515 DEBUG [RolapCube] RolapCube.getUsages: name=Store Size in SQFT
- 16:26:37,515 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,515 DEBUG [RolapCube] RolapCube<init>: dimension=Store Type
- 16:26:37,515 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,515 DEBUG [RolapCube] RolapCube.createUsage: cube=Warehouse, hierarchy=Store Type, usage=HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type
- 16:26:37,515 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type
- 16:26:37,515 DEBUG [RolapCube] RolapCube.getUsages: name=Store Type
- 16:26:37,515 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,516 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,516 DEBUG [RolapCube] RolapCube<init>: dimension=Time
- 16:26:37,516 DEBUG [RolapCube] RolapCube<init>: hierarchy=Time
- 16:26:37,516 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,516 DEBUG [RolapCube] RolapCube.createUsage: cube=Warehouse, hierarchy=Time, usage=HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time
- 16:26:37,516 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time
- 16:26:37,516 DEBUG [RolapCube] RolapCube<init>: hierarchy=Time.Weekly
- 16:26:37,516 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,516 DEBUG [RolapCube] RolapCube.createUsage: cube=Warehouse, hierarchy=Time.Weekly, usage=HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time
- 16:26:37,516 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time
- 16:26:37,516 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,517 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,517 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,517 DEBUG [RolapCube] RolapCube<init>: dimension=Product
- 16:26:37,517 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,517 DEBUG [RolapCube] RolapCube.createUsage: cube=Warehouse, hierarchy=Product, usage=HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product
- 16:26:37,517 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product
- 16:26:37,517 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,518 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Warehouse, fullName=Warehouse, foreignKey=warehouse_id, source=Warehouse, level=null, name=Warehouse, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,518 DEBUG [RolapCube] RolapCube<init>: dimension=Warehouse
- 16:26:37,518 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Warehouse, fullName=Warehouse, foreignKey=warehouse_id, source=Warehouse, level=null, name=Warehouse, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,518 DEBUG [RolapCube] RolapCube.createUsage: cube=Warehouse, hierarchy=Warehouse, usage=HierarchyUsage: kind=SHARED, hierarchyName=Warehouse, fullName=Warehouse, foreignKey=warehouse_id, source=Warehouse, level=null, name=Warehouse
- 16:26:37,518 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Warehouse, fullName=Warehouse, foreignKey=warehouse_id, source=Warehouse, level=null, name=Warehouse
- 16:26:37,518 DEBUG [RolapCube] RolapCube.getUsages: name=Warehouse
- 16:26:37,518 DEBUG [RolapSchema] Normal cardinality for [Store]
- 16:26:37,519 DEBUG [RolapSchema] Normal cardinality for [Store Size in SQFT]
- 16:26:37,519 DEBUG [RolapSchema] Normal cardinality for [Store Type]
- 16:26:37,519 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,519 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,519 DEBUG [RolapSchema] Normal cardinality for [Product]
- 16:26:37,519 DEBUG [RolapSchema] Normal cardinality for [Warehouse]
- 16:26:37,519 DEBUG [RolapSchema] Normal cardinality for [Warehouse]
- 16:26:37,519 DEBUG [RolapConnection]
- WITH
- MEMBER [Measures].[Measures].[Average Warehouse Sale]
- AS '[Measures].[Warehouse Sales] / [Measures].[Warehouse Cost]',
- FORMAT_STRING = "$#,##0.00",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 8
- SET [Top Sellers]
- AS 'TopCount([Warehouse].[Warehouse Name].MEMBERS, 5, [Measures].[Warehouse Sales])'
- SELECT FROM [Warehouse]
- 16:26:37,521 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse, childname=[Measures] returning elementname=Measures
- 16:26:37,521 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,521 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse, category=unknown, names=[Measures].[Warehouse Sales]
- 16:26:37,521 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse, childname=[Measures] returning elementname=Measures
- 16:26:37,522 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Warehouse Sales] returning elementname=Warehouse Sales
- 16:26:37,522 DEBUG [Util] Util.lookupCompound: found child.name=Warehouse Sales, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,522 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse, category=unknown, names=[Measures].[Warehouse Cost]
- 16:26:37,522 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse, childname=[Measures] returning elementname=Measures
- 16:26:37,522 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Warehouse Cost] returning elementname=Warehouse Cost
- 16:26:37,522 DEBUG [Util] Util.lookupCompound: found child.name=Warehouse Cost, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,522 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse, category=unknown, names=[Warehouse].[Warehouse Name]
- 16:26:37,522 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse, childname=[Warehouse], status=hierUsage == shared returning elementname=Warehouse
- 16:26:37,522 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Warehouse, childname=[Warehouse Name] returning elementname=Warehouse Name
- 16:26:37,523 DEBUG [Util] Util.lookupCompound: found child.name=Warehouse Name, child.class=mondrian.rolap.RolapCubeLevel
- 16:26:37,523 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse, category=unknown, names=[Measures].[Warehouse Sales]
- 16:26:37,523 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse, childname=[Measures] returning elementname=Measures
- 16:26:37,524 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Warehouse Sales] returning elementname=Warehouse Sales
- 16:26:37,524 DEBUG [Util] Util.lookupCompound: found child.name=Warehouse Sales, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,524 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,524 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,524 DEBUG [RolapCube] RolapCube.getUsages: name=Store Size in SQFT
- 16:26:37,524 DEBUG [RolapCube] RolapCube.getUsages: name=Store Type
- 16:26:37,525 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,525 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,525 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,525 DEBUG [RolapCube] RolapCube.getUsages: name=Warehouse
- 16:26:37,525 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,525 DEBUG [ExplicitRules]
- ExplicitRules.Group:
- name=inventory_fact_1997
- TableDefs: [
- ]
- 16:26:37,525 DEBUG [RolapCube] RolapCube<init>: cube=Store
- 16:26:37,526 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Store Type, fullName=Store Type, foreignKey=null, source=null, level=null, name=Store Type, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,526 DEBUG [RolapCube] RolapCube<init>: dimension=Store Type
- 16:26:37,526 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Store Type, fullName=Store Type, foreignKey=null, source=null, level=null, name=Store Type, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,526 DEBUG [RolapCube] RolapCube.createUsage: cube=Store, hierarchy=Store Type, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Store Type, fullName=Store Type, foreignKey=null, source=null, level=null, name=Store Type
- 16:26:37,526 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Store Type, fullName=Store Type, foreignKey=null, source=null, level=null, name=Store Type
- 16:26:37,526 DEBUG [RolapCube] RolapCube.getUsages: name=Store Type
- 16:26:37,526 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=null, source=Store, level=null, name=Store, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,527 DEBUG [RolapCube] RolapCube<init>: dimension=Store
- 16:26:37,527 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=null, source=Store, level=null, name=Store, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,527 DEBUG [RolapCube] RolapCube.createUsage: cube=Store, hierarchy=Store, usage=HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=null, source=Store, level=null, name=Store
- 16:26:37,527 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Store, fullName=Store, foreignKey=null, source=Store, level=null, name=Store
- 16:26:37,527 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,527 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Has coffee bar, fullName=Has coffee bar, foreignKey=null, source=null, level=null, name=Has coffee bar, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,527 DEBUG [RolapCube] RolapCube<init>: dimension=Has coffee bar
- 16:26:37,527 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Has coffee bar, fullName=Has coffee bar, foreignKey=null, source=null, level=null, name=Has coffee bar, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,527 DEBUG [RolapCube] RolapCube.createUsage: cube=Store, hierarchy=Has coffee bar, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Has coffee bar, fullName=Has coffee bar, foreignKey=null, source=null, level=null, name=Has coffee bar
- 16:26:37,527 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Has coffee bar, fullName=Has coffee bar, foreignKey=null, source=null, level=null, name=Has coffee bar
- 16:26:37,527 DEBUG [RolapCube] RolapCube.getUsages: name=Has coffee bar
- 16:26:37,528 DEBUG [RolapSchema] Normal cardinality for [Store Type]
- 16:26:37,528 DEBUG [RolapSchema] Normal cardinality for [Store Type]
- 16:26:37,528 DEBUG [RolapSchema] Normal cardinality for [Store]
- 16:26:37,528 DEBUG [RolapSchema] Normal cardinality for [Has coffee bar]
- 16:26:37,528 DEBUG [RolapSchema] Normal cardinality for [Has coffee bar]
- 16:26:37,528 DEBUG [ExplicitRules]
- ExplicitRules.Group:
- name=store
- TableDefs: [
- ]
- 16:26:37,528 DEBUG [RolapCube] RolapCube<init>: cube=HR
- 16:26:37,529 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Time, fullName=Time, foreignKey=pay_date, source=null, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,529 DEBUG [RolapCube] RolapCube<init>: dimension=Time
- 16:26:37,529 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Time, fullName=Time, foreignKey=pay_date, source=null, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,529 DEBUG [RolapCube] RolapCube.createUsage: cube=HR, hierarchy=Time, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Time, fullName=Time, foreignKey=pay_date, source=null, level=null, name=Time
- 16:26:37,529 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Time, fullName=Time, foreignKey=pay_date, source=null, level=null, name=Time
- 16:26:37,529 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,530 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Store, fullName=Store, foreignKey=employee_id, source=null, level=null, name=Store, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,530 DEBUG [RolapCube] RolapCube<init>: dimension=Store
- 16:26:37,530 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Store, fullName=Store, foreignKey=employee_id, source=null, level=null, name=Store, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,530 DEBUG [RolapCube] RolapCube.createUsage: cube=HR, hierarchy=Store, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Store, fullName=Store, foreignKey=employee_id, source=null, level=null, name=Store
- 16:26:37,530 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Store, fullName=Store, foreignKey=employee_id, source=null, level=null, name=Store
- 16:26:37,530 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,530 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Pay Type, fullName=Pay Type, foreignKey=employee_id, source=null, level=null, name=Pay Type, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,531 DEBUG [RolapCube] RolapCube<init>: dimension=Pay Type
- 16:26:37,531 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Pay Type, fullName=Pay Type, foreignKey=employee_id, source=null, level=null, name=Pay Type, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,531 DEBUG [RolapCube] RolapCube.createUsage: cube=HR, hierarchy=Pay Type, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Pay Type, fullName=Pay Type, foreignKey=employee_id, source=null, level=null, name=Pay Type
- 16:26:37,531 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Pay Type, fullName=Pay Type, foreignKey=employee_id, source=null, level=null, name=Pay Type
- 16:26:37,531 DEBUG [RolapCube] RolapCube.getUsages: name=Pay Type
- 16:26:37,531 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Store Type, fullName=Store Type, foreignKey=employee_id, source=null, level=null, name=Store Type, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,531 DEBUG [RolapCube] RolapCube<init>: dimension=Store Type
- 16:26:37,531 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Store Type, fullName=Store Type, foreignKey=employee_id, source=null, level=null, name=Store Type, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,531 DEBUG [RolapCube] RolapCube.createUsage: cube=HR, hierarchy=Store Type, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Store Type, fullName=Store Type, foreignKey=employee_id, source=null, level=null, name=Store Type
- 16:26:37,531 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Store Type, fullName=Store Type, foreignKey=employee_id, source=null, level=null, name=Store Type
- 16:26:37,531 DEBUG [RolapCube] RolapCube.getUsages: name=Store Type
- 16:26:37,532 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Position, fullName=Position, foreignKey=employee_id, source=null, level=null, name=Position, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,532 DEBUG [RolapCube] RolapCube<init>: dimension=Position
- 16:26:37,532 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Position, fullName=Position, foreignKey=employee_id, source=null, level=null, name=Position, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,532 DEBUG [RolapCube] RolapCube.createUsage: cube=HR, hierarchy=Position, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Position, fullName=Position, foreignKey=employee_id, source=null, level=null, name=Position
- 16:26:37,532 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Position, fullName=Position, foreignKey=employee_id, source=null, level=null, name=Position
- 16:26:37,532 DEBUG [RolapCube] RolapCube.getUsages: name=Position
- 16:26:37,532 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Department, fullName=Department, foreignKey=department_id, source=null, level=null, name=Department, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,533 DEBUG [RolapCube] RolapCube<init>: dimension=Department
- 16:26:37,533 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Department, fullName=Department, foreignKey=department_id, source=null, level=null, name=Department, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,533 DEBUG [RolapCube] RolapCube.createUsage: cube=HR, hierarchy=Department, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Department, fullName=Department, foreignKey=department_id, source=null, level=null, name=Department
- 16:26:37,533 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Department, fullName=Department, foreignKey=department_id, source=null, level=null, name=Department
- 16:26:37,533 DEBUG [RolapCube] RolapCube.getUsages: name=Department
- 16:26:37,533 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Employees, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,533 DEBUG [RolapCube] RolapCube<init>: dimension=Employees
- 16:26:37,533 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Employees, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,533 DEBUG [RolapCube] RolapCube.createUsage: cube=HR, hierarchy=Employees, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Employees, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees
- 16:26:37,533 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Employees, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees
- 16:26:37,534 DEBUG [RolapCube] RolapCube.getUsages: name=Employees
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Store]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Store]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Pay Type]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Pay Type]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Store Type]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Store Type]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Position]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Position]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Department]
- 16:26:37,534 DEBUG [RolapSchema] Normal cardinality for [Department]
- 16:26:37,535 DEBUG [RolapSchema] Normal cardinality for [Employees]
- 16:26:37,535 DEBUG [RolapSchema] Normal cardinality for [Employees]
- 16:26:37,535 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,536 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,536 DEBUG [RolapCube] RolapCube.createUsage: cube=HR, hierarchy=Employees$Closure, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees
- 16:26:37,536 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Employees$Closure, fullName=Employees, foreignKey=employee_id, source=null, level=null, name=Employees
- 16:26:37,536 DEBUG [RolapSchema] Normal cardinality for [Employees$Closure]
- 16:26:37,536 DEBUG [RolapSchema] Normal cardinality for [Employees$Closure]
- 16:26:37,536 DEBUG [RolapCube] RolapCube.getUsages: name=Employees$Closure
- 16:26:37,537 DEBUG [RolapConnection]
- WITH
- MEMBER [Measures].[Measures].[Employee Salary]
- AS '([Employees].currentmember.datamember, [Measures].[Org Salary])',
- FORMAT_STRING = "Currency",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 3
- MEMBER [Measures].[Measures].[Avg Salary]
- AS '[Measures].[Org Salary]/[Measures].[Number of Employees]',
- FORMAT_STRING = "Currency",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 4
- SELECT FROM [HR]
- 16:26:37,538 DEBUG [RolapCube] RolapCube.lookupChild: name=HR, childname=[Measures] returning elementname=Measures
- 16:26:37,538 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,539 DEBUG [RolapCube] RolapCube.lookupChild: name=HR, childname=[Measures] returning elementname=Measures
- 16:26:37,539 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,539 DEBUG [Util] Util.lookupCompound: parent.name=HR, category=unknown, names=[Employees]
- 16:26:37,539 DEBUG [RolapCube] RolapCube.lookupChild: name=HR, childname=[Employees], status=hierUsage == not shared returning elementname=Employees
- 16:26:37,539 DEBUG [Util] Util.lookupCompound: found child.name=Employees, child.class=mondrian.rolap.RolapCubeDimension
- 16:26:37,540 DEBUG [Util] Util.lookupCompound: parent.name=HR, category=unknown, names=[Measures].[Org Salary]
- 16:26:37,540 DEBUG [RolapCube] RolapCube.lookupChild: name=HR, childname=[Measures] returning elementname=Measures
- 16:26:37,540 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Org Salary] returning elementname=Org Salary
- 16:26:37,540 DEBUG [Util] Util.lookupCompound: found child.name=Org Salary, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,541 DEBUG [Util] Util.lookupCompound: parent.name=HR, category=unknown, names=[Measures].[Org Salary]
- 16:26:37,541 DEBUG [RolapCube] RolapCube.lookupChild: name=HR, childname=[Measures] returning elementname=Measures
- 16:26:37,541 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Org Salary] returning elementname=Org Salary
- 16:26:37,541 DEBUG [Util] Util.lookupCompound: found child.name=Org Salary, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,541 DEBUG [Util] Util.lookupCompound: parent.name=HR, category=unknown, names=[Measures].[Number of Employees]
- 16:26:37,542 DEBUG [RolapCube] RolapCube.lookupChild: name=HR, childname=[Measures] returning elementname=Measures
- 16:26:37,542 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Number of Employees] returning elementname=Number of Employees
- 16:26:37,542 DEBUG [Util] Util.lookupCompound: found child.name=Number of Employees, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,542 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,542 DEBUG [sql] 2: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC]
- 16:26:37,544 DEBUG [sql] 2: , exec 2 ms
- 16:26:37,544 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec 2 ms
- 16:26:37,544 DEBUG [sql] 2: , exec+fetch 2 ms, 2 rows
- 16:26:37,544 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: done executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec+fetch 2 ms, 2 rows
- 16:26:37,544 DEBUG [sql] 3: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC]
- 16:26:37,545 DEBUG [sql] 3: , exec 1 ms
- 16:26:37,545 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec 1 ms
- 16:26:37,545 DEBUG [sql] 3: , exec+fetch 1 ms, 2 rows
- 16:26:37,546 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: done executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec+fetch 1 ms, 2 rows
- 16:26:37,546 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,546 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,546 DEBUG [RolapCube] RolapCube.getUsages: name=Pay Type
- 16:26:37,546 DEBUG [RolapCube] RolapCube.getUsages: name=Store Type
- 16:26:37,546 DEBUG [RolapCube] RolapCube.getUsages: name=Position
- 16:26:37,546 DEBUG [RolapCube] RolapCube.getUsages: name=Department
- 16:26:37,546 DEBUG [RolapCube] RolapCube.getUsages: name=Employees
- 16:26:37,546 DEBUG [RolapCube] RolapCube.getUsages: name=Employees$Closure
- 16:26:37,547 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,547 DEBUG [ExplicitRules]
- ExplicitRules.Group:
- name=salary
- TableDefs: [
- ]
- 16:26:37,548 DEBUG [RolapCube] RolapCube<init>: cube=Sales Ragged
- 16:26:37,548 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=null, level=null, name=Store, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,548 DEBUG [RolapCube] RolapCube<init>: dimension=Store
- 16:26:37,548 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=null, level=null, name=Store, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,548 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Store, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=null, level=null, name=Store
- 16:26:37,548 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Store, fullName=Store, foreignKey=store_id, source=null, level=null, name=Store
- 16:26:37,549 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,549 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Geography, fullName=Geography, foreignKey=store_id, source=null, level=null, name=Geography, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,549 DEBUG [RolapCube] RolapCube<init>: dimension=Geography
- 16:26:37,549 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Geography, fullName=Geography, foreignKey=store_id, source=null, level=null, name=Geography, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,549 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Geography, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Geography, fullName=Geography, foreignKey=store_id, source=null, level=null, name=Geography
- 16:26:37,549 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Geography, fullName=Geography, foreignKey=store_id, source=null, level=null, name=Geography
- 16:26:37,549 DEBUG [RolapCube] RolapCube.getUsages: name=Geography
- 16:26:37,549 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,550 DEBUG [RolapCube] RolapCube<init>: dimension=Store Size in SQFT
- 16:26:37,550 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,550 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Store Size in SQFT, usage=HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT
- 16:26:37,550 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Store Size in SQFT, fullName=Store Size in SQFT, foreignKey=store_id, source=Store Size in SQFT, level=null, name=Store Size in SQFT
- 16:26:37,550 DEBUG [RolapCube] RolapCube.getUsages: name=Store Size in SQFT
- 16:26:37,550 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,550 DEBUG [RolapCube] RolapCube<init>: dimension=Store Type
- 16:26:37,550 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,550 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Store Type, usage=HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type
- 16:26:37,550 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Store Type, fullName=Store Type, foreignKey=store_id, source=Store Type, level=null, name=Store Type
- 16:26:37,550 DEBUG [RolapCube] RolapCube.getUsages: name=Store Type
- 16:26:37,551 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,551 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,551 DEBUG [RolapCube] RolapCube<init>: dimension=Time
- 16:26:37,551 DEBUG [RolapCube] RolapCube<init>: hierarchy=Time
- 16:26:37,551 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,551 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Time, usage=HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time
- 16:26:37,551 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time
- 16:26:37,551 DEBUG [RolapCube] RolapCube<init>: hierarchy=Time.Weekly
- 16:26:37,551 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,552 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Time.Weekly, usage=HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time
- 16:26:37,552 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time
- 16:26:37,552 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,552 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,552 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,552 DEBUG [RolapCube] RolapCube<init>: dimension=Product
- 16:26:37,552 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,552 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Product, usage=HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product
- 16:26:37,552 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product
- 16:26:37,552 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,553 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Promotion Media, fullName=Promotion Media, foreignKey=promotion_id, source=null, level=null, name=Promotion Media, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,553 DEBUG [RolapCube] RolapCube<init>: dimension=Promotion Media
- 16:26:37,553 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Promotion Media, fullName=Promotion Media, foreignKey=promotion_id, source=null, level=null, name=Promotion Media, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,553 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Promotion Media, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Promotion Media, fullName=Promotion Media, foreignKey=promotion_id, source=null, level=null, name=Promotion Media
- 16:26:37,553 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Promotion Media, fullName=Promotion Media, foreignKey=promotion_id, source=null, level=null, name=Promotion Media
- 16:26:37,553 DEBUG [RolapCube] RolapCube.getUsages: name=Promotion Media
- 16:26:37,554 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Promotions, fullName=Promotions, foreignKey=promotion_id, source=null, level=null, name=Promotions, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,555 DEBUG [RolapCube] RolapCube<init>: dimension=Promotions
- 16:26:37,555 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Promotions, fullName=Promotions, foreignKey=promotion_id, source=null, level=null, name=Promotions, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,555 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Promotions, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Promotions, fullName=Promotions, foreignKey=promotion_id, source=null, level=null, name=Promotions
- 16:26:37,555 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Promotions, fullName=Promotions, foreignKey=promotion_id, source=null, level=null, name=Promotions
- 16:26:37,555 DEBUG [RolapCube] RolapCube.getUsages: name=Promotions
- 16:26:37,556 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Customers, fullName=Customers, foreignKey=customer_id, source=null, level=null, name=Customers, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,556 DEBUG [RolapCube] RolapCube<init>: dimension=Customers
- 16:26:37,556 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Customers, fullName=Customers, foreignKey=customer_id, source=null, level=null, name=Customers, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,557 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Customers, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Customers, fullName=Customers, foreignKey=customer_id, source=null, level=null, name=Customers
- 16:26:37,557 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Customers, fullName=Customers, foreignKey=customer_id, source=null, level=null, name=Customers
- 16:26:37,557 DEBUG [RolapCube] RolapCube.getUsages: name=Customers
- 16:26:37,557 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Education Level, fullName=Education Level, foreignKey=customer_id, source=null, level=null, name=Education Level, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,558 DEBUG [RolapCube] RolapCube<init>: dimension=Education Level
- 16:26:37,558 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Education Level, fullName=Education Level, foreignKey=customer_id, source=null, level=null, name=Education Level, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,558 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Education Level, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Education Level, fullName=Education Level, foreignKey=customer_id, source=null, level=null, name=Education Level
- 16:26:37,558 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Education Level, fullName=Education Level, foreignKey=customer_id, source=null, level=null, name=Education Level
- 16:26:37,558 DEBUG [RolapCube] RolapCube.getUsages: name=Education Level
- 16:26:37,558 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,559 DEBUG [RolapCube] RolapCube<init>: dimension=Gender
- 16:26:37,559 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,559 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Gender, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender
- 16:26:37,559 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender
- 16:26:37,559 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,560 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Marital Status, fullName=Marital Status, foreignKey=customer_id, source=null, level=null, name=Marital Status, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,560 DEBUG [RolapCube] RolapCube<init>: dimension=Marital Status
- 16:26:37,560 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Marital Status, fullName=Marital Status, foreignKey=customer_id, source=null, level=null, name=Marital Status, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,560 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Marital Status, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Marital Status, fullName=Marital Status, foreignKey=customer_id, source=null, level=null, name=Marital Status
- 16:26:37,560 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Marital Status, fullName=Marital Status, foreignKey=customer_id, source=null, level=null, name=Marital Status
- 16:26:37,560 DEBUG [RolapCube] RolapCube.getUsages: name=Marital Status
- 16:26:37,560 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Yearly Income, fullName=Yearly Income, foreignKey=customer_id, source=null, level=null, name=Yearly Income, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,560 DEBUG [RolapCube] RolapCube<init>: dimension=Yearly Income
- 16:26:37,561 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Yearly Income, fullName=Yearly Income, foreignKey=customer_id, source=null, level=null, name=Yearly Income, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,561 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales Ragged, hierarchy=Yearly Income, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Yearly Income, fullName=Yearly Income, foreignKey=customer_id, source=null, level=null, name=Yearly Income
- 16:26:37,561 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Yearly Income, fullName=Yearly Income, foreignKey=customer_id, source=null, level=null, name=Yearly Income
- 16:26:37,561 DEBUG [RolapCube] RolapCube.getUsages: name=Yearly Income
- 16:26:37,561 DEBUG [RolapSchema] Normal cardinality for [Store]
- 16:26:37,561 DEBUG [RolapSchema] Normal cardinality for [Store]
- 16:26:37,561 DEBUG [RolapSchema] Normal cardinality for [Geography]
- 16:26:37,561 DEBUG [RolapSchema] Normal cardinality for [Geography]
- 16:26:37,561 DEBUG [RolapSchema] Normal cardinality for [Store Size in SQFT]
- 16:26:37,561 DEBUG [RolapSchema] Normal cardinality for [Store Type]
- 16:26:37,561 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,561 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Product]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Promotion Media]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Promotion Media]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Promotions]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Promotions]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Customers]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Customers]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Education Level]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Education Level]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Gender]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Gender]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Marital Status]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Marital Status]
- 16:26:37,562 DEBUG [RolapSchema] Normal cardinality for [Yearly Income]
- 16:26:37,563 DEBUG [RolapSchema] Normal cardinality for [Yearly Income]
- 16:26:37,563 DEBUG [ExplicitRules]
- ExplicitRules.Group:
- name=sales_fact_1997
- TableDefs: [
- ]
- 16:26:37,563 DEBUG [RolapCube] RolapCube<init>: cube=Sales 2
- 16:26:37,563 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,563 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,564 DEBUG [RolapCube] RolapCube<init>: dimension=Time
- 16:26:37,564 DEBUG [RolapCube] RolapCube<init>: hierarchy=Time
- 16:26:37,564 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,564 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales 2, hierarchy=Time, usage=HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time
- 16:26:37,564 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Time, fullName=Time, foreignKey=time_id, source=Time, level=null, name=Time
- 16:26:37,564 DEBUG [RolapCube] RolapCube<init>: hierarchy=Time.Weekly
- 16:26:37,564 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,564 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales 2, hierarchy=Time.Weekly, usage=HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time
- 16:26:37,564 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Time.Weekly, fullName=Time.Weekly, foreignKey=time_id, source=Time.Weekly, level=null, name=Time
- 16:26:37,564 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,564 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,564 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,565 DEBUG [RolapCube] RolapCube<init>: dimension=Product
- 16:26:37,565 DEBUG [HierarchyUsage] HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product, cubeDim=mondrian.olap.MondrianDef$DimensionUsage
- 16:26:37,565 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales 2, hierarchy=Product, usage=HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product
- 16:26:37,565 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=SHARED, hierarchyName=Product, fullName=Product, foreignKey=product_id, source=Product, level=null, name=Product
- 16:26:37,565 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,565 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,565 DEBUG [RolapCube] RolapCube<init>: dimension=Gender
- 16:26:37,565 DEBUG [HierarchyUsage] HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender, cubeDim=mondrian.olap.MondrianDef$Dimension
- 16:26:37,566 DEBUG [RolapCube] RolapCube.createUsage: cube=Sales 2, hierarchy=Gender, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender
- 16:26:37,566 DEBUG [RolapCube] RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Gender, fullName=Gender, foreignKey=customer_id, source=null, level=null, name=Gender
- 16:26:37,566 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,566 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,566 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,566 DEBUG [RolapSchema] Normal cardinality for [Product]
- 16:26:37,567 DEBUG [RolapSchema] Normal cardinality for [Gender]
- 16:26:37,567 DEBUG [RolapSchema] Normal cardinality for [Gender]
- 16:26:37,567 DEBUG [RolapConnection]
- WITH
- MEMBER [Measures].[Measures].[Profit]
- AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
- FORMAT_STRING = "$#,##0.00",
- MEMBER_ORDINAL = 4,
- [$member_scope] = 'CUBE'
- MEMBER [Measures].[Measures].[Profit last Period]
- AS 'COALESCEEMPTY((Measures.[Profit], [Time].[Time].PREVMEMBER), Measures.[Profit])',
- MEMBER_ORDINAL = 5,
- [$member_scope] = 'CUBE'
- SELECT FROM [Sales 2]
- 16:26:37,569 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales 2, childname=[Measures] returning elementname=Measures
- 16:26:37,569 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,569 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales 2, childname=[Measures] returning elementname=Measures
- 16:26:37,569 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,570 DEBUG [Util] Util.lookupCompound: parent.name=Sales 2, category=unknown, names=[Measures].[Store Sales]
- 16:26:37,570 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales 2, childname=[Measures] returning elementname=Measures
- 16:26:37,570 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Store Sales] returning elementname=Store Sales
- 16:26:37,570 DEBUG [Util] Util.lookupCompound: found child.name=Store Sales, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,571 DEBUG [Util] Util.lookupCompound: parent.name=Sales 2, category=unknown, names=[Measures].[Store Cost]
- 16:26:37,571 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales 2, childname=[Measures] returning elementname=Measures
- 16:26:37,571 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Store Cost] returning elementname=Store Cost
- 16:26:37,571 DEBUG [Util] Util.lookupCompound: found child.name=Store Cost, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,572 DEBUG [Util] Util.lookupCompound: parent.name=Sales 2, category=unknown, names=[Time].[Time]
- 16:26:37,572 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales 2, childname=[Time], status=hierUsage == shared returning elementname=Time
- 16:26:37,572 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Time, childname=[Time] returning null
- 16:26:37,572 DEBUG [Util] Util.lookupCompound: found child.name=Time, child.class=mondrian.rolap.RolapCubeHierarchy
- 16:26:37,574 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,574 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,574 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,574 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,574 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,574 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,575 DEBUG [ExplicitRules]
- ExplicitRules.Group:
- name=sales_fact_1997
- TableDefs: [
- ]
- 16:26:37,575 DEBUG [RolapCube] RolapCube<init>: virtual cube=Warehouse and Sales
- 16:26:37,575 DEBUG [RolapCube] RolapCube<init>: dimension=Customers
- 16:26:37,575 DEBUG [RolapCube] RolapCube.getUsages: name=Customers
- 16:26:37,576 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Customers"
- 16:26:37,576 DEBUG [RolapCube] RolapCube<init>: dimension=Education Level
- 16:26:37,576 DEBUG [RolapCube] RolapCube.getUsages: name=Education Level
- 16:26:37,576 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Education Level"
- 16:26:37,577 DEBUG [RolapCube] RolapCube<init>: dimension=Gender
- 16:26:37,577 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,577 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Gender"
- 16:26:37,577 DEBUG [RolapCube] RolapCube<init>: dimension=Marital Status
- 16:26:37,577 DEBUG [RolapCube] RolapCube.getUsages: name=Marital Status
- 16:26:37,578 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Marital Status"
- 16:26:37,578 DEBUG [RolapCube] RolapCube<init>: dimension=Product
- 16:26:37,578 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,578 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Product"
- 16:26:37,579 DEBUG [RolapCube] RolapCube<init>: dimension=Promotion Media
- 16:26:37,579 DEBUG [RolapCube] RolapCube.getUsages: name=Promotion Media
- 16:26:37,579 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Promotion Media"
- 16:26:37,580 DEBUG [RolapCube] RolapCube<init>: dimension=Promotions
- 16:26:37,580 DEBUG [RolapCube] RolapCube.getUsages: name=Promotions
- 16:26:37,580 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Promotions"
- 16:26:37,581 DEBUG [RolapCube] RolapCube<init>: dimension=Store
- 16:26:37,581 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,581 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Store"
- 16:26:37,582 DEBUG [RolapCube] RolapCube<init>: dimension=Time
- 16:26:37,582 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,582 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Time"
- 16:26:37,582 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,582 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Time.Weekly"
- 16:26:37,583 DEBUG [RolapCube] RolapCube<init>: dimension=Yearly Income
- 16:26:37,583 DEBUG [RolapCube] RolapCube.getUsages: name=Yearly Income
- 16:26:37,583 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Yearly Income"
- 16:26:37,584 DEBUG [RolapCube] RolapCube<init>: dimension=Warehouse
- 16:26:37,584 DEBUG [RolapCube] RolapCube.getUsages: name=Warehouse
- 16:26:37,584 DEBUG [RolapCube] RolapCube.registerDimension: hierarchyUsages == null for cube="Warehouse and Sales", hierarchy="Warehouse"
- 16:26:37,588 DEBUG [RolapSchema] Normal cardinality for [Measures]
- 16:26:37,588 DEBUG [RolapSchema] Normal cardinality for [Customers]
- 16:26:37,588 DEBUG [RolapSchema] Normal cardinality for [Customers]
- 16:26:37,589 DEBUG [RolapSchema] Normal cardinality for [Education Level]
- 16:26:37,589 DEBUG [RolapSchema] Normal cardinality for [Education Level]
- 16:26:37,589 DEBUG [RolapSchema] Normal cardinality for [Gender]
- 16:26:37,589 DEBUG [RolapSchema] Normal cardinality for [Gender]
- 16:26:37,589 DEBUG [RolapSchema] Normal cardinality for [Marital Status]
- 16:26:37,589 DEBUG [RolapSchema] Normal cardinality for [Marital Status]
- 16:26:37,589 DEBUG [RolapSchema] Normal cardinality for [Product]
- 16:26:37,589 DEBUG [RolapSchema] Normal cardinality for [Product]
- 16:26:37,589 DEBUG [RolapSchema] Normal cardinality for [Promotion Media]
- 16:26:37,590 DEBUG [Util] Util.lookupCompound: parent.name=Promotion Media, category=member, names=[All Media]
- 16:26:37,590 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Promotion Media, childname=[All Media] returning elementname=All Media
- 16:26:37,590 DEBUG [Util] Util.lookupCompound: found child.name=All Media, child.class=mondrian.rolap.RolapMemberBase
- 16:26:37,590 DEBUG [RolapSchema] Normal cardinality for [Promotion Media]
- 16:26:37,590 DEBUG [RolapSchema] Normal cardinality for [Promotions]
- 16:26:37,590 DEBUG [Util] Util.lookupCompound: parent.name=Promotions, category=member, names=[All Promotions]
- 16:26:37,590 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Promotions, childname=[All Promotions] returning elementname=All Promotions
- 16:26:37,590 DEBUG [Util] Util.lookupCompound: found child.name=All Promotions, child.class=mondrian.rolap.RolapMemberBase
- 16:26:37,590 DEBUG [RolapSchema] Normal cardinality for [Promotions]
- 16:26:37,591 DEBUG [RolapSchema] Normal cardinality for [Store]
- 16:26:37,591 DEBUG [RolapSchema] Normal cardinality for [Store]
- 16:26:37,591 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,591 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,591 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,591 DEBUG [RolapSchema] Normal cardinality for [Time]
- 16:26:37,591 DEBUG [RolapSchema] Normal cardinality for [Yearly Income]
- 16:26:37,591 DEBUG [RolapSchema] Normal cardinality for [Yearly Income]
- 16:26:37,591 DEBUG [RolapSchema] Normal cardinality for [Warehouse]
- 16:26:37,592 DEBUG [RolapSchema] Normal cardinality for [Warehouse]
- 16:26:37,593 DEBUG [RolapConnection]
- WITH
- MEMBER [Measures].[Measures].[Profit]
- AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
- FORMAT_STRING = "$#,##0.00",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 9
- MEMBER [Measures].[Measures].[Profit Growth]
- AS '([Measures].[Profit] - [Measures].[Profit last Period]) / [Measures].[Profit last Period]',
- FORMAT_STRING = "0.0%",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 10
- SELECT FROM [Sales]
- 16:26:37,594 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,594 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,594 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,594 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,595 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=unknown, names=[Measures].[Store Sales]
- 16:26:37,595 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,595 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Store Sales] returning elementname=Store Sales
- 16:26:37,595 DEBUG [Util] Util.lookupCompound: found child.name=Store Sales, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,595 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=unknown, names=[Measures].[Store Cost]
- 16:26:37,595 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,595 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Store Cost] returning elementname=Store Cost
- 16:26:37,595 DEBUG [Util] Util.lookupCompound: found child.name=Store Cost, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,596 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=unknown, names=[Measures].[Profit last Period]
- 16:26:37,596 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=unknown, names=[Measures].[Profit last Period]
- 16:26:37,596 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,597 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,598 DEBUG [RolapConnection]
- WITH
- MEMBER [Measures].[Measures].[Profit]
- AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
- FORMAT_STRING = "$#,##0.00",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 2
- SELECT FROM [Warehouse and Sales]
- 16:26:37,598 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,598 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,599 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Store Sales]
- 16:26:37,599 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,599 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Store Sales] returning elementname=Store Sales
- 16:26:37,599 DEBUG [Util] Util.lookupCompound: found child.name=Store Sales, child.class=mondrian.rolap.RolapVirtualCubeMeasure
- 16:26:37,599 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Store Cost]
- 16:26:37,599 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,599 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Store Cost] returning elementname=Store Cost
- 16:26:37,599 DEBUG [Util] Util.lookupCompound: found child.name=Store Cost, child.class=mondrian.rolap.RolapVirtualCubeMeasure
- 16:26:37,599 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,599 DEBUG [RolapCube] RolapCube.getUsages: name=Customers
- 16:26:37,599 DEBUG [RolapCube] RolapCube.getUsages: name=Education Level
- 16:26:37,600 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,600 DEBUG [RolapCube] RolapCube.getUsages: name=Marital Status
- 16:26:37,600 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,600 DEBUG [RolapCube] RolapCube.getUsages: name=Promotion Media
- 16:26:37,600 DEBUG [RolapCube] RolapCube.getUsages: name=Promotions
- 16:26:37,600 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,600 DEBUG [sql] 4: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC]
- 16:26:37,601 DEBUG [sql] 4: , exec 1 ms
- 16:26:37,601 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec 1 ms
- 16:26:37,601 DEBUG [sql] 4: , exec+fetch 1 ms, 2 rows
- 16:26:37,601 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: done executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec+fetch 1 ms, 2 rows
- 16:26:37,601 DEBUG [sql] 5: SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC]
- 16:26:37,602 DEBUG [sql] 5: , exec 1 ms
- 16:26:37,602 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec 1 ms
- 16:26:37,602 DEBUG [sql] 5: , exec+fetch 1 ms, 2 rows
- 16:26:37,602 DEBUG [RolapUtil] SqlTupleReader.readTuples [[Time].[Year]]: done executing sql [select "time_by_day"."the_year" as "c0" from "time_by_day" as "time_by_day" group by "time_by_day"."the_year" order by CASE WHEN "time_by_day"."the_year" IS NULL THEN 1 ELSE 0 END, "time_by_day"."the_year" ASC], exec+fetch 1 ms, 2 rows
- 16:26:37,602 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Yearly Income
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Warehouse
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Customers
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Education Level
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Marital Status
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Promotion Media
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Promotions
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Yearly Income
- 16:26:37,603 DEBUG [RolapCube] RolapCube.getUsages: name=Warehouse
- 16:26:37,604 DEBUG [RolapConnection]
- WITH
- MEMBER [Measures].[Measures].[Profit last Period]
- AS 'COALESCEEMPTY((Measures.[Profit], [Time].[Time].PREVMEMBER), Measures.[Profit])',
- FORMAT_STRING = "$#,##0.00",
- MEMBER_ORDINAL = 18,
- [$member_scope] = 'CUBE'
- SELECT FROM [Warehouse and Sales]
- 16:26:37,604 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,605 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,605 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Profit]
- 16:26:37,605 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Time].[Time]
- 16:26:37,605 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Time], status=hierUsage == null returning elementname=Time
- 16:26:37,605 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Time, childname=[Time] returning null
- 16:26:37,605 DEBUG [Util] Util.lookupCompound: found child.name=Time, child.class=mondrian.rolap.RolapCubeHierarchy
- 16:26:37,606 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Profit]
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Customers
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Education Level
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Marital Status
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Promotion Media
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Promotions
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,606 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Yearly Income
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Warehouse
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Customers
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Education Level
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Marital Status
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Promotion Media
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Promotions
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,607 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,608 DEBUG [RolapCube] RolapCube.getUsages: name=Yearly Income
- 16:26:37,608 DEBUG [RolapCube] RolapCube.getUsages: name=Warehouse
- 16:26:37,608 DEBUG [RolapConnection]
- WITH
- MEMBER [Measures].[Measures].[Average Warehouse Sale]
- AS '[Measures].[Warehouse Sales] / [Measures].[Warehouse Cost]',
- FORMAT_STRING = "$#,##0.00",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 9
- SELECT FROM [Warehouse]
- 16:26:37,608 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse, childname=[Measures] returning elementname=Measures
- 16:26:37,609 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,609 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse, category=unknown, names=[Measures].[Warehouse Sales]
- 16:26:37,609 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse, childname=[Measures] returning elementname=Measures
- 16:26:37,609 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Warehouse Sales] returning elementname=Warehouse Sales
- 16:26:37,609 DEBUG [Util] Util.lookupCompound: found child.name=Warehouse Sales, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,609 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse, category=unknown, names=[Measures].[Warehouse Cost]
- 16:26:37,609 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse, childname=[Measures] returning elementname=Measures
- 16:26:37,609 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Warehouse Cost] returning elementname=Warehouse Cost
- 16:26:37,609 DEBUG [Util] Util.lookupCompound: found child.name=Warehouse Cost, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,610 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,610 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,610 DEBUG [RolapConnection]
- WITH
- MEMBER [Measures].[Measures].[Profit]
- AS '[Measures].[Store Sales] - [Measures].[Store Cost]',
- FORMAT_STRING = "$#,##0.00",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 15
- MEMBER [Measures].[Measures].[Profit Growth]
- AS '([Measures].[Profit] - [Measures].[Profit last Period]) / [Measures].[Profit last Period]',
- FORMAT_STRING = "0.0%",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 16
- MEMBER [Measures].[Measures].[Average Warehouse Sale]
- AS '[Measures].[Warehouse Sales] / [Measures].[Warehouse Cost]',
- FORMAT_STRING = "$#,##0.00",
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 17
- MEMBER [Measures].[Measures].[Profit Per Unit Shipped]
- AS '[Measures].[Profit] / [Measures].[Units Shipped]',
- [$member_scope] = 'CUBE',
- MEMBER_ORDINAL = 18
- SELECT FROM [Warehouse and Sales]
- 16:26:37,612 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,613 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,613 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,614 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,614 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,614 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,614 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,615 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Measures] returning null
- 16:26:37,615 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Store Sales]
- 16:26:37,615 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,616 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Store Sales] returning elementname=Store Sales
- 16:26:37,616 DEBUG [Util] Util.lookupCompound: found child.name=Store Sales, child.class=mondrian.rolap.RolapVirtualCubeMeasure
- 16:26:37,616 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Store Cost]
- 16:26:37,616 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,616 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Store Cost] returning elementname=Store Cost
- 16:26:37,616 DEBUG [Util] Util.lookupCompound: found child.name=Store Cost, child.class=mondrian.rolap.RolapVirtualCubeMeasure
- 16:26:37,617 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Profit last Period]
- 16:26:37,618 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Profit last Period]
- 16:26:37,618 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Warehouse Sales]
- 16:26:37,618 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,619 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Warehouse Sales] returning elementname=Warehouse Sales
- 16:26:37,619 DEBUG [Util] Util.lookupCompound: found child.name=Warehouse Sales, child.class=mondrian.rolap.RolapVirtualCubeMeasure
- 16:26:37,619 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Warehouse Cost]
- 16:26:37,619 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,620 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Warehouse Cost] returning elementname=Warehouse Cost
- 16:26:37,620 DEBUG [Util] Util.lookupCompound: found child.name=Warehouse Cost, child.class=mondrian.rolap.RolapVirtualCubeMeasure
- 16:26:37,620 DEBUG [Util] Util.lookupCompound: parent.name=Warehouse and Sales, category=unknown, names=[Measures].[Units Shipped]
- 16:26:37,620 DEBUG [RolapCube] RolapCube.lookupChild: name=Warehouse and Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,621 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Units Shipped] returning elementname=Units Shipped
- 16:26:37,621 DEBUG [Util] Util.lookupCompound: found child.name=Units Shipped, child.class=mondrian.rolap.RolapVirtualCubeMeasure
- 16:26:37,621 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,621 DEBUG [RolapCube] RolapCube.getUsages: name=Customers
- 16:26:37,621 DEBUG [RolapCube] RolapCube.getUsages: name=Education Level
- 16:26:37,621 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,622 DEBUG [RolapCube] RolapCube.getUsages: name=Marital Status
- 16:26:37,622 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,622 DEBUG [RolapCube] RolapCube.getUsages: name=Promotion Media
- 16:26:37,622 DEBUG [RolapCube] RolapCube.getUsages: name=Promotions
- 16:26:37,622 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,622 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,622 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,622 DEBUG [RolapCube] RolapCube.getUsages: name=Yearly Income
- 16:26:37,622 DEBUG [RolapCube] RolapCube.getUsages: name=Warehouse
- 16:26:37,623 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,623 DEBUG [RolapCube] RolapCube.getUsages: name=Customers
- 16:26:37,623 DEBUG [RolapCube] RolapCube.getUsages: name=Education Level
- 16:26:37,623 DEBUG [RolapCube] RolapCube.getUsages: name=Gender
- 16:26:37,624 DEBUG [RolapCube] RolapCube.getUsages: name=Marital Status
- 16:26:37,624 DEBUG [RolapCube] RolapCube.getUsages: name=Product
- 16:26:37,624 DEBUG [RolapCube] RolapCube.getUsages: name=Promotion Media
- 16:26:37,624 DEBUG [RolapCube] RolapCube.getUsages: name=Promotions
- 16:26:37,624 DEBUG [RolapCube] RolapCube.getUsages: name=Store
- 16:26:37,624 DEBUG [RolapCube] RolapCube.getUsages: name=Time
- 16:26:37,624 DEBUG [RolapCube] RolapCube.getUsages: name=Time.Weekly
- 16:26:37,624 DEBUG [RolapCube] RolapCube.getUsages: name=Yearly Income
- 16:26:37,624 DEBUG [RolapCube] RolapCube.getUsages: name=Warehouse
- 16:26:37,625 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=hierarchy, names=[Store]
- 16:26:37,625 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Store], status=hierUsage == shared returning elementname=Store
- 16:26:37,625 DEBUG [Util] Util.lookupCompound: found child.name=Store, child.class=mondrian.rolap.RolapCubeDimension
- 16:26:37,625 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=level, names=[Store].[Store Country]
- 16:26:37,625 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Store], status=hierUsage == shared returning elementname=Store
- 16:26:37,626 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Store, childname=[Store Country] returning elementname=Store Country
- 16:26:37,626 DEBUG [Util] Util.lookupCompound: found child.name=Store Country, child.class=mondrian.rolap.RolapCubeLevel
- 16:26:37,626 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=member, names=[Store].[USA].[CA]
- 16:26:37,626 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Store], status=hierUsage == shared returning elementname=Store
- 16:26:37,626 DEBUG [RolapSchemaReader] looking for child "[USA]" of [Store].[All Stores]
- 16:26:37,628 DEBUG [sql] 6: SqlMemberSource.getMemberChildren: executing sql [select "store"."store_country" as "c0" from "store" as "store" where UPPER("store"."store_country") = UPPER('USA') group by "store"."store_country" order by CASE WHEN "store"."store_country" IS NULL THEN 1 ELSE 0 END, "store"."store_country" ASC]
- 16:26:37,663 DEBUG [sql] 6: , exec 35 ms
- 16:26:37,663 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: executing sql [select "store"."store_country" as "c0" from "store" as "store" where UPPER("store"."store_country") = UPPER('USA') group by "store"."store_country" order by CASE WHEN "store"."store_country" IS NULL THEN 1 ELSE 0 END, "store"."store_country" ASC], exec 35 ms
- 16:26:37,664 DEBUG [sql] 6: , exec+fetch 36 ms, 1 rows
- 16:26:37,664 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: done executing sql [select "store"."store_country" as "c0" from "store" as "store" where UPPER("store"."store_country") = UPPER('USA') group by "store"."store_country" order by CASE WHEN "store"."store_country" IS NULL THEN 1 ELSE 0 END, "store"."store_country" ASC], exec+fetch 36 ms, 1 rows
- 16:26:37,664 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Store, childname=[USA] returning elementname=USA
- 16:26:37,665 DEBUG [RolapSchemaReader] looking for child "[CA]" of [Store].[USA]
- 16:26:37,666 DEBUG [sql] 7: SqlMemberSource.getMemberChildren: executing sql [select "store"."store_state" as "c0" from "store" as "store" where ("store"."store_country" = 'USA') and UPPER("store"."store_state") = UPPER('CA') group by "store"."store_state" order by CASE WHEN "store"."store_state" IS NULL THEN 1 ELSE 0 END, "store"."store_state" ASC]
- 16:26:37,674 DEBUG [sql] 7: , exec 8 ms
- 16:26:37,674 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: executing sql [select "store"."store_state" as "c0" from "store" as "store" where ("store"."store_country" = 'USA') and UPPER("store"."store_state") = UPPER('CA') group by "store"."store_state" order by CASE WHEN "store"."store_state" IS NULL THEN 1 ELSE 0 END, "store"."store_state" ASC], exec 8 ms
- 16:26:37,675 DEBUG [sql] 7: , exec+fetch 9 ms, 1 rows
- 16:26:37,675 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: done executing sql [select "store"."store_state" as "c0" from "store" as "store" where ("store"."store_country" = 'USA') and UPPER("store"."store_state") = UPPER('CA') group by "store"."store_state" order by CASE WHEN "store"."store_state" IS NULL THEN 1 ELSE 0 END, "store"."store_state" ASC], exec+fetch 9 ms, 1 rows
- 16:26:37,675 DEBUG [Util] Util.lookupCompound: found child.name=CA, child.class=mondrian.rolap.RolapCubeMember
- 16:26:37,675 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=member, names=[Store].[USA].[CA].[Los Angeles]
- 16:26:37,675 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Store], status=hierUsage == shared returning elementname=Store
- 16:26:37,675 DEBUG [RolapSchemaReader] looking for child "[USA]" of [Store].[All Stores]
- 16:26:37,676 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Store, childname=[USA] returning elementname=USA
- 16:26:37,676 DEBUG [RolapSchemaReader] looking for child "[CA]" of [Store].[USA]
- 16:26:37,676 DEBUG [RolapSchemaReader] looking for child "[Los Angeles]" of [Store].[USA].[CA]
- 16:26:37,676 DEBUG [sql] 8: SqlMemberSource.getMemberChildren: executing sql [select "store"."store_city" as "c0" from "store" as "store" where ("store"."store_state" = 'CA') and UPPER("store"."store_city") = UPPER('Los Angeles') group by "store"."store_city" order by CASE WHEN "store"."store_city" IS NULL THEN 1 ELSE 0 END, "store"."store_city" ASC]
- 16:26:37,678 DEBUG [sql] 8: , exec 2 ms
- 16:26:37,679 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: executing sql [select "store"."store_city" as "c0" from "store" as "store" where ("store"."store_state" = 'CA') and UPPER("store"."store_city") = UPPER('Los Angeles') group by "store"."store_city" order by CASE WHEN "store"."store_city" IS NULL THEN 1 ELSE 0 END, "store"."store_city" ASC], exec 2 ms
- 16:26:37,679 DEBUG [sql] 8: , exec+fetch 3 ms, 1 rows
- 16:26:37,679 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: done executing sql [select "store"."store_city" as "c0" from "store" as "store" where ("store"."store_state" = 'CA') and UPPER("store"."store_city") = UPPER('Los Angeles') group by "store"."store_city" order by CASE WHEN "store"."store_city" IS NULL THEN 1 ELSE 0 END, "store"."store_city" ASC], exec+fetch 3 ms, 1 rows
- 16:26:37,679 DEBUG [Util] Util.lookupCompound: found child.name=Los Angeles, child.class=mondrian.rolap.RolapCubeMember
- 16:26:37,679 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=hierarchy, names=[Customers]
- 16:26:37,680 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Customers], status=hierUsage == not shared returning elementname=Customers
- 16:26:37,680 DEBUG [Util] Util.lookupCompound: found child.name=Customers, child.class=mondrian.rolap.RolapCubeDimension
- 16:26:37,680 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=level, names=[Customers].[State Province]
- 16:26:37,680 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Customers], status=hierUsage == not shared returning elementname=Customers
- 16:26:37,680 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Customers, childname=[State Province] returning elementname=State Province
- 16:26:37,680 DEBUG [Util] Util.lookupCompound: found child.name=State Province, child.class=mondrian.rolap.RolapCubeLevel
- 16:26:37,680 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=level, names=[Customers].[City]
- 16:26:37,680 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Customers], status=hierUsage == not shared returning elementname=Customers
- 16:26:37,680 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Customers, childname=[City] returning elementname=City
- 16:26:37,680 DEBUG [Util] Util.lookupCompound: found child.name=City, child.class=mondrian.rolap.RolapCubeLevel
- 16:26:37,681 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=member, names=[Customers].[USA].[CA]
- 16:26:37,681 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Customers], status=hierUsage == not shared returning elementname=Customers
- 16:26:37,681 DEBUG [RolapSchemaReader] looking for child "[USA]" of [Customers].[All Customers]
- 16:26:37,681 DEBUG [sql] 9: SqlMemberSource.getMemberChildren: executing sql [select "customer"."country" as "c0" from "customer" as "customer" where UPPER("customer"."country") = UPPER('USA') group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC]
- 16:26:37,703 DEBUG [sql] 9: , exec 22 ms
- 16:26:37,703 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: executing sql [select "customer"."country" as "c0" from "customer" as "customer" where UPPER("customer"."country") = UPPER('USA') group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC], exec 22 ms
- 16:26:37,703 DEBUG [sql] 9: , exec+fetch 22 ms, 1 rows
- 16:26:37,703 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: done executing sql [select "customer"."country" as "c0" from "customer" as "customer" where UPPER("customer"."country") = UPPER('USA') group by "customer"."country" order by CASE WHEN "customer"."country" IS NULL THEN 1 ELSE 0 END, "customer"."country" ASC], exec+fetch 22 ms, 1 rows
- 16:26:37,703 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Customers, childname=[USA] returning elementname=USA
- 16:26:37,703 DEBUG [RolapSchemaReader] looking for child "[CA]" of [Customers].[USA]
- 16:26:37,704 DEBUG [sql] 10: SqlMemberSource.getMemberChildren: executing sql [select "customer"."state_province" as "c0" from "customer" as "customer" where ("customer"."country" = 'USA') and UPPER("customer"."state_province") = UPPER('CA') group by "customer"."state_province" order by CASE WHEN "customer"."state_province" IS NULL THEN 1 ELSE 0 END, "customer"."state_province" ASC]
- 16:26:37,726 DEBUG [sql] 10: , exec 22 ms
- 16:26:37,727 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: executing sql [select "customer"."state_province" as "c0" from "customer" as "customer" where ("customer"."country" = 'USA') and UPPER("customer"."state_province") = UPPER('CA') group by "customer"."state_province" order by CASE WHEN "customer"."state_province" IS NULL THEN 1 ELSE 0 END, "customer"."state_province" ASC], exec 22 ms
- 16:26:37,727 DEBUG [sql] 10: , exec+fetch 23 ms, 1 rows
- 16:26:37,728 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: done executing sql [select "customer"."state_province" as "c0" from "customer" as "customer" where ("customer"."country" = 'USA') and UPPER("customer"."state_province") = UPPER('CA') group by "customer"."state_province" order by CASE WHEN "customer"."state_province" IS NULL THEN 1 ELSE 0 END, "customer"."state_province" ASC], exec+fetch 23 ms, 1 rows
- 16:26:37,728 DEBUG [Util] Util.lookupCompound: found child.name=CA, child.class=mondrian.rolap.RolapCubeMember
- 16:26:37,728 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=member, names=[Customers].[USA].[CA].[Los Angeles]
- 16:26:37,729 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Customers], status=hierUsage == not shared returning elementname=Customers
- 16:26:37,729 DEBUG [RolapSchemaReader] looking for child "[USA]" of [Customers].[All Customers]
- 16:26:37,730 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Customers, childname=[USA] returning elementname=USA
- 16:26:37,730 DEBUG [RolapSchemaReader] looking for child "[CA]" of [Customers].[USA]
- 16:26:37,730 DEBUG [RolapSchemaReader] looking for child "[Los Angeles]" of [Customers].[USA].[CA]
- 16:26:37,731 DEBUG [sql] 11: SqlMemberSource.getMemberChildren: executing sql [select "customer"."city" as "c0" from "customer" as "customer" where ("customer"."state_province" = 'CA') and UPPER("customer"."city") = UPPER('Los Angeles') group by "customer"."city" order by CASE WHEN "customer"."city" IS NULL THEN 1 ELSE 0 END, "customer"."city" ASC]
- 16:26:37,738 DEBUG [sql] 11: , exec 7 ms
- 16:26:37,738 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: executing sql [select "customer"."city" as "c0" from "customer" as "customer" where ("customer"."state_province" = 'CA') and UPPER("customer"."city") = UPPER('Los Angeles') group by "customer"."city" order by CASE WHEN "customer"."city" IS NULL THEN 1 ELSE 0 END, "customer"."city" ASC], exec 7 ms
- 16:26:37,738 DEBUG [sql] 11: , exec+fetch 7 ms, 1 rows
- 16:26:37,738 DEBUG [RolapUtil] SqlMemberSource.getMemberChildren: done executing sql [select "customer"."city" as "c0" from "customer" as "customer" where ("customer"."state_province" = 'CA') and UPPER("customer"."city") = UPPER('Los Angeles') group by "customer"."city" order by CASE WHEN "customer"."city" IS NULL THEN 1 ELSE 0 END, "customer"."city" ASC], exec+fetch 7 ms, 1 rows
- 16:26:37,738 DEBUG [Util] Util.lookupCompound: found child.name=Los Angeles, child.class=mondrian.rolap.RolapCubeMember
- 16:26:37,738 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=hierarchy, names=[Gender]
- 16:26:37,738 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Gender], status=hierUsage == not shared returning elementname=Gender
- 16:26:37,738 DEBUG [Util] Util.lookupCompound: found child.name=Gender, child.class=mondrian.rolap.RolapCubeDimension
- 16:26:37,746 DEBUG [AggTableManager]
- RolapStar:
- Table:
- alias=store
- relation=store
- Columns:
- Store Type (0): "store"."store_type"
- Store Country (1): "store"."store_country"
- Store State (2): "store"."store_state"
- Store City (3): "store"."store_city"
- Store Name (4): "store"."store_name"
- Has coffee bar (5): "store"."coffee_bar"
- Store Sqft (6): sum("store"."store_sqft")
- Grocery Sqft (7): sum("store"."grocery_sqft")
- Fact Count (8): count(null)
- RolapStar:
- Table:
- alias=inventory_fact_1997
- relation=inventory_fact_1997
- Columns:
- Store Invoice (21): sum("inventory_fact_1997"."store_invoice")
- Supply Time (22): sum("inventory_fact_1997"."supply_time")
- Warehouse Cost (23): sum("inventory_fact_1997"."warehouse_cost")
- Warehouse Sales (24): sum("inventory_fact_1997"."warehouse_sales")
- Units Shipped (25): sum("inventory_fact_1997"."units_shipped")
- Units Ordered (26): sum("inventory_fact_1997"."units_ordered")
- Warehouse Profit (27): sum("warehouse_sales" - "inventory_fact_1997"."warehouse_cost")
- Fact Count (28): count(null)
- Table:
- alias=store
- relation=store
- Columns:
- Store Country (0): "store"."store_country"
- Store State (1): "store"."store_state"
- Store City (2): "store"."store_city"
- Store Name (3): "store"."store_name"
- Store Sqft (4): "store"."store_sqft"
- Store Type (5): "store"."store_type"
- Condition:
- left="inventory_fact_1997"."store_id"
- right="store"."store_id"
- Table:
- alias=time_by_day
- relation=time_by_day
- Columns:
- Year (6): "time_by_day"."the_year"
- Quarter (7): "time_by_day"."quarter"
- Month (8): "time_by_day"."month_of_year"
- Week (9): "time_by_day"."week_of_year"
- Day (10): "time_by_day"."day_of_month"
- Condition:
- left="inventory_fact_1997"."time_id"
- right="time_by_day"."time_id"
- Table:
- alias=product
- relation=product
- Columns:
- Brand Name (15): "product"."brand_name"
- Product Name (16): "product"."product_name"
- Condition:
- left="inventory_fact_1997"."product_id"
- right="product"."product_id"
- Table:
- alias=product_class
- relation=product_class
- Columns:
- Product Family (11): "product_class"."product_family"
- Product Department (12): "product_class"."product_department"
- Product Category (13): "product_class"."product_category"
- Product Subcategory (14): "product_class"."product_subcategory"
- Condition:
- left="product"."product_class_id"
- right="product_class"."product_class_id"
- Table:
- alias=warehouse
- relation=warehouse
- Columns:
- Country (17): "warehouse"."warehouse_country"
- State Province (18): "warehouse"."warehouse_state_province"
- City (19): "warehouse"."warehouse_city"
- Warehouse Name (20): "warehouse"."warehouse_name"
- Condition:
- left="inventory_fact_1997"."warehouse_id"
- right="warehouse"."warehouse_id"
- RolapStar:
- Table:
- alias=sales_fact_1997
- relation=sales_fact_1997
- Columns:
- Unit Sales (28): sum("sales_fact_1997"."unit_sales")
- Store Cost (29): sum("sales_fact_1997"."store_cost")
- Store Sales (30): sum("sales_fact_1997"."store_sales")
- Sales Count (31): count("sales_fact_1997"."product_id")
- Customer Count (32): count(distinct "sales_fact_1997"."customer_id")
- Promotion Sales (33): sum((case when sales_fact_1997.promotion_id = 0 then 0 else sales_fact_1997.store_sales end))
- Unit Sales (39): sum("sales_fact_1997"."unit_sales")
- Store Cost (40): sum("sales_fact_1997"."store_cost")
- Store Sales (41): sum("sales_fact_1997"."store_sales")
- Sales Count (42): count("sales_fact_1997"."product_id")
- Customer Count (43): count(distinct "sales_fact_1997"."customer_id")
- Sales Count (44): count("sales_fact_1997"."product_id")
- Unit Sales (45): sum("sales_fact_1997"."unit_sales")
- Store Sales (46): sum("sales_fact_1997"."store_sales")
- Store Cost (47): sum("sales_fact_1997"."store_cost")
- Customer Count (48): count(distinct "sales_fact_1997"."customer_id")
- Table:
- alias=store
- relation=store
- Columns:
- Store Country (0): "store"."store_country"
- Store State (1): "store"."store_state"
- Store City (2): "store"."store_city"
- Store Name (3): "store"."store_name"
- Store Sqft (4): "store"."store_sqft"
- Store Type (5): "store"."store_type"
- Condition:
- left="sales_fact_1997"."store_id"
- right="store"."store_id"
- Table:
- alias=time_by_day
- relation=time_by_day
- Columns:
- Year (6): "time_by_day"."the_year"
- Quarter (7): "time_by_day"."quarter"
- Month (8): "time_by_day"."month_of_year"
- Week (9): "time_by_day"."week_of_year"
- Day (10): "time_by_day"."day_of_month"
- Condition:
- left="sales_fact_1997"."time_id"
- right="time_by_day"."time_id"
- Table:
- alias=product
- relation=product
- Columns:
- Brand Name (15): "product"."brand_name"
- Product Name (16): "product"."product_name"
- Condition:
- left= (31) "sales_fact_1997"."product_id"
- right="product"."product_id"
- Table:
- alias=product_class
- relation=product_class
- Columns:
- Product Family (11): "product_class"."product_family"
- Product Department (12): "product_class"."product_department"
- Product Category (13): "product_class"."product_category"
- Product Subcategory (14): "product_class"."product_subcategory"
- Condition:
- left="product"."product_class_id"
- right="product_class"."product_class_id"
- Table:
- alias=promotion
- relation=promotion
- Columns:
- Media Type (17): "promotion"."media_type"
- Promotion Name (18): "promotion"."promotion_name"
- Condition:
- left="sales_fact_1997"."promotion_id"
- right="promotion"."promotion_id"
- Table:
- alias=customer
- relation=customer
- Columns:
- Country (19): "customer"."country"
- State Province (20): "customer"."state_province"
- City (21): "customer"."city"
- Name (22): fullname
- Name (Key) (23): "customer"."customer_id"
- Education Level (24): "customer"."education"
- Gender (25): "customer"."gender"
- Marital Status (26): "customer"."marital_status"
- Yearly Income (27): "customer"."yearly_income"
- Name (38): fullname
- Condition:
- left= (32) "sales_fact_1997"."customer_id"
- right="customer"."customer_id"
- Table:
- alias=store_ragged
- relation=store_ragged
- Columns:
- Store Country (34): "store_ragged"."store_country"
- Store State (35): "store_ragged"."store_state"
- Store City (36): "store_ragged"."store_city"
- Store Name (37): "store_ragged"."store_name"
- Condition:
- left="sales_fact_1997"."store_id"
- right="store_ragged"."store_id"
- RolapStar:
- Table:
- alias=salary
- relation=salary
- Columns:
- Org Salary (17): sum("salary"."salary_paid")
- Count (18): count("salary"."employee_id")
- Number of Employees (19): count(distinct "salary"."employee_id")
- Table:
- alias=time_by_day
- relation=time_by_day
- Columns:
- Year (0): "time_by_day"."the_year"
- Quarter (1): "time_by_day"."quarter"
- Month (2): "time_by_day"."the_month"
- Month (Key) (3): "time_by_day"."month_of_year"
- Condition:
- left="salary"."pay_date"
- right="time_by_day"."the_date"
- Table:
- alias=employee
- relation=employee
- Columns:
- Management Role (10): "employee"."management_role"
- Position Title (11): "employee"."position_title"
- Employee Id (13): "employee"."full_name"
- Employee Id (Key) (14): "employee"."employee_id"
- Condition:
- left= (18) "salary"."employee_id"
- right="employee"."employee_id"
- Table:
- alias=store
- relation=store
- Columns:
- Store Country (4): "store"."store_country"
- Store State (5): "store"."store_state"
- Store City (6): "store"."store_city"
- Store Name (7): "store"."store_name"
- Store Type (9): "store"."store_type"
- Condition:
- left="employee"."store_id"
- right="store"."store_id"
- Table:
- alias=position
- relation=position
- Columns:
- Pay Type (8): "position"."pay_type"
- Condition:
- left="employee"."position_id"
- right="position"."position_id"
- Table:
- alias=department
- relation=department
- Columns:
- Department Description (12): "department"."department_id"
- Condition:
- left="salary"."department_id"
- right="department"."department_id"
- Table:
- alias=employee_closure
- relation=employee_closure
- Columns:
- Closure (15): "employee_closure"."supervisor_id"
- Item (16): "employee_closure"."employee_id"
- Condition:
- left= (18) "salary"."employee_id"
- right="employee_closure"."employee_id"
- Table:
- alias=employee_1
- relation=employee
- Columns:
- Condition:
- left="employee_closure"."supervisor_id"
- right="employee_1"."employee_id"
- 16:26:37,747 DEBUG [RolapSchema] Pool.get: create schema "FoodMart.xml"
- 16:26:37,785 DEBUG [RolapConnection]
- SELECT [Measures].[Unit Sales] on COLUMNS FROM [Sales]
- 16:26:37,786 DEBUG [Util] Util.lookupCompound: parent.name=Sales, category=unknown, names=[Measures].[Unit Sales]
- 16:26:37,786 DEBUG [RolapCube] RolapCube.lookupChild: name=Sales, childname=[Measures] returning elementname=Measures
- 16:26:37,787 DEBUG [RolapHierarchy] HierarchyBase.lookupChild: name=Measures, childname=[Unit Sales] returning elementname=Unit Sales
- 16:26:37,787 DEBUG [Util] Util.lookupCompound: found child.name=Unit Sales, child.class=mondrian.rolap.RolapBaseCubeMeasure
- 16:26:37,788 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,815 DEBUG [RolapConnection] select {[Measures].[Unit Sales]} ON COLUMNS
- from [Sales]
- 16:26:37,815 DEBUG [mdx] 118: select {[Measures].[Unit Sales]} ON COLUMNS
- from [Sales]
- 16:26:37,815 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,824 DEBUG [FastBatchingCellReader] FastBatchingCellReader: bitkey=0x0000000000000000000000000000000000000000000000000000000001000000
- Year (6): "time_by_day"."the_year"
- 16:26:37,826 DEBUG [RolapCube] RolapCube.getUsages: name=Measures
- 16:26:37,843 DEBUG [AggregationManager] NO MATCH : sales_fact_1997
- Foreign columns bit key=0x0000000000000000000000000000000000000000000000000000000001000000
- Measure bit key= 0x0000000000000000000000000000000000010000000000000000000000000000
- Agg Stars=[
- ]
- 16:26:37,846 DEBUG [AggregationManager] generateSqlQuery: sql=select "time_by_day"."the_year" as "c0", sum("sales_fact_1997"."unit_sales") as "m0" from "time_by_day" as "time_by_day", "sales_fact_1997" as "sales_fact_1997" where "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 group by "time_by_day"."the_year"
- 16:26:37,847 DEBUG [sql] 12: Segment.load: executing sql [select "time_by_day"."the_year" as "c0", sum("sales_fact_1997"."unit_sales") as "m0" from "time_by_day" as "time_by_day", "sales_fact_1997" as "sales_fact_1997" where "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 group by "time_by_day"."the_year"]
- 16:26:37,949 DEBUG [sql] 12: , exec 80 ms
- 16:26:37,949 DEBUG [RolapUtil] Segment.load: executing sql [select "time_by_day"."the_year" as "c0", sum("sales_fact_1997"."unit_sales") as "m0" from "time_by_day" as "time_by_day", "sales_fact_1997" as "sales_fact_1997" where "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 group by "time_by_day"."the_year"], exec 80 ms
- 16:26:37,976 DEBUG [sql] 12: , exec+fetch 129 ms, 1 rows
- 16:26:37,976 DEBUG [RolapUtil] Segment.load: done executing sql [select "time_by_day"."the_year" as "c0", sum("sales_fact_1997"."unit_sales") as "m0" from "time_by_day" as "time_by_day", "sales_fact_1997" as "sales_fact_1997" where "sales_fact_1997"."time_id" = "time_by_day"."time_id" and "time_by_day"."the_year" = 1997 group by "time_by_day"."the_year"], exec+fetch 129 ms, 1 rows
- 16:26:37,976 DEBUG [FastBatchingCellReader$Batch] Batch.loadAggregation (millis) 146
- 16:26:37,976 DEBUG [FastBatchingCellReader] loadAggregation (millis): 148
- 16:26:37,977 DEBUG [ResultBase] RolapResult<init>: FREE_MEMORY: 82831kb 68.26%
- 16:26:37,979 DEBUG [Execution] mondrian.olap.MondrianException: Mondrian Error:An exception was encountered while trying to cleanup an execution context. A statement failed to cancel gracefully. Locus was : "Error while loading segment".
- java.sql.SQLException: org.apache.commons.dbcp.DelegatingStatement is closed.
- at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:136)
- at org.apache.commons.dbcp.DelegatingStatement.cancel(DelegatingStatement.java:249)
- at mondrian.server.Execution.cleanStatements(Execution.java:147)
- at mondrian.server.Execution.end(Execution.java:168)
- at mondrian.server.StatementImpl.end(StatementImpl.java:98)
- at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:644)
- at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52)
- at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:586)
- at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:585)
- at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
- at java.util.concurrent.FutureTask.run(FutureTask.java:166)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
- at java.lang.Thread.run(Thread.java:722)
- 16:26:37,980 DEBUG [mdx] 118: exec: 165 ms
- Elapsed Time in MilliSeconds: 197
- Elapsed Time in Seconds: 0.197
- Unit Sales
- ==========
- 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement