{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Reports_AS","ReportsInPBIService_staging","Result","Measures_Delete","Columns_Hide","DMV_Measures","DMV_Columns","DMV_CalculationGroupItems","DMV_Hierarchies"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":25,"comments":2,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,"Power BI Cleaner Gen2 V2",null,null,null,null,"PBI_Desktop_pbix"]
[null,null,null,null,null,null,"Analysis_Server"]
["Choose modus:",null,null,null,null,null,"PBI_Live_Connection"]
[]
[null,null,null,null,null,null,3]
["1)","Connect to Power BI Desktop"]
[]
["Portnumber:"]
[]
[]
[]
[]
["2)","Live connection to Analysis Services"]
[]
["Server:"]
["Database:"]
[null,null,null,"Datasets - Get Datasets (Power BI Power BI REST APIs) | Microsoft Docs"]
[null,"Token Details"]
[]
[]
[]
[]
["3)","Live connection to Power BI dataset"]
[]
["Portnumber:"]
["DatasetID:"]
["Modus:"]
[null,null,null,"Datasets - Get Datasets (Power BI Power BI REST APIs) | Microsoft Docs"]
[null,"Token Details"]
[]
[]
[]
[]
["optional:","pbix/pbit files that are connected to the dataset/model",null,null,"For detailled instructions, visit this page: "]
[null,null,null,null,"https://wp.me/p6lgsG-2qy"]
[null,"Report File(s)"]

{"sheet":"Reports_AS","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Column1"]
[""]

{"sheet":"ReportsInPBIService_staging","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Column1"]
[""]

{"sheet":"Result","index":3,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"IsAutoDateTable","All"]
[]
[null,"Row Labels","Can be deleted/hidden","Column size","Not used at all","Not used at the end","Used in report_"]
[null,"Customer","keep",323291,null,null,"Visuals, Relationships, Filter - VisualLevel, Filter - ReportLevel, Filter - PageLevel"]
[null,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8","delete",35068,null,"DAX Expressions"]
[null,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a","keep",88776,null,null,"Relationships"]
[null,"New Calculation Group","keep",17152,null,null,"Filter - VisualLevel"]
[null,"Sales","keep",150748,null,"DAX Expressions","Roles, GroupingMetadata, Visuals, Relationships, IncrementalRefresh, CalculationGroups, Filter - VisualLevel, Titles, ConditionalFormatting, DAX Expressions"]
[null,"TestFilterTable","keep",17152,null,null,"Filter - VisualLevel"]
[null,"Grand Total","keep",735275,null,"DAX Expressions","Roles, GroupingMetadata, Visuals, Relationships, IncrementalRefresh, CalculationGroups, Filter - VisualLevel, Filter - ReportLevel, Filter - PageLevel, Titles, ConditionalFormatting, DAX Expressions"]

{"sheet":"Measures_Delete","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"1) Check measures in this list and if you want to keep some",null,null,"2) Press button below",null,"3) Open Tabular Editor and use the code in there:"]
[null,"of these measures, delete the entry in column \"Action\""]
[]
["TableName","MeasureName","Action",null,null,null,"Code to be used in Tabular Editor"]
["Sales","UnusedSalesMeasure","Delete",null,null,null,"Model.Tables[\"Sales\"].Measures[\"UnusedSalesMeasure\"].Delete(); Model.Tables[\"Sales\"].Measures[\"UnusedMeasureReferencingAnotherUnusedMeasure\"].Delete();"]
["Sales","UnusedMeasureReferencingAnotherUnusedMeasure","Delete"]
[]
[]
[null,null,null,null,null,null,"Click to get Tabular Editor Pro Version"]
[null,null,null,null,null,null,"Click to get Tabular Editor Free Version"]
[]
[null,null,null,null,null,null,"In Tabular Editor follow these steps:"]

{"sheet":"Columns_Hide","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"1) Check columns  in this list and if you want to keep some",null,null,"2) Press button below",null,"3) Open Tabular Editor and use the code in there:"]
[null,"of these columns, delete the entry in column \"Action\"",null,null,null,null,"For instructions, see sheet \"Measures_Delete\""]
[]
["TableName","ColumnName","Action",null,null,null,"Column1"]
["Sales","DeliveryDateKey","Hide",null,null,null,"Model.Tables[\"Sales\"].Columns[\"DeliveryDateKey\"].IsHidden=true; Model.Tables[\"Sales\"].Columns[\"ProductKey (bins)\"].IsHidden=true; Model.Tables[\"Customer\"].Columns[\"Company Name\"].IsHidden=true; Model.Tables[\"Customer\"].Columns[\"Profit\"].IsHidden=true; Model.Tables[\"Customer\"].Columns[\"RankOnProfit\"].IsHidden=true;"]
["Sales","ProductKey (bins)","Hide"]
["Customer","Company Name","Hide"]
["Customer","Profit","Hide"]
["Customer","RankOnProfit","Hide"]

