Index: AAS_PROJ_LEMANS_TAB_MDL.sln =================================================================== diff -u --- AAS_PROJ_LEMANS_TAB_MDL.sln (revision 0) +++ AAS_PROJ_LEMANS_TAB_MDL.sln (revision 1986c2b453d7b4037c2ec9115f03449cfd7d3acd) @@ -0,0 +1,20 @@ + +Microsoft Visual Studio Solution File, Format Version 12.00 +# Visual Studio Version 17 +VisualStudioVersion = 17.12.35527.113 d17.12 +MinimumVisualStudioVersion = 10.0.40219.1 +Project("{6870E480-7721-4708-BFB8-9AE898AA21B3}") = "AAS_PROJ_LEMANS_TAB_MDL", "AAS_PROJ_LEMANS_TAB_MDL.smproj", "{8CE414BB-95B2-4C99-9E03-51BA72086E22}" +EndProject +Global + GlobalSection(SolutionConfigurationPlatforms) = preSolution + Development|x86 = Development|x86 + EndGlobalSection + GlobalSection(ProjectConfigurationPlatforms) = postSolution + {8CE414BB-95B2-4C99-9E03-51BA72086E22}.Development|x86.ActiveCfg = Development|x86 + {8CE414BB-95B2-4C99-9E03-51BA72086E22}.Development|x86.Build.0 = Development|x86 + {8CE414BB-95B2-4C99-9E03-51BA72086E22}.Development|x86.Deploy.0 = Development|x86 + EndGlobalSection + GlobalSection(SolutionProperties) = preSolution + HideSolutionNode = FALSE + EndGlobalSection +EndGlobal Index: AAS_PROJ_LEMANS_TAB_MDL.smproj =================================================================== diff -u --- AAS_PROJ_LEMANS_TAB_MDL.smproj (revision 0) +++ AAS_PROJ_LEMANS_TAB_MDL.smproj (revision 1986c2b453d7b4037c2ec9115f03449cfd7d3acd) @@ -0,0 +1,44 @@ + + + Development + 2.0 + {8CE414BB-95B2-4C99-9E03-51BA72086E22} + Exe + MyRootNamespace + MyAssemblyName + false + bin\ + AAS_PROJ_LEMANS_TAB_MDL + + + bin\ + STG-DATAWH02VM\pdwtabular_uat + Developer + Unknown + Lemans + DataWarehouse + DoNotProcess + False + Default + InMemory + Default + + + asazure://centralus.asazure.windows.net/pdwtabular + Developer + Unknown + AAS_PROJ_LEMANS_TAB_MDL + Model + Default + False + Default + InMemory + Default + + + + Code + + + + \ No newline at end of file Index: Lemans_Tabular.bim =================================================================== diff -u --- Lemans_Tabular.bim (revision 0) +++ Lemans_Tabular.bim (revision 1986c2b453d7b4037c2ec9115f03449cfd7d3acd) @@ -0,0 +1,7927 @@ +{ + "name": "SemanticModel", + "compatibilityLevel": 1500, + "model": { + "name": "DataWarehouse", + "culture": "en-US", + "dataSources": [ + { + "type": "structured", + "name": "SQL/PRD-DATAWH01VM;PDW_Reporting", + "connectionDetails": { + "protocol": "tds", + "address": { + "server": "STG-DATAWH02VM.LEMANSCORP.COM", + "database": "PDW_Reporting" + }, + "authentication": null, + "query": null + }, + "credential": { + "AuthenticationKind": "UsernamePassword", + "kind": "SQL", + "path": "stg-datawh02vm.lemanscorp.com;PDW_Reporting", + "Username": "PDW_Reporting_Read_Only", + "EncryptConnection": false + } + }, + { + "name": "STG-DATAWH02VM PDW_Reporting", + "connectionString": "Provider=SQLNCLI11;Data Source=STG-DATAWH02VM;Persist Security Info=true;User ID=PDW_Reporting_Read_Only;Initial Catalog=PDW_Reporting;Trust Server Certificate=True;Integrated Security=SSPI", + "impersonationMode": "impersonateServiceAccount", + "annotations": [ + { + "name": "ConnectionEditUISource", + "value": "SqlServer" + } + ] + } + ], + "tables": [ + { + "name": "Date Shipped", + "dataCategory": "Time", + "columns": [ + { + "name": "DateID", + "dataType": "int64", + "isHidden": true, + "isUnique": true, + "sourceColumn": "DateID", + "sourceProviderType": "Integer" + }, + { + "name": "Calendar Date", + "dataType": "dateTime", + "isKey": true, + "sourceColumn": "Calendar Date", + "formatString": "yyyy-MM-dd", + "sourceProviderType": "DBDate", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Yr", + "dataType": "int64", + "sourceColumn": "Yr", + "sourceProviderType": "SmallInt" + }, + { + "name": "Qtr", + "dataType": "string", + "sourceColumn": "Qtr", + "sourceProviderType": "Char" + }, + { + "name": "YrQtrID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "YrQtrID", + "sourceProviderType": "SmallInt" + }, + { + "name": "Yr Qtr", + "dataType": "string", + "sourceColumn": "Yr Qtr", + "sourceProviderType": "Char" + }, + { + "name": "MthID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "MthID", + "sourceProviderType": "UnsignedTinyInt" + }, + { + "name": "Mth", + "dataType": "string", + "sourceColumn": "Mth", + "sortByColumn": "MthID", + "sourceProviderType": "Char" + }, + { + "name": "YrMthID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "YrMthID", + "sourceProviderType": "Integer" + }, + { + "name": "Yr Mth", + "dataType": "string", + "sourceColumn": "Yr Mth", + "sortByColumn": "YrMthID", + "sourceProviderType": "Char" + }, + { + "name": "Fiscal Yr", + "dataType": "int64", + "sourceColumn": "Fiscal Yr", + "sourceProviderType": "SmallInt" + }, + { + "name": "Fiscal Qtr", + "dataType": "string", + "sourceColumn": "Fiscal Qtr", + "sourceProviderType": "Char" + }, + { + "name": "Fiscal Yr Qtr", + "dataType": "string", + "sourceColumn": "Fiscal Yr Qtr", + "sourceProviderType": "Char" + }, + { + "name": "FiscalYrMthID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "FiscalYrMthID", + "sourceProviderType": "Integer" + }, + { + "name": "Fiscal Yr Mth", + "dataType": "string", + "sourceColumn": "Fiscal Yr Mth", + "sortByColumn": "FiscalYrMthID", + "sourceProviderType": "Char" + }, + { + "name": "DayNameID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "DayNameID", + "sourceProviderType": "UnsignedTinyInt" + }, + { + "name": "Day Name", + "dataType": "string", + "sourceColumn": "Day Name", + "sortByColumn": "DayNameID", + "sourceProviderType": "Char" + }, + { + "name": "Week Day", + "dataType": "string", + "sourceColumn": "Week Day", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Week End", + "dataType": "string", + "sourceColumn": "Week End", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Holiday", + "dataType": "string", + "sourceColumn": "Holiday", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Current Day", + "dataType": "string", + "sourceColumn": "Current Day", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Current Month", + "dataType": "string", + "sourceColumn": "Current Month", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Current Year", + "dataType": "string", + "sourceColumn": "Current Year", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Rolling 12", + "dataType": "string", + "sourceColumn": "Rolling 12", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Rolling 24", + "dataType": "string", + "sourceColumn": "Rolling 24", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "ShippingDayID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ShippingDayID", + "sourceProviderType": "Integer" + }, + { + "name": "Shipping Day", + "dataType": "string", + "sourceColumn": "Shipping Day", + "sortByColumn": "ShippingDayID", + "sourceProviderType": "Char" + }, + { + "name": "Rolling 12 Prior", + "dataType": "string", + "sourceColumn": "Rolling 12 Prior", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Rolling 12 Prior2", + "dataType": "string", + "sourceColumn": "Rolling 12 Prior2", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Rolling 12 Plus Curr Mth", + "dataType": "string", + "sourceColumn": "Rolling 12 Plus Curr Mth", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Rolling 24 Plus Curr Mth", + "dataType": "string", + "sourceColumn": "Rolling 24 Plus Curr Mth", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Rolling 36", + "dataType": "string", + "sourceColumn": "Rolling 36", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Rolling 36 Plus Curr Mth", + "dataType": "string", + "sourceColumn": "Rolling 36 Plus Curr Mth", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "QtrID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "QtrID" + }, + { + "name": "FiscalQtrID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "FiscalQtrID" + }, + { + "name": "FiscalYrQtrID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "FiscalYrQtrID" + }, + { + "name": "Yr Mth#", + "dataType": "string", + "sourceColumn": "Yr Mth#" + }, + { + "name": "WeekNumberID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "WeekNumberID" + }, + { + "name": "Week Start Date", + "dataType": "dateTime", + "sourceColumn": "Week Start Date", + "formatString": "MM/dd/yyyy", + "sortByColumn": "WeekNumberID", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Week Range", + "dataType": "string", + "sourceColumn": "Week Range", + "sortByColumn": "WeekNumberID" + }, + { + "name": "MtdTy", + "dataType": "string", + "isHidden": true, + "sourceColumn": "MtdTy" + }, + { + "name": "MtdLy", + "dataType": "string", + "isHidden": true, + "sourceColumn": "MtdLy" + }, + { + "name": "PrevMthTy", + "dataType": "string", + "isHidden": true, + "sourceColumn": "PrevMthTy" + }, + { + "name": "PrevMthLy", + "dataType": "string", + "isHidden": true, + "sourceColumn": "PrevMthLy" + }, + { + "name": "FiscalTy", + "dataType": "string", + "isHidden": true, + "sourceColumn": "FiscalTy" + }, + { + "name": "FiscalLy", + "dataType": "string", + "isHidden": true, + "sourceColumn": "FiscalLy" + }, + { + "name": "Week Nbr", + "dataType": "string", + "sourceColumn": "WeekNbr" + } + ], + "partitions": [ + { + "name": "Date Shipped", + "dataView": "full", + "source": { + "type": "query", + "query": "SELECT [SalesCube].[vwDateShipped].* FROM [SalesCube].[vwDateShipped]", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwDateShipped].* FROM [SalesCube].[vwDateShipped]Text]]>" + } + ] + } + ], + "hierarchies": [ + { + "name": "Ship Date", + "levels": [ + { + "name": "Yr", + "ordinal": 0, + "column": "Yr" + }, + { + "name": "Yr Mth", + "ordinal": 1, + "column": "Yr Mth" + }, + { + "name": "Calendar Date", + "ordinal": 2, + "column": "Calendar Date" + } + ] + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": "SELECT [SalesCube].[vwDateShipped].* FROM [SalesCube].[vwDateShipped]" + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwDateShipped" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + }, + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwDateShipped].* FROM [SalesCube].[vwDateShipped]Text]]>" + } + ] + }, + { + "name": "Dealer", + "columns": [ + { + "name": "DealerID", + "dataType": "int64", + "isHidden": true, + "isUnique": true, + "isKey": true, + "sourceColumn": "DealerID", + "sourceProviderType": "Integer" + }, + { + "name": "Dealer Number", + "dataType": "string", + "sourceColumn": "Dealer Number", + "sourceProviderType": "Char" + }, + { + "name": "Dealer", + "dataType": "string", + "sourceColumn": "Dealer", + "sourceProviderType": "Char" + }, + { + "name": "Dealer Ext", + "dataType": "string", + "sourceColumn": "Dealer Ext", + "sourceProviderType": "Char" + }, + { + "name": "Dealer DBA", + "dataType": "string", + "sourceColumn": "Dealer DBA", + "sourceProviderType": "Char" + }, + { + "name": "Contact Name", + "dataType": "string", + "sourceColumn": "Contact Name", + "sourceProviderType": "Char", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer Email", + "dataType": "string", + "sourceColumn": "Dealer Email", + "sourceProviderType": "Char", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dflt Whse", + "dataType": "string", + "sourceColumn": "Dflt Whse", + "sourceProviderType": "Char" + }, + { + "name": "Purchase Level Code", + "dataType": "string", + "sourceColumn": "Purchase Level Code", + "sourceProviderType": "Char" + }, + { + "name": "Purchase Level", + "dataType": "string", + "sourceColumn": "Purchase Level", + "sourceProviderType": "Char" + }, + { + "name": "Purchase Level Disc Plus", + "dataType": "string", + "sourceColumn": "Purchase Level Disc Plus", + "sourceProviderType": "Char" + }, + { + "name": "Parent Dealer Number", + "dataType": "string", + "sourceColumn": "Parent Dealer Number", + "sourceProviderType": "Char" + }, + { + "name": "Parent Dealer", + "dataType": "string", + "sourceColumn": "Parent Dealer", + "sourceProviderType": "Char" + }, + { + "name": "Sales Region Code", + "dataType": "string", + "sourceColumn": "Sales Region Code", + "sourceProviderType": "Char", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Sales Region", + "dataType": "string", + "sourceColumn": "Sales Region", + "sourceProviderType": "Char", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Sales Region Manager", + "dataType": "string", + "sourceColumn": "Sales Region Manager", + "sourceProviderType": "Char", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Sales Region Group", + "dataType": "string", + "sourceColumn": "Sales Region Group", + "sourceProviderType": "Char", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Sales Rep Code", + "dataType": "string", + "sourceColumn": "Sales Rep Code", + "sourceProviderType": "Char", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Sales Rep", + "dataType": "string", + "sourceColumn": "Sales Rep", + "sourceProviderType": "Char", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Dealer Type Code", + "dataType": "string", + "sourceColumn": "Dealer Type Code", + "sourceProviderType": "Char" + }, + { + "name": "Dealer Type", + "dataType": "string", + "sourceColumn": "Dealer Type", + "sourceProviderType": "Char" + }, + { + "name": "Dealer Address1", + "dataType": "string", + "sourceColumn": "Dealer Address1", + "sourceProviderType": "Char", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer Address2", + "dataType": "string", + "sourceColumn": "Dealer Address2", + "sourceProviderType": "Char", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer City", + "dataType": "string", + "sourceColumn": "Dealer City", + "sourceProviderType": "Char", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer State", + "dataType": "string", + "sourceColumn": "Dealer State", + "sourceProviderType": "Char", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer Zip", + "dataType": "string", + "sourceColumn": "Dealer Zip", + "sourceProviderType": "Char", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Carb Opt Out", + "dataType": "string", + "sourceColumn": "Carb Opt Out", + "sourceProviderType": "Char" + }, + { + "name": "Dealer Type Code History", + "dataType": "string", + "sourceColumn": "Dealer Type Code History", + "sourceProviderType": "Char", + "displayFolder": "History Tracking" + }, + { + "name": "Dealer Type History", + "dataType": "string", + "sourceColumn": "Dealer Type History", + "sourceProviderType": "Char", + "displayFolder": "History Tracking" + }, + { + "name": "Sales Region Code History", + "dataType": "string", + "sourceColumn": "Sales Region Code History", + "sourceProviderType": "Char", + "displayFolder": "History Tracking" + }, + { + "name": "Sales Region History", + "dataType": "string", + "sourceColumn": "Sales Region History", + "sourceProviderType": "Char", + "displayFolder": "History Tracking" + }, + { + "name": "Sales Rep Code History", + "dataType": "string", + "sourceColumn": "Sales Rep Code History", + "sourceProviderType": "Char", + "displayFolder": "History Tracking" + }, + { + "name": "Sales Rep History", + "dataType": "string", + "sourceColumn": "Sales Rep History", + "sourceProviderType": "Char", + "displayFolder": "History Tracking" + }, + { + "name": "Base Rep Code", + "dataType": "string", + "sourceColumn": "Base Rep Code", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Base Rep", + "dataType": "string", + "sourceColumn": "Base Rep", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Dealer State Abbr", + "dataType": "string", + "sourceColumn": "Dealer State Abbr", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "National Sales Mgr", + "dataType": "string", + "sourceColumn": "National Sales Mgr", + "sortByColumn": "NationalSalesMgrSort", + "displayFolder": "Sales Rep Details" + }, + { + "name": "NationalSalesMgrSort", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "NationalSalesMgrSort", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Title Name", + "dataType": "string", + "sourceColumn": "Title Name", + "sortByColumn": "TitleSort", + "displayFolder": "Sales Rep Details" + }, + { + "name": "TitleSort", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "TitleSort" + }, + { + "name": "Base Region Code", + "dataType": "string", + "sourceColumn": "Base Region Code", + "displayFolder": "Sales Rep Details" + }, + { + "name": "LeMans Corp Dealer", + "dataType": "string", + "sourceColumn": "LeMans Corp Dealer" + }, + { + "name": "Dealer Country Code", + "dataType": "string", + "sourceColumn": "Dealer Country Code", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer Country", + "dataType": "string", + "sourceColumn": "Dealer Country", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer Class Code", + "dataType": "string", + "sourceColumn": "Dealer Class Code" + }, + { + "name": "Dealer Class", + "dataType": "string", + "sourceColumn": "Dealer Class" + }, + { + "name": "Dealer Open", + "dataType": "string", + "sourceColumn": "Dealer Open" + }, + { + "name": "Multi Dealer", + "dataType": "string", + "sourceColumn": "Multi Dealer" + }, + { + "name": "Secondary Rep", + "dataType": "string", + "sourceColumn": "Secondary Rep", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Road Rep Code", + "dataType": "string", + "sourceColumn": "Road Rep Code", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Road Rep", + "dataType": "string", + "sourceColumn": "Road Rep", + "displayFolder": "Sales Rep Details" + }, + { + "name": "Dealer Primary Email", + "dataType": "string", + "sourceColumn": "Dealer Primary Email", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer ShipTo Address1", + "dataType": "string", + "sourceColumn": "Dealer ShipTo Address1", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer ShipTo Address2", + "dataType": "string", + "sourceColumn": "Dealer ShipTo Address2", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer ShipTo City", + "dataType": "string", + "sourceColumn": "Dealer ShipTo City", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer ShipTo State Abbr", + "dataType": "string", + "sourceColumn": "Dealer ShipTo State Abbr", + "displayFolder": "Dealer Address & Contact" + }, + { + "name": "Dealer ShipTo Zip", + "dataType": "string", + "sourceColumn": "Dealer ShipTo Zip", + "displayFolder": "Dealer Address & Contact" + } + ], + "partitions": [ + { + "name": "Dealer", + "dataView": "full", + "source": { + "type": "query", + "query": "SELECT [SalesCube].[vwDealer].* FROM [SalesCube].[vwDealer]", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwDealer].* FROM [SalesCube].[vwDealer]Text]]>" + } + ] + } + ], + "hierarchies": [ + { + "name": "Dealers", + "levels": [ + { + "name": "Parent Dealer", + "ordinal": 0, + "column": "Parent Dealer" + }, + { + "name": "Dealer Ext", + "ordinal": 1, + "column": "Dealer Ext" + } + ] + }, + { + "name": "Regions", + "levels": [ + { + "name": "Sales Region", + "ordinal": 0, + "column": "Sales Region" + }, + { + "name": "Sales Rep", + "ordinal": 2, + "column": "Sales Rep" + }, + { + "name": "Dealer Ext", + "ordinal": 3, + "column": "Dealer Ext" + }, + { + "name": "Base Rep", + "ordinal": 1, + "column": "Base Rep" + } + ] + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": "SELECT [SalesCube].[vwDealer].* FROM [SalesCube].[vwDealer]" + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwDealer" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + }, + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwDealer].* FROM [SalesCube].[vwDealer]Text]]>" + } + ] + }, + { + "name": "Item", + "columns": [ + { + "name": "ItemID", + "dataType": "int64", + "isHidden": true, + "isKey": true, + "sourceColumn": "ItemID", + "sourceProviderType": "Integer" + }, + { + "name": "Item Number", + "dataType": "string", + "sourceColumn": "Item Number", + "sourceProviderType": "Char" + }, + { + "name": "Item", + "dataType": "string", + "sourceColumn": "Item", + "sourceProviderType": "Char" + }, + { + "name": "Item Ext", + "dataType": "string", + "sourceColumn": "Item Ext", + "sourceProviderType": "Char" + }, + { + "name": "Unit of Measure", + "dataType": "string", + "sourceColumn": "Unit of Measure", + "sourceProviderType": "Char" + }, + { + "name": "Abc Usage Code", + "dataType": "string", + "sourceColumn": "Abc Usage Code", + "sourceProviderType": "Char", + "displayFolder": "ABC Codes" + }, + { + "name": "Abc Forecast Code", + "dataType": "string", + "sourceColumn": "Abc Forecast Code", + "sourceProviderType": "Char", + "displayFolder": "ABC Codes" + }, + { + "name": "Upc Code", + "dataType": "string", + "sourceColumn": "Upc Code", + "sourceProviderType": "Char" + }, + { + "name": "Truck Only", + "dataType": "string", + "sourceColumn": "Truck Only", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Date Added", + "dataType": "string", + "sourceColumn": "Date Added", + "sourceProviderType": "DBDate", + "displayFolder": "Date Details" + }, + { + "name": "Current Retail Price", + "dataType": "double", + "sourceColumn": "Current Retail Price", + "sourceProviderType": "Numeric", + "displayFolder": "Pricing Details" + }, + { + "name": "Dealer Price", + "dataType": "double", + "sourceColumn": "Dealer Price", + "sourceProviderType": "Numeric", + "displayFolder": "Pricing Details" + }, + { + "name": "Current Cost", + "dataType": "double", + "sourceColumn": "Current Cost", + "sourceProviderType": "Numeric", + "displayFolder": "Pricing Details" + }, + { + "name": "Original Retail Price", + "dataType": "double", + "sourceColumn": "Original Retail Price", + "sourceProviderType": "Numeric", + "displayFolder": "Pricing Details" + }, + { + "name": "Original Dealer Price", + "dataType": "double", + "sourceColumn": "Original Dealer Price", + "sourceProviderType": "Numeric", + "displayFolder": "Pricing Details" + }, + { + "name": "Visible", + "dataType": "string", + "sourceColumn": "Visible", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Prop65", + "dataType": "string", + "sourceColumn": "Prop65", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "RetailAA", + "dataType": "string", + "sourceColumn": "RetailAA", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "DealerAA", + "dataType": "string", + "sourceColumn": "DealerAA", + "sourceProviderType": "Char", + "displayFolder": "Indicators" + }, + { + "name": "Go Live Date", + "dataType": "string", + "sourceColumn": "Go Live Date", + "sourceProviderType": "DBDate", + "displayFolder": "Date Details" + }, + { + "name": "Metric Cubes", + "dataType": "double", + "sourceColumn": "Metric Cubes", + "sourceProviderType": "Numeric" + }, + { + "name": "Country of Origin", + "dataType": "string", + "sourceColumn": "Country of Origin", + "sourceProviderType": "Char" + }, + { + "name": "Standard Cost", + "dataType": "double", + "sourceColumn": "Standard Cost", + "sourceProviderType": "Numeric", + "displayFolder": "Pricing Details" + }, + { + "name": "Next Standard Cost", + "dataType": "double", + "sourceColumn": "Next Standard Cost", + "sourceProviderType": "Numeric", + "displayFolder": "Pricing Details" + }, + { + "name": "First Day Visible", + "dataType": "dateTime", + "sourceColumn": "First Day Visible", + "formatString": "yyyy-MM-dd", + "sourceProviderType": "DBDate", + "displayFolder": "Date Details", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Date First Received", + "dataType": "dateTime", + "sourceColumn": "Date First Received", + "formatString": "yyyy-MM-dd", + "sourceProviderType": "DBDate", + "displayFolder": "Date Details", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Brand Code", + "dataType": "string", + "sourceColumn": "Brand Code", + "sourceProviderType": "Char", + "displayFolder": "Brand" + }, + { + "name": "Brand", + "dataType": "string", + "sourceColumn": "Brand", + "sourceProviderType": "Char", + "displayFolder": "Brand" + }, + { + "name": "Brand Ext", + "dataType": "string", + "sourceColumn": "Brand Ext", + "sourceProviderType": "Char", + "displayFolder": "Brand" + }, + { + "name": "Carb Code", + "dataType": "string", + "sourceColumn": "Carb Code", + "sourceProviderType": "Char", + "displayFolder": "Carb Code" + }, + { + "name": "Carb Code Desc", + "dataType": "string", + "sourceColumn": "Carb Code Desc", + "sourceProviderType": "Char", + "displayFolder": "Carb Code" + }, + { + "name": "Harmonized Code Eu", + "dataType": "string", + "sourceColumn": "Harmonized Code Eu", + "sourceProviderType": "Char", + "displayFolder": "Harmonized" + }, + { + "name": "Harmonized Eu", + "dataType": "string", + "sourceColumn": "Harmonized Eu", + "sourceProviderType": "Char", + "displayFolder": "Harmonized" + }, + { + "name": "Harmonized Code Us", + "dataType": "string", + "sourceColumn": "Harmonized Code Us", + "sourceProviderType": "Char", + "displayFolder": "Harmonized" + }, + { + "name": "Harmonized Us", + "dataType": "string", + "sourceColumn": "Harmonized Us", + "sourceProviderType": "Char", + "displayFolder": "Harmonized" + }, + { + "name": "Schedule B", + "dataType": "string", + "sourceColumn": "Schedule B", + "sourceProviderType": "Char" + }, + { + "name": "Hazardous Code", + "dataType": "string", + "sourceColumn": "Hazardous Code", + "sourceProviderType": "Char", + "displayFolder": "Hazardous" + }, + { + "name": "Hazardous", + "dataType": "string", + "sourceColumn": "Hazardous", + "sourceProviderType": "Char", + "displayFolder": "Hazardous" + }, + { + "name": "Item Status Code", + "dataType": "string", + "sourceColumn": "Item Status Code", + "sourceProviderType": "Char", + "displayFolder": "Item Status" + }, + { + "name": "Item Status", + "dataType": "string", + "sourceColumn": "Item Status", + "sourceProviderType": "Char", + "displayFolder": "Item Status" + }, + { + "name": "Product Code", + "dataType": "string", + "sourceColumn": "Product Code", + "sourceProviderType": "Char", + "displayFolder": "Product" + }, + { + "name": "Product", + "dataType": "string", + "sourceColumn": "Product", + "sourceProviderType": "Char", + "displayFolder": "Product" + }, + { + "name": "Product Ext", + "dataType": "string", + "sourceColumn": "Product Ext", + "sourceProviderType": "Char", + "displayFolder": "Product" + }, + { + "name": "Commodity Code", + "dataType": "string", + "sourceColumn": "Commodity Code", + "sourceProviderType": "Char", + "displayFolder": "Commodity" + }, + { + "name": "Commodity", + "dataType": "string", + "sourceColumn": "Commodity", + "sourceProviderType": "Char", + "displayFolder": "Commodity" + }, + { + "name": "Commodity Ext", + "dataType": "string", + "sourceColumn": "Commodity Ext", + "sourceProviderType": "Char", + "displayFolder": "Commodity" + }, + { + "name": "Sub Commodity Code", + "dataType": "string", + "sourceColumn": "Sub Commodity Code", + "sourceProviderType": "Char", + "displayFolder": "Commodity" + }, + { + "name": "Sub Commodity", + "dataType": "string", + "sourceColumn": "Sub Commodity", + "sourceProviderType": "Char", + "displayFolder": "Commodity" + }, + { + "name": "Sub Commodity Ext", + "dataType": "string", + "sourceColumn": "Sub Commodity Ext", + "sourceProviderType": "Char", + "displayFolder": "Commodity" + }, + { + "name": "Primary Vendor Code", + "dataType": "string", + "sourceColumn": "Primary Vendor Code", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Primary Vendor", + "dataType": "string", + "sourceColumn": "Primary Vendor", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Primary Vendor Ext", + "dataType": "string", + "sourceColumn": "Primary Vendor Ext", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Secondary Vendor Code", + "dataType": "string", + "sourceColumn": "Secondary Vendor Code", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Secondary Vendor", + "dataType": "string", + "sourceColumn": "Secondary Vendor", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Secondary Vendor Ext", + "dataType": "string", + "sourceColumn": "Secondary Vendor Ext", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Parent Supplier Code", + "dataType": "string", + "sourceColumn": "Parent Supplier Code", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Parent Supplier", + "dataType": "string", + "sourceColumn": "Parent Supplier", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Parent Supplier Ext", + "dataType": "string", + "sourceColumn": "Parent Supplier Ext", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Supplier Code", + "dataType": "string", + "sourceColumn": "Supplier Code", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Supplier", + "dataType": "string", + "sourceColumn": "Supplier", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Supplier Ext", + "dataType": "string", + "sourceColumn": "Supplier Ext", + "sourceProviderType": "Char", + "displayFolder": "Vendor Details" + }, + { + "name": "Buyer Code", + "dataType": "string", + "sourceColumn": "Buyer Code", + "sourceProviderType": "Char", + "displayFolder": "Buyer Details" + }, + { + "name": "Buyer", + "dataType": "string", + "sourceColumn": "Buyer", + "sourceProviderType": "Char", + "displayFolder": "Buyer Details" + }, + { + "name": "Buyer Ext", + "dataType": "string", + "sourceColumn": "Buyer Ext", + "sourceProviderType": "Char", + "displayFolder": "Buyer Details" + }, + { + "name": "Buyer Location", + "dataType": "string", + "sourceColumn": "Buyer Location", + "sourceProviderType": "Char", + "displayFolder": "Buyer Details" + }, + { + "name": "Buyer Manager", + "dataType": "string", + "sourceColumn": "Buyer Manager", + "sourceProviderType": "Char", + "displayFolder": "Buyer Details" + }, + { + "name": "Warehoused Country Code", + "dataType": "string", + "sourceColumn": "Warehoused Country Code", + "sourceProviderType": "Char" + }, + { + "name": "Gender Age", + "dataType": "string", + "sourceColumn": "Gender Age", + "sourceProviderType": "Char", + "displayFolder": "Digi Attributes" + }, + { + "name": "Display Color", + "dataType": "string", + "sourceColumn": "Display Color", + "sourceProviderType": "Char", + "displayFolder": "Digi Attributes" + }, + { + "name": "Size", + "dataType": "string", + "sourceColumn": "Size", + "sourceProviderType": "Char", + "displayFolder": "Digi Attributes" + }, + { + "name": "Product Name", + "dataType": "string", + "sourceColumn": "Product Name", + "sourceProviderType": "Char", + "displayFolder": "Digi Attributes" + }, + { + "name": "Type", + "dataType": "string", + "sourceColumn": "Type", + "sourceProviderType": "Char", + "displayFolder": "Digi Attributes" + }, + { + "name": "Model", + "dataType": "string", + "sourceColumn": "Model", + "sourceProviderType": "Char", + "displayFolder": "Digi Attributes" + }, + { + "name": "Color Finish", + "dataType": "string", + "sourceColumn": "Color Finish", + "displayFolder": "Digi Attributes" + }, + { + "name": "Sales Model", + "dataType": "string", + "sourceColumn": "Sales Model", + "displayFolder": "Digi Attributes" + }, + { + "name": "Catalog List", + "dataType": "string", + "sourceColumn": "Catalog List" + }, + { + "name": "Primary Vendor Status Code", + "dataType": "string", + "sourceColumn": "Primary Vendor Status Code", + "displayFolder": "Vendor Details" + }, + { + "name": "Primary Vendor Status", + "dataType": "string", + "sourceColumn": "Primary Vendor Status", + "displayFolder": "Vendor Details" + }, + { + "name": "Secondary Vendor Status Code", + "dataType": "string", + "sourceColumn": "Secondary Vendor Status Code", + "displayFolder": "Vendor Details" + }, + { + "name": "Secondary Vendor Status", + "dataType": "string", + "sourceColumn": "Secondary Vendor Status", + "displayFolder": "Vendor Details" + }, + { + "name": "Date Discontinued", + "dataType": "string", + "sourceColumn": "Date Discontinued" + }, + { + "name": "Brand Group", + "dataType": "string", + "sourceColumn": "Brand Group", + "displayFolder": "Brand" + }, + { + "name": "House Brand", + "dataType": "string", + "sourceColumn": "House Brand", + "displayFolder": "Brand" + }, + { + "name": "Primary Vendor Visible", + "dataType": "string", + "sourceColumn": "Primary Vendor Visible", + "displayFolder": "Vendor Details" + }, + { + "name": "Secondary Vendor Visible", + "dataType": "string", + "sourceColumn": "Secondary Vendor Visible", + "displayFolder": "Vendor Details" + }, + { + "name": "Vendor Item Number", + "dataType": "string", + "sourceColumn": "Vendor Item Number", + "displayFolder": "Vendor Details" + }, + { + "name": "PE Default Vendor Code", + "dataType": "string", + "sourceColumn": "PE Default Vendor Code", + "displayFolder": "Vendor Details" + }, + { + "type": "calculated", + "name": "Total Sales", + "dataType": "double", + "isDataTypeInferred": true, + "expression": " SUMX ( RELATEDTABLE ('Shipped Orders'), 'Shipped Orders'[Dealer Price] * 'Shipped Orders'[QtyShipped])", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Pick ID", + "dataType": "string", + "description": "Mainframe assigned Pick ID", + "isHidden": true, + "sourceColumn": "Pick ID" + }, + { + "name": "Auto Go Live Ind", + "dataType": "string", + "sourceColumn": "Auto Go Live Ind" + }, + { + "name": "Planning Group", + "dataType": "string", + "sourceColumn": "Planning Group", + "displayFolder": "SO99" + }, + { + "name": "Death Date", + "dataType": "string", + "sourceColumn": "Death Date", + "displayFolder": "SO99" + }, + { + "name": "Product Line", + "dataType": "string", + "sourceColumn": "Product Line", + "displayFolder": "SO99" + }, + { + "name": "Service Class", + "dataType": "string", + "sourceColumn": "Service Class", + "displayFolder": "SO99" + }, + { + "name": "Item Type", + "dataType": "string", + "sourceColumn": "Item Type", + "displayFolder": "SO99" + }, + { + "name": "Seasonality Group", + "dataType": "string", + "sourceColumn": "Seasonality Group", + "displayFolder": "SO99" + }, + { + "name": "Item Catalog Status Code", + "dataType": "string", + "sourceColumn": "Item Catalog Status Code", + "displayFolder": "Item Status" + }, + { + "name": "Item Catalog Status", + "dataType": "string", + "sourceColumn": "Item Catalog Status", + "displayFolder": "Item Status" + } + ], + "partitions": [ + { + "name": "Item", + "dataView": "full", + "source": { + "type": "query", + "query": "SELECT [SalesCube].[vwItem].* FROM [SalesCube].[vwItem]", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwItem].* FROM [SalesCube].[vwItem]Text]]>" + } + ] + } + ], + "hierarchies": [ + { + "name": "Buyers", + "levels": [ + { + "name": "Buyer Ext", + "ordinal": 0, + "column": "Buyer Ext" + }, + { + "name": "Primary Vendor Ext", + "ordinal": 1, + "column": "Primary Vendor Ext" + }, + { + "name": "Item Ext", + "ordinal": 2, + "column": "Item Ext" + } + ] + }, + { + "name": "Commodities", + "levels": [ + { + "name": "Commodity Ext", + "ordinal": 0, + "column": "Commodity Ext" + }, + { + "name": "Sub Commodity Ext", + "ordinal": 1, + "column": "Sub Commodity Ext" + }, + { + "name": "Item Ext", + "ordinal": 2, + "column": "Item Ext" + } + ] + }, + { + "name": "Vendors", + "levels": [ + { + "name": "Primary Vendor Ext", + "ordinal": 1, + "column": "Primary Vendor Ext" + }, + { + "name": "Parent Vendor Ext", + "ordinal": 0, + "column": "Parent Supplier Ext" + }, + { + "name": "Item Ext", + "ordinal": 2, + "column": "Item Ext" + } + ] + }, + { + "name": "Managers", + "levels": [ + { + "name": "Buyer Manager", + "ordinal": 0, + "column": "Buyer Manager" + }, + { + "name": "Buyer Ext", + "ordinal": 1, + "column": "Buyer Ext" + }, + { + "name": "Primary Vendor Ext", + "ordinal": 2, + "column": "Primary Vendor Ext" + }, + { + "name": "Item Ext", + "ordinal": 3, + "column": "Item Ext" + } + ] + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": "SELECT [SalesCube].[vwItem].* FROM [SalesCube].[vwItem]" + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwItem" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + }, + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwItem].* FROM [SalesCube].[vwItem]Text]]>" + } + ] + }, + { + "name": "Item History", + "columns": [ + { + "name": "ItemHistoryID", + "dataType": "int64", + "isHidden": true, + "isKey": true, + "sourceColumn": "ItemHistoryID", + "sourceProviderType": "Integer" + }, + { + "name": "Item Number", + "dataType": "string", + "sourceColumn": "Item Number", + "sourceProviderType": "Char" + }, + { + "name": "Item Start Date", + "dataType": "dateTime", + "sourceColumn": "Item Start Date", + "formatString": "yyyy-MM-dd", + "sourceProviderType": "DBDate", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Item End Date", + "dataType": "dateTime", + "sourceColumn": "Item End Date", + "formatString": "yyyy-MM-dd", + "sourceProviderType": "DBDate", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Current Cost History", + "dataType": "double", + "sourceColumn": "Current Cost History", + "sourceProviderType": "Numeric" + }, + { + "name": "Dealer Price History", + "dataType": "double", + "sourceColumn": "Dealer Price History", + "sourceProviderType": "Numeric" + }, + { + "name": "Current Retail Price History", + "dataType": "double", + "sourceColumn": "Current Retail Price History", + "sourceProviderType": "Numeric" + }, + { + "name": "Item Status Code History", + "dataType": "string", + "sourceColumn": "Item Status Code History", + "sourceProviderType": "Char" + }, + { + "name": "Visible History", + "dataType": "string", + "sourceColumn": "Visible History", + "sourceProviderType": "Char" + }, + { + "name": "Warehoused Country Code History", + "dataType": "string", + "sourceColumn": "Warehoused Country Code History", + "sourceProviderType": "Char" + } + ], + "partitions": [ + { + "name": "Item History", + "dataView": "full", + "source": { + "type": "query", + "query": " SELECT [SalesCube].[vwItemHistory].* FROM [SalesCube].[vwItemHistory] ", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + } + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": " SELECT [SalesCube].[vwItemHistory].* FROM [SalesCube].[vwItemHistory] " + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwItemHistory" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + } + ] + }, + { + "name": "Sales Misc", + "columns": [ + { + "name": "SalesMiscID", + "dataType": "int64", + "isHidden": true, + "isKey": true, + "sourceColumn": "SalesMiscID", + "sourceProviderType": "Integer" + }, + { + "name": "Freight Code", + "dataType": "string", + "sourceColumn": "Freight Code", + "sourceProviderType": "Char", + "displayFolder": "Freight" + }, + { + "name": "Freight", + "dataType": "string", + "sourceColumn": "Freight", + "sourceProviderType": "Char", + "displayFolder": "Freight" + }, + { + "name": "Order Source Code", + "dataType": "string", + "sourceColumn": "Order Source Code", + "sourceProviderType": "Char", + "displayFolder": "Order Source" + }, + { + "name": "Order Source", + "dataType": "string", + "sourceColumn": "Order Source", + "sourceProviderType": "Char", + "displayFolder": "Order Source" + }, + { + "name": "Order Source Type", + "dataType": "string", + "sourceColumn": "Order Source Type", + "sourceProviderType": "Char", + "displayFolder": "Order Source" + }, + { + "name": "Order Terms Code", + "dataType": "string", + "sourceColumn": "Order Terms Code", + "sourceProviderType": "Char", + "displayFolder": "Order Terms" + }, + { + "name": "Order Terms", + "dataType": "string", + "sourceColumn": "Order Terms", + "sourceProviderType": "Char", + "displayFolder": "Order Terms" + }, + { + "name": "OrderTimeID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "OrderTimeID", + "sourceProviderType": "UnsignedTinyInt" + }, + { + "name": "Order Time Hr", + "dataType": "string", + "sourceColumn": "Order Time Hr", + "sortByColumn": "OrderTimeID", + "sourceProviderType": "Char" + }, + { + "name": "Order Type Code", + "dataType": "string", + "sourceColumn": "Order Type Code", + "sourceProviderType": "Char", + "displayFolder": "Order Type" + }, + { + "name": "Order Type", + "dataType": "string", + "sourceColumn": "Order Type", + "sourceProviderType": "Char", + "displayFolder": "Order Type" + }, + { + "name": "Shipped Via Code", + "dataType": "string", + "sourceColumn": "Shipped Via Code", + "sourceProviderType": "Char", + "displayFolder": "Shipped Via" + }, + { + "name": "Shipped Via", + "dataType": "string", + "sourceColumn": "Shipped Via", + "sourceProviderType": "Char", + "displayFolder": "Shipped Via" + }, + { + "name": "Shipped Via Category Code", + "dataType": "string", + "sourceColumn": "Shipped Via Category Code", + "sourceProviderType": "Char", + "displayFolder": "Shipped Via" + }, + { + "name": "Shipped Via Category", + "dataType": "string", + "sourceColumn": "Shipped Via Category", + "sourceProviderType": "Char", + "displayFolder": "Shipped Via" + }, + { + "name": "Dealer Type Desc", + "dataType": "string", + "sourceColumn": "Dealer Type Desc", + "displayFolder": "Dealer Type" + }, + { + "name": "Dealer Type Code", + "dataType": "string", + "sourceColumn": "Dealer Type Code", + "displayFolder": "Dealer Type" + } + ], + "partitions": [ + { + "name": "SalesMisc", + "dataView": "full", + "source": { + "type": "query", + "query": "SELECT [SalesCube].[vwSalesMisc].* FROM [SalesCube].[vwSalesMisc]", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwSalesMisc].* FROM [SalesCube].[vwSalesMisc]Text]]>" + } + ] + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": "SELECT [SalesCube].[vwSalesMisc].* FROM [SalesCube].[vwSalesMisc]" + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwSalesMisc" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + }, + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwSalesMisc].* FROM [SalesCube].[vwSalesMisc]Text]]>" + } + ] + }, + { + "name": "Ship To Address", + "columns": [ + { + "name": "SalesShipToAddressID", + "dataType": "int64", + "isHidden": true, + "isKey": true, + "sourceColumn": "SalesShipToAddressID", + "sourceProviderType": "Integer" + }, + { + "name": "Ship To Address1", + "dataType": "string", + "sourceColumn": "ShipToAddress1", + "sourceProviderType": "Char" + }, + { + "name": "Ship To Address2", + "dataType": "string", + "sourceColumn": "ShipToAddress2", + "sourceProviderType": "Char" + }, + { + "name": "Ship To Address3", + "dataType": "string", + "sourceColumn": "ShipToAddress3", + "sourceProviderType": "Char" + }, + { + "name": "Ship To City", + "dataType": "string", + "sourceColumn": "ShipToCity", + "sourceProviderType": "Char" + }, + { + "name": "Ship To State", + "dataType": "string", + "sourceColumn": "ShipToState", + "sourceProviderType": "Char" + }, + { + "name": "Ship To Zip Code", + "dataType": "string", + "sourceColumn": "ShipToZipCode", + "sourceProviderType": "Char" + }, + { + "name": "Ship To Zip Code4", + "dataType": "string", + "sourceColumn": "ShipToZipCode4", + "sourceProviderType": "Char" + }, + { + "name": "Ship To Country", + "dataType": "string", + "sourceColumn": "ShipToCountry", + "sourceProviderType": "Char" + } + ], + "partitions": [ + { + "name": "Ship To Address", + "dataView": "full", + "source": { + "type": "query", + "query": " SELECT [SalesCube].[vwDimShipToAddress].* FROM [SalesCube].[vwDimShipToAddress] ", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + } + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": " SELECT [SalesCube].[vwDimShipToAddress].* FROM [SalesCube].[vwDimShipToAddress] " + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwDimShipToAddress" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + } + ] + }, + { + "name": "Inventory Date", + "columns": [ + { + "name": "InventoryDateID", + "dataType": "int64", + "isHidden": true, + "isKey": true, + "sourceColumn": "InventoryDateID", + "sourceProviderType": "Integer" + }, + { + "name": "Inventory Yr Mth", + "dataType": "string", + "sourceColumn": "Inventory Yr Mth", + "sortByColumn": "InventoryDateID", + "sourceProviderType": "Char" + }, + { + "name": "Inventory Yr Mth Nbr", + "dataType": "string", + "sourceColumn": "Inventory Yr Mth Nbr", + "sourceProviderType": "Char" + }, + { + "name": "Rolling 12", + "dataType": "string", + "sourceColumn": "Rolling 12", + "sourceProviderType": "Char" + }, + { + "name": "Rolling 24", + "dataType": "string", + "sourceColumn": "Rolling 24", + "sourceProviderType": "Char" + }, + { + "name": "Current Month", + "dataType": "string", + "sourceColumn": "Current Month", + "sourceProviderType": "Char" + } + ], + "partitions": [ + { + "name": "Inventory Date", + "dataView": "full", + "source": { + "type": "query", + "query": " SELECT [SalesCube].[vwDimInventoryDate].* FROM [SalesCube].[vwDimInventoryDate] ", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + } + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": " SELECT [SalesCube].[vwDimInventoryDate].* FROM [SalesCube].[vwDimInventoryDate] " + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwDimInventoryDate" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + } + ] + }, + { + "name": "Inventory", + "columns": [ + { + "name": "InventoryID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "InventoryID", + "sourceProviderType": "Integer" + }, + { + "name": "InventoryDateID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "InventoryDateID", + "sourceProviderType": "Integer" + }, + { + "name": "ItemID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ItemID", + "sourceProviderType": "Integer" + }, + { + "name": "ItemHistoryID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ItemHistoryID", + "sourceProviderType": "Integer" + }, + { + "name": "Warehouse Code", + "dataType": "string", + "sourceColumn": "Warehouse Code", + "sourceProviderType": "Char" + }, + { + "name": "Warehouse State", + "dataType": "string", + "sourceColumn": "Warehouse State", + "sourceProviderType": "Char" + }, + { + "name": "Buy Status Code", + "dataType": "string", + "sourceColumn": "Buy Status Code", + "sourceProviderType": "Char" + }, + { + "name": "Buy Status", + "dataType": "string", + "sourceColumn": "Buy Status", + "sourceProviderType": "Char" + }, + { + "name": "Warehouse Status Code", + "dataType": "string", + "sourceColumn": "Warehouse Status Code", + "sourceProviderType": "Char" + }, + { + "name": "Warehouse Status", + "dataType": "string", + "sourceColumn": "Warehouse Status", + "sourceProviderType": "Char" + }, + { + "name": "OnHandQty", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "OnHandQty", + "sourceProviderType": "Integer" + }, + { + "name": "OnHandCost", + "dataType": "double", + "isHidden": true, + "sourceColumn": "OnHandCost", + "sourceProviderType": "Numeric" + }, + { + "name": "OnOrderQty", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "OnOrderQty", + "sourceProviderType": "Integer" + }, + { + "name": "OnOrderCost", + "dataType": "double", + "isHidden": true, + "sourceColumn": "OnOrderCost", + "sourceProviderType": "Numeric" + }, + { + "name": "ReservedQty", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ReservedQty", + "sourceProviderType": "Integer" + }, + { + "name": "ReservedCost", + "dataType": "double", + "isHidden": true, + "sourceColumn": "ReservedCost", + "sourceProviderType": "Numeric" + }, + { + "name": "On Hand Cost Defaulted", + "dataType": "string", + "sourceColumn": "On Hand Cost Defaulted" + }, + { + "name": "TransitQty", + "dataType": "int64", + "sourceColumn": "TransitQty", + "formatString": "0.00" + }, + { + "name": "TransitCost", + "dataType": "double", + "sourceColumn": "TransitCost", + "formatString": "0.00" + } + ], + "partitions": [ + { + "name": "Inventory", + "dataView": "full", + "source": { + "type": "query", + "query": "SELECT [SalesCube].[vwFactInventory].[InventoryID],[SalesCube].[vwFactInventory].[InventoryDateID],[SalesCube].[vwFactInventory].[ItemID],[SalesCube].[vwFactInventory].[ItemHistoryID],[SalesCube].[vwFactInventory].[Warehouse Code],[SalesCube].[vwFactInventory].[Warehouse State],[SalesCube].[vwFactInventory].[Buy Status Code],[SalesCube].[vwFactInventory].[Buy Status],[SalesCube].[vwFactInventory].[Warehouse Status Code],[SalesCube].[vwFactInventory].[Warehouse Status],[SalesCube].[vwFactInventory].[OnHandQty],[SalesCube].[vwFactInventory].[OnHandCost],[SalesCube].[vwFactInventory].[OnOrderQty],[SalesCube].[vwFactInventory].[OnOrderCost],[SalesCube].[vwFactInventory].[TransitQty],[SalesCube].[vwFactInventory].[TransitCost],[SalesCube].[vwFactInventory].[ReservedQty],[SalesCube].[vwFactInventory].[ReservedCost],[SalesCube].[vwFactInventory].[On Hand Cost Defaulted] FROM [SalesCube].[vwFactInventory]", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwFactInventory].[InventoryID],[SalesCube].[vwFactInventory].[InventoryDateID],[SalesCube].[vwFactInventory].[ItemID],[SalesCube].[vwFactInventory].[ItemHistoryID],[SalesCube].[vwFactInventory].[Warehouse Code],[SalesCube].[vwFactInventory].[Warehouse State],[SalesCube].[vwFactInventory].[Buy Status Code],[SalesCube].[vwFactInventory].[Buy Status],[SalesCube].[vwFactInventory].[Warehouse Status Code],[SalesCube].[vwFactInventory].[Warehouse Status],[SalesCube].[vwFactInventory].[OnHandQty],[SalesCube].[vwFactInventory].[OnHandCost],[SalesCube].[vwFactInventory].[OnOrderQty],[SalesCube].[vwFactInventory].[OnOrderCost],[SalesCube].[vwFactInventory].[TransitQty],[SalesCube].[vwFactInventory].[TransitCost],[SalesCube].[vwFactInventory].[ReservedQty],[SalesCube].[vwFactInventory].[ReservedCost],[SalesCube].[vwFactInventory].[On Hand Cost Defaulted] FROM [SalesCube].[vwFactInventory]Text]]>" + } + ] + } + ], + "measures": [ + { + "name": "On Hand Qty", + "expression": [ + "CALCULATE(", + " SUM(Inventory[OnHandQty]),", + " LASTNONBLANK(", + " 'Inventory Date'[InventoryDateID],", + " COUNTROWS(RELATEDTABLE('Inventory'))", + " )", + ")" + ], + "formatString": "#,0" + }, + { + "name": "On Hand Cost", + "expression": [ + "CALCULATE(", + " SUM(Inventory[OnHandCost]),", + " LASTNONBLANK(", + " 'Inventory Date'[InventoryDateID],", + " COUNTROWS(RELATEDTABLE('Inventory'))", + " )", + ")" + ], + "formatString": "#,0.00" + }, + { + "name": "On Order Qty", + "expression": [ + "CALCULATE(", + " SUM(Inventory[OnOrderQty]),", + " LASTNONBLANK(", + " 'Inventory Date'[InventoryDateID],", + " COUNTROWS(RELATEDTABLE('Inventory'))", + " )", + ")" + ], + "formatString": "#,0" + }, + { + "name": "On Order Cost", + "expression": [ + "CALCULATE(", + " SUM(Inventory[OnOrderCost]),", + " LASTNONBLANK(", + " 'Inventory Date'[InventoryDateID],", + " COUNTROWS(RELATEDTABLE('Inventory'))", + " )", + ")" + ], + "formatString": "#,0.00" + }, + { + "name": "Reserved Qty", + "expression": [ + "CALCULATE(", + " SUM(Inventory[ReservedQty]),", + " LASTNONBLANK(", + " 'Inventory Date'[InventoryDateID],", + " COUNTROWS(RELATEDTABLE('Inventory'))", + " )", + ")" + ], + "formatString": "#,0" + }, + { + "name": "Reserved Cost", + "expression": [ + "CALCULATE(", + " SUM(Inventory[ReservedCost]),", + " LASTNONBLANK(", + " 'Inventory Date'[InventoryDateID],", + " COUNTROWS(RELATEDTABLE('Inventory'))", + " )", + ")" + ], + "formatString": "#,0.00" + }, + { + "name": "Transit Qty", + "expression": [ + "CALCULATE(", + " SUM(Inventory[TransitQty]),", + " LASTNONBLANK(", + " 'Inventory Date'[InventoryDateID],", + " COUNTROWS(RELATEDTABLE('Inventory'))", + " )", + ")" + ], + "formatString": "#,0", + "isHidden": true + }, + { + "name": "Transit Cost", + "expression": [ + "CALCULATE(", + " SUM(Inventory[TransitCost]),", + " LASTNONBLANK(", + " 'Inventory Date'[InventoryDateID],", + " COUNTROWS(RELATEDTABLE('Inventory'))", + " )", + ")" + ], + "formatString": "#,0.00", + "isHidden": true + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": "SELECT [SalesCube].[vwFactInventory].[InventoryID],[SalesCube].[vwFactInventory].[InventoryDateID],[SalesCube].[vwFactInventory].[ItemID],[SalesCube].[vwFactInventory].[ItemHistoryID],[SalesCube].[vwFactInventory].[Warehouse Code],[SalesCube].[vwFactInventory].[Warehouse State],[SalesCube].[vwFactInventory].[Buy Status Code],[SalesCube].[vwFactInventory].[Buy Status],[SalesCube].[vwFactInventory].[Warehouse Status Code],[SalesCube].[vwFactInventory].[Warehouse Status],[SalesCube].[vwFactInventory].[OnHandQty],[SalesCube].[vwFactInventory].[OnHandCost],[SalesCube].[vwFactInventory].[OnOrderQty],[SalesCube].[vwFactInventory].[OnOrderCost],[SalesCube].[vwFactInventory].[TransitQty],[SalesCube].[vwFactInventory].[TransitCost],[SalesCube].[vwFactInventory].[ReservedQty],[SalesCube].[vwFactInventory].[ReservedCost],[SalesCube].[vwFactInventory].[On Hand Cost Defaulted] FROM [SalesCube].[vwFactInventory]" + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwFactInventory" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + }, + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwFactInventory].[InventoryID],[SalesCube].[vwFactInventory].[InventoryDateID],[SalesCube].[vwFactInventory].[ItemID],[SalesCube].[vwFactInventory].[ItemHistoryID],[SalesCube].[vwFactInventory].[Warehouse Code],[SalesCube].[vwFactInventory].[Warehouse State],[SalesCube].[vwFactInventory].[Buy Status Code],[SalesCube].[vwFactInventory].[Buy Status],[SalesCube].[vwFactInventory].[Warehouse Status Code],[SalesCube].[vwFactInventory].[Warehouse Status],[SalesCube].[vwFactInventory].[OnHandQty],[SalesCube].[vwFactInventory].[OnHandCost],[SalesCube].[vwFactInventory].[OnOrderQty],[SalesCube].[vwFactInventory].[OnOrderCost],[SalesCube].[vwFactInventory].[TransitQty],[SalesCube].[vwFactInventory].[TransitCost],[SalesCube].[vwFactInventory].[ReservedQty],[SalesCube].[vwFactInventory].[ReservedCost],[SalesCube].[vwFactInventory].[On Hand Cost Defaulted] FROM [SalesCube].[vwFactInventory]Text]]>" + } + ] + }, + { + "name": "Forecast", + "columns": [ + { + "name": "ForecastID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ForecastID", + "sourceProviderType": "Integer" + }, + { + "name": "ForecastDateID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ForecastDateID", + "sourceProviderType": "Integer" + }, + { + "name": "ItemID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ItemID", + "sourceProviderType": "Integer" + }, + { + "name": "Warehouse Code", + "dataType": "string", + "sourceColumn": "WarehouseCode", + "sourceProviderType": "Char" + }, + { + "name": "ForecastQty", + "dataType": "double", + "isHidden": true, + "sourceColumn": "ForecastQty", + "sourceProviderType": "Double" + }, + { + "name": "ForecastCost", + "dataType": "double", + "isHidden": true, + "sourceColumn": "ForecastCost", + "sourceProviderType": "Numeric" + }, + { + "name": "Forecast Yr", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Forecast Yr" + }, + { + "name": "ForecastMthID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ForecastMthID" + }, + { + "name": "Forecast Mth", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Forecast Mth", + "sortByColumn": "ForecastMthID" + }, + { + "name": "Sales Area", + "dataType": "string", + "sourceColumn": "Sales Area" + }, + { + "name": "Forecast Unit Cost", + "dataType": "double", + "sourceColumn": "Forecast Unit Cost" + }, + { + "name": "ForecastSales", + "dataType": "double", + "isHidden": true, + "sourceColumn": "ForecastSales" + } + ], + "partitions": [ + { + "name": "Forecast", + "dataView": "full", + "source": { + "type": "query", + "query": "SELECT [SalesCube].[vwFactForecast].* FROM [SalesCube].[vwFactForecast]", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwFactForecast].* FROM [SalesCube].[vwFactForecast]Text]]>" + } + ] + } + ], + "measures": [ + { + "name": "Forecast Cost", + "expression": " SUM(Forecast[ForecastCost])", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Forecast Qty", + "expression": " SUM(Forecast[ForecastQty])", + "formatString": "#,0.0000" + }, + { + "name": "Forecast Items", + "expression": "DISTINCTCOUNT([ItemID])", + "formatString": "#,0" + }, + { + "name": "Forecast Sales", + "expression": "SUM([ForecastSales])", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + } + ], + "hierarchies": [ + { + "name": "Forecast Date", + "levels": [ + { + "name": "Forecast Yr", + "ordinal": 0, + "column": "Forecast Yr" + }, + { + "name": "Forecast Mth", + "ordinal": 1, + "column": "Forecast Mth" + } + ] + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": "SELECT [SalesCube].[vwFactForecast].* FROM [SalesCube].[vwFactForecast]" + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwFactForecast" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + }, + { + "name": "QueryEditorSerialization", + "value": "SELECT [SalesCube].[vwFactForecast].* FROM [SalesCube].[vwFactForecast]Text]]>" + } + ] + }, + { + "name": "Shipped Orders", + "columns": [ + { + "name": "ShippedOrderLineID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ShippedOrderLineID" + }, + { + "name": "SalesShippingAddressID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "SalesShippingAddressID" + }, + { + "name": "SalesMiscID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "SalesMiscID" + }, + { + "name": "DealerID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "DealerID" + }, + { + "name": "ItemID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ItemID" + }, + { + "name": "ItemHistoryID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ItemHistoryID" + }, + { + "name": "ShipDateID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ShipDateID" + }, + { + "name": "OrderDateID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "OrderDateID" + }, + { + "name": "Order Location", + "dataType": "string", + "sourceColumn": "Order Location" + }, + { + "name": "Order Number", + "dataType": "string", + "sourceColumn": "Order Number" + }, + { + "name": "Order Suffix", + "dataType": "string", + "sourceColumn": "Order Suffix" + }, + { + "name": "Invoice Number", + "dataType": "string", + "sourceColumn": "Invoice Number" + }, + { + "name": "Order Line Number", + "dataType": "int64", + "sourceColumn": "Order Line Number" + }, + { + "name": "Dealer Number", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Dealer Number" + }, + { + "name": "Customer PO", + "dataType": "string", + "sourceColumn": "Customer PO" + }, + { + "name": "Default Warehouse", + "dataType": "string", + "sourceColumn": "Default Warehouse" + }, + { + "name": "QtyShipped", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "QtyShipped" + }, + { + "name": "QtyBackordered", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "QtyBackordered" + }, + { + "name": "QtyOrdered", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "QtyOrdered" + }, + { + "name": "QtyOrderedTest", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "QtyOrderedTest" + }, + { + "name": "Unit Cost", + "dataType": "double", + "sourceColumn": "Unit Cost" + }, + { + "name": "Base Price", + "dataType": "double", + "sourceColumn": "Base Price" + }, + { + "name": "Dealer Price", + "dataType": "double", + "sourceColumn": "Dealer Price" + }, + { + "name": "Retail Price", + "dataType": "double", + "sourceColumn": "Retail Price" + }, + { + "name": "UnitCostExt", + "dataType": "double", + "isHidden": true, + "sourceColumn": "UnitCostExt" + }, + { + "name": "BasePriceExt", + "dataType": "double", + "isHidden": true, + "sourceColumn": "BasePriceExt" + }, + { + "name": "DealerPriceExt", + "dataType": "double", + "isHidden": true, + "sourceColumn": "DealerPriceExt" + }, + { + "name": "DealerPriceOrderedExtTest", + "dataType": "double", + "isHidden": true, + "sourceColumn": "DealerPriceOrderedExtTest" + }, + { + "name": "MarginExt", + "dataType": "double", + "isHidden": true, + "sourceColumn": "MarginExt" + }, + { + "name": "DiscountExt", + "dataType": "double", + "isHidden": true, + "sourceColumn": "DiscountExt" + }, + { + "name": "DropShipFee", + "dataType": "double", + "isHidden": true, + "sourceColumn": "DropShipFee" + }, + { + "name": "Order State", + "dataType": "string", + "sourceColumn": "Order State" + }, + { + "type": "calculated", + "name": "OrderNumberPlusDate", + "dataType": "string", + "isDataTypeInferred": true, + "isHidden": true, + "expression": " 'Shipped Orders'[Order Number] & 'Shipped Orders'[OrderDateID] " + }, + { + "name": "ProgramID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ProgramID" + }, + { + "name": "InvoiceID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "InvoiceID" + }, + { + "name": "OrderSegmentID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "OrderSegmentID" + }, + { + "name": "Order Group", + "dataType": "string", + "sourceColumn": "Order Group" + }, + { + "name": "Order Date", + "dataType": "dateTime", + "sourceColumn": "Order Date" + }, + { + "name": "Order Yr Mth", + "dataType": "string", + "sourceColumn": "Order Yr Mth" + } + ], + "partitions": [ + { + "name": "Shipped Orders 2017", + "source": { + "type": "m", + "expression": [ + "let", + " Source = GetFactData(20170101, 20171231)", + "in", + " Source" + ] + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": [ + "let\r", + " Source = GetFactData(20170101, 20171231)\r", + "in\r", + " SourceText]]>" + ] + } + ] + }, + { + "name": "Shipped Orders 2018", + "mode": "import", + "source": { + "type": "m", + "expression": [ + "let", + " Source = GetFactData(20180101, 20181231)", + "in", + " Source" + ] + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": [ + "let\r", + " Source = GetFactData(20180101, 20181231)\r", + "in\r", + " SourceText]]>" + ] + } + ] + }, + { + "name": "Shipped Orders 2019", + "mode": "import", + "source": { + "type": "m", + "expression": [ + "let", + " Source = GetFactData(20190101, 20191231)", + "in", + " Source" + ] + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": [ + "let\r", + " Source = GetFactData(20190101, 20191231)\r", + "in\r", + " SourceText]]>" + ] + } + ] + }, + { + "name": "Shipped Orders 2020", + "mode": "import", + "source": { + "type": "m", + "expression": [ + "let", + " Source = GetFactData(20200101, 20201231)", + "in", + " Source" + ] + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": [ + "let\r", + " Source = GetFactData(20200101, 20201231)\r", + "in\r", + " SourceText]]>" + ] + } + ] + }, + { + "name": "Shipped Orders 2021", + "mode": "import", + "source": { + "type": "m", + "expression": [ + "let", + " Source = GetFactData(20210101, 20211231)", + "in", + " Source" + ] + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": [ + "let\r", + " Source = GetFactData(20210101, 20211231)\r", + "in\r", + " SourceText]]>" + ] + } + ] + }, + { + "name": "Shipped Orders 2022", + "mode": "import", + "source": { + "type": "m", + "expression": [ + "let", + " Source = GetFactData(20220101, 20221231)", + "in", + " Source" + ] + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": [ + "let\r", + " Source = GetFactData(20220101, 20221231)\r", + "in\r", + " SourceText]]>" + ] + } + ] + }, + { + "name": "Shipped Orders 2023", + "mode": "import", + "source": { + "type": "m", + "expression": [ + "let", + " Source = GetFactData(20230101, 20231231)", + "in", + " Source" + ] + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": [ + "let\r", + " Source = GetFactData(20230101, 20231231)\r", + "in\r", + " SourceText]]>" + ] + } + ] + }, + { + "name": "Shipped Orders 2024", + "mode": "import", + "source": { + "type": "m", + "expression": [ + "let", + " Source = GetFactData(20240101, 20241231)", + "in", + " Source" + ] + }, + "annotations": [ + { + "name": "QueryEditorSerialization", + "value": [ + "let\r", + " Source = GetFactData(20240101, 20241231)\r", + "in\r", + " SourceText]]>" + ] + } + ] + }, + { + "name": "Shipped Orders 2025", + "dataView": "full", + "source": { + "type": "m", + "expression": [ + "let", + " Source = GetFactData(20250101, 20251231)", + "in", + " Source" + ] + } + } + ], + "measures": [ + { + "name": "Items Shipped", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ItemID] ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Shipped Distinct Counts" + }, + { + "name": "Orders", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[OrderNumberPlusDate] ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Shipped Distinct Counts" + }, + { + "name": "Dealers", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[Dealer Number] ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Shipped Distinct Counts" + }, + { + "name": "Qty Shipped", + "expression": [ + "CALCULATE(SUMX('Shipped Orders', [QtyShipped]), 'Dealer'[Dealer Type Code] <> \"B\")", + "" + ], + "formatString": "#,0" + }, + { + "name": "Qty Backordered", + "expression": "CALCULATE(SUMX('Shipped Orders', [QtyBackordered]), 'Dealer'[Dealer Type Code] <> \"B\")", + "formatString": "#,0" + }, + { + "name": "Qty Ordered", + "expression": "CALCULATE(SUMX('Shipped Orders', [QtyOrdered]), 'Sales Misc'[Dealer Type Code] <> \"B\")", + "formatString": "#,0" + }, + { + "name": "Qty Ordered Test", + "expression": [ + "CALCULATE(SUMX('Shipped Orders', [QtyOrderedTest]), 'Dealer'[Dealer Type Code] <> \"B\")", + "" + ], + "formatString": "#,0" + }, + { + "name": "COGS", + "expression": "CALCULATE(SUMX('Shipped Orders', [UnitCostExt]), 'Dealer'[Dealer Type Code] <> \"B\")", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "List Price", + "expression": "CALCULATE(SUMX('Shipped Orders', [BasePriceExt]), 'Dealer'[Dealer Type Code] <> \"B\")", + "isHidden": true + }, + { + "name": "Sales", + "expression": "CALCULATE(SUMX('Shipped Orders', [DealerPriceExt]), 'Dealer'[Dealer Type Code] <> \"B\")", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Sales Prior Period", + "expression": [ + "CALCULATE(SUMX('Shipped Orders', [DealerPriceExt]), 'Dealer'[Dealer Type Code] <> \"B\", SAMEPERIODLASTYEAR('Date Shipped'[Calendar Date]))", + "" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Prior Period Growth Pct", + "expression": "DIVIDE('Shipped Orders'[Sales] - 'Shipped Orders'[Sales Prior Period], [Sales Prior Period])", + "formatString": "0.00%;-0.00%;0.00%" + }, + { + "name": "Margin", + "expression": [ + "CALCULATE(SUMX('Shipped Orders', [MarginExt]), 'Dealer'[Dealer Type Code] <> \"B\")", + "" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Margin Pct", + "expression": " DIVIDE( [Margin], [Sales] )", + "formatString": "0.00%;-0.00%;0.00%" + }, + { + "name": "Prior Period Growth", + "expression": "'Shipped Orders'[Sales] - 'Shipped Orders'[Sales Prior Period]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Discount", + "expression": "CALCULATE(SUMX('Shipped Orders', [DiscountExt]), 'Dealer'[Dealer Type Code] <> \"B\")", + "isHidden": true + }, + { + "name": "Discount Pct", + "expression": " DIVIDE( [Discount], [List Price] )", + "formatString": "0.00%;-0.00%;0.00%" + }, + { + "name": "Dropship Sales", + "expression": " CALCULATE(SUMX('Shipped Orders', [DealerPriceExt]), 'Sales Misc'[Order Type Code] = \"DS\")", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Dropship", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Dropship Qty", + "expression": " CALCULATE(SUMX('Shipped Orders', [Qty Shipped]), 'Sales Misc'[Order Type Code] = \"DS\")", + "formatString": "#,0", + "displayFolder": "Dropship" + }, + { + "name": "Dropship Pct", + "expression": " DIVIDE( [Dropship Sales], [Sales] )", + "formatString": "0.0%;-0.0%;0.0%", + "displayFolder": "Dropship" + }, + { + "name": "Margin Prior Period", + "expression": [ + "CALCULATE(SUMX('Shipped Orders', [MarginExt]), 'Dealer'[Dealer Type Code] <> \"B\", SAMEPERIODLASTYEAR('Date Shipped'[Calendar Date]))", + "" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Discount Prior Period", + "expression": [ + "CALCULATE(SUMX('Shipped Orders', [DiscountExt]), 'Dealer'[Dealer Type Code] <> \"B\", SAMEPERIODLASTYEAR('Date Shipped'[Calendar Date]))", + "", + "" + ], + "isHidden": true + }, + { + "name": "Margin Prior Period Pct", + "expression": " DIVIDE( [Margin Prior Period], [Sales Prior Period] )", + "formatString": "0.00%;-0.00%;0.00%" + }, + { + "name": "List Price Prior Period", + "expression": [ + "CALCULATE(SUMX('Shipped Orders', [BasePriceExt]), 'Dealer'[Dealer Type Code] <> \"B\", SAMEPERIODLASTYEAR('Date Shipped'[Calendar Date]))", + "" + ], + "isHidden": true + }, + { + "name": "Discount Prior Period Pct", + "expression": " DIVIDE( [Discount Prior Period], [List Price Prior Period] )", + "formatString": "0.00%;-0.00%;0.00%" + }, + { + "name": "Dropship Fee", + "expression": "CALCULATE(SUMX('Shipped Orders', [DropShipFee]), 'Sales Misc'[Order Type Code] = \"DS\")", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Dropship", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Dropship Dealers", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[Dealer Number] ),", + " FILTER ( 'Sales Misc','Sales Misc'[Order Type Code] = \"DS\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Dropship" + }, + { + "name": "Dropship Orders", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[OrderNumberPlusDate] ),", + " FILTER ( 'Sales Misc','Sales Misc'[Order Type Code] = \"DS\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Dropship" + }, + { + "name": "Dropship Items", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ItemID] ),", + " FILTER ( 'Sales Misc','Sales Misc'[Order Type Code] = \"DS\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Dropship" + }, + { + "name": "Dropship Sales Prior Period", + "expression": "CALCULATE(SUMX('Shipped Orders', [DealerPriceExt]), 'Sales Misc'[Order Type Code] = \"DS\", SAMEPERIODLASTYEAR('Date Shipped'[Calendar Date]))", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Dropship", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Dropship Prior Period Growth Pct", + "expression": "DIVIDE('Shipped Orders'[Dropship Sales] - 'Shipped Orders'[Dropship Sales Prior Period], [Dropship Sales Prior Period])", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Dropship" + }, + { + "name": "Brands Shipped", + "expression": " CALCULATE ( DISTINCTCOUNT ( 'Item'[Brand Code] ), 'Shipped Orders' )", + "formatString": "#,0", + "displayFolder": "Shipped Distinct Counts" + }, + { + "name": "Dropship Order Avg", + "expression": " [Dropship Sales] / [Dropship Orders]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Dropship", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Order Avg", + "expression": " [Sales] / [Orders]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "R12 Sales Ty", + "expression": [ + " ", + "CALCULATE (", + " SUM ( 'Shipped Orders'[DealerPriceExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\R12", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "R12 Sales Ly", + "expression": [ + " ", + "CALCULATE (", + " SUM ( 'Shipped Orders'[DealerPriceExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12 Prior] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\R12", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "R12 Sales Growth", + "expression": "[R12 Sales Ty] - [R12 Sales Ly]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\R12", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "R12 Sales Growth%", + "expression": "DIVIDE([R12 Sales Growth], [R12 Sales Ly])", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "Mtd Sales Ty", + "expression": [ + "", + "CALCULATE (", + " SUM ( 'Shipped Orders'[DealerPriceExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Mtd", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Mtd Sales Ly", + "expression": [ + "", + "CALCULATE (", + " SUM ( 'Shipped Orders'[DealerPriceExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Mtd", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Mtd Sales Growth", + "expression": "[Mtd Sales Ty] - [Mtd Sales Ly]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Mtd", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Mtd Sales Growth%", + "expression": "DIVIDE([Mtd Sales Growth], [Mtd Sales Ly])", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Fiscal Sales Ty", + "expression": [ + "", + "CALCULATE (", + " SUM ( 'Shipped Orders'[DealerPriceExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Fiscal", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Fiscal Sales Ly", + "expression": [ + "", + "CALCULATE (", + " SUM ( 'Shipped Orders'[DealerPriceExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Fiscal", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Fiscal Sales Growth", + "expression": "[Fiscal Sales Ty] - [Fiscal Sales Ly]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Fiscal", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Fiscal Sales Growth%", + "expression": "DIVIDE([Fiscal Sales Growth], [Fiscal Sales Ly])", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "Prev Mth Sales Ty", + "expression": [ + "", + "CALCULATE (", + " SUM ( 'Shipped Orders'[DealerPriceExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Prev Month-End", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Prev Mth Sales Ly", + "expression": [ + "", + "CALCULATE (", + " SUM ( 'Shipped Orders'[DealerPriceExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Prev Month-End", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "R12 Cogs Ty", + "expression": [ + "CALCULATE (", + " SUM ( 'Shipped Orders'[UnitCostExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\R12", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "R12 Margin Ty", + "expression": "[R12 Sales Ty] - [R12 Cogs Ty]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\R12", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "R12 Margin% Ty", + "expression": " DIVIDE( [R12 Margin Ty], [R12 Sales Ty] )", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "R12 Cogs Ly", + "expression": [ + "CALCULATE (", + " SUM ( 'Shipped Orders'[UnitCostExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12 Prior] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\R12", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "R12 Margin Ly", + "expression": "[R12 Sales Ly] - [R12 Cogs Ly]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\R12", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "R12 Margin% Ly", + "expression": " DIVIDE( [R12 Margin Ly], [R12 Sales Ly] )", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "R12 Dealers Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[Dealer Number] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "R12 Dealers Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[Dealer Number] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12 Prior] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "Prev Mth Sales Growth", + "expression": "[Prev Mth Sales Ty] - [Prev Mth Sales Ly]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Prev Month-End", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Prev Mth Sales Growth%", + "expression": "DIVIDE([Prev Mth Sales Growth], [Prev Mth Sales Ly])", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\Prev Month-End" + }, + { + "name": "Dropship Prior Period Growth", + "expression": "'Shipped Orders'[Dropship Sales] - 'Shipped Orders'[Dropship Sales Prior Period]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Dropship", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Prev Mth Cogs Ty", + "expression": [ + "CALCULATE (", + " SUM ( 'Shipped Orders'[UnitCostExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Prev Month-End", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Prev Mth Cogs Ly", + "expression": [ + "CALCULATE (", + " SUM ( 'Shipped Orders'[UnitCostExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Prev Month-End", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Prev Mth Margin Ty", + "expression": "[Prev Mth Sales Ty] - [Prev Mth Cogs Ty]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Prev Month-End", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Prev Mth Margin Ly", + "expression": "[Prev Mth Sales Ly] - [Prev Mth Cogs Ly]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Prev Month-End", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Prev Mth Margin% Ly", + "expression": " DIVIDE( [Prev Mth Margin Ly], [Prev Mth Sales Ly] )", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\Prev Month-End" + }, + { + "name": "Prev Mth Dealers Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[Dealer Number] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Prev Month-End" + }, + { + "name": "Prev Mth Dealers Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[Dealer Number] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Prev Month-End" + }, + { + "name": "Mtd Cogs Ty", + "expression": [ + "CALCULATE (", + " SUM ( 'Shipped Orders'[UnitCostExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Mtd", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Mtd Cogs Ly", + "expression": [ + "CALCULATE (", + " SUM ( 'Shipped Orders'[UnitCostExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Mtd", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Mtd Margin Ty", + "expression": "[Mtd Sales Ty] - [Mtd Cogs Ty]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Mtd", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Mtd Margin Ly", + "expression": " [Mtd Sales Ly] - [Mtd Cogs Ly]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Mtd", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Mtd Dealers Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[Dealer Number] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Mtd Dealers Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[Dealer Number] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Fiscal Cogs Ty", + "expression": [ + "CALCULATE (", + " SUM ( 'Shipped Orders'[UnitCostExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Fiscal", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Fiscal Cogs Ly", + "expression": [ + "CALCULATE (", + " SUM ( 'Shipped Orders'[UnitCostExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Fiscal", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Fiscal Margin Ty", + "expression": "[Fiscal Sales Ty] - [Fiscal Cogs Ty]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Fiscal", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Fiscal Margin Ly", + "expression": "[Fiscal Sales Ly] - [Fiscal Cogs Ly]", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Fiscal", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Fiscal Dealers Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[Dealer Number] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "Fiscal Dealers Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[Dealer Number] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "Prev Mth DS Sales Ty", + "expression": [ + "", + "CALCULATE (", + " SUM ( 'Shipped Orders'[DealerPriceExt]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthTy] = \"YES\" ),", + " FILTER ( 'Sales Misc','Sales Misc'[Order Type Code] = \"DS\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "displayFolder": "Sales Periods\\Prev Month-End", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Qty Shipped Prior Period", + "expression": [ + "CALCULATE(SUMX('Shipped Orders', [QtyShipped]), 'Dealer'[Dealer Type Code] <> \"B\", SAMEPERIODLASTYEAR('Date Shipped'[Calendar Date]))", + "" + ], + "formatString": "#,0" + }, + { + "name": "R12 Qty Shipped Ty", + "expression": [ + " ", + "CALCULATE (", + " SUM ( 'Shipped Orders'[QtyShipped]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "R12 Qty Shipped Ly", + "expression": [ + " ", + "CALCULATE (", + " SUM ( 'Shipped Orders'[QtyShipped]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12 Prior] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "Packages", + "expression": "SUMX ( DISTINCT ( Packages[PackageID]), 1 )", + "formatString": "#,0", + "displayFolder": "Shipped Distinct Counts" + }, + { + "name": "Invoices", + "expression": [ + "CALCULATE (", + "DISTINCTCOUNT([Invoice Number]),", + " FILTER ( 'Sales Misc','Sales Misc'[Order Type Code] <> \"CM\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Shipped Distinct Counts" + }, + { + "name": "Packages Invoice", + "expression": "DIVIDE([Packages], [Invoices])", + "formatString": "#,0.00" + }, + { + "name": "R12 Orders Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[OrderNumberPlusDate] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "R12 Orders Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[OrderNumberPlusDate] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12 Prior] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "Fiscal Orders Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[OrderNumberPlusDate] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "Fiscal Orders Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[OrderNumberPlusDate] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "Mtd Margin% Ty", + "expression": " DIVIDE( [Mtd Margin Ty], [Mtd Sales Ty] )", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Mtd Margin% Ly", + "expression": " DIVIDE( [Mtd Margin Ly], [Mtd Sales Ly] )", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Fiscal Margin% Ty", + "expression": " DIVIDE( [Fiscal Margin Ty], [Fiscal Sales Ty] )", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "Fiscal Margin% Ly", + "expression": " DIVIDE( [Fiscal Margin Ly], [Fiscal Sales Ly] )", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "Prev Mth Margin% Ty", + "expression": " DIVIDE( [Prev Mth Margin Ty], [Prev Mth Sales Ty] )", + "formatString": "0.00%;-0.00%;0.00%", + "displayFolder": "Sales Periods\\Prev Month-End" + }, + { + "name": "Mtd Orders Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[OrderNumberPlusDate] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Mtd Orders Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[OrderNumberPlusDate] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Mtd Lines Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ShippedOrderLineID] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Mtd Lines Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ShippedOrderLineID] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Fiscal Lines Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ShippedOrderLineID] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "Fiscal Lines Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ShippedOrderLineID] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "R12 Lines Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ShippedOrderLineID] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "R12 Lines Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ShippedOrderLineID] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[Rolling 12 Prior] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\R12" + }, + { + "name": "Mtd Qty Shipped Ty", + "expression": [ + " ", + "CALCULATE (", + " SUM ( 'Shipped Orders'[QtyShipped]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Mtd Qty Shipped Ly", + "expression": [ + " ", + "CALCULATE (", + " SUM ( 'Shipped Orders'[QtyShipped]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Mtd" + }, + { + "name": "Fiscal Qty Shipped Ty", + "expression": [ + " ", + "CALCULATE (", + " SUM ( 'Shipped Orders'[QtyShipped]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "Fiscal Qty Shipped Ly", + "expression": [ + " ", + "CALCULATE (", + " SUM ( 'Shipped Orders'[QtyShipped]) ,", + " FILTER ( 'Date Shipped', 'Date Shipped'[FiscalLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Fiscal" + }, + { + "name": "Prev Mth Orders Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[OrderNumberPlusDate] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Prev Month-End" + }, + { + "name": "Prev Mth Orders Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[OrderNumberPlusDate] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Prev Month-End" + }, + { + "name": "Prev Mth Lines Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ShippedOrderLineID] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthLy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Prev Month-End" + }, + { + "name": "Prev Mth Lines Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ShippedOrderLineID] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[PrevMthTy] = \"YES\" ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Sales Periods\\Prev Month-End" + }, + { + "name": "Mtd Shipping Days Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Date Shipped'[Shipping Day] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdTy] = \"YES\" )", + ")" + ] + }, + { + "name": "Mtd Shipping Days Ly", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Date Shipped'[Shipping Day] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[MtdLy] = \"YES\" )", + ")" + ] + }, + { + "name": "Mtd Total Shipping Days Ty", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Date Shipped'[Shipping Day] ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[Current Month] = \"YES\" ),", + " FILTER ( 'Date Shipped', 'Date Shipped'[Shipping Day] <> \"\" )", + ")", + "" + ] + }, + { + "name": "Lines", + "expression": [ + "CALCULATE (", + " DISTINCTCOUNT ( 'Shipped Orders'[ShippedOrderLineID] ),", + " FILTER ( 'Dealer','Dealer'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "#,0", + "displayFolder": "Shipped Distinct Counts" + } + ] + }, + { + "name": "Back Orders", + "columns": [ + { + "name": "BackOrderLineID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "BackOrderLineID" + }, + { + "name": "Order Location", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Order Location" + }, + { + "name": "Order Number", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Order Number" + }, + { + "name": "Order Suffix", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Order Suffix" + }, + { + "name": "Invoice Number", + "dataType": "string", + "sourceColumn": "Invoice Number" + }, + { + "name": "Order Line Number", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "Order Line Number" + }, + { + "name": "Backorder Xfer Srce", + "dataType": "string", + "sourceColumn": "Backorder Xfer Srce" + }, + { + "name": "Backorder Xfer Dest", + "dataType": "string", + "sourceColumn": "Backorder Xfer Dest" + }, + { + "name": "SalesMiscID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "SalesMiscID" + }, + { + "name": "DealerID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "DealerID" + }, + { + "name": "Dealer Number", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Dealer Number" + }, + { + "name": "ItemID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ItemID" + }, + { + "name": "ItemHistoryID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ItemHistoryID" + }, + { + "name": "Customer PO", + "dataType": "string", + "sourceColumn": "Customer PO" + }, + { + "name": "SalesLineTypeCode", + "dataType": "string", + "isHidden": true, + "sourceColumn": "SalesLineTypeCode" + }, + { + "name": "SalesLineStatusCode", + "dataType": "string", + "isHidden": true, + "sourceColumn": "SalesLineStatusCode" + }, + { + "name": "SalesLineBoStatus", + "dataType": "string", + "isHidden": true, + "sourceColumn": "SalesLineBoStatus" + }, + { + "name": "ExceptionCode", + "dataType": "string", + "isHidden": true, + "sourceColumn": "ExceptionCode" + }, + { + "name": "QtyShipped", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "QtyShipped" + }, + { + "name": "QtyBackordered", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "QtyBackordered" + }, + { + "name": "QtyOrdered", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "QtyOrdered" + }, + { + "name": "Unit Cost", + "dataType": "double", + "sourceColumn": "Unit Cost" + }, + { + "name": "Base Price", + "dataType": "double", + "sourceColumn": "Base Price" + }, + { + "name": "Dealer Price", + "dataType": "double", + "sourceColumn": "Dealer Price" + }, + { + "name": "Retail Price", + "dataType": "double", + "sourceColumn": "Retail Price" + }, + { + "name": "UnitCostExt", + "dataType": "double", + "isHidden": true, + "sourceColumn": "UnitCostExt" + }, + { + "name": "BasePriceExt", + "dataType": "double", + "isHidden": true, + "sourceColumn": "BasePriceExt" + }, + { + "name": "DealerPriceExt", + "dataType": "double", + "isHidden": true, + "sourceColumn": "DealerPriceExt" + }, + { + "name": "MarginExt", + "dataType": "double", + "isHidden": true, + "sourceColumn": "MarginExt" + }, + { + "name": "DiscountExt", + "dataType": "double", + "isHidden": true, + "sourceColumn": "DiscountExt" + }, + { + "name": "Order Yr", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Order Yr" + }, + { + "name": "Order Mth", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Order Mth", + "sortByColumn": "OrderMthID" + }, + { + "name": "Order Date", + "dataType": "dateTime", + "isHidden": true, + "sourceColumn": "Order Date", + "formatString": "yyyy-MM-dd", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "OrderMthID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "OrderMthID" + } + ], + "partitions": [ + { + "name": "Partition", + "dataView": "full", + "source": { + "type": "m", + "expression": [ + "let", + " Source = #\"SQL/PRD-DATAWH01VM;PDW_Reporting\",", + " SalesCube_vwFactBackOrders = Source{[Schema=\"SalesCube\",Item=\"vwFactBackOrders\"]}[Data]", + "in", + " SalesCube_vwFactBackOrders" + ] + } + } + ], + "measures": [ + { + "name": "Backordered Dealers", + "expression": "DISTINCTCOUNT([Dealer Number])", + "formatString": "#,0" + }, + { + "name": "Backordered Items", + "expression": "DISTINCTCOUNT([ItemID])", + "formatString": "#,0" + }, + { + "name": "Backordered Qty", + "expression": "SUM([QtyBackordered])", + "formatString": "#,0" + }, + { + "name": "Initial Qty Ordered", + "expression": "SUM([QtyOrdered])", + "formatString": "#,0" + }, + { + "name": "Backordered COGS", + "expression": "SUM([UnitCostExt])", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Backorder Total", + "expression": "SUM([DealerPriceExt])", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + } + ], + "hierarchies": [ + { + "name": "Date Ordered", + "levels": [ + { + "name": "Order Yr", + "ordinal": 0, + "column": "Order Yr" + }, + { + "name": "Order Mth", + "ordinal": 1, + "column": "Order Mth" + }, + { + "name": "Order Date", + "ordinal": 2, + "column": "Order Date" + } + ] + } + ] + }, + { + "name": "Purchase Orders", + "columns": [ + { + "name": "PurchaseOrderLineID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "PurchaseOrderLineID" + }, + { + "name": "ItemID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ItemID" + }, + { + "name": "Warehouse", + "dataType": "string", + "sourceColumn": "Warehouse" + }, + { + "name": "Po Number", + "dataType": "string", + "sourceColumn": "Po Number" + }, + { + "name": "Po Date", + "dataType": "dateTime", + "sourceColumn": "Po Date", + "formatString": "yyyy-MM-dd", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Po Supplier Code", + "dataType": "string", + "sourceColumn": "Po Supplier Code" + }, + { + "name": "Po Supplier", + "dataType": "string", + "sourceColumn": "Po Supplier" + }, + { + "name": "Po Currency", + "dataType": "string", + "sourceColumn": "Po Currency" + }, + { + "name": "Po Conversion Factor", + "dataType": "double", + "sourceColumn": "Po Conversion Factor", + "formatString": "0.000000" + }, + { + "name": "Po Line", + "dataType": "int64", + "sourceColumn": "Po Line" + }, + { + "name": "Po Foreign Unit Price", + "dataType": "double", + "sourceColumn": "Po Foreign Unit Price" + }, + { + "name": "Po Unit Price", + "dataType": "double", + "sourceColumn": "Po Unit Price" + }, + { + "name": "PoOrderCost", + "dataType": "double", + "isHidden": true, + "sourceColumn": "PoOrderCost" + }, + { + "name": "PoQty", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "PoQty" + }, + { + "name": "PoQtyReceived", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "PoQtyReceived" + }, + { + "name": "PoQtyRemaining", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "PoQtyRemaining" + }, + { + "name": "Po Expected Date", + "dataType": "dateTime", + "isHidden": true, + "sourceColumn": "Po Expected Date", + "formatString": "yyyy-MM-dd", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Po Expected Yr", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "PoExpectedYr" + }, + { + "name": "PoExpectedMonthID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "PoExpectedMonthID" + }, + { + "name": "Po Expected Month", + "dataType": "string", + "isHidden": true, + "sourceColumn": "PoExpectedMonth", + "sortByColumn": "PoExpectedMonthID" + }, + { + "name": "Inventory Lot ID", + "dataType": "string", + "sourceColumn": "Inventory Lot ID" + }, + { + "name": "Cash Disc", + "dataType": "string", + "sourceColumn": "Cash Disc" + }, + { + "name": "Cash Disc Pct", + "dataType": "double", + "sourceColumn": "Cash Disc Pct" + } + ], + "partitions": [ + { + "name": "Partition", + "dataView": "full", + "source": { + "type": "m", + "expression": [ + "let", + " Source = #\"SQL/PRD-DATAWH01VM;PDW_Reporting\",", + " SalesCube_vwFactPurchaseOrderLine = Source{[Schema=\"SalesCube\",Item=\"vwFactPurchaseOrderLine\"]}[Data]", + "in", + " SalesCube_vwFactPurchaseOrderLine" + ] + } + } + ], + "measures": [ + { + "name": "Po Qty", + "expression": "SUM([PoQty])", + "formatString": "#,0" + }, + { + "name": "Po Qty Received", + "expression": "SUM([PoQtyReceived])", + "formatString": "#,0" + }, + { + "name": "Po Qty Remaining", + "expression": "SUM([PoQtyRemaining])", + "formatString": "#,0" + }, + { + "name": "Purchase Orders", + "expression": "DISTINCTCOUNT([Po Number])", + "formatString": "#,0" + }, + { + "name": "Po Suppliers", + "expression": "DISTINCTCOUNT([Po Supplier Code])", + "formatString": "#,0" + }, + { + "name": "Po Items", + "expression": "DISTINCTCOUNT([ItemID])", + "formatString": "#,0" + }, + { + "name": "Po Order Cost", + "expression": "SUM([PoOrderCost])", + "formatString": "#,0.00" + } + ], + "hierarchies": [ + { + "name": "Po Date Expected", + "levels": [ + { + "name": "Po Expected Yr", + "ordinal": 0, + "column": "Po Expected Yr" + }, + { + "name": "Po Expected Month", + "ordinal": 1, + "column": "Po Expected Month" + }, + { + "name": "Po Expected Date", + "ordinal": 2, + "column": "Po Expected Date" + } + ] + } + ] + }, + { + "name": "Program", + "columns": [ + { + "name": "ProgramID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ProgramID", + "sourceProviderType": "Integer" + }, + { + "name": "Program Code", + "dataType": "string", + "sourceColumn": "Program Code", + "sourceProviderType": "Char" + }, + { + "name": "Program Name", + "dataType": "string", + "sourceColumn": "Program Name", + "sourceProviderType": "Char" + }, + { + "name": "Program Desc", + "dataType": "string", + "sourceColumn": "Program Desc", + "sourceProviderType": "Char" + }, + { + "name": "Program Type Name", + "dataType": "string", + "sourceColumn": "Program Type Name", + "sourceProviderType": "Char" + }, + { + "name": "Start Date", + "dataType": "dateTime", + "sourceColumn": "Start Date", + "formatString": "Short Date", + "sourceProviderType": "DBTimeStamp", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "End Date", + "dataType": "dateTime", + "sourceColumn": "End Date", + "formatString": "Short Date", + "sourceProviderType": "DBTimeStamp", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + } + ], + "partitions": [ + { + "name": "Program", + "dataView": "full", + "source": { + "type": "query", + "query": " SELECT [SalesCube].[vwDimProgram].* FROM [SalesCube].[vwDimProgram] ", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + } + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": " SELECT [SalesCube].[vwDimProgram].* FROM [SalesCube].[vwDimProgram] " + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwDimProgram" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + } + ] + }, + { + "name": "Shipped Orders Ex", + "columns": [ + { + "name": "ItemID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ItemID" + }, + { + "name": "ShipDateID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ShipDateID" + }, + { + "name": "AmountExtd", + "dataType": "double", + "isHidden": true, + "sourceColumn": "AmountExtd" + }, + { + "name": "CostExtd", + "dataType": "double", + "isHidden": true, + "sourceColumn": "CostExtd" + }, + { + "name": "QtyShipped", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "QtyShipped" + } + ], + "partitions": [ + { + "name": "Partition", + "dataView": "full", + "source": { + "type": "m", + "expression": [ + "let", + " Source = #\"SQL/PRD-DATAWH01VM;PDW_Reporting\",", + " SalesCube_vwFactExSales = Source{[Schema=\"SalesCube\",Item=\"vwFactExSales\"]}[Data]", + "in", + " SalesCube_vwFactExSales" + ] + } + } + ], + "measures": [ + { + "name": "Ex Sales", + "expression": "SUM([AmountExtd])", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Ex Cogs", + "expression": "SUM([CostExtd])", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Ex Qty Shipped", + "expression": "SUM([QtyShipped])", + "formatString": "#,0" + } + ] + }, + { + "name": "Packages", + "isHidden": true, + "columns": [ + { + "name": "Tracking Number", + "dataType": "string", + "sourceColumn": "Tracking Number" + }, + { + "name": "Carton Number", + "dataType": "string", + "sourceColumn": "Carton Number" + }, + { + "name": "InvoiceID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "InvoiceID" + }, + { + "name": "PackageID", + "dataType": "int64", + "isHidden": true, + "isKey": true, + "sourceColumn": "PackageID" + } + ], + "partitions": [ + { + "name": "Partition", + "dataView": "full", + "source": { + "type": "m", + "expression": [ + "let", + " Source = #\"SQL/PRD-DATAWH01VM;PDW_Reporting\",", + " SalesCube_vwFactPackage = Source{[Schema=\"SalesCube\",Item=\"vwFactPackage\"]}[Data]", + "in", + " SalesCube_vwFactPackage" + ] + } + } + ] + }, + { + "name": "Dealer Returns", + "columns": [ + { + "name": "DealerReturnLineID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "DealerReturnLineID", + "sourceProviderType": "Integer" + }, + { + "name": "Dealer Return Number", + "dataType": "string", + "sourceColumn": "Dealer Return Number", + "sourceProviderType": "Char" + }, + { + "name": "Dealer Return Seq", + "dataType": "int64", + "sourceColumn": "Dealer Return Seq", + "sourceProviderType": "Integer" + }, + { + "name": "FinalDateID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "FinalDateID", + "sourceProviderType": "Integer" + }, + { + "name": "Disp Status Code", + "dataType": "string", + "sourceColumn": "Disp Status Code", + "sourceProviderType": "Char" + }, + { + "name": "Disp Status", + "dataType": "string", + "sourceColumn": "Disp Status", + "sourceProviderType": "Char" + }, + { + "name": "Return Status Code", + "dataType": "string", + "sourceColumn": "Return Status Code", + "sourceProviderType": "Char" + }, + { + "name": "Return Status", + "dataType": "string", + "sourceColumn": "Return Status", + "sourceProviderType": "Char" + }, + { + "name": "Refund Type Code", + "dataType": "string", + "sourceColumn": "Refund Type Code", + "sourceProviderType": "Char" + }, + { + "name": "Refund Type", + "dataType": "string", + "sourceColumn": "Refund Type", + "sourceProviderType": "Char" + }, + { + "name": "Return Detail Code", + "dataType": "string", + "sourceColumn": "Return Detail Code", + "sourceProviderType": "Char" + }, + { + "name": "Return Detail", + "dataType": "string", + "sourceColumn": "Return Detail", + "sourceProviderType": "Char" + }, + { + "name": "Return Reason Code", + "dataType": "string", + "sourceColumn": "Return Reason Code", + "sourceProviderType": "Char" + }, + { + "name": "Return Reason", + "dataType": "string", + "sourceColumn": "Return Reason", + "sourceProviderType": "Char" + }, + { + "name": "Pct Dealer Resp", + "dataType": "int64", + "sourceColumn": "Pct Dealer Resp", + "formatString": "0", + "sourceProviderType": "UnsignedTinyInt" + }, + { + "name": "Defect Desc", + "dataType": "string", + "sourceColumn": "Defect Desc", + "sourceProviderType": "Char" + }, + { + "name": "Last Update", + "dataType": "dateTime", + "sourceColumn": "Last Update", + "formatString": "Short Date", + "sourceProviderType": "DBDate", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Original Invoice Nbr", + "dataType": "string", + "sourceColumn": "Original Invoice Nbr", + "sourceProviderType": "Char" + }, + { + "name": "Original Order Period", + "dataType": "int64", + "sourceColumn": "Original Order Period", + "sourceProviderType": "Integer" + }, + { + "name": "ItemID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ItemID", + "sourceProviderType": "Integer" + }, + { + "name": "DealerID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "DealerID", + "sourceProviderType": "Integer" + }, + { + "name": "Return Location", + "dataType": "string", + "sourceColumn": "Return Location", + "sourceProviderType": "Char" + }, + { + "name": "AuthorizedQty", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "AuthorizedQty", + "sourceProviderType": "Integer" + }, + { + "name": "ReturnQty", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "ReturnQty", + "sourceProviderType": "Integer" + }, + { + "name": "ReturnCogs", + "dataType": "double", + "isHidden": true, + "sourceColumn": "ReturnCogs", + "sourceProviderType": "Numeric" + }, + { + "name": "ReturnDealerPrice", + "dataType": "double", + "isHidden": true, + "sourceColumn": "ReturnDealerPrice", + "sourceProviderType": "Numeric" + }, + { + "name": "Final Yr", + "dataType": "int64", + "sourceColumn": "Final Yr" + }, + { + "name": "Final Yr Mth", + "dataType": "string", + "sourceColumn": "Final Yr Mth", + "sortByColumn": "YrMthID" + }, + { + "name": "YrMthID", + "dataType": "int64", + "isHidden": true, + "sourceColumn": "YrMthID" + }, + { + "name": "Final Date", + "dataType": "dateTime", + "sourceColumn": "Final Date", + "formatString": "Short Date", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "ReturnRolling12", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Return Rolling 12" + }, + { + "name": "ReturnCurrentFiscalYr", + "dataType": "string", + "isHidden": true, + "sourceColumn": "Return Current Fiscal Yr" + }, + { + "name": "Credit Memo Number", + "dataType": "string", + "sourceColumn": "Credit Memo Number" + } + ], + "partitions": [ + { + "name": "Dealer Return Line", + "dataView": "full", + "source": { + "type": "query", + "query": " SELECT [SalesCube].[vwFactDealerReturnLine].* FROM [SalesCube].[vwFactDealerReturnLine] ", + "dataSource": "STG-DATAWH02VM PDW_Reporting" + }, + "annotations": [ + { + "name": "TableWidgetSerialization", + "value": [ + "\r", + "\r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " DealerReturnLineID\r", + " \r", + " \r", + " 124\r", + " \r", + " \r", + " \r", + " \r", + " Dealer Return Number\r", + " \r", + " \r", + " 137\r", + " \r", + " \r", + " \r", + " \r", + " Dealer Return Seq\r", + " \r", + " \r", + " 118\r", + " \r", + " \r", + " \r", + " \r", + " FinalDateID\r", + " \r", + " \r", + " 86\r", + " \r", + " \r", + " \r", + " \r", + " Final Yr\r", + " \r", + " \r", + " 65\r", + " \r", + " \r", + " \r", + " \r", + " Final Yr Mth\r", + " \r", + " \r", + " 86\r", + " \r", + " \r", + " \r", + " \r", + " YrMthID\r", + " \r", + " \r", + " 69\r", + " \r", + " \r", + " \r", + " \r", + " Final Date\r", + " \r", + " \r", + " 78\r", + " \r", + " \r", + " \r", + " \r", + " Disp Status Code\r", + " \r", + " \r", + " 112\r", + " \r", + " \r", + " \r", + " \r", + " Disp Status\r", + " \r", + " \r", + " 84\r", + " \r", + " \r", + " \r", + " \r", + " Return Status Code\r", + " \r", + " \r", + " 125\r", + " \r", + " \r", + " \r", + " \r", + " Return Status\r", + " \r", + " \r", + " 97\r", + " \r", + " \r", + " \r", + " \r", + " Refund Type Code\r", + " \r", + " \r", + " 120\r", + " \r", + " \r", + " \r", + " \r", + " Refund Type\r", + " \r", + " \r", + " 92\r", + " \r", + " \r", + " \r", + " \r", + " Return Detail Code\r", + " \r", + " \r", + " 121\r", + " \r", + " \r", + " \r", + " \r", + " Return Detail\r", + " \r", + " \r", + " 93\r", + " \r", + " \r", + " \r", + " \r", + " Return Reason Code\r", + " \r", + " \r", + " 130\r", + " \r", + " \r", + " \r", + " \r", + " Return Reason\r", + " \r", + " \r", + " 102\r", + " \r", + " \r", + " \r", + " \r", + " Pct Dealer Resp\r", + " \r", + " \r", + " 106\r", + " \r", + " \r", + " \r", + " \r", + " Defect Desc\r", + " \r", + " \r", + " 88\r", + " \r", + " \r", + " \r", + " \r", + " Last Update\r", + " \r", + " \r", + " 88\r", + " \r", + " \r", + " \r", + " \r", + " Original Invoice Nbr\r", + " \r", + " \r", + " 124\r", + " \r", + " \r", + " \r", + " \r", + " Original Order Period\r", + " \r", + " \r", + " 130\r", + " \r", + " \r", + " \r", + " \r", + " ItemID\r", + " \r", + " \r", + " 63\r", + " \r", + " \r", + " \r", + " \r", + " DealerID\r", + " \r", + " \r", + " 72\r", + " \r", + " \r", + " \r", + " \r", + " Return Location\r", + " \r", + " \r", + " 106\r", + " \r", + " \r", + " \r", + " \r", + " AuthorizedQty\r", + " \r", + " \r", + " 100\r", + " \r", + " \r", + " \r", + " \r", + " ReturnQty\r", + " \r", + " \r", + " 81\r", + " \r", + " \r", + " \r", + " \r", + " ReturnCogs\r", + " \r", + " \r", + " 87\r", + " \r", + " \r", + " \r", + " \r", + " ReturnDealerPrice\r", + " \r", + " \r", + " 117\r", + " \r", + " \r", + " \r", + " \r", + " Return Rolling 12\r", + " \r", + " \r", + " 112\r", + " \r", + " \r", + " \r", + " \r", + " Return Current Fiscal Yr\r", + " \r", + " \r", + " 145\r", + " \r", + " \r", + " \r", + " \r", + " Credit Memo Number\r", + " \r", + " \r", + " 130\r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " DealerReturnLineID\r", + " \r", + " \r", + " 0\r", + " \r", + " \r", + " \r", + " \r", + " Dealer Return Number\r", + " \r", + " \r", + " 1\r", + " \r", + " \r", + " \r", + " \r", + " Dealer Return Seq\r", + " \r", + " \r", + " 2\r", + " \r", + " \r", + " \r", + " \r", + " FinalDateID\r", + " \r", + " \r", + " 3\r", + " \r", + " \r", + " \r", + " \r", + " Final Yr\r", + " \r", + " \r", + " 4\r", + " \r", + " \r", + " \r", + " \r", + " Final Yr Mth\r", + " \r", + " \r", + " 5\r", + " \r", + " \r", + " \r", + " \r", + " YrMthID\r", + " \r", + " \r", + " 6\r", + " \r", + " \r", + " \r", + " \r", + " Final Date\r", + " \r", + " \r", + " 7\r", + " \r", + " \r", + " \r", + " \r", + " Disp Status Code\r", + " \r", + " \r", + " 8\r", + " \r", + " \r", + " \r", + " \r", + " Disp Status\r", + " \r", + " \r", + " 9\r", + " \r", + " \r", + " \r", + " \r", + " Return Status Code\r", + " \r", + " \r", + " 10\r", + " \r", + " \r", + " \r", + " \r", + " Return Status\r", + " \r", + " \r", + " 11\r", + " \r", + " \r", + " \r", + " \r", + " Refund Type Code\r", + " \r", + " \r", + " 12\r", + " \r", + " \r", + " \r", + " \r", + " Refund Type\r", + " \r", + " \r", + " 13\r", + " \r", + " \r", + " \r", + " \r", + " Return Detail Code\r", + " \r", + " \r", + " 14\r", + " \r", + " \r", + " \r", + " \r", + " Return Detail\r", + " \r", + " \r", + " 15\r", + " \r", + " \r", + " \r", + " \r", + " Return Reason Code\r", + " \r", + " \r", + " 16\r", + " \r", + " \r", + " \r", + " \r", + " Return Reason\r", + " \r", + " \r", + " 17\r", + " \r", + " \r", + " \r", + " \r", + " Pct Dealer Resp\r", + " \r", + " \r", + " 18\r", + " \r", + " \r", + " \r", + " \r", + " Defect Desc\r", + " \r", + " \r", + " 19\r", + " \r", + " \r", + " \r", + " \r", + " Last Update\r", + " \r", + " \r", + " 20\r", + " \r", + " \r", + " \r", + " \r", + " Original Invoice Nbr\r", + " \r", + " \r", + " 21\r", + " \r", + " \r", + " \r", + " \r", + " Original Order Period\r", + " \r", + " \r", + " 22\r", + " \r", + " \r", + " \r", + " \r", + " ItemID\r", + " \r", + " \r", + " 23\r", + " \r", + " \r", + " \r", + " \r", + " DealerID\r", + " \r", + " \r", + " 24\r", + " \r", + " \r", + " \r", + " \r", + " Return Location\r", + " \r", + " \r", + " 25\r", + " \r", + " \r", + " \r", + " \r", + " AuthorizedQty\r", + " \r", + " \r", + " 26\r", + " \r", + " \r", + " \r", + " \r", + " ReturnQty\r", + " \r", + " \r", + " 27\r", + " \r", + " \r", + " \r", + " \r", + " ReturnCogs\r", + " \r", + " \r", + " 28\r", + " \r", + " \r", + " \r", + " \r", + " ReturnDealerPrice\r", + " \r", + " \r", + " 29\r", + " \r", + " \r", + " \r", + " \r", + " Return Rolling 12\r", + " \r", + " \r", + " 30\r", + " \r", + " \r", + " \r", + " \r", + " Return Current Fiscal Yr\r", + " \r", + " \r", + " 31\r", + " \r", + " \r", + " \r", + " \r", + " Credit Memo Number\r", + " \r", + " \r", + " 32\r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " Final Yr\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " Final Yr Mth\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " YrMthID\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " Final Date\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " Return Rolling 12\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " Return Current Fiscal Yr\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " Credit Memo Number\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " false\r", + "]]>" + ] + } + ] + } + ], + "measures": [ + { + "name": "Authorized Qty", + "expression": "SUM([AuthorizedQty])", + "formatString": "#,0" + }, + { + "name": "Return Qty", + "expression": "SUM([ReturnQty])", + "formatString": "#,0" + }, + { + "name": "Return Cogs", + "expression": "SUM([ReturnCogs])", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "Return Dealer Price", + "expression": "SUM([ReturnDealerPrice])", + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "R12 Returns", + "expression": [ + " ", + "CALCULATE (", + " SUM ( 'Dealer Returns'[ReturnDealerPrice]) ,", + " FILTER ( 'Dealer Returns', 'Dealer Returns'[ReturnRolling12] = \"YES\" ),", + " FILTER ( 'Sales Misc','Sales Misc'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + }, + { + "name": "FY Returns", + "expression": [ + " ", + "CALCULATE (", + " SUM ( 'Dealer Returns'[ReturnDealerPrice]) ,", + " FILTER ( 'Dealer Returns', 'Dealer Returns'[ReturnCurrentFiscalYr] = \"YES\" ),", + " FILTER ( 'Sales Misc','Sales Misc'[Dealer Type Code] <> \"B\" )", + ")" + ], + "formatString": "\\$#,0.00;(\\$#,0.00);\\$#,0.00", + "annotations": [ + { + "name": "Format", + "value": "" + } + ] + } + ], + "hierarchies": [ + { + "name": "Final Dates", + "levels": [ + { + "name": "Final Yr", + "ordinal": 0, + "column": "Final Yr" + }, + { + "name": "Final Yr Mth", + "ordinal": 1, + "column": "Final Yr Mth" + }, + { + "name": "Final Date", + "ordinal": 2, + "column": "Final Date" + } + ] + } + ], + "annotations": [ + { + "name": "_TM_ExtProp_QueryDefinition", + "value": " SELECT [SalesCube].[vwFactDealerReturnLine].* FROM [SalesCube].[vwFactDealerReturnLine] " + }, + { + "name": "_TM_ExtProp_DbTableName", + "value": "vwFactDealerReturnLine" + }, + { + "name": "_TM_ExtProp_DbSchemaName", + "value": "SalesCube" + }, + { + "name": "TableWidgetSerialization", + "value": [ + "\r", + "\r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " DealerReturnLineID\r", + " \r", + " \r", + " 124\r", + " \r", + " \r", + " \r", + " \r", + " Dealer Return Number\r", + " \r", + " \r", + " 137\r", + " \r", + " \r", + " \r", + " \r", + " Dealer Return Seq\r", + " \r", + " \r", + " 118\r", + " \r", + " \r", + " \r", + " \r", + " FinalDateID\r", + " \r", + " \r", + " 86\r", + " \r", + " \r", + " \r", + " \r", + " Final Yr\r", + " \r", + " \r", + " 65\r", + " \r", + " \r", + " \r", + " \r", + " Final Yr Mth\r", + " \r", + " \r", + " 86\r", + " \r", + " \r", + " \r", + " \r", + " YrMthID\r", + " \r", + " \r", + " 69\r", + " \r", + " \r", + " \r", + " \r", + " Final Date\r", + " \r", + " \r", + " 78\r", + " \r", + " \r", + " \r", + " \r", + " Disp Status Code\r", + " \r", + " \r", + " 112\r", + " \r", + " \r", + " \r", + " \r", + " Disp Status\r", + " \r", + " \r", + " 84\r", + " \r", + " \r", + " \r", + " \r", + " Return Status Code\r", + " \r", + " \r", + " 125\r", + " \r", + " \r", + " \r", + " \r", + " Return Status\r", + " \r", + " \r", + " 97\r", + " \r", + " \r", + " \r", + " \r", + " Refund Type Code\r", + " \r", + " \r", + " 120\r", + " \r", + " \r", + " \r", + " \r", + " Refund Type\r", + " \r", + " \r", + " 92\r", + " \r", + " \r", + " \r", + " \r", + " Return Detail Code\r", + " \r", + " \r", + " 121\r", + " \r", + " \r", + " \r", + " \r", + " Return Detail\r", + " \r", + " \r", + " 93\r", + " \r", + " \r", + " \r", + " \r", + " Return Reason Code\r", + " \r", + " \r", + " 130\r", + " \r", + " \r", + " \r", + " \r", + " Return Reason\r", + " \r", + " \r", + " 102\r", + " \r", + " \r", + " \r", + " \r", + " Pct Dealer Resp\r", + " \r", + " \r", + " 106\r", + " \r", + " \r", + " \r", + " \r", + " Defect Desc\r", + " \r", + " \r", + " 88\r", + " \r", + " \r", + " \r", + " \r", + " Last Update\r", + " \r", + " \r", + " 88\r", + " \r", + " \r", + " \r", + " \r", + " Original Invoice Nbr\r", + " \r", + " \r", + " 124\r", + " \r", + " \r", + " \r", + " \r", + " Original Order Period\r", + " \r", + " \r", + " 130\r", + " \r", + " \r", + " \r", + " \r", + " ItemID\r", + " \r", + " \r", + " 63\r", + " \r", + " \r", + " \r", + " \r", + " DealerID\r", + " \r", + " \r", + " 72\r", + " \r", + " \r", + " \r", + " \r", + " Return Location\r", + " \r", + " \r", + " 106\r", + " \r", + " \r", + " \r", + " \r", + " AuthorizedQty\r", + " \r", + " \r", + " 100\r", + " \r", + " \r", + " \r", + " \r", + " ReturnQty\r", + " \r", + " \r", + " 81\r", + " \r", + " \r", + " \r", + " \r", + " ReturnCogs\r", + " \r", + " \r", + " 87\r", + " \r", + " \r", + " \r", + " \r", + " ReturnDealerPrice\r", + " \r", + " \r", + " 117\r", + " \r", + " \r", + " \r", + " \r", + " Return Rolling 12\r", + " \r", + " \r", + " 112\r", + " \r", + " \r", + " \r", + " \r", + " Return Current Fiscal Yr\r", + " \r", + " \r", + " 145\r", + " \r", + " \r", + " \r", + " \r", + " Credit Memo Number\r", + " \r", + " \r", + " 130\r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " DealerReturnLineID\r", + " \r", + " \r", + " 0\r", + " \r", + " \r", + " \r", + " \r", + " Dealer Return Number\r", + " \r", + " \r", + " 1\r", + " \r", + " \r", + " \r", + " \r", + " Dealer Return Seq\r", + " \r", + " \r", + " 2\r", + " \r", + " \r", + " \r", + " \r", + " FinalDateID\r", + " \r", + " \r", + " 3\r", + " \r", + " \r", + " \r", + " \r", + " Final Yr\r", + " \r", + " \r", + " 4\r", + " \r", + " \r", + " \r", + " \r", + " Final Yr Mth\r", + " \r", + " \r", + " 5\r", + " \r", + " \r", + " \r", + " \r", + " YrMthID\r", + " \r", + " \r", + " 6\r", + " \r", + " \r", + " \r", + " \r", + " Final Date\r", + " \r", + " \r", + " 7\r", + " \r", + " \r", + " \r", + " \r", + " Disp Status Code\r", + " \r", + " \r", + " 8\r", + " \r", + " \r", + " \r", + " \r", + " Disp Status\r", + " \r", + " \r", + " 9\r", + " \r", + " \r", + " \r", + " \r", + " Return Status Code\r", + " \r", + " \r", + " 10\r", + " \r", + " \r", + " \r", + " \r", + " Return Status\r", + " \r", + " \r", + " 11\r", + " \r", + " \r", + " \r", + " \r", + " Refund Type Code\r", + " \r", + " \r", + " 12\r", + " \r", + " \r", + " \r", + " \r", + " Refund Type\r", + " \r", + " \r", + " 13\r", + " \r", + " \r", + " \r", + " \r", + " Return Detail Code\r", + " \r", + " \r", + " 14\r", + " \r", + " \r", + " \r", + " \r", + " Return Detail\r", + " \r", + " \r", + " 15\r", + " \r", + " \r", + " \r", + " \r", + " Return Reason Code\r", + " \r", + " \r", + " 16\r", + " \r", + " \r", + " \r", + " \r", + " Return Reason\r", + " \r", + " \r", + " 17\r", + " \r", + " \r", + " \r", + " \r", + " Pct Dealer Resp\r", + " \r", + " \r", + " 18\r", + " \r", + " \r", + " \r", + " \r", + " Defect Desc\r", + " \r", + " \r", + " 19\r", + " \r", + " \r", + " \r", + " \r", + " Last Update\r", + " \r", + " \r", + " 20\r", + " \r", + " \r", + " \r", + " \r", + " Original Invoice Nbr\r", + " \r", + " \r", + " 21\r", + " \r", + " \r", + " \r", + " \r", + " Original Order Period\r", + " \r", + " \r", + " 22\r", + " \r", + " \r", + " \r", + " \r", + " ItemID\r", + " \r", + " \r", + " 23\r", + " \r", + " \r", + " \r", + " \r", + " DealerID\r", + " \r", + " \r", + " 24\r", + " \r", + " \r", + " \r", + " \r", + " Return Location\r", + " \r", + " \r", + " 25\r", + " \r", + " \r", + " \r", + " \r", + " AuthorizedQty\r", + " \r", + " \r", + " 26\r", + " \r", + " \r", + " \r", + " \r", + " ReturnQty\r", + " \r", + " \r", + " 27\r", + " \r", + " \r", + " \r", + " \r", + " ReturnCogs\r", + " \r", + " \r", + " 28\r", + " \r", + " \r", + " \r", + " \r", + " ReturnDealerPrice\r", + " \r", + " \r", + " 29\r", + " \r", + " \r", + " \r", + " \r", + " Return Rolling 12\r", + " \r", + " \r", + " 30\r", + " \r", + " \r", + " \r", + " \r", + " Return Current Fiscal Yr\r", + " \r", + " \r", + " 31\r", + " \r", + " \r", + " \r", + " \r", + " Credit Memo Number\r", + " \r", + " \r", + " 32\r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " Final Yr\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " Final Yr Mth\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " YrMthID\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " Final Date\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " Return Rolling 12\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " Return Current Fiscal Yr\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " Credit Memo Number\r", + " \r", + " \r", + " true\r", + " \r", + " \r", + " \r", + " \r", + " \r", + " \r", + " false\r", + "]]>" + ] + } + ] + } + ], + "relationships": [ + { + "name": "ff649c61-6b08-4f21-8007-084b70d7cc4b", + "fromTable": "Inventory", + "fromColumn": "InventoryDateID", + "toTable": "Inventory Date", + "toColumn": "InventoryDateID" + }, + { + "name": "f5b853fa-92b5-4ebe-b418-6252c70692cf", + "fromTable": "Inventory", + "fromColumn": "ItemID", + "toTable": "Item", + "toColumn": "ItemID" + }, + { + "name": "bd180f59-8d29-42f9-97a3-49d0c05cfc7a", + "fromTable": "Inventory", + "fromColumn": "ItemHistoryID", + "toTable": "Item History", + "toColumn": "ItemHistoryID" + }, + { + "name": "b5484788-1a72-400d-a2e5-ee08b46229bc", + "fromTable": "Forecast", + "fromColumn": "ItemID", + "toTable": "Item", + "toColumn": "ItemID" + }, + { + "name": "8d285fb2-41c4-4aac-9d64-820323ff6940", + "fromTable": "Shipped Orders", + "fromColumn": "SalesShippingAddressID", + "toTable": "Ship To Address", + "toColumn": "SalesShipToAddressID" + }, + { + "name": "e5be24d9-3877-434a-9c6b-e7443b028f6d", + "fromTable": "Shipped Orders", + "fromColumn": "SalesMiscID", + "toTable": "Sales Misc", + "toColumn": "SalesMiscID" + }, + { + "name": "14d262e1-63eb-403c-ac35-f42bad3a07e5", + "fromTable": "Shipped Orders", + "fromColumn": "DealerID", + "toTable": "Dealer", + "toColumn": "DealerID" + }, + { + "name": "b27a9a7f-2ddb-4f69-866e-e892424768ae", + "fromTable": "Shipped Orders", + "fromColumn": "ItemID", + "toTable": "Item", + "toColumn": "ItemID" + }, + { + "name": "ea34667f-91a2-4a1c-a954-2e28ad6649ec", + "fromTable": "Shipped Orders", + "fromColumn": "ItemHistoryID", + "toTable": "Item History", + "toColumn": "ItemHistoryID" + }, + { + "name": "4901d258-8125-42a1-8f63-7033f9079bd0", + "fromTable": "Shipped Orders", + "fromColumn": "ShipDateID", + "toTable": "Date Shipped", + "toColumn": "DateID" + }, + { + "name": "d0cdcfb3-dfb6-4caf-a953-fd281bc575a0", + "fromTable": "Back Orders", + "fromColumn": "ItemID", + "toTable": "Item", + "toColumn": "ItemID" + }, + { + "name": "3b0c8de0-c562-480a-a5f4-d7f732601ac4", + "fromTable": "Back Orders", + "fromColumn": "DealerID", + "toTable": "Dealer", + "toColumn": "DealerID" + }, + { + "name": "dd04ea87-e1f9-4393-8c65-fc04190fa018", + "fromTable": "Back Orders", + "fromColumn": "SalesMiscID", + "toTable": "Sales Misc", + "toColumn": "SalesMiscID" + }, + { + "name": "0e199bbd-6a2b-4e29-99c4-c8e576ede9c7", + "fromTable": "Back Orders", + "fromColumn": "ItemHistoryID", + "toTable": "Item History", + "toColumn": "ItemHistoryID" + }, + { + "name": "d46b2d75-ff7a-49b7-a347-c4fba33f8f8a", + "fromTable": "Purchase Orders", + "fromColumn": "ItemID", + "toTable": "Item", + "toColumn": "ItemID" + }, + { + "name": "eeafa63b-d05c-42c7-9a40-029839160af5", + "fromTable": "Shipped Orders", + "fromColumn": "ProgramID", + "toTable": "Program", + "toColumn": "ProgramID" + }, + { + "name": "595219ce-2a7d-447e-a1d9-fd6494f6e27b", + "fromTable": "Shipped Orders Ex", + "fromColumn": "ItemID", + "toTable": "Item", + "toColumn": "ItemID" + }, + { + "name": "4b8e786f-e636-434b-9fdf-6ee69c648d94", + "fromTable": "Shipped Orders Ex", + "fromColumn": "ShipDateID", + "toTable": "Date Shipped", + "toColumn": "DateID" + }, + { + "name": "4c2a1a70-210c-4912-b7fb-961a64c10189", + "toCardinality": "many", + "fromTable": "Packages", + "fromColumn": "InvoiceID", + "toTable": "Shipped Orders", + "toColumn": "InvoiceID", + "crossFilteringBehavior": "bothDirections" + }, + { + "name": "e60b5644-862d-40ad-9ac2-8a9fc61ae872", + "fromTable": "Dealer Returns", + "fromColumn": "DealerID", + "toTable": "Dealer", + "toColumn": "DealerID" + }, + { + "name": "748a49de-65e9-4ec5-83d4-0e2eeff49857", + "fromTable": "Dealer Returns", + "fromColumn": "ItemID", + "toTable": "Item", + "toColumn": "ItemID" + } + ], + "perspectives": [ + { + "name": "Sales", + "tables": [ + { + "name": "Date Shipped", + "columns": [ + { + "name": "Calendar Date" + }, + { + "name": "Current Day" + }, + { + "name": "Current Month" + }, + { + "name": "Current Year" + }, + { + "name": "DateID" + }, + { + "name": "Day Name" + }, + { + "name": "DayNameID" + }, + { + "name": "Fiscal Qtr" + }, + { + "name": "Fiscal Yr" + }, + { + "name": "Fiscal Yr Mth" + }, + { + "name": "Fiscal Yr Qtr" + }, + { + "name": "FiscalQtrID" + }, + { + "name": "FiscalYrMthID" + }, + { + "name": "FiscalYrQtrID" + }, + { + "name": "Holiday" + }, + { + "name": "Mth" + }, + { + "name": "MthID" + }, + { + "name": "Qtr" + }, + { + "name": "QtrID" + }, + { + "name": "Rolling 12" + }, + { + "name": "Rolling 12 Plus Curr Mth" + }, + { + "name": "Rolling 12 Prior" + }, + { + "name": "Rolling 12 Prior2" + }, + { + "name": "Rolling 24" + }, + { + "name": "Rolling 24 Plus Curr Mth" + }, + { + "name": "Rolling 36" + }, + { + "name": "Rolling 36 Plus Curr Mth" + }, + { + "name": "Shipping Day" + }, + { + "name": "ShippingDayID" + }, + { + "name": "Week Day" + }, + { + "name": "Week End" + }, + { + "name": "Yr" + }, + { + "name": "Yr Mth" + }, + { + "name": "Yr Mth#" + }, + { + "name": "Yr Qtr" + }, + { + "name": "YrMthID" + }, + { + "name": "YrQtrID" + } + ], + "hierarchies": [ + { + "name": "Ship Date" + } + ] + }, + { + "name": "Dealer", + "columns": [ + { + "name": "Base Rep" + }, + { + "name": "Base Rep Code" + }, + { + "name": "Carb Opt Out" + }, + { + "name": "Contact Name" + }, + { + "name": "Dealer" + }, + { + "name": "Dealer Address1" + }, + { + "name": "Dealer Address2" + }, + { + "name": "Dealer City" + }, + { + "name": "Dealer DBA" + }, + { + "name": "Dealer Email" + }, + { + "name": "Dealer Ext" + }, + { + "name": "Dealer Number" + }, + { + "name": "Dealer State" + }, + { + "name": "Dealer State Abbr" + }, + { + "name": "Dealer Type" + }, + { + "name": "Dealer Type Code" + }, + { + "name": "Dealer Zip" + }, + { + "name": "Parent Dealer" + }, + { + "name": "Parent Dealer Number" + }, + { + "name": "Purchase Level" + }, + { + "name": "Purchase Level Code" + }, + { + "name": "Purchase Level Disc Plus" + }, + { + "name": "Sales Region" + }, + { + "name": "Sales Region Code" + }, + { + "name": "Sales Region Group" + }, + { + "name": "Sales Region Manager" + }, + { + "name": "Sales Rep" + }, + { + "name": "Sales Rep Code" + }, + { + "name": "Base Region Code" + }, + { + "name": "LeMans Corp Dealer" + }, + { + "name": "National Sales Mgr" + }, + { + "name": "Dealer Country" + }, + { + "name": "Dealer Country Code" + } + ] + }, + { + "name": "Item", + "columns": [ + { + "name": "Brand" + }, + { + "name": "Brand Code" + }, + { + "name": "Brand Ext" + }, + { + "name": "Brand Group" + }, + { + "name": "Color Finish" + }, + { + "name": "Commodity" + }, + { + "name": "Commodity Code" + }, + { + "name": "Commodity Ext" + }, + { + "name": "Display Color" + }, + { + "name": "Gender Age" + }, + { + "name": "Harmonized Code Eu" + }, + { + "name": "Harmonized Code Us" + }, + { + "name": "House Brand" + }, + { + "name": "Item" + }, + { + "name": "Item Ext" + }, + { + "name": "Item Number" + }, + { + "name": "Item Status" + }, + { + "name": "Item Status Code" + }, + { + "name": "Model" + }, + { + "name": "Primary Vendor" + }, + { + "name": "Primary Vendor Code" + }, + { + "name": "Primary Vendor Ext" + }, + { + "name": "Primary Vendor Status" + }, + { + "name": "Primary Vendor Status Code" + }, + { + "name": "Primary Vendor Visible" + }, + { + "name": "Product" + }, + { + "name": "Product Code" + }, + { + "name": "Product Ext" + }, + { + "name": "Product Name" + }, + { + "name": "Sales Model" + }, + { + "name": "Size" + }, + { + "name": "Sub Commodity" + }, + { + "name": "Sub Commodity Code" + }, + { + "name": "Sub Commodity Ext" + } + ] + }, + { + "name": "Sales Misc", + "columns": [ + { + "name": "Dealer Type Desc" + }, + { + "name": "Order Time Hr" + }, + { + "name": "Order Type" + }, + { + "name": "Order Type Code" + } + ] + }, + { + "name": "Ship To Address", + "columns": [ + { + "name": "Ship To City" + }, + { + "name": "Ship To Country" + }, + { + "name": "Ship To State" + }, + { + "name": "Ship To Zip Code" + } + ] + }, + { + "name": "Shipped Orders", + "columns": [ + { + "name": "Customer PO" + }, + { + "name": "Invoice Number" + }, + { + "name": "Order Line Number" + }, + { + "name": "Order Location" + }, + { + "name": "Order Number" + }, + { + "name": "Order Suffix" + }, + { + "name": "Order State" + } + ], + "measures": [ + { + "name": "COGS" + }, + { + "name": "Dealers" + }, + { + "name": "Discount" + }, + { + "name": "Discount Pct" + }, + { + "name": "Items Shipped" + }, + { + "name": "List Price" + }, + { + "name": "Margin" + }, + { + "name": "Margin Pct" + }, + { + "name": "Orders" + }, + { + "name": "Prior Period Growth" + }, + { + "name": "Prior Period Growth Pct" + }, + { + "name": "Qty Backordered" + }, + { + "name": "Qty Ordered" + }, + { + "name": "Qty Ordered Test" + }, + { + "name": "Qty Shipped" + }, + { + "name": "Sales" + }, + { + "name": "Sales Prior Period" + }, + { + "name": "Dropship Pct" + }, + { + "name": "Dropship Qty" + }, + { + "name": "Dropship Sales" + }, + { + "name": "Discount Prior Period" + }, + { + "name": "Discount Prior Period Pct" + }, + { + "name": "List Price Prior Period" + }, + { + "name": "Margin Prior Period" + }, + { + "name": "Margin Prior Period Pct" + }, + { + "name": "Dropship Dealers" + }, + { + "name": "Dropship Fee" + }, + { + "name": "Dropship Items" + }, + { + "name": "Dropship Orders" + }, + { + "name": "Dropship Prior Period Growth Pct" + }, + { + "name": "Dropship Sales Prior Period" + }, + { + "name": "Brands Shipped" + }, + { + "name": "Dropship Order Avg" + }, + { + "name": "Fiscal Sales Growth" + }, + { + "name": "Fiscal Sales Growth%" + }, + { + "name": "Fiscal Sales Ly" + }, + { + "name": "Fiscal Sales Ty" + }, + { + "name": "Mtd Sales Growth" + }, + { + "name": "Mtd Sales Growth%" + }, + { + "name": "Mtd Sales Ly" + }, + { + "name": "Mtd Sales Ty" + }, + { + "name": "Order Avg" + }, + { + "name": "Prev Mth Sales Ly" + }, + { + "name": "Prev Mth Sales Ty" + }, + { + "name": "R12 Sales Growth" + }, + { + "name": "R12 Sales Growth%" + }, + { + "name": "R12 Sales Ly" + }, + { + "name": "R12 Sales Ty" + }, + { + "name": "Prev Mth Sales Growth" + }, + { + "name": "Prev Mth Sales Growth%" + }, + { + "name": "Prev Mth Dealers Ly" + }, + { + "name": "Prev Mth Cogs Ty" + }, + { + "name": "Prev Mth Cogs Ly" + }, + { + "name": "Mtd Margin Ty" + }, + { + "name": "Mtd Dealers Ty" + }, + { + "name": "Mtd Dealers Ly" + }, + { + "name": "Mtd Cogs Ty" + }, + { + "name": "Mtd Cogs Ly" + }, + { + "name": "Fiscal Margin Ty" + }, + { + "name": "Fiscal Margin Ly" + }, + { + "name": "Fiscal Dealers Ty" + }, + { + "name": "Fiscal Dealers Ly" + }, + { + "name": "Fiscal Cogs Ty" + }, + { + "name": "Fiscal Cogs Ly" + }, + { + "name": "Dropship Prior Period Growth" + }, + { + "name": "Mtd Margin Ly" + }, + { + "name": "Prev Mth Dealers Ty" + }, + { + "name": "Prev Mth DS Sales Ty" + }, + { + "name": "Prev Mth Margin Ly" + }, + { + "name": "Prev Mth Margin Ty" + }, + { + "name": "Prev Mth Margin% Ly" + }, + { + "name": "R12 Cogs Ly" + }, + { + "name": "R12 Cogs Ty" + }, + { + "name": "R12 Dealers Ly" + }, + { + "name": "R12 Dealers Ty" + }, + { + "name": "R12 Margin Ly" + }, + { + "name": "R12 Margin Ty" + }, + { + "name": "R12 Margin% Ly" + }, + { + "name": "R12 Margin% Ty" + }, + { + "name": "Qty Shipped Prior Period" + }, + { + "name": "R12 Qty Shipped Ty" + }, + { + "name": "R12 Qty Shipped Ly" + }, + { + "name": "Packages" + }, + { + "name": "Invoices" + }, + { + "name": "Packages Invoice" + }, + { + "name": "R12 Orders Ty" + }, + { + "name": "Mtd Margin% Ty" + }, + { + "name": "Mtd Margin% Ly" + }, + { + "name": "Fiscal Margin% Ty" + }, + { + "name": "Fiscal Margin% Ly" + }, + { + "name": "Prev Mth Margin% Ty" + }, + { + "name": "Mtd Orders Ly" + } + ] + }, + { + "name": "Dealer Returns", + "columns": [ + { + "name": "AuthorizedQty" + }, + { + "name": "Dealer Return Number" + }, + { + "name": "Dealer Return Seq" + }, + { + "name": "DealerID" + }, + { + "name": "DealerReturnLineID" + }, + { + "name": "Defect Desc" + }, + { + "name": "Disp Status" + }, + { + "name": "Disp Status Code" + }, + { + "name": "Final Date" + }, + { + "name": "Final Yr" + }, + { + "name": "Final Yr Mth" + }, + { + "name": "FinalDateID" + }, + { + "name": "ItemID" + }, + { + "name": "Last Update" + }, + { + "name": "Original Invoice Nbr" + }, + { + "name": "Original Order Period" + }, + { + "name": "Pct Dealer Resp" + }, + { + "name": "Refund Type" + }, + { + "name": "Refund Type Code" + }, + { + "name": "Return Detail" + }, + { + "name": "Return Detail Code" + }, + { + "name": "Return Location" + }, + { + "name": "Return Reason" + }, + { + "name": "Return Reason Code" + }, + { + "name": "Return Status" + }, + { + "name": "Return Status Code" + }, + { + "name": "ReturnCogs" + }, + { + "name": "ReturnDealerPrice" + }, + { + "name": "ReturnQty" + }, + { + "name": "YrMthID" + } + ], + "measures": [ + { + "name": "Authorized Qty" + }, + { + "name": "Return Cogs" + }, + { + "name": "Return Dealer Price" + }, + { + "name": "Return Qty" + } + ] + } + ] + } + ], + "roles": [ + { + "name": "Sales", + "modelPermission": "read", + "members": [ + { + "memberName": "jharp@parts-unltd.com", + "memberId": "jharp@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "AGelsinger@Parts-Unltd.com", + "memberId": "AGelsinger@Parts-Unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "TCorum@Parts-Unltd.com", + "memberId": "TCorum@Parts-Unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "AGleason@parts-unltd.com", + "memberId": "AGleason@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "BCounter@parts-unltd.com", + "memberId": "BCounter@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "jstrangfeld@dragspecialties.com", + "memberId": "jstrangfeld@dragspecialties.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "PAustin@Parts-Unltd.com", + "memberId": "PAustin@Parts-Unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "achristl@parts-unltd.com", + "memberId": "achristl@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "gmatter@dragspecialties.com", + "memberId": "gmatter@dragspecialties.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "kvance@parts-unltd.com", + "memberId": "kvance@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "JAJanisch@parts-unltd.com", + "memberId": "JAJanisch@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + } + ], + "tablePermissions": [ + { + "name": "Forecast", + "metadataPermission": "none" + }, + { + "name": "Inventory", + "metadataPermission": "none" + }, + { + "name": "Inventory Date", + "metadataPermission": "none" + } + ] + }, + { + "name": "Purchasing", + "modelPermission": "read", + "members": [ + { + "memberName": "FZiegler@parts-unltd.com", + "memberId": "FZiegler@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "kpersak@parts-unltd.com", + "memberId": "kpersak@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "QBanh@parts-unltd.com", + "memberId": "QBanh@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "CPower@parts-unltd.com", + "memberId": "CPower@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "MAthanassiadis@parts-unltd.com", + "memberId": "MAthanassiadis@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "BBelken@parts-unltd.com", + "memberId": "BBelken@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "BWalford@parts-unltd.com", + "memberId": "BWalford@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "JRicci@parts-unltd.com", + "memberId": "JRicci@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "APanici@parts-unltd.com", + "memberId": "APanici@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "BGreene@parts-unltd.com", + "memberId": "BGreene@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "EJadoul@parts-unltd.com", + "memberId": "EJadoul@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "PLampher@parts-unltd.com", + "memberId": "PLampher@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "rgusner@parts-unltd.com", + "memberId": "rgusner@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "SMiller@parts-unltd.com", + "memberId": "SMiller@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "smlynch@parts-unltd.com", + "memberId": "smlynch@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "msaleem@parts-unltd.com", + "memberId": "msaleem@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "wclaypool@parts-unltd.com", + "memberId": "wclaypool@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "NBrewer@thormx.com", + "memberId": "NBrewer@thormx.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "KFoster@rideicon.com", + "memberId": "KFoster@rideicon.com#AzureAD", + "identityProvider": "AzureAD" + } + ] + }, + { + "name": "IT", + "modelPermission": "read", + "members": [ + { + "memberName": "LEMANSCORP\\BENGEBRETSON", + "memberId": "S-1-5-21-1065490020-189596164-1233803906-10725" + }, + { + "memberName": "ARajaraman@parts-unltd.com", + "memberId": "ARajaraman@parts-unltd.com", + "identityProvider": "AzureAD" + }, + { + "memberName": "LPerry@Parts-Unltd.com", + "memberId": "LPerry@Parts-Unltd.com", + "identityProvider": "AzureAD" + }, + { + "memberName": "DUrness@Parts-Unltd.com", + "memberId": "DUrness@Parts-Unltd.com", + "identityProvider": "AzureAD" + }, + { + "memberName": "DKostinek@Parts-Unltd.com", + "memberId": "DKostinek@Parts-Unltd.com", + "identityProvider": "AzureAD" + }, + { + "memberName": "BDunk@Parts-Unltd.com", + "memberId": "BDunk@Parts-Unltd.com", + "identityProvider": "AzureAD" + }, + { + "memberName": "kkraus@parts-unltd.com", + "memberId": "kkraus@parts-unltd.com", + "identityProvider": "AzureAD" + }, + { + "memberName": "achouinard@parts-unltd.com", + "memberId": "achouinard@parts-unltd.com", + "identityProvider": "AzureAD" + }, + { + "memberName": "BENGEBRETSON@parts-unltd.com", + "memberId": "BENGEBRETSON@parts-unltd.com", + "identityProvider": "AzureAD" + } + ] + }, + { + "name": "DbaTeam", + "modelPermission": "administrator", + "members": [ + { + "memberName": "vbhadharla@parts-unltd.com", + "memberId": "vbhadharla@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "WPhaobanchong@parts-unltd.com", + "memberId": "WPhaobanchong@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "DKirchens@parts-unltd.com", + "memberId": "DKirchens@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "prd-sqlservice@lemanscorp.com", + "memberId": "prd-sqlservice@lemanscorp.com#AzureAD", + "identityProvider": "AzureAD" + } + ] + }, + { + "name": "DigitalServices", + "modelPermission": "read", + "members": [ + { + "memberName": "CRing@parts-unltd.com", + "memberId": "CRing@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "abondjuk@parts-unltd.com", + "memberId": "abondjuk@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + } + ] + }, + { + "name": "Management", + "modelPermission": "read", + "members": [ + { + "memberName": "JBPoehlman@Parts-Unltd.com", + "memberId": "JBPoehlman@Parts-Unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "PLangley@parts-unltd.com", + "memberId": "PLangley@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "mcollins@parts-unltd.com", + "memberId": "mcollins@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "IKramer@parts-unltd.com", + "memberId": "IKramer@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "PDevine@parts-unltd.com", + "memberId": "PDevine@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "GMcmanus@parts-unltd.com", + "memberId": "GMcmanus@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "BNorwell@parts-unltd.com", + "memberId": "BNorwell@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + } + ] + }, + { + "name": "DealerServices", + "modelPermission": "read", + "members": [ + { + "memberName": "PSchoonover@parts-unltd.com", + "memberId": "PSchoonover@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "MLeVelle@parts-unltd.com", + "memberId": "MLeVelle@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "MAGraves@parts-unltd.com", + "memberId": "MAGraves@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "TReilly@parts-unltd.com", + "memberId": "TReilly@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + } + ] + }, + { + "name": "Accounting", + "modelPermission": "read", + "members": [ + { + "memberName": "KFinn@parts-unltd.com", + "memberId": "KFinn@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "TFritsch@parts-unltd.com", + "memberId": "TFritsch@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "LBell@parts-unltd.com", + "memberId": "LBell@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "VJankiewicz@parts-unltd.com", + "memberId": "VJankiewicz@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "WBolger@parts-unltd.com", + "memberId": "WBolger@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "GSinn@parts-unltd.com", + "memberId": "GSinn@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "DBianchi@parts-unltd.com", + "memberId": "DBianchi@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "NBoukidis@parts-unltd.com", + "memberId": "NBoukidis@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + }, + { + "memberName": "mpartipilo@parts-unltd.com", + "memberId": "mpartipilo@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + } + ] + }, + { + "name": "Legal", + "modelPermission": "read", + "members": [ + { + "memberName": "bnightengale@parts-unltd.com", + "memberId": "bnightengale@parts-unltd.com#AzureAD", + "identityProvider": "AzureAD" + } + ] + } + ], + "expressions": [ + { + "name": "SalesCube vwFactShippedOrders", + "kind": "m", + "expression": [ + "let\r", + " Source = #\"SQL/PRD-DATAWH01VM;PDW_Reporting\",\r", + " SalesCube_vwFactShippedOrders = Source{[Schema=\"SalesCube\",Item=\"vwFactShippedOrders\"]}[Data],\r", + " #\"Filtered Rows\" = Table.SelectRows(SalesCube_vwFactShippedOrders, each [ShipDateID] >= StartDate and [ShipDateID] <= EndDate)\r", + "in\r", + " #\"Filtered Rows\"" + ] + }, + { + "name": "StartDate", + "kind": "m", + "expression": [ + "let\r", + " Source = 20080101 meta [IsParameterQuery=true, Type=\"Number\", IsParameterQueryRequired=true]\r", + "in\r", + " Source" + ] + }, + { + "name": "EndDate", + "kind": "m", + "expression": [ + "let\r", + " Source = 20081231 meta [IsParameterQuery=true, Type=\"Number\", IsParameterQueryRequired=true]\r", + "in\r", + " Source" + ] + }, + { + "name": "GetFactData", + "kind": "m", + "expression": [ + "let\r", + " Source = (StartDate as number, EndDate as number) => let\r", + " Source = #\"SQL/PRD-DATAWH01VM;PDW_Reporting\",\r", + " SalesCube_vwFactShippedOrders = Source{[Schema=\"SalesCube\",Item=\"vwFactShippedOrders\"]}[Data],\r", + " #\"Filtered Rows\" = Table.SelectRows(SalesCube_vwFactShippedOrders, each [ShipDateID] >= StartDate and [ShipDateID] <= EndDate)\r", + " in\r", + " #\"Filtered Rows\"\r", + "in\r", + " Source" + ] + } + ], + "annotations": [ + { + "name": "ClientCompatibilityLevel", + "value": "600" + } + ] + }, + "id": "SemanticModel" +} \ No newline at end of file