Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Union report totals are not added together.
I have a union report that has 2 columns with the same value in column 1 and Sales in column 2. The sales are not summed together but showing as 2 separate rows. Why? We are using OIBEE 12.2.1.4. Please let me know what I should be looking at that I am missing.
This should show as 1 line with a TY-MTD value of $650,503 not 2 lines.
Here is the log from the report:
[2019-07-17T10:24:40.999-04:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 6ec] [messageid: USER-0] [requestid: a60003d] [sessionid: a600000] [username: dcsab074] ############################################## [[
-------------------- SQL Request, logical request hash:
ee9d0ef3
SET VARIABLE QUERY_SRC_CD='Report',SAW_SRC_PATH='/users/dcsab074/Report for Paige Sales By Brand',ENABLE_DIMENSIONALITY = 1; SELECT
saw_0,
saw_1
FROM ((SELECT
"- Product Groups"."Level 6" saw_0,
SUM(IFNULL( "- TD Canada Sales Facts Secured"."Total Sales MTD" ,0) BY "- Product Groups"."Level 6") saw_1
FROM "Dentsply BI Cube"
WHERE
("- Product Groups"."Group Division" = 'Canada') AND ("- Product Groups"."Group Type" = '2019 Canada Commission Brand') AND ("Time Period"."Year" IN
(
SELECT saw_0 FROM (SELECT
"Time Period"."Year" saw_0
FROM "Dentsply BI Cube"
) nqw_1
)) AND (Distributor."Distributor Name" = 'Patterson-Canada') AND ("- Product Groups"."Level 1" IN ('CAD CAM Consumables', 'CAD CAM Equipment')) AND ((("Account"."Zipcode (3-digit)" IN ('P0T', 'P0V', 'P0W', 'P0X', 'P7A', 'P7B', 'P7C', 'P7E', 'P7K', 'P7L', 'P8N', 'P8T', 'P9A', 'P9N')) AND ("Position Hierarchy"."FSR" <> 'CC104')) OR (("Account"."Zipcode (3-digit)" IN ('G9B', 'G9N', 'J0Y', 'J0Z', 'J3T', 'J5V')) AND ("Position Hierarchy"."FSR" <> 'CC106')) OR (("Account"."Zipcode (3-digit)" IN ('H4Y', 'J0W')) AND ("Position Hierarchy"."FSR" <> 'CC105')) OR (("Account"."Zipcode (3-digit)" = 'V0A') AND ("Position Hierarchy"."FSR" <> 'CC104')) OR (("Account"."Zipcode (3-digit)" IN ('E1W', 'E1X', 'E2A', 'E3N', 'E3V', 'E3Z', 'E7C', 'E8A', 'E8B', 'E8C', 'E8E', 'E8J', 'E8K', 'E8S', 'E8T')) AND ("Position Hierarchy"."FSR" <> 'CC105')) OR (("Account"."Zipcode (3-digit)" IN ('S0A', 'S0C', 'S0G', 'S0H', 'S0K', 'S0L', 'S0N', 'T0A', 'T0B', 'T0C', 'T0E', 'T0G', 'T0H', 'S0J', 'S3N', 'S4A', 'S4H', 'S4P', 'S4R', 'S4S', 'S4T', 'S4V', 'S4X', 'S4Z')) AND ("Position Hierarchy"."FSR" <> 'CC103')) OR (("Account"."Zipcode (3-digit)" IN ('S6W', 'X0A', 'X0B', 'X0C', 'X0E', 'X1A', 'T4L')) AND ("Position Hierarchy"."FSR" <> 'CC101')) OR (("Account"."Zipcode (3-digit)" NOT IN ('S6W', 'T4L', 'X0A', 'X0B', 'X0C', 'X0E', 'X1A', 'S0A', 'S0C', 'S0G', 'S0H', 'S0K', 'S0L', 'S0N', 'T0A', 'T0B', 'T0C', 'T0E', 'T0G', 'T0H', 'S0J', 'S3N', 'S4A', 'S4H', 'S4P', 'S4R', 'S4S', 'S4T', 'S4V', 'S4X', 'S4Z', 'E1W', 'E1X', 'E2A', 'E3N', 'E3V', 'E3Z', 'E7C', 'E8A', 'E8B', 'E8C', 'E8E', 'E8J', 'E8K', 'E8S', 'E8T', 'P0T', 'P0V', 'P0W', 'P0X', 'P7A', 'P7B', 'P7C', 'P7E', 'P7K', 'P7L', 'P8N', 'P8T', 'P9A', 'P9N', 'V0A', 'H4Y', 'J0W', 'G9B', 'G9N', 'J0Y', 'J0Z', 'J3T', 'J5V')) AND ("Position Hierarchy"."FSR" LIKE 'CC%'))) AND ("- Product Groups"."Level 6" = 'AC OMNICAM CONNECT') AND ("Position Hierarchy"."Position Hierarchy Type" = 'Canada')
) UNION (SELECT
"- Product Groups"."Level 6" saw_0,
SUM(IFNULL( "- TD Canada Sales Facts Secured"."Total Sales MTD" ,0 ) BY "- Product Groups"."Level 6") saw_1
FROM "Dentsply BI Cube"
WHERE
("Time Period"."Year" IN
(
SELECT saw_0 FROM (SELECT
"Time Period"."Year" saw_0
FROM "Dentsply BI Cube"
) nqw_1
)) AND ("- Product Groups"."Group Division" = 'Canada') AND ("- Product Groups"."Group Type" = '2019 Canada Commission Brand') AND ("- Product Groups"."Level 1" IN ('CAD CAM Consumables', 'CAD CAM Equipment')) AND ("Position Hierarchy"."Position Hierarchy Type" = 'Canada') AND ((("Account"."Zipcode (3-digit)" IN ('A0A', 'A0B', 'A0C', 'A0E', 'A0G', 'A0H', 'A0J', 'A0K', 'A0L', 'A0M', 'A0N', 'A0P', 'A0R', 'A1A', 'A1B', 'A1C', 'A1E', 'A1G', 'A1H', 'A1J', 'A1K', 'A1L', 'A1M', 'A1N', 'A1P', 'A1R', 'A1S', 'A1T', 'A1V', 'A1W', 'A1X', 'A1Y', 'A1Z', 'A2A', 'A2B', 'A2C', 'A2E', 'A2G', 'A2H', 'A2J', 'A2K', 'A2L', 'A2M', 'A2N', 'A2P', 'A2R', 'A2S', 'A2T', 'A2V', 'A2W', 'A2X', 'A2Y', 'A2Z', 'A3A', 'A3B', 'A3C', 'A3E', 'A3G', 'A3H', 'A3J', 'A3K', 'A3L', 'A3M', 'A3N', 'A3P', 'A3R', 'A3S', 'A3T', 'A3V', 'A3W', 'A3X', 'A3Y', 'A3Z', 'A4A', 'A4B', 'A4C', 'A4E', 'A4G', 'A4H', 'A4J', 'A4K', 'A4L', 'A4M', 'A4N', 'A4P', 'A4R', 'A4S', 'A4T', 'A4V', 'A4W', 'A4X', 'A4Y', 'A4Z', 'A5A', 'A5B', 'A5C', 'A5E', 'A5G', 'A5H', 'A5J', 'A5K', 'A5L', 'A5M', 'A5N', 'A5P', 'A5R', 'A5S', 'A5T', 'A5V', 'A5W', 'A5X', 'A5Y', 'A5Z', 'A6A', 'A6B', 'A6C', 'A6E', 'A6G', 'A6H', 'A6J', 'A6K', 'A6L', 'A6M', 'A6N', 'A6P', 'A6R', 'A6S', 'A6T', 'A6V', 'A6W', 'A6X', 'A6Y', 'A6Z', 'A7A', 'A7B', 'A7C', 'A7E', 'A7G', 'A7H', 'A7J', 'A7K', 'A7L', 'A7M', 'A7N', 'A7P', 'A7R', 'A7S', 'A7T', 'A7V', 'A7W', 'A7X', 'A7Y', 'A7Z', 'A8A', 'A8B', 'A8C', 'A8E', 'A8G', 'A8H', 'A8J', 'A8K', 'A8L', 'A8M', 'A8N', 'A8P', 'A8R', 'A8S', 'A8T', 'A8V', 'A8W', 'A8X', 'A8Y', 'A8Z', 'A9A', 'A9B', 'A9C', 'A9E', 'A9G', 'A9H', 'A9J', 'A9K', 'A9L', 'A9M', 'A9N', 'A9P', 'A9R', 'A9S', 'A9T', 'A9V', 'B0B', 'B0C', 'B0E', 'B0G', 'B0H', 'B0J', 'B0K', 'B0L', 'B0M', 'B0N', 'B0P', 'B0R', 'B0S', 'B0T', 'B0V', 'B0W', 'B0X', 'B0Y', 'B0Z', 'B1A', 'B1B', 'B1C', 'B1E', 'B1G', 'B1H', 'B1J', 'B1K', 'B1L', 'B1M', 'B1N', 'B1P', 'B1R', 'B1S', 'B1T', 'B1V', 'B1W', 'B1X', 'B1Y', 'B1Z', 'B2A', 'B2B', 'B2C', 'B2E', 'B2G', 'B2H', 'B2J', 'B2K', 'B2L', 'B2M', 'B2N', 'B2P', 'B2R', 'B2S', 'B2T', 'B2V', 'B2W', 'B2X', 'B2Y', 'B2Z', 'B3A', 'B3B', 'B3C', 'B3E', 'B3G', 'B3H', 'B3J', 'B3K', 'B3L', 'B3M', 'B3N', 'B3P', 'B3R', 'B3S', 'B3T', 'B3V', 'B3W', 'B3X', 'B3Y', 'B3Z', 'B4A', 'B4B', 'B4C', 'B4E', 'B4G', 'B4H', 'B4J', 'B4K', 'B4L', 'B4M', 'B4N', 'B4P', 'B4R', 'B4S', 'B4T', 'B4V', 'B4W', 'B4X', 'B4Y', 'B4Z', 'B5A', 'B5B', 'B5C', 'B5E', 'B5G', 'B5H', 'B5J', 'B5K', 'B5L', 'B5M', 'B5N', 'B5P', 'B5R', 'B5S', 'B5T', 'B5V', 'B5W', 'B5X', 'B5Y', 'B5Z', 'B6A', 'B6B', 'B6C', 'B6E', 'B6G', 'B6H', 'B6J', 'B6K', 'B6L', 'B6M', 'B6N', 'B6P', 'B6R', 'B6S', 'B6T', 'B6V', 'B6W', 'B6X', 'B6Y', 'B6Z', 'B7A', 'B7B', 'B7C', 'B7E', 'B7G', 'B7H', 'B7J', 'B7K', 'B7L', 'B7M', 'B7N', 'B7P', 'B7R', 'B7S', 'B7T', 'B7V', 'B7W', 'B7X', 'B7Y', 'B7Z', 'B8A', 'B8B', 'B8C', 'B8E', 'B8G', 'B8H', 'B8J', 'B8K', 'B8L', 'B8M', 'B8N', 'B8P', 'B8R', 'B8S', 'B8T', 'B8V', 'B8W', 'B8X', 'B8Y', 'B8Z', 'B9A', 'B9B', 'B9C', 'B9E', 'B9G', 'B9H', 'B9J', 'B9K', 'B9L', 'B9M', 'B9N', 'B9P', 'B9R', 'B9S', 'B9T', 'B9V', 'B9W', 'B9X', 'B9Y', 'B9Z', 'C0A', 'C0B', 'C1A', 'C1B', 'C1C', 'C1E', 'C1N', 'E0A', 'E0B', 'E0C', 'E0E', 'E0G', 'E0H', 'E0J', 'E0K', 'E0L', 'E0M', 'E0N', 'E0P', 'E0R', 'E0S', 'E0T', 'E0V', 'E0W', 'E0X', 'E0Y', 'E0Z', 'E1A', 'E1B', 'E1C', 'E1E', 'E1G', 'E1H', 'E1J', 'E1K', 'E1L', 'E1M', 'E1N', 'E1P', 'E1R', 'E1S', 'E1T', 'E1V', 'E1W', 'E1X', 'E1Y', 'E1Z', 'E2A', 'E2B', 'E2C', 'E2E', 'E2G', 'E2H', 'E2J', 'E2K', 'E2L', 'E2M', 'E2N', 'E2P', 'E2R', 'E2S', 'E2T', 'E2V', 'E2W', 'E2X', 'E2Y', 'E2Z', 'E3A', 'E3B', 'E3C', 'E3E', 'E3G', 'E3H', 'E3J', 'E3K', 'E3L', 'E3M', 'E3N', 'E3P', 'E3R', 'E3S', 'E3T', 'E3V', 'E3W', 'E3X', 'E3Y', 'E3Z', 'E4A', 'E4B', 'E4C', 'E4E', 'E4G', 'E4H', 'E4J', 'E4K', 'E4L', 'E4M', 'E4N', 'E4P', 'E4R', 'E4S', 'E4T', 'E4V', 'E4W', 'E4X', 'E4Y', 'E4Z', 'E5A', 'E5B', 'E5C', 'E5E', 'E5G', 'E5H', 'E5J', 'E5K', 'E5L', 'E5M', 'E5N', 'E5P', 'E5R', 'E5S', 'E5T', 'E5V', 'E5W', 'E5X', 'E5Y', 'E5Z', 'E6A', 'E6B', 'E6C', 'E6E', 'E6G', 'E6H', 'E6J', 'E6K', 'E6L', 'E6M', 'E6N', 'E6P', 'E6R', 'E6S', 'E6T', 'E6V', 'E6W', 'E6X', 'E6Y', 'E6Z', 'E7A', 'E7B', 'E7C', 'E7E', 'E7G', 'E7H', 'E7J', 'E7K', 'E7L', 'E7M', 'E7N', 'E7P', 'E7R', 'E7S', 'E7T', 'E7V', 'E7W', 'E7X', 'E7Y', 'E7Z', 'E8A', 'E8B', 'E8C', 'E8E', 'E8G', 'E8H', 'E8J', 'E8K', 'E8L', 'E8M', 'E8N', 'E8P', 'E8R', 'E8S', 'E8T', 'E8V', 'E8W', 'E8X', 'E8Y', 'E8Z', 'E9A', 'E9B', 'E9C', 'E9E', 'E9G', 'E9H', 'E9J', 'E9K', 'E9L', 'E9M', 'E9N', 'E9P', 'E9R', 'E9S', 'E9T', 'E9V', 'E9W', 'E9X', 'E9Y', 'E9Z')) AND ("Distributor"."Distributor Name" = 'Patterson-Canada')) OR (("Account"."Zipcode (3-digit)" IN ('A0A', 'A0B', 'A0C', 'A0E', 'A0G', 'A0H', 'A0K', 'A0L', 'A0M', 'A0N', 'A0P', 'A0R', 'A1A', 'A1B', 'A1C', 'A1E', 'A1G', 'A1H', 'A1K', 'A1L', 'A1N', 'A1S', 'A1V', 'A1W', 'A1X', 'A1Y', 'A2A', 'A2H', 'A2N', 'A2V', 'A5A', 'A8A', 'B0E', 'B0H', 'B0J', 'B0K', 'B0M', 'B0N', 'B0P', 'B0R', 'B0S', 'B0T', 'B0V', 'B0W', 'B1A', 'B1H', 'B1J', 'B1L', 'B1M', 'B1N', 'B1P', 'B1R', 'B1S', 'B1V', 'B1W', 'B1Y', 'B2A', 'B2G', 'B2H', 'B2N', 'B2R', 'B2S', 'B2T', 'B2V', 'B2W', 'B2X', 'B2Y', 'B2Z', 'B3A', 'B3B', 'B3E', 'B3G', 'B3H', 'B3J', 'B3K', 'B3L', 'B3M', 'B3N', 'B3P', 'B3R', 'B3S', 'B3T', 'B3V', 'B3Z', 'B4A', 'B4B', 'B4C', 'B4E', 'B4H', 'B4N', 'B4P', 'B4R', 'B4V', 'B5A', 'B9A', 'C0A', 'C0B', 'C1A', 'C1B', 'C1C', 'C1E', 'C1N', 'E1A', 'E1B', 'E1C', 'E1E', 'E1G', 'E1N', 'E1V', 'E2E', 'E2G', 'E2H', 'E2J', 'E2K', 'E2L', 'E2M', 'E2V', 'E3A', 'E3B', 'E3C', 'E3E', 'E3G', 'E3L', 'E3Y', 'E4B', 'E4E', 'E4K', 'E4L', 'E4P', 'E4S', 'E4V', 'E4W', 'E4X', 'E4Z', 'E5B', 'E5C', 'E5G', 'E5K', 'E5N', 'E5P', 'E6L', 'E7E', 'E7G', 'E7H', 'E7J', 'E7L', 'E7M', 'E8P', 'E9A', 'E9C', 'E9E', 'E9G')) AND ("Distributor"."Distributor Name" <> 'Patterson-Canada'))) AND ("- Product Groups"."Level 6" = 'AC OMNICAM CONNECT')
)) t1 ORDER BY saw_0
]]
[2019-07-17T10:24:40.999-04:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 6ec] [messageid: USER-23] [requestid: a60003d] [sessionid: a600000] [username: dcsab074] -------------------- General Query Info: [[
Repository: ssi, Subject Area: Dentsply BI Cube, Presentation: Dentsply BI Cube
]]
[2019-07-17T10:24:41.93-04:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 6ec] [messageid: USER-23] [requestid: a60003d] [sessionid: a600000] [username: dcsab074] -------------------- General Query Info: [[
Repository: ssi, Subject Area: Dentsply BI Cube, Presentation: Dentsply BI Cube
]]
[2019-07-17T10:24:41.155-04:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 6ec] [messageid: USER-23] [requestid: a60003d] [sessionid: a600000] [username: dcsab074] -------------------- General Query Info: [[
Repository: ssi, Subject Area: Dentsply BI Cube, Presentation: Dentsply BI Cube
]]
[2019-07-17T10:24:41.202-04:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 6ec] [messageid: USER-23] [requestid: a60003d] [sessionid: a600000] [username: dcsab074] -------------------- General Query Info: [[
Repository: ssi, Subject Area: Dentsply BI Cube, Presentation: Dentsply BI Cube
]]
[2019-07-17T10:24:41.265-04:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 6ec] [messageid: USER-23] [requestid: a60003d] [sessionid: a600000] [username: dcsab074] -------------------- General Query Info: [[
Repository: ssi, Subject Area: Dentsply BI Cube, Presentation: Dentsply BI Cube
]]
[2019-07-17T10:24:41.327-04:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 6ec] [messageid: USER-23] [requestid: a60003d] [sessionid: a600000] [username: dcsab074] -------------------- General Query Info: [[
Repository: ssi, Subject Area: Dentsply BI Cube, Presentation: Dentsply BI Cube
]]
[2019-07-17T10:24:41.751-04:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 6ec] [messageid: USER-16] [requestid: a60003d] [sessionid: a600000] [username: dcsab074] -------------------- Execution plan: [[
RqList <<18991333>> [for database 0:0,0]
D1.c1 as c1 [for database 3023:11:Dentsply BI Cube,83],
D1.c2 as c2 [for database 3023:11:Dentsply BI Cube,83]
Child Nodes (RqJoinSpec): <<18991343>> [for database 0:0,0]
RqJoinNode <<18991332>> []
((
RqList <<19016371>> [for database 0:0,0]
D1.c1 as c1 [for database 0:0,1],
D1.c2 as c2 [for database 0:0,1]
Child Nodes (RqJoinSpec): <<19016383>> [for database 0:0,1]
RqJoinNode <<19016382>> []
(
RqStats [for database 0:0,0]
RqList <<18991857>> [for database 3023:11:Dentsply BI Cube,83]
D1.c2 as c1 GB [for database 3023:11:Dentsply BI Cube,83],
sum(ifnull(D1.c1 , 0) by [ D1.c2] ) as c2 GB [for database 3023:11:Dentsply BI Cube,83]
Child Nodes (RqJoinSpec): <<18993582>> [for database 3023:11:Dentsply BI Cube,83]
RqJoinNode <<18993581>> []
(
RqList <<18991864>> [for database 3023:11:Dentsply BI Cube,83]
sum(Fact_Canada_Sales_Current_MTD_Mth.S_AMT by [ Dim_Product_Hierarchy.LEVEL_6] ) as c1 [for database 3023:11:Dentsply BI Cube,83],
Dim_Product_Hierarchy.LEVEL_6 as c2 GB [for database 3023:11:Dentsply BI Cube,83]
Child Nodes (RqJoinSpec): <<18993607>> [for database 3023:11:Dentsply BI Cube,83]
RqJoinNode <<18993526>> [(InNode:<<18993526>>) (OutNode:<<18993537>>) ]
WC_DEALERBRANCH_SALES_D AS Dim_Distributor_Branch
RqJoinNode <<18993527>> [(InNode:<<18993527>>) (OutNode:<<18993537>>) ]
WC_PRODUCT_HIERARCHY_D AS Dim_Product_Hierarchy
RqJoinNode <<18993528>> [(InNode:<<18993528>>) (OutNode:<<18993529>>) ]
W_ORG_DH AS Dim_Account_Hierarchy
RqJoinNode <<18993529>> [(InNode:<<18993528>>) (OutNode:<<18993529>>) , (InNode:<<18993529>>) (OutNode:<<18993537>>) ]
W_ORG_D AS Dim_Account
RqJoinNode <<18993534>> [(InNode:<<18993534>>) (OutNode:<<18993535>>) , (InNode:<<18993534>>) (OutNode:<<18993537>>) ]
WC_POSTN_CATLG_FILTER AS Security_Position_Catalog_Filter
RqJoinNode <<18993535>> [(InNode:<<18993534>>) (OutNode:<<18993535>>) , (InNode:<<18993535>>) (OutNode:<<18993537>>) ]
W_ORG_PARTY AS Dim_Position_Hierarchy
RqJoinNode <<18993536>> [(InNode:<<18993536>>) (OutNode:<<18993537>>) ]
W_MONTH_D AS Dim_Period_Month
RqJoinNode <<18993537>> [(InNode:<<18993526>>) (OutNode:<<18993537>>) , (InNode:<<18993527>>) (OutNode:<<18993537>>) , (InNode:<<18993529>>) (OutNode:<<18993537>>) , (InNode:<<18993534>>) (OutNode:<<18993537>>) , (InNode:<<18993535>>) (OutNode:<<18993537>>) , (InNode:<<18993536>>) (OutNode:<<18993537>>) ]
WC_SYNDD_CS_CAN_F AS Fact_Canada_Sales_Current_MTD_Mth
DetailFilter: Dim_Distributor_Branch.ROW_WID = Fact_Canada_Sales_Current_MTD_Mth.X_DISTRIBUTOR_WID and Dim_Account_Hierarchy.ACCNT_WID = Dim_Account.ROW_WID and Dim_Account.ROW_WID = Fact_Canada_Sales_Current_MTD_Mth.ACCNT_WID and Dim_Product_Hierarchy.PROD_WID = Fact_Canada_Sales_Current_MTD_Mth.PROD_WID and Fact_Canada_Sales_Current_MTD_Mth.ACCNT_WID = Dim_Position_Hierarchy.X_ACCNT_WID and Dim_Period_Month.ROW_WID = Fact_Canada_Sales_Current_MTD_Mth.MONTH_WID and Fact_Canada_Sales_Current_MTD_Mth.X_CATALOG_ID = Security_Position_Catalog_Filter.CATALOG_ID and Security_Position_Catalog_Filter.POSTN_ID = Dim_Position_Hierarchy.PARTY_ID and Fact_Canada_Sales_Current_MTD_Mth.X_CATALOG_ID = Security_Position_Catalog_Filter.CATALOG_ID and Security_Position_Catalog_Filter.POSTN_ID = Dim_Position_Hierarchy.PARTY_ID and Dim_Distributor_Branch.Distributor_Name = 'Patterson-Canada' and Dim_Product_Hierarchy.HIERARCHY_TYPE = '2019 Canada Commission Brand' and Dim_Distributor_Branch.Distributor_Name = 'Patterson-Canada' and Dim_Product_Hierarchy.LEVEL_6 = 'AC OMNICAM CONNECT' and Dim_Product_Hierarchy.HIERARCHY_DIVISION = 'Canada' and Dim_Position_Hierarchy.POSITION_HIER_TYPE = 'Canada' and Dim_Product_Hierarchy.HIERARCHY_TYPE = '2019 Canada Commission Brand' and Dim_Product_Hierarchy.LEVEL_6 = 'AC OMNICAM CONNECT' and Dim_Product_Hierarchy.HIERARCHY_DIVISION = 'Canada' and Dim_Position_Hierarchy.POSITION_HIER_TYPE = 'Canada' and (not Dim_Account.X_ZIP3 in ([ 'E1W', 'E1X', 'E2A', 'E3N', 'E3V', 'E3Z', 'E7C', 'E8A', 'E8B', 'E8C', 'E8E', 'E8J', 'E8K', 'E8S', 'E8T', 'G9B', 'G9N', 'H4Y', 'J0W', 'J0Y', 'J0Z', 'J3T', 'J5V', 'P0T', 'P0V', 'P0W', 'P0X', 'P7A', 'P7B', 'P7C', 'P7E', 'P7K', 'P7L', 'P8N', 'P8T', 'P9A', 'P9N', 'S0A', 'S0C', 'S0G', 'S0H', 'S0J', 'S0K', 'S0L', 'S0N', 'S3N', 'S4A', 'S4H', 'S4P', 'S4R', 'S4S', 'S4T', 'S4V', 'S4X', 'S4Z', 'S6W', 'T0A', 'T0B', 'T0C', 'T0E', 'T0G', 'T0H', 'T4L', 'V0A', 'X0A', 'X0B', 'X0C', 'X0E', 'X1A'] ) and Dim_Position_Hierarchy.LVL5ANC_POSTN like 'CC%' or Dim_Position_Hierarchy.LVL5ANC_POSTN <> 'CC101' and Dim_Account.X_ZIP3 in ([ 'S6W', 'T4L', 'X0A', 'X0B', 'X0C', 'X0E', 'X1A'] ) or Dim_Position_Hierarchy.LVL5ANC_POSTN <> 'CC103' and Dim_Account.X_ZIP3 in ([ 'S0A', 'S0C', 'S0G', 'S0H', 'S0J', 'S0K', 'S0L', 'S0N', 'S3N', 'S4A', 'S4H', 'S4P', 'S4R', 'S4S', 'S4T', 'S4V', 'S4X', 'S4Z', 'T0A', 'T0B', 'T0C', 'T0E', 'T0G', 'T0H'] ) or Dim_Position_Hierarchy.LVL5ANC_POSTN <> 'CC105' and Dim_Account.X_ZIP3 in ([ 'E1W', 'E1X', 'E2A', 'E3N', 'E3V', 'E3Z', 'E7C', 'E8A', 'E8B', 'E8C', 'E8E', 'E8J', 'E8K', 'E8S', 'E8T'] ) or Dim_Account.X_ZIP3 = 'V0A' and Dim_Position_Hierarchy.LVL5ANC_POSTN <> 'CC104' or Dim_Position_Hierarchy.LVL5ANC_POSTN <> 'CC105' and Dim_Account.X_ZIP3 in ([ 'H4Y', 'J0W'] ) or Dim_Position_Hierarchy.LVL5ANC_POSTN <> 'CC104' and Dim_Account.X_ZIP3 in ([ 'P0T', 'P0V', 'P0W', 'P0X', 'P7A', 'P7B', 'P7C', 'P7E', 'P7K', 'P7L', 'P8N', 'P8T', 'P9A', 'P9N'] ) or Dim_Position_Hierarchy.LVL5ANC_POSTN <> 'CC106' and Dim_Account.X_ZIP3 in ([ 'G9B', 'G9N', 'J0Y', 'J0Z', 'J3T', 'J5V'] )) and Dim_Period_Month.PER_NAME_YEAR in (Subquery(
RqList <<18991479>> [for database 3023:11:Dentsply BI Cube,83] distinct
Dim_Period_Month.PER_NAME_YEAR as c1 GB [for database 3023:11:Dentsply BI Cube,83]
Child Nodes (RqJoinSpec): <<18991490>> [for database 3023:11:Dentsply BI Cube,83]
RqJoinNode <<18991489>> []
W_MONTH_D AS Dim_Period_Month)) and Dim_Product_Hierarchy.LEVEL_1 in ([ 'CAD CAM Consumables', 'CAD CAM Equipment'] ) and (Dim_Position_Hierarchy.FIXED_HIER_LEVEL = 5 or Dim_Position_Hierarchy.FIXED_HIER_LEVEL = 9) and Dim_Product_Hierarchy.LEVEL_1 in ([ 'CAD CAM Consumables', 'CAD CAM Equipment'] ) [for database 3023:11:Dentsply BI Cube,83]
GroupBy: [ Dim_Product_Hierarchy.LEVEL_6] [for database 3023:11:Dentsply BI Cube,83]
) as D1
GroupBy: [ D1.c2] [for database 3023:11:Dentsply BI Cube,83]
) as D1
OrderBy: c1 asc, c2 asc [for database 0:0,0]
RqUnion <<18991328>> [for database 0:0,0]
RqList <<19016387>> [for database 0:0,0]
D1.c1 as c1 [for database 0:0,1],
D1.c2 as c2 [for database 0:0,1]
Child Nodes (RqJoinSpec): <<19016399>> [for database 0:0,1]
RqJoinNode <<19016398>> []
(
RqStats [for database 0:0,0]
RqList <<18996722>> [for database 3023:11:Dentsply BI Cube,83]
D1.c2 as c1 GB [for database 3023:11:Dentsply BI Cube,83],
sum(ifnull(D1.c1 , 0) by [ D1.c2] ) as c2 GB [for database 3023:11:Dentsply BI Cube,83]
Child Nodes (RqJoinSpec): <<19013427>> [for database 3023:11:Dentsply BI Cube,83]
RqJoinNode <<19013426>> []
(
RqList <<18996729>> [for database 3023:11:Dentsply BI Cube,83]
sum(Fact_Canada_Sales_Current_MTD_Mth.S_AMT by [ Dim_Product_Hierarchy.LEVEL_6] ) as c1 [for database 3023:11:Dentsply BI Cube,83],
Dim_Product_Hierarchy.LEVEL_6 as c2 GB [for database 3023:11:Dentsply BI Cube,83]
Child Nodes (RqJoinSpec): <<19014410>> [for database 3023:11:Dentsply BI Cube,83]
RqJoinNode <<19012419>> [(InNode:<<19012419>>) (OutNode:<<19012430>>) ]
WC_DEALERBRANCH_SALES_D AS Dim_Distributor_Branch
RqJoinNode <<19012420>> [(InNode:<<19012420>>) (OutNode:<<19012430>>) ]
WC_PRODUCT_HIERARCHY_D AS Dim_Product_Hierarchy
RqJoinNode <<19012421>> [(InNode:<<19012421>>) (OutNode:<<19012422>>) ]
W_ORG_DH AS Dim_Account_Hierarchy
RqJoinNode <<19012422>> [(InNode:<<19012421>>) (OutNode:<<19012422>>) , (InNode:<<19012422>>) (OutNode:<<19012430>>) ]
W_ORG_D AS Dim_Account
RqJoinNode <<19012427>> [(InNode:<<19012427>>) (OutNode:<<19012428>>) , (InNode:<<19012427>>) (OutNode:<<19012430>>) ]
WC_POSTN_CATLG_FILTER AS Security_Position_Catalog_Filter
RqJoinNode <<19012428>> [(InNode:<<19012427>>) (OutNode:<<19012428>>) , (InNode:<<19012428>>) (OutNode:<<19012430>>) ]
W_ORG_PARTY AS Dim_Position_Hierarchy
RqJoinNode <<19012429>> [(InNode:<<19012429>>) (OutNode:<<19012430>>) ]
W_MONTH_D AS Dim_Period_Month
RqJoinNode <<19012430>> [(InNode:<<19012419>>) (OutNode:<<19012430>>) , (InNode:<<19012420>>) (OutNode:<<19012430>>) , (InNode:<<19012422>>) (OutNode:<<19012430>>) , (InNode:<<19012427>>) (OutNode:<<19012430>>) , (InNode:<<19012428>>) (OutNode:<<19012430>>) , (InNode:<<19012429>>) (OutNode:<<19012430>>) ]
WC_SYNDD_CS_CAN_F AS Fact_Canada_Sales_Current_MTD_Mth
DetailFilter: Dim_Account_Hierarchy.ACCNT_WID = Dim_Account.ROW_WID and Dim_Account.ROW_WID = Fact_Canada_Sales_Current_MTD_Mth.ACCNT_WID and Dim_Distributor_Branch.ROW_WID = Fact_Canada_Sales_Current_MTD_Mth.X_DISTRIBUTOR_WID and Dim_Product_Hierarchy.PROD_WID = Fact_Canada_Sales_Current_MTD_Mth.PROD_WID and Dim_Period_Month.ROW_WID = Fact_Canada_Sales_Current_MTD_Mth.MONTH_WID and Fact_Canada_Sales_Current_MTD_Mth.ACCNT_WID = Dim_Position_Hierarchy.X_ACCNT_WID and Fact_Canada_Sales_Current_MTD_Mth.X_CATALOG_ID = Security_Position_Catalog_Filter.CATALOG_ID and Dim_Product_Hierarchy.HIERARCHY_TYPE = '2019 Canada Commission Brand' and Dim_Product_Hierarchy.LEVEL_6 = 'AC OMNICAM CONNECT' and Dim_Product_Hierarchy.HIERARCHY_DIVISION = 'Canada' and Security_Position_Catalog_Filter.POSTN_ID = Dim_Position_Hierarchy.PARTY_ID and Dim_Position_Hierarchy.POSITION_HIER_TYPE = 'Canada' and (Dim_Product_Hierarchy.LEVEL_1 = 'CAD CAM Consumables' or Dim_Product_Hierarchy.LEVEL_1 = 'CAD CAM Equipment') and (Dim_Account.X_ZIP3 = 'A0A' or Dim_Account.X_ZIP3 = 'A0B' or Dim_Account.X_ZIP3 = 'A0C' or Dim_Account.X_ZIP3 = 'A0E' or Dim_Account.X_ZIP3 = 'A0G' or Dim_Account.X_ZIP3 = 'A0H' or Dim_Account.X_ZIP3 = 'A0K' or Dim_Account.X_ZIP3 = 'A0L' or Dim_Account.X_ZIP3 = 'A0M' or Dim_Account.X_ZIP3 = 'A0N' or Dim_Account.X_ZIP3 = 'A0P' or Dim_Account.X_ZIP3 = 'A0R' or Dim_Account.X_ZIP3 = 'A1A' or Dim_Account.X_ZIP3 = 'A1B' or Dim_Account.X_ZIP3 = 'A1C' or Dim_Account.X_ZIP3 = 'A1E' or Dim_Account.X_ZIP3 = 'A1G' or Dim_Account.X_ZIP3 = 'A1H' or Dim_Account.X_ZIP3 = 'A1K' or Dim_Account.X_ZIP3 = 'A1L' or Dim_Account.X_ZIP3 = 'A1N' or Dim_Account.X_ZIP3 = 'A1S' or Dim_Account.X_ZIP3 = 'A1V' or Dim_Account.X_ZIP3 = 'A1W' or Dim_Account.X_ZIP3 = 'A1X' or Dim_Account.X_ZIP3 = 'A1Y' or Dim_Account.X_ZIP3 = 'A2A' or Dim_Account.X_ZIP3 = 'A2H' or Dim_Account.X_ZIP3 = 'A2N' or Dim_Account.X_ZIP3 = 'A2V' or Dim_Account.X_ZIP3 = 'A5A' or Dim_Account.X_ZIP3 = 'A8A' or Dim_Account.X_ZIP3 = 'B0E' or Dim_Account.X_ZIP3 = 'B0H' or Dim_Account.X_ZIP3 = 'B0J' or Dim_Account.X_ZIP3 = 'B0K' or Dim_Account.X_ZIP3 = 'B0M' or Dim_Account.X_ZIP3 = 'B0N' or Dim_Account.X_ZIP3 = 'B0P' or Dim_Account.X_ZIP3 = 'B0R' or Dim_Account.X_ZIP3 = 'B0S' or Dim_Account.X_ZIP3 = 'B0T' or Dim_Account.X_ZIP3 = 'B0V' or Dim_Account.X_ZIP3 = 'B0W' or Dim_Account.X_ZIP3 = 'B1A' or Dim_Account.X_ZIP3 = 'B1H' or Dim_Account.X_ZIP3 = 'B1J' or Dim_Account.X_ZIP3 = 'B1L' or Dim_Account.X_ZIP3 = 'B1M' or Dim_Account.X_ZIP3 = 'B1N' or Dim_Account.X_ZIP3 = 'B1P' or Dim_Account.X_ZIP3 = 'B1R' or Dim_Account.X_ZIP3 = 'B1S' or Dim_Account.X_ZIP3 = 'B1V' or Dim_Account.X_ZIP3 = 'B1W' or Dim_Account.X_ZIP3 = 'B1Y' or Dim_Account.X_ZIP3 = 'B2A' or Dim_Account.X_ZIP3 = 'B2G' or Dim_Account.X_ZIP3 = 'B2H' or Dim_Account.X_ZIP3 = 'B2N' or Dim_Account.X_ZIP3 = 'B2R' or Dim_Account.X_ZIP3 = 'B2S' or Dim_Account.X_ZIP3 = 'B2T' or Dim_Account.X_ZIP3 = 'B2V' or Dim_Account.X_ZIP3 = 'B2W' or Dim_Account.X_ZIP3 = 'B2X' or Dim_Account.X_ZIP3 = 'B2Y' or Dim_Account.X_ZIP3 = 'B2Z' or Dim_Account.X_ZIP3 = 'B3A' or Dim_Account.X_ZIP3 = 'B3B' or Dim_Account.X_ZIP3 = 'B3E' or Dim_Account.X_ZIP3 = 'B3G' or Dim_Account.X_ZIP3 = 'B3H' or Dim_Account.X_ZIP3 = 'B3J' or Dim_Account.X_ZIP3 = 'B3K' or Dim_Account.X_ZIP3 = 'B3L' or Dim_Account.X_ZIP3 = 'B3M' or Dim_Account.X_ZIP3 = 'B3N' or Dim_Account.X_ZIP3 = 'B3P' or Dim_Account.X_ZIP3 = 'B3R' or Dim_Account.X_ZIP3 = 'B3S' or Dim_Account.X_ZIP3 = 'B3T' or Dim_Account.X_ZIP3 = 'B3V' or Dim_Account.X_ZIP3 = 'B3Z' or Dim_Account.X_ZIP3 = 'B4A' or Dim_Account.X_ZIP3 = 'B4B' or Dim_Account.X_ZIP3 = 'B4C' or Dim_Account.X_ZIP3 = 'B4E' or Dim_Account.X_ZIP3 = 'B4H' or Dim_Account.X_ZIP3 = 'B4N' or Dim_Account.X_ZIP3 = 'B4P' or Dim_Account.X_ZIP3 = 'B4R' or Dim_Account.X_ZIP3 = 'B4V' or Dim_Account.X_ZIP3 = 'B5A' or Dim_Account.X_ZIP3 = 'B9A' or Dim_Account.X_ZIP3 = 'C0A' or Dim_Account.X_ZIP3 = 'C0B' or Dim_Account.X_ZIP3 = 'C1A' or Dim_Account.X_ZIP3 = 'C1B' or Dim_Account.X_ZIP3 = 'C1C' or Dim_Account.X_ZIP3 = 'C1E' or Dim_Account.X_ZIP3 = 'C1N' or Dim_Account.X_ZIP3 = 'E1A' or Dim_Account.X_ZIP3 = 'E1B' or Dim_Account.X_ZIP3 = 'E1C' or Dim_Account.X_ZIP3 = 'E1E' or Dim_Account.X_ZIP3 = 'E1G' or Dim_Account.X_ZIP3 = 'E1N' or Dim_Account.X_ZIP3 = 'E1V' or Dim_Account.X_ZIP3 = 'E2E' or Dim_Account.X_ZIP3 = 'E2G' or Dim_Account.X_ZIP3 = 'E2H' or Dim_Account.X_ZIP3 = 'E2J' or Dim_Account.X_ZIP3 = 'E2K' or Dim_Account.X_ZIP3 = 'E2L' or Dim_Account.X_ZIP3 = 'E2M' or Dim_Account.X_ZIP3 = 'E2V' or Dim_Account.X_ZIP3 = 'E3A' or Dim_Account.X_ZIP3 = 'E3B' or Dim_Account.X_ZIP3 = 'E3C' or Dim_Account.X_ZIP3 = 'E3E' or Dim_Account.X_ZIP3 = 'E3G' or Dim_Account.X_ZIP3 = 'E3L' or Dim_Account.X_ZIP3 = 'E3Y' or Dim_Account.X_ZIP3 = 'E4B' or Dim_Account.X_ZIP3 = 'E4E' or Dim_Account.X_ZIP3 = 'E4K' or Dim_Account.X_ZIP3 = 'E4L' or Dim_Account.X_ZIP3 = 'E4P' or Dim_Account.X_ZIP3 = 'E4S' or Dim_Account.X_ZIP3 = 'E4V' or Dim_Account.X_ZIP3 = 'E4W' or Dim_Account.X_ZIP3 = 'E4X' or Dim_Account.X_ZIP3 = 'E4Z' or Dim_Account.X_ZIP3 = 'E5B' or Dim_Account.X_ZIP3 = 'E5C' or Dim_Account.X_ZIP3 = 'E5G' or Dim_Account.X_ZIP3 = 'E5K' or Dim_Account.X_ZIP3 = 'E5N' or Dim_Account.X_ZIP3 = 'E5P' or Dim_Account.X_ZIP3 = 'E6L' or Dim_Account.X_ZIP3 = 'E7E' or Dim_Account.X_ZIP3 = 'E7G' or Dim_Account.X_ZIP3 = 'E7H' or Dim_Account.X_ZIP3 = 'E7J' or Dim_Account.X_ZIP3 = 'E7L' or Dim_Account.X_ZIP3 = 'E7M' or Dim_Account.X_ZIP3 = 'E8P' or Dim_Account.X_ZIP3 = 'E9A' or Dim_Account.X_ZIP3 = 'E9C' or Dim_Account.X_ZIP3 = 'E9E' or Dim_Account.X_ZIP3 = 'E9G' or Dim_Distributor_Branch.Distributor_Name = 'Patterson-Canada') and (Dim_Account.X_ZIP3 = 'A0A' or Dim_Account.X_ZIP3 = 'A0B' or Dim_Account.X_ZIP3 = 'A0C' or Dim_Account.X_ZIP3 = 'A0E' or Dim_Account.X_ZIP3 = 'A0G' or Dim_Account.X_ZIP3 = 'A0H' or Dim_Account.X_ZIP3 = 'A0K' or Dim_Account.X_ZIP3 = 'A0L' or Dim_Account.X_ZIP3 = 'A0M' or Dim_Account.X_ZIP3 = 'A0N' or Dim_Account.X_ZIP3 = 'A0P' or Dim_Account.X_ZIP3 = 'A0R' or Dim_Account.X_ZIP3 = 'A1A' or Dim_Account.X_ZIP3 = 'A1B' or Dim_Account.X_ZIP3 = 'A1C' or Dim_Account.X_ZIP3 = 'A1E' or Dim_Account.X_ZIP3 = 'A1G' or Dim_Account.X_ZIP3 = 'A1H' or Dim_Account.X_ZIP3 = 'A1K' or Dim_Account.X_ZIP3 = 'A1L' or Dim_Account.X_ZIP3 = 'A1N' or Dim_Account.X_ZIP3 = 'A1S' or Dim_Account.X_ZIP3 = 'A1V' or Dim_Account.X_ZIP3 = 'A1W' or Dim_Account.X_ZIP3 = 'A1X' or Dim_Account.X_ZIP3 = 'A1Y' or Dim_Account.X_ZIP3 = 'A2A' or Dim_Account.X_ZIP3 = 'A2H' or Dim_Account.X_ZIP3 = 'A2N' or Dim_Account.X_ZIP3 = 'A2V' or Dim_Account.X_ZIP3 = 'A5A' or Dim_Account.X_ZIP3 = 'A8A' or Dim_Account.X_ZIP3 = 'B0E' or Dim_Account.X_ZIP3 = 'B0H' or Dim_Account.X_ZIP3 = 'B0J' or Dim_Account.X_ZIP3 = 'B0K' or Dim_Account.X_ZIP3 = 'B0M' or Dim_Account.X_ZIP3 = 'B0N' or Dim_Account.X_ZIP3 = 'B0P' or Dim_Account.X_ZIP3 = 'B0R' or Dim_Account.X_ZIP3 = 'B0S' or Dim_Account.X_ZIP3 = 'B0T' or Dim_Account.X_ZIP3 = 'B0V' or Dim_Account.X_ZIP3 = 'B0W' or Dim_Account.X_ZIP3 = 'B1A' or Dim_Account.X_ZIP3 = 'B1H' or Dim_Account.X_ZIP3 = 'B1J' or Dim_Account.X_ZIP3 = 'B1L' or Dim_Account.X_ZIP3 = 'B1M' or Dim_Account.X_ZIP3 = 'B1N' or Dim_Account.X_ZIP3 = 'B1P' or Dim_Account.X_ZIP3 = 'B1R' or Dim_Account.X_ZIP3 = 'B1S' or Dim_Account.X_ZIP3 = 'B1V' or Dim_Account.X_ZIP3 = 'B1W' or Dim_Account.X_ZIP3 = 'B1Y' or Dim_Account.X_ZIP3 = 'B2A' or Dim_Account.X_ZIP3 = 'B2G' or Dim_Account.X_ZIP3 = 'B2H' or Dim_Account.X_ZIP3 = 'B2N' or Dim_Account.X_ZIP3 = 'B2R' or Dim_Account.X_ZIP3 = 'B2S' or Dim_Account.X_ZIP3 = 'B2T' or Dim_Account.X_ZIP3 = 'B2V' or Dim_Account.X_ZIP3 = 'B2W' or Dim_Account.X_ZIP3 = 'B2X' or Dim_Account.X_ZIP3 = 'B2Y' or Dim_Account.X_ZIP3 = 'B2Z' or Dim_Account.X_ZIP3 = 'B3A' or Dim_Account.X_ZIP3 = 'B3B' or Dim_Account.X_ZIP3 = 'B3E' or Dim_Account.X_ZIP3 = 'B3G' or Dim_Account.X_ZIP3 = 'B3H' or Dim_Account.X_ZIP3 = 'B3J' or Dim_Account.X_ZIP3 = 'B3K' or Dim_Account.X_ZIP3 = 'B3L' or Dim_Account.X_ZIP3 = 'B3M' or Dim_Account.X_ZIP3 = 'B3N' or Dim_Account.X_ZIP3 = 'B3P' or Dim_Account.X_ZIP3 = 'B3R' or Dim_Account.X_ZIP3 = 'B3S' or Dim_Account.X_ZIP3 = 'B3T' or Dim_Account.X_ZIP3 = 'B3V' or Dim_Account.X_ZIP3 = 'B3Z' or Dim_Account.X_ZIP3 = 'B4A' or Dim_Account.X_ZIP3 = 'B4B' or Dim_Account.X_ZIP3 = 'B4C' or Dim_Account.X_ZIP3 = 'B4E' or Dim_Account.X_ZIP3 = 'B4H' or Dim_Account.X_ZIP3 = 'B4N' or Dim_Account.X_ZIP3 = 'B4P' or Dim_Account.X_ZIP3 = 'B4R' or Dim_Account.X_ZIP3 = 'B4V' or Dim_Account.X_ZIP3 = 'B5A' or Dim_Account.X_ZIP3 = 'B9A' or Dim_Account.X_ZIP3 = 'C0A' or Dim_Account.X_ZIP3 = 'C0B' or Dim_Account.X_ZIP3 = 'C1A' or Dim_Account.X_ZIP3 = 'C1B' or Dim_Account.X_ZIP3 = 'C1C' or Dim_Account.X_ZIP3 = 'C1E' or Dim_Account.X_ZIP3 = 'C1N' or Dim_Account.X_ZIP3 = 'E1A' or Dim_Account.X_ZIP3 = 'E1B' or Dim_Account.X_ZIP3 = 'E1C' or Dim_Account.X_ZIP3 = 'E1E' or Dim_Account.X_ZIP3 = 'E1G' or Dim_Account.X_ZIP3 = 'E1N' or Dim_Account.X_ZIP3 = 'E1V' or Dim_Account.X_ZIP3 = 'E2E' or Dim_Account.X_ZIP3 = 'E2G' or Dim_Account.X_ZIP3 = 'E2H' or Dim_Account.X_ZIP3 = 'E2J' or Dim_Account.X_ZIP3 = 'E2K' or Dim_Account.X_ZIP3 = 'E2L' or Dim_Account.X_ZIP3 = 'E2M' or Dim_Account.X_ZIP3 = 'E2V' or Dim_Account.X_ZIP3 = 'E3A' or Dim_Account.X_ZIP3 = 'E3B' or Dim_Account.X_ZIP3 = 'E3C' or Dim_Account.X_ZIP3 = 'E3E' or Dim_Account.X_ZIP3 = 'E3G' or Dim_Account.X_ZIP3 = 'E3L' or Dim_Account.X_ZIP3 = 'E3Y' or Dim_Account.X_ZIP3 = 'E4B' or Dim_Account.X_ZIP3 = 'E4E' or Dim_Account.X_ZIP3 = 'E4K' or Dim_Account.X_ZIP3 = 'E4L' or Dim_Account.X_ZIP3 = 'E4P' or Dim_Account.X_ZIP3 = 'E4S' or Dim_Account.X_ZIP3 = 'E4V' or Dim_Account.X_ZIP3 = 'E4W' or Dim_Account.X_ZIP3 = 'E4X' or Dim_Account.X_ZIP3 = 'E4Z' or Dim_Account.X_ZIP3 = 'E5B' or Dim_Account.X_ZIP3 = 'E5C' or Dim_Account.X_ZIP3 = 'E5G' or Dim_Account.X_ZIP3 = 'E5K' or Dim_Account.X_ZIP3 = 'E5N' or Dim_Account.X_ZIP3 = 'E5P' or Dim_Account.X_ZIP3 = 'E6L' or Dim_Account.X_ZIP3 = 'E7E' or Dim_Account.X_ZIP3 = 'E7G' or Dim_Account.X_ZIP3 = 'E7H' or Dim_Account.X_ZIP3 = 'E7J' or Dim_Account.X_ZIP3 = 'E7L' or Dim_Account.X_ZIP3 = 'E7M' or Dim_Account.X_ZIP3 = 'E8P' or Dim_Account.X_ZIP3 = 'E9A' or Dim_Account.X_ZIP3 = 'E9C' or Dim_Account.X_ZIP3 = 'E9E' or Dim_Account.X_ZIP3 = 'E9G' or Dim_Account.X_ZIP3 in ([ 'A0A', 'A0B', 'A0C', 'A0E', 'A0G', 'A0H', 'A0J', 'A0K', 'A0L', 'A0M', 'A0N', 'A0P', 'A0R', 'A1A', 'A1B', 'A1C', 'A1E', 'A1G', 'A1H', 'A1J', 'A1K', 'A1L', 'A1M', 'A1N', 'A1P', 'A1R', 'A1S', 'A1T', 'A1V', 'A1W', 'A1X', 'A1Y', 'A1Z', 'A2A', 'A2B', 'A2C', 'A2E', 'A2G', 'A2H', 'A2J', 'A2K', 'A2L', 'A2M', 'A2N', 'A2P', 'A2R', 'A2S', 'A2T', 'A2V', 'A2W', 'A2X', 'A2Y', 'A2Z', 'A3A', 'A3B', 'A3C', 'A3E', 'A3G', 'A3H', 'A3J', 'A3K', 'A3L', 'A3M', 'A3N', 'A3P', 'A3R', 'A3S', 'A3T', 'A3V', 'A3W', 'A3X', 'A3Y', 'A3Z', 'A4A', 'A4B', 'A4C', 'A4E', 'A4G', 'A4H', 'A4J', 'A4K', 'A4L', 'A4M', 'A4N', 'A4P', 'A4R', 'A4S', 'A4T', 'A4V', 'A4W', 'A4X', 'A4Y', 'A4Z', 'A5A', 'A5B', 'A5C', 'A5E', 'A5G', 'A5H', 'A5J', 'A5K', 'A5L', 'A5M', 'A5N', 'A5P', 'A5R', 'A5S', 'A5T', 'A5V', 'A5W', 'A5X', 'A5Y', 'A5Z', 'A6A', 'A6B', 'A6C', 'A6E', 'A6G', 'A6H', 'A6J', 'A6K', 'A6L', 'A6M', 'A6N', 'A6P', 'A6R', 'A6S', 'A6T', 'A6V', 'A6W', 'A6X', 'A6Y', 'A6Z', 'A7A', 'A7B', 'A7C', 'A7E', 'A7G', 'A7H', 'A7J', 'A7K', 'A7L', 'A7M', 'A7N', 'A7P', 'A7R', 'A7S', 'A7T', 'A7V', 'A7W', 'A7X', 'A7Y', 'A7Z', 'A8A', 'A8B', 'A8C', 'A8E', 'A8G', 'A8H', 'A8J', 'A8K', 'A8L', 'A8M', 'A8N', 'A8P', 'A8R', 'A8S', 'A8T', 'A8V', 'A8W', 'A8X', 'A8Y', 'A8Z', 'A9A', 'A9B', 'A9C', 'A9E', 'A9G', 'A9H', 'A9J', 'A9K', 'A9L', 'A9M', 'A9N', 'A9P', 'A9R', 'A9S', 'A9T', 'A9V', 'B0B', 'B0C', 'B0E', 'B0G', 'B0H', 'B0J', 'B0K', 'B0L', 'B0M', 'B0N', 'B0P', 'B0R', 'B0S', 'B0T', 'B0V', 'B0W', 'B0X', 'B0Y', 'B0Z', 'B1A', 'B1B', 'B1C', 'B1E', 'B1G', 'B1H', 'B1J', 'B1K', 'B1L', 'B1M', 'B1N', 'B1P', 'B1R', 'B1S', 'B1T', 'B1V', 'B1W', 'B1X', 'B1Y', 'B1Z', 'B2A', 'B2B', 'B2C', 'B2E', 'B2G', 'B2H', 'B2J', 'B2K', 'B2L', 'B2M', 'B2N', 'B2P', 'B2R', 'B2S', 'B2T', 'B2V', 'B2W', 'B2X', 'B2Y', 'B2Z', 'B3A', 'B3B', 'B3C', 'B3E', 'B3G', 'B3H', 'B3J', 'B3K', 'B3L', 'B3M', 'B3N', 'B3P', 'B3R', 'B3S', 'B3T', 'B3V', 'B3W', 'B3X', 'B3Y', 'B3Z', 'B4A', 'B4B', 'B4C', 'B4E', 'B4G', 'B4H', 'B4J', 'B4K', 'B4L', 'B4M', 'B4N', 'B4P', 'B4R', 'B4S', 'B4T', 'B4V', 'B4W', 'B4X', 'B4Y', 'B4Z', 'B5A', 'B5B', 'B5C', 'B5E', 'B5G', 'B5H', 'B5J', 'B5K', 'B5L', 'B5M', 'B5N', 'B5P', 'B5R', 'B5S', 'B5T', 'B5V', 'B5W', 'B5X', 'B5Y', 'B5Z', 'B6A', 'B6B', 'B6C', 'B6E', 'B6G', 'B6H', 'B6J', 'B6K', 'B6L', 'B6M', 'B6N', 'B6P', 'B6R', 'B6S', 'B6T', 'B6V', 'B6W', 'B6X', 'B6Y', 'B6Z', 'B7A', 'B7B', 'B7C', 'B7E', 'B7G', 'B7H', 'B7J', 'B7K', 'B7L', 'B7M', 'B7N', 'B7P', 'B7R', 'B7S', 'B7T', 'B7V', 'B7W', 'B7X', 'B7Y', 'B7Z', 'B8A', 'B8B', 'B8C', 'B8E', 'B8G', 'B8H', 'B8J', 'B8K', 'B8L', 'B8M', 'B8N', 'B8P', 'B8R', 'B8S', 'B8T', 'B8V', 'B8W', 'B8X', 'B8Y', 'B8Z', 'B9A', 'B9B', 'B9C', 'B9E', 'B9G', 'B9H', 'B9J', 'B9K', 'B9L', 'B9M', 'B9N', 'B9P', 'B9R', 'B9S', 'B9T', 'B9V', 'B9W', 'B9X', 'B9Y', 'B9Z', 'C0A', 'C0B', 'C1A', 'C1B', 'C1C', 'C1E', 'C1N', 'E0A', 'E0B', 'E0C', 'E0E', 'E0G', 'E0H', 'E0J', 'E0K', 'E0L', 'E0M', 'E0N', 'E0P', 'E0R', 'E0S', 'E0T', 'E0V', 'E0W', 'E0X', 'E0Y', 'E0Z', 'E1A', 'E1B', 'E1C', 'E1E', 'E1G', 'E1H', 'E1J', 'E1K', 'E1L', 'E1M', 'E1N', 'E1P', 'E1R', 'E1S', 'E1T', 'E1V', 'E1W', 'E1X', 'E1Y', 'E1Z', 'E2A', 'E2B', 'E2C', 'E2E', 'E2G', 'E2H', 'E2J', 'E2K', 'E2L', 'E2M', 'E2N', 'E2P', 'E2R', 'E2S', 'E2T', 'E2V', 'E2W', 'E2X', 'E2Y', 'E2Z', 'E3A', 'E3B', 'E3C', 'E3E', 'E3G', 'E3H', 'E3J', 'E3K', 'E3L', 'E3M', 'E3N', 'E3P', 'E3R', 'E3S', 'E3T', 'E3V', 'E3W', 'E3X', 'E3Y', 'E3Z', 'E4A', 'E4B', 'E4C', 'E4E', 'E4G', 'E4H', 'E4J', 'E4K', 'E4L', 'E4M', 'E4N', 'E4P', 'E4R', 'E4S', 'E4T', 'E4V', 'E4W', 'E4X', 'E4Y', 'E4Z', 'E5A', 'E5B', 'E5C', 'E5E', 'E5G', 'E5H', 'E5J', 'E5K', 'E5L', 'E5M', 'E5N', 'E5P', 'E5R', 'E5S', 'E5T', 'E5V', 'E5W', 'E5X', 'E5Y', 'E5Z', 'E6A', 'E6B', 'E6C', 'E6E', 'E6G', 'E6H', 'E6J', 'E6K', 'E6L', 'E6M', 'E6N', 'E6P', 'E6R', 'E6S', 'E6T', 'E6V', 'E6W', 'E6X', 'E6Y', 'E6Z', 'E7A', 'E7B', 'E7C', 'E7E', 'E7G', 'E7H', 'E7J', 'E7K', 'E7L', 'E7M', 'E7N', 'E7P', 'E7R', 'E7S', 'E7T', 'E7V', 'E7W', 'E7X', 'E7Y', 'E7Z', 'E8A', 'E8B', 'E8C', 'E8E', 'E8G', 'E8H', 'E8J', 'E8K', 'E8L', 'E8M', 'E8N', 'E8P', 'E8R', 'E8S', 'E8T', 'E8V', 'E8W', 'E8X', 'E8Y', 'E8Z', 'E9A', 'E9B', 'E9C', 'E9E', 'E9G', 'E9H', 'E9J', 'E9K', 'E9L', 'E9M', 'E9N', 'E9P', 'E9R', 'E9S', 'E9T', 'E9V', 'E9W', 'E9X', 'E9Y', 'E9Z'] )) and (Dim_Position_Hierarchy.FIXED_HIER_LEVEL = 5 or Dim_Position_Hierarchy.FIXED_HIER_LEVEL = 9) and (not Dim_Distributor_Branch.Distributor_Name = 'Patterson-Canada' or Dim_Account.X_ZIP3 in ([ 'A0A', 'A0B', 'A0C', 'A0E', 'A0G', 'A0H', 'A0J', 'A0K', 'A0L', 'A0M', 'A0N', 'A0P', 'A0R', 'A1A', 'A1B', 'A1C', 'A1E', 'A1G', 'A1H', 'A1J', 'A1K', 'A1L', 'A1M', 'A1N', 'A1P', 'A1R', 'A1S', 'A1T', 'A1V', 'A1W', 'A1X', 'A1Y', 'A1Z', 'A2A', 'A2B', 'A2C', 'A2E', 'A2G', 'A2H', 'A2J', 'A2K', 'A2L', 'A2M', 'A2N', 'A2P', 'A2R', 'A2S', 'A2T', 'A2V', 'A2W', 'A2X', 'A2Y', 'A2Z', 'A3A', 'A3B', 'A3C', 'A3E', 'A3G', 'A3H', 'A3J', 'A3K', 'A3L', 'A3M', 'A3N', 'A3P', 'A3R', 'A3S', 'A3T', 'A3V', 'A3W', 'A3X', 'A3Y', 'A3Z', 'A4A', 'A4B', 'A4C', 'A4E', 'A4G', 'A4H', 'A4J', 'A4K', 'A4L', 'A4M', 'A4N', 'A4P', 'A4R', 'A4S', 'A4T', 'A4V', 'A4W', 'A4X', 'A4Y', 'A4Z', 'A5A', 'A5B', 'A5C', 'A5E', 'A5G', 'A5H', 'A5J', 'A5K', 'A5L', 'A5M', 'A5N', 'A5P', 'A5R', 'A5S', 'A5T', 'A5V', 'A5W', 'A5X', 'A5Y', 'A5Z', 'A6A', 'A6B', 'A6C', 'A6E', 'A6G', 'A6H', 'A6J', 'A6K', 'A6L', 'A6M', 'A6N', 'A6P', 'A6R', 'A6S', 'A6T', 'A6V', 'A6W', 'A6X', 'A6Y', 'A6Z', 'A7A', 'A7B', 'A7C', 'A7E', 'A7G', 'A7H', 'A7J', 'A7K', 'A7L', 'A7M', 'A7N', 'A7P', 'A7R', 'A7S', 'A7T', 'A7V', 'A7W', 'A7X', 'A7Y', 'A7Z', 'A8A', 'A8B', 'A8C', 'A8E', 'A8G', 'A8H', 'A8J', 'A8K', 'A8L', 'A8M', 'A8N', 'A8P', 'A8R', 'A8S', 'A8T', 'A8V', 'A8W', 'A8X', 'A8Y', 'A8Z', 'A9A', 'A9B', 'A9C', 'A9E', 'A9G', 'A9H', 'A9J', 'A9K', 'A9L', 'A9M', 'A9N', 'A9P', 'A9R', 'A9S', 'A9T', 'A9V', 'B0B', 'B0C', 'B0E', 'B0G', 'B0H', 'B0J', 'B0K', 'B0L', 'B0M', 'B0N', 'B0P', 'B0R', 'B0S', 'B0T', 'B0V', 'B0W', 'B0X', 'B0Y', 'B0Z', 'B1A', 'B1B', 'B1C', 'B1E', 'B1G', 'B1H', 'B1J', 'B1K', 'B1L', 'B1M', 'B1N', 'B1P', 'B1R', 'B1S', 'B1T', 'B1V', 'B1W', 'B1X', 'B1Y', 'B1Z', 'B2A', 'B2B', 'B2C', 'B2E', 'B2G', 'B2H', 'B2J', 'B2K', 'B2L', 'B2M', 'B2N', 'B2P', 'B2R', 'B2S', 'B2T', 'B2V', 'B2W', 'B2X', 'B2Y', 'B2Z', 'B3A', 'B3B', 'B3C', 'B3E', 'B3G', 'B3H', 'B3J', 'B3K', 'B3L', 'B3M', 'B3N', 'B3P', 'B3R', 'B3S', 'B3T', 'B3V', 'B3W', 'B3X', 'B3Y', 'B3Z', 'B4A', 'B4B', 'B4C', 'B4E', 'B4G', 'B4H', 'B4J', 'B4K', 'B4L', 'B4M', 'B4N', 'B4P', 'B4R', 'B4S', 'B4T', 'B4V', 'B4W', 'B4X', 'B4Y', 'B4Z', 'B5A', 'B5B', 'B5C', 'B5E', 'B5G', 'B5H', 'B5J', 'B5K', 'B5L', 'B5M', 'B5N', 'B5P', 'B5R', 'B5S', 'B5T', 'B5V', 'B5W', 'B5X', 'B5Y', 'B5Z', 'B6A', 'B6B', 'B6C', 'B6E', 'B6G', 'B6H', 'B6J', 'B6K', 'B6L', 'B6M', 'B6N', 'B6P', 'B6R', 'B6S', 'B6T', 'B6V', 'B6W', 'B6X', 'B6Y', 'B6Z', 'B7A', 'B7B', 'B7C', 'B7E', 'B7G', 'B7H', 'B7J', 'B7K', 'B7L', 'B7M', 'B7N', 'B7P', 'B7R', 'B7S', 'B7T', 'B7V', 'B7W', 'B7X', 'B7Y', 'B7Z', 'B8A', 'B8B', 'B8C', 'B8E', 'B8G', 'B8H', 'B8J', 'B8K', 'B8L', 'B8M', 'B8N', 'B8P', 'B8R', 'B8S', 'B8T', 'B8V', 'B8W', 'B8X', 'B8Y', 'B8Z', 'B9A', 'B9B', 'B9C', 'B9E', 'B9G', 'B9H', 'B9J', 'B9K', 'B9L', 'B9M', 'B9N', 'B9P', 'B9R', 'B9S', 'B9T', 'B9V', 'B9W', 'B9X', 'B9Y', 'B9Z', 'C0A', 'C0B', 'C1A', 'C1B', 'C1C', 'C1E', 'C1N', 'E0A', 'E0B', 'E0C', 'E0E', 'E0G', 'E0H', 'E0J', 'E0K', 'E0L', 'E0M', 'E0N', 'E0P', 'E0R', 'E0S', 'E0T', 'E0V', 'E0W', 'E0X', 'E0Y', 'E0Z', 'E1A', 'E1B', 'E1C', 'E1E', 'E1G', 'E1H', 'E1J', 'E1K', 'E1L', 'E1M', 'E1N', 'E1P', 'E1R', 'E1S', 'E1T', 'E1V', 'E1W', 'E1X', 'E1Y', 'E1Z', 'E2A', 'E2B', 'E2C', 'E2E', 'E2G', 'E2H', 'E2J', 'E2K', 'E2L', 'E2M', 'E2N', 'E2P', 'E2R', 'E2S', 'E2T', 'E2V', 'E2W', 'E2X', 'E2Y', 'E2Z', 'E3A', 'E3B', 'E3C', 'E3E', 'E3G', 'E3H', 'E3J', 'E3K', 'E3L', 'E3M', 'E3N', 'E3P', 'E3R', 'E3S', 'E3T', 'E3V', 'E3W', 'E3X', 'E3Y', 'E3Z', 'E4A', 'E4B', 'E4C', 'E4E', 'E4G', 'E4H', 'E4J', 'E4K', 'E4L', 'E4M', 'E4N', 'E4P', 'E4R', 'E4S', 'E4T', 'E4V', 'E4W', 'E4X', 'E4Y', 'E4Z', 'E5A', 'E5B', 'E5C', 'E5E', 'E5G', 'E5H', 'E5J', 'E5K', 'E5L', 'E5M', 'E5N', 'E5P', 'E5R', 'E5S', 'E5T', 'E5V', 'E5W', 'E5X', 'E5Y', 'E5Z', 'E6A', 'E6B', 'E6C', 'E6E', 'E6G', 'E6H', 'E6J', 'E6K', 'E6L', 'E6M', 'E6N', 'E6P', 'E6R', 'E6S', 'E6T', 'E6V', 'E6W', 'E6X', 'E6Y', 'E6Z', 'E7A', 'E7B', 'E7C', 'E7E', 'E7G', 'E7H', 'E7J', 'E7K', 'E7L', 'E7M', 'E7N', 'E7P', 'E7R', 'E7S', 'E7T', 'E7V', 'E7W', 'E7X', 'E7Y', 'E7Z', 'E8A', 'E8B', 'E8C', 'E8E', 'E8G', 'E8H', 'E8J', 'E8K', 'E8L', 'E8M', 'E8N', 'E8P', 'E8R', 'E8S', 'E8T', 'E8V', 'E8W', 'E8X', 'E8Y', 'E8Z', 'E9A', 'E9B', 'E9C', 'E9E', 'E9G', 'E9H', 'E9J', 'E9K', 'E9L', 'E9M', 'E9N', 'E9P', 'E9R', 'E9S', 'E9T', 'E9V', 'E9W', 'E9X', 'E9Y', 'E9Z'] )) and Dim_Period_Month.PER_NAME_YEAR in (Subquery(
RqList <<18991565>> [for database 3023:11:Dentsply BI Cube,83] distinct
Dim_Period_Month.PER_NAME_YEAR as c1 GB [for database 3023:11:Dentsply BI Cube,83]
Child Nodes (RqJoinSpec): <<18991576>> [for database 3023:11:Dentsply BI Cube,83]
RqJoinNode <<18991575>> []
W_MONTH_D AS Dim_Period_Month)) [for database 3023:11:Dentsply BI Cube,83]
GroupBy: [ Dim_Product_Hierarchy.LEVEL_6] [for database 3023:11:Dentsply BI Cube,83]
) as D1
GroupBy: [ D1.c2] [for database 3023:11:Dentsply BI Cube,83]
) as D1
OrderBy: c1 asc, c2 asc [for database 0:0,0])
) as D1
OrderBy: c1 asc [for database 0:0,0]
]]
[2019-07-17T10:24:41.751-04:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 6ec] [messageid: USER-18] [requestid: a60003d] [sessionid: a600000] [username: dcsab074] -------------------- Sending query to database named Dentsply BI Cube (id: <<18991857>>), connection pool named Connection Pool, logical request hash ee9d0ef3, physical request hash aa010e9e: [[
select D1.c2 as c1,
sum(isnull(D1.c1 , 0)) as c2
from
(select sum(T292.S_AMT) as c1,
T245.LEVEL_6 as c2
from
WC_DEALERBRANCH_SALES_D T107 /* Dim_Distributor_Branch */ ,
WC_PRODUCT_HIERARCHY_D T245 /* Dim_Product_Hierarchy */ ,
W_ORG_DH T56 /* Dim_Account_Hierarchy */ ,
W_ORG_D T98 /* Dim_Account */ ,
WC_POSTN_CATLG_FILTER T420 /* Security_Position_Catalog_Filter */ ,
W_ORG_PARTY T673 /* Dim_Position_Hierarchy */ ,
W_MONTH_D T112 /* Dim_Period_Month */ ,
WC_SYNDD_CS_CAN_F T292 /* Fact_Canada_Sales_Current_MTD_Mth */
where ( T107.ROW_WID = T292.X_DISTRIBUTOR_WID and T56.ACCNT_WID = T98.ROW_WID and T98.ROW_WID = T292.ACCNT_WID and T245.PROD_WID = T292.PROD_WID and T292.ACCNT_WID = T673.X_ACCNT_WID and T112.ROW_WID = T292.MONTH_WID and T292.X_CATALOG_ID = T420.CATALOG_ID and T420.POSTN_ID = T673.PARTY_ID and T292.X_CATALOG_ID = T420.CATALOG_ID and T420.POSTN_ID = T673.PARTY_ID and T107.Distributor_Name = 'Patterson-Canada' and T245.HIERARCHY_TYPE = '2019 Canada Commission Brand' and T107.Distributor_Name = 'Patterson-Canada' and T245.LEVEL_6 = 'AC OMNICAM CONNECT' and T245.HIERARCHY_DIVISION = 'Canada' and T673.POSITION_HIER_TYPE = 'Canada' and T245.HIERARCHY_TYPE = '2019 Canada Commission Brand' and T245.LEVEL_6 = 'AC OMNICAM CONNECT' and T245.HIERARCHY_DIVISION = 'Canada' and T673.POSITION_HIER_TYPE = 'Canada' and (T98.X_ZIP3 not in ('E1W', 'E1X', 'E2A', 'E3N', 'E3V', 'E3Z', 'E7C', 'E8A', 'E8B', 'E8C', 'E8E', 'E8J', 'E8K', 'E8S', 'E8T', 'G9B', 'G9N', 'H4Y', 'J0W', 'J0Y', 'J0Z', 'J3T', 'J5V', 'P0T', 'P0V', 'P0W', 'P0X', 'P7A', 'P7B', 'P7C', 'P7E', 'P7K', 'P7L', 'P8N', 'P8T', 'P9A', 'P9N', 'S0A', 'S0C', 'S0G', 'S0H', 'S0J', 'S0K', 'S0L', 'S0N', 'S3N', 'S4A', 'S4H', 'S4P', 'S4R', 'S4S', 'S4T', 'S4V', 'S4X', 'S4Z', 'S6W', 'T0A', 'T0B', 'T0C', 'T0E', 'T0G', 'T0H', 'T4L', 'V0A', 'X0A', 'X0B', 'X0C', 'X0E', 'X1A') and T673.LVL5ANC_POSTN like 'CC%' or T673.LVL5ANC_POSTN <> 'CC101' and T98.X_ZIP3 in ('S6W', 'T4L', 'X0A', 'X0B', 'X0C', 'X0E', 'X1A') or T673.LVL5ANC_POSTN <> 'CC103' and T98.X_ZIP3 in ('S0A', 'S0C', 'S0G', 'S0H', 'S0J', 'S0K', 'S0L', 'S0N', 'S3N', 'S4A', 'S4H', 'S4P', 'S4R', 'S4S', 'S4T', 'S4V', 'S4X', 'S4Z', 'T0A', 'T0B', 'T0C', 'T0E', 'T0G', 'T0H') or T673.LVL5ANC_POSTN <> 'CC105' and T98.X_ZIP3 in ('E1W', 'E1X', 'E2A', 'E3N', 'E3V', 'E3Z', 'E7C', 'E8A', 'E8B', 'E8C', 'E8E', 'E8J', 'E8K', 'E8S', 'E8T') or T98.X_ZIP3 = 'V0A' and T673.LVL5ANC_POSTN <> 'CC104' or T673.LVL5ANC_POSTN <> 'CC105' and T98.X_ZIP3 in ('H4Y', 'J0W') or T673.LVL5ANC_POSTN <> 'CC104' and T98.X_ZIP3 in ('P0T', 'P0V', 'P0W', 'P0X', 'P7A', 'P7B', 'P7C', 'P7E', 'P7K', 'P7L', 'P8N', 'P8T', 'P9A', 'P9N') or T673.LVL5ANC_POSTN <> 'CC106' and T98.X_ZIP3 in ('G9B', 'G9N', 'J0Y', 'J0Z', 'J3T', 'J5V')) and T112.PER_NAME_YEAR in (select distinct T112.PER_NAME_YEAR as c1
from
W_MONTH_D T112 /* Dim_Period_Month */ ) and T245.LEVEL_1 in ('CAD CAM Consumables', 'CAD CAM Equipment') and (T673.FIXED_HIER_LEVEL = 5 or T673.FIXED_HIER_LEVEL = 9) and T245.LEVEL_1 in ('CAD CAM Consumables', 'CAD CAM Equipment') )
group by T245.LEVEL_6
) D1
group by D1.c2
]]
<
p>[2019-07-17T10:24:41.845-04:00] [OBIS] [TRACE:2] [] [] [ecid: ] [sik: ssi] [tid: 6ec] [messageid: USER-18] [requestid: a60003d] [sessionid: a600000] [username: dcsab074] -------------------- Sending query to database named Dentsply BI Cube (id: <<18996722>>), connection pool named Connection Pool, logical request hash ee9d0ef3, physical request hash 98b5be2e:
Answers
-
Is that a Table? If it is, change it to a Pivot Table and that should sort out your issue. If this isn't the issue then we may need to take a further look.
0 -
A Pivot table does work, but this works for other union reports without using a pivot table. What is different.
0