{"sheet":"DMV_Measures","index":6,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["ID","TableID","ItemName","Description","DataType","Expression","FormatString","IsHidden","State","ModifiedTime","StructureModifiedTime","KPIID","IsSimpleMeasure","ErrorMessage","DisplayFolder","DetailRowsDefinitionID","DataCategory","LineageTag","SourceLineageTag","TableName","Source"]
[1592,12,"SalesMeasure",null,20,"SUMx(Sales, Sales[Quantity] * Sales[Net Price])",null,false,1,"2021-04-24T20:10:01.400","2019-11-25T09:30:00.220",null,false,null,null,null,null,"dc59686e-47a0-4e61-b573-2542f353de7d",null,"Sales","Measures"]
[3758,12,"(New) Used.SalesMeasure (\"Test?!\")",null,20,"[SalesMeasure] + MAX(Sales[Unit Cost])",null,false,1,"2021-05-01T08:12:37.296","2019-11-29T13:52:06.646",null,false,null,null,null,null,"f4d6c87a-6926-44b4-8aab-5babfa7d92fb",null,"Sales","Measures"]
[3761,12,"UnusedMeasureReferencingAnotherUnusedMeasure",null,20,"[UnusedSalesMeasure]",null,false,1,"2021-08-23T14:46:21.676","2019-11-29T13:52:44.603",null,false,null,null,null,null,"bae7b98e-c739-4466-86d5-c13b49598fee",null,"Sales","Measures"]
[3764,12,"AnotherUsedSalesMeasure",null,20,"[(New) Used.SalesMeasure (\"Test?!\")] * 2",null,false,1,"2021-05-01T08:12:37.340","2019-12-31T11:07:15.830",null,false,null,null,null,null,"b4e67898-b986-4d4d-9e1c-ea0fa3bde4f6",null,"Sales","Measures"]
[5276,12,"myMeasure",null,20,"10",null,false,1,"2021-04-29T05:40:15.783","2021-04-29T05:39:54.073",null,false,null,null,null,null,"a9400ae4-13f8-465c-9bba-714ddfaee712",null,"Sales","Measures"]
[6176,12,"UsedInTitleMeasure",null,20,"\"My Measure Title\"",null,false,1,"2021-05-01T09:23:23.030","2021-05-01T09:22:37.490",null,false,null,null,null,null,"6a10c77d-60bf-477e-8514-c4e0f5df6b49",null,"Sales","Measures"]
[6179,12,"conditionalFormatMeasure",null,20,"SUMx(Sales, Sales[Quantity] * Sales[Net Price])",null,false,1,"2021-05-01T12:56:54.026","2021-05-01T12:56:28.766",null,false,null,null,null,null,"57889cea-21f9-419e-a602-9ac50a367a5d",null,"Sales","Measures"]
[6183,12,"PBIT_Measure",null,20,"SUMx(Sales, Sales[Quantity] * Sales[Net Price])",null,false,1,"2021-05-02T08:41:49.196","2021-05-02T08:41:31.713",null,false,null,null,null,null,"3593d57e-bcbf-4cdf-b140-1c7e52f54d79",null,"Sales","Measures"]
[6186,12,"FormatstringMeasure",null,20,"\"0\"",null,false,1,"2021-05-02T15:24:14.930","2021-05-02T15:24:01.580",null,false,null,null,null,null,"8060081e-7dd2-41b1-bbd9-f7f16264b5cd",null,"Sales","Measures"]
[7110,12,"Smarties (don't eat)",null,20,"SUMx(Sales, Sales[Quantity] * Sales[Net Price]) / 2",null,false,1,"2021-07-11T09:28:39.196","2021-07-10T21:25:39.753",null,false,null,null,null,null,"b555f332-90e0-41d1-9749-56ff63488aed",null,"Sales","Measures"]
[7226,12,"SecDataLabelMeasure",null,20,"max(Sales[Net Price])",null,false,1,"2021-08-22T05:47:36.743","2021-08-21T09:52:52.500",null,false,null,null,null,null,"0bb313b2-8637-45b4-ae6c-1e9aad7d6d64",null,"Sales","Measures"]
[7229,12,"SecTotalLabelMeasure",null,20,"200",null,false,1,"2021-08-22T05:47:19.316","2021-08-22T05:47:03.260",null,false,null,null,null,null,"38f7665c-7df6-4694-ba86-a3ab3943828e",null,"Sales","Measures"]
[7232,12,"SecLegendMeasure",null,20,"0100",null,false,1,"2021-08-22T05:53:30.520","2021-08-22T05:53:15.846",null,false,null,null,null,null,"40c75585-9d75-4a19-b52c-ac19a5f0c926",null,"Sales","Measures"]
[7235,12,"SecDataColorMeasure2",null,20,"50",null,false,1,"2021-08-22T05:55:11.770","2021-08-22T05:54:47.130",null,false,null,null,null,null,"47b6ffed-4b5e-44fe-8a4f-1f246e0e661e",null,"Sales","Measures"]
[7238,12,"SecDataCategoryMeasure",null,20,"300",null,false,1,"2021-08-22T05:56:07.906","2021-08-22T05:55:52.436",null,false,null,null,null,null,"cbf0bfc8-a650-4dc2-9a74-b349dc651bb9",null,"Sales","Measures"]
[7241,12,"SecBackgroundColor",null,20,"\"#EE1111\"",null,false,1,"2021-08-22T05:57:54.600","2021-08-22T05:57:35.520",null,false,null,null,null,null,"ea4e7cb8-010c-45c6-85a0-7e8f8628af39",null,"Sales","Measures"]
[7244,12,"SecShadow",null,20,"\"EE1200\"",null,false,1,"2021-08-22T05:59:36.773","2021-08-22T05:59:06.636",null,false,null,null,null,null,"9d6dcc73-94df-42c2-8779-a501270336df",null,"Sales","Measures"]
[7247,12,"SecCondFormateDecompTree",null,20,"20",null,false,1,"2021-08-22T06:06:41.220","2021-08-22T06:06:19.646",null,false,null,null,null,null,"12e54f31-e5a9-4551-a6c9-593dda8fcc39",null,"Sales","Measures"]
[7250,12,"UnusedSalesMeasure",null,20,"[SalesMeasure] * 10",null,false,1,"2021-08-23T14:46:21.613","2021-08-23T13:19:57.303",null,false,null,null,null,null,"b9a0271a-27d2-4033-bace-421cae05f93e",null,"Sales","Measures"]

{"sheet":"DMV_Columns","index":7,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["ID","TableID","ItemName","IsHidden","ColumnStorageID","Expression","SortByColumnID","AttributeHierarchyID","TableName","TableStorageID","CalculationGroupID","RefreshPolicyID","Source","Key"]
[113,12,"StoreKey",false,164,null,null,153,"Sales",57,null,7175,"Columns","Sales.StoreKey"]
[114,12,"ProductKey",false,168,null,null,154,"Sales",57,null,7175,"Columns","Sales.ProductKey"]
[115,12,"CustomerKey",false,172,null,null,155,"Sales",57,null,7175,"Columns","Sales.CustomerKey"]
[116,12,"OrderDateKey",false,176,null,null,156,"Sales",57,null,7175,"Columns","Sales.OrderDateKey"]
[117,12,"DueDateKey",false,180,null,null,157,"Sales",57,null,7175,"Columns","Sales.DueDateKey"]
[118,12,"DeliveryDateKey",false,184,null,null,158,"Sales",57,null,7175,"Columns","Sales.DeliveryDateKey"]
[119,12,"Quantity",false,188,null,null,159,"Sales",57,null,7175,"Columns","Sales.Quantity"]
[120,12,"Unit Price",false,192,null,null,160,"Sales",57,null,7175,"Columns","Sales.Unit Price"]
[121,12,"Unit Discount",false,196,null,null,161,"Sales",57,null,7175,"Columns","Sales.Unit Discount"]
[122,12,"Unit Cost",false,200,null,null,162,"Sales",57,null,7175,"Columns","Sales.Unit Cost"]
[123,12,"Net Price",false,204,null,null,163,"Sales",57,null,7175,"Columns","Sales.Net Price"]
[1537,12,"Sales",false,1539,"'Sales'[Quantity] * Sales[Net Price]",null,1538,"Sales",57,null,7175,"Columns","Sales.Sales"]
[3717,12,"ProductKey (bins)",false,3721,"IF(\n  ISBLANK('Sales'[ProductKey]),\n  BLANK(),\n  INT('Sales'[ProductKey] / 69) * 69\n)",null,3720,"Sales",57,null,7175,"Columns","Sales.ProductKey (bins)"]
[19,15,"Date",true,75,null,null,50,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8",59,null,null,"Columns","DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8.Date"]
[20,15,"Year",true,79,"YEAR([Date])",null,51,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8",59,null,null,"Columns","DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8.Year"]
[21,15,"MonthNo",true,83,"MONTH([Date])",null,52,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8",59,null,null,"Columns","DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8.MonthNo"]
[22,15,"Month",true,87,"FORMAT([Date], \"MMMM\")",21,53,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8",59,null,null,"Columns","DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8.Month"]
[23,15,"QuarterNo",true,91,"INT(([MonthNo] + 2) / 3)",null,54,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8",59,null,null,"Columns","DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8.QuarterNo"]
[24,15,"Quarter",true,95,"\"Qtr \" & [QuarterNo]",23,55,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8",59,null,null,"Columns","DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8.Quarter"]
[25,15,"Day",true,99,"DAY([Date])",null,56,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8",59,null,null,"Columns","DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8.Day"]
[223,219,"CustomerKey",false,367,null,null,334,"Customer",358,null,null,"Columns","Customer.CustomerKey"]
[224,219,"GeographyKey",false,371,null,null,335,"Customer",358,null,null,"Columns","Customer.GeographyKey"]
[225,219,"Customer Code",false,375,null,null,336,"Customer",358,null,null,"Columns","Customer.Customer Code"]
[226,219,"Title",false,379,null,null,337,"Customer",358,null,null,"Columns","Customer.Title"]
[227,219,"Name",false,383,null,null,338,"Customer",358,null,null,"Columns","Customer.Name"]
[228,219,"Birth Date",false,387,null,null,339,"Customer",358,null,null,"Columns","Customer.Birth Date"]
[229,219,"Marital Status",false,391,null,null,340,"Customer",358,null,null,"Columns","Customer.Marital Status"]
[230,219,"Gender",false,395,null,null,341,"Customer",358,null,null,"Columns","Customer.Gender"]
[231,219,"Yearly Income",false,399,null,null,342,"Customer",358,null,null,"Columns","Customer.Yearly Income"]
[232,219,"Total Children",false,403,null,null,343,"Customer",358,null,null,"Columns","Customer.Total Children"]
[233,219,"Children At Home",false,407,null,null,344,"Customer",358,null,null,"Columns","Customer.Children At Home"]
[235,219,"Occupation",false,415,null,null,346,"Customer",358,null,null,"Columns","Customer.Occupation"]
[236,219,"House Ownership",false,419,null,null,347,"Customer",358,null,null,"Columns","Customer.House Ownership"]
[237,219,"Cars Owned",false,423,null,null,348,"Customer",358,null,null,"Columns","Customer.Cars Owned"]
[238,219,"Continent",false,427,null,null,349,"Customer",358,null,null,"Columns","Customer.Continent"]
[239,219,"City",false,431,null,null,350,"Customer",358,null,null,"Columns","Customer.City"]
[240,219,"State",false,435,null,null,351,"Customer",358,null,null,"Columns","Customer.State"]
[241,219,"Country",false,439,null,null,352,"Customer",358,null,null,"Columns","Customer.Country"]
[242,219,"Date First Purchase",false,443,null,null,353,"Customer",358,null,null,"Columns","Customer.Date First Purchase"]
[243,219,"Customer Type",false,447,null,null,354,"Customer",358,null,null,"Columns","Customer.Customer Type"]
[244,219,"Company Name",false,451,null,null,355,"Customer",358,null,null,"Columns","Customer.Company Name"]
[245,219,"Profit",false,455,null,null,356,"Customer",358,null,null,"Columns","Customer.Profit"]
[246,219,"RankOnProfit",false,459,null,null,357,"Customer",358,null,null,"Columns","Customer.RankOnProfit"]
[4783,219,"Education",false,4788,null,null,4787,"Customer",358,null,null,"Columns","Customer.Education"]
[7113,219,"MyManualColumnIsNowRenamed",false,7115,"10",null,7114,"Customer",358,null,null,"Columns","Customer.MyManualColumnIsNowRenamed"]
[2339,2335,"Date",true,2391,null,null,2375,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a",2382,null,null,"Columns","LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a.Date"]
[2340,2335,"Year",true,2395,"YEAR([Date])",null,2376,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a",2382,null,null,"Columns","LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a.Year"]
[2341,2335,"MonthNo",true,2399,"MONTH([Date])",null,2377,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a",2382,null,null,"Columns","LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a.MonthNo"]
[2342,2335,"Month",true,2403,"FORMAT([Date], \"MMMM\")",2341,2378,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a",2382,null,null,"Columns","LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a.Month"]
[2343,2335,"QuarterNo",true,2407,"INT(([MonthNo] + 2) / 3)",null,2379,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a",2382,null,null,"Columns","LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a.QuarterNo"]
[2344,2335,"Quarter",true,2411,"\"Qtr \" & [QuarterNo]",2343,2380,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a",2382,null,null,"Columns","LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a.Quarter"]
[2345,2335,"Day",true,2415,"DAY([Date])",null,2381,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a",2382,null,null,"Columns","LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a.Day"]
[4704,4701,"Name",false,4721,null,4705,4710,"New Calculation Group",4712,4707,null,"Columns","New Calculation Group.Name"]
[7173,7170,"Column1",false,7193,null,null,7183,"TestFilterTable",7184,null,null,"Columns","TestFilterTable.Column1"]

{"sheet":"DMV_CalculationGroupItems","index":8,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["ID","CalculationGroupID","FormatStringDefinitionID","Name","Description","ModifiedTime","State","ErrorMessage","Expression","Ordinal"]
[4708,4707,null,"New Calculation","CalculationGroupItem1","2021-05-12T05:49:43.716",1,null,"[FormatstringMeasure] * 10\n",-1]

{"sheet":"DMV_Hierarchies","index":9,"n_rows":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["ID","TableID","ItemName","ColumnID","TableName","Source",null,null,"ID","HierarchyID","Ordinal","Name","Description","ColumnID","ModifiedTime","LineageTag","SourceLineageTag"]
[28,15,"Date Hierarchy.Year",20,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8","Hierarchies",null,null,29,28,0,"Year",null,20,"2021-04-24T20:10:01.400","44b0cf1b-2559-4d75-b602-f402a974e49e"]
[28,15,"Date Hierarchy.Quarter",24,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8","Hierarchies",null,null,30,28,1,"Quarter",null,24,"2021-04-24T20:10:01.400","a26fa0b1-f8b0-44be-869a-ef8a5efd167d"]
[28,15,"Date Hierarchy.Month",22,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8","Hierarchies",null,null,31,28,2,"Month",null,22,"2021-04-24T20:10:01.400","1d096888-d037-44e6-833d-2c1d2b50d11d"]
[28,15,"Date Hierarchy.Day",25,"DateTableTemplate_3548d6ea-df56-4751-84f7-6cf59cd2d1c8","Hierarchies",null,null,32,28,3,"Day",null,25,"2021-04-24T20:10:01.400","bf8af19c-f4b0-4324-be4e-b653b91d9dd4"]
[2347,2335,"Date Hierarchy.Year",2340,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a","Hierarchies",null,null,2349,2347,0,"Year",null,2340,"2021-04-24T20:10:01.400","bacedf4d-4e01-4cc1-86d1-c6b90068f698"]
[2347,2335,"Date Hierarchy.Quarter",2344,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a","Hierarchies",null,null,2350,2347,1,"Quarter",null,2344,"2021-04-24T20:10:01.400","61dbab6d-3829-4f50-af97-5b24d93fa2c8"]
[2347,2335,"Date Hierarchy.Month",2342,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a","Hierarchies",null,null,2351,2347,2,"Month",null,2342,"2021-04-24T20:10:01.400","a9d5de83-d6bd-44f9-a763-d65efd716a51"]
[2347,2335,"Date Hierarchy.Day",2345,"LocalDateTable_6f0dc109-d05e-44c0-90b3-4976c0be9c3a","Hierarchies",null,null,2352,2347,3,"Day",null,2345,"2021-04-24T20:10:01.400","9126b46b-b969-4b27-8021-b81935975d3e"]