{ "_id": "68e459d2383aeadfc675cfe7", "oid": "81bd6709-5563-4c9a-80d6-de1ff457dd0c", "title": "Sample ECommerce - Custom Fiscal Year", "type": "extract", "relationType": "regular", "server": "LocalHost", "buildDestination": { "destination": "elasticube", "database": null, "schema": null }, "modelStatistics": { "enableModelStatistics": true, "allTablesPerCollection": true, "maxTablesPerCollection": 10 }, "fiscal": "system", "relations": [ { "oid": "47175811-0f86-4729-bb01-b2035b63a4dd", "type": null, "columns": [ { "dataset": "ec9f7a4c-c51c-4f26-9011-89439f263477", "table": "f6924374-5007-4e76-88bf-0b696296f096", "column": "316db54a-d575-4cd3-99d1-357107081b2b", "isDropped": null }, { "dataset": "c771a269-10cd-437c-bf28-f81dd8d2aef0", "table": "acc1d8b8-e1ca-421f-98c6-467aa27c79d9", "column": "21b42ec4-0cc8-46a1-ad88-abb7a4154ea5", "isDropped": null } ] }, { "oid": "9214b5fe-1290-4baa-843d-bde0c2d3e8c7", "type": null, "columns": [ { "dataset": "ec9f7a4c-c51c-4f26-9011-89439f263477", "table": "f6924374-5007-4e76-88bf-0b696296f096", "column": "6623fd0c-5153-485c-94c3-6e356a8971b6", "isDropped": null }, { "dataset": "20da862b-f3e1-4a70-83a0-8ccf108d86d3", "table": "018be447-4774-449c-a595-9b46781ee371", "column": "00aba5b5-8115-4502-8384-11a638d2a121", "isDropped": null } ] }, { "oid": "184ec2e5-6c4a-49ce-ae29-6bb0f3260e1e", "type": null, "columns": [ { "dataset": "ec9f7a4c-c51c-4f26-9011-89439f263477", "table": "f6924374-5007-4e76-88bf-0b696296f096", "column": "633bc015-b149-4ae3-9f38-2524f5366eeb", "isDropped": null }, { "dataset": "2ef3fec3-62b0-4c0b-8ec1-16c86767917a", "table": "93fe8e39-4807-4f50-9faa-88b6540be785", "column": "b4b5ad7a-db68-4ccf-95d4-8c4b86438f8b", "isDropped": null } ] }, { "oid": "ec30826e-715c-45a9-ad1a-79862aa2bb6a", "type": null, "columns": [ { "dataset": "ec9f7a4c-c51c-4f26-9011-89439f263477", "table": "f6924374-5007-4e76-88bf-0b696296f096", "column": "7f71c004-48e6-4748-8db3-0be09ff31786", "isDropped": null }, { "dataset": "0c497eea-c19f-4c87-a106-b51fb387bee7", "table": "e4fc2faa-f622-4b30-817c-c9a5ca2f8b69", "column": "b16d5d6b-5a29-410b-821b-ae4a0658aa09", "isDropped": null } ] } ], "datasets": [ { "oid": "c771a269-10cd-437c-bf28-f81dd8d2aef0", "fullname": "CSV:ff27d87d-d6df-4793-aafa-7bdcfe6dcca2", "database": "null", "type": "extract", "name": "ff27d87d-d6df-4793-aafa-7bdcfe6dcca2", "schemaName": "null", "connection": { "oid": "3f5dc349-8293-4ec7-9c81-91092ffd4d36", "name": "Sample ECommerce - EC Group 2 2", "description": "", "id": null, "provider": "CSV", "parameters": "eyJlbmNyeXB0ZWREYXRhIjp7ImNpcGhlcnRleHQiOiJEUmZQU2Q2VjM5TlRnSU1KNmI1ZUtRVVZXZWxtRmZMdjk1aHRRdlVrTmFEMkV0L3JNUFZ5VCtyU2dxNC9EV21rMEF1azdFWnZDU1ljbzlVQ21VMFdQYjYyN0RhcVBYMGFlKzY4TVR1Z2lEd1gwREZQWkljZG5wTW1nbkxQeUVOcHRoTlFxQWdXU1ZrbDhha1BqSHRIMHloUkdPaFFoSGd4bTBKUTRRbkdkRElabnlmYTVUcVRXWWZabW02VnBlWWhWaFhsd21IWWtSNkw1ekNvcituMWRmckc4a3FlSmx3dEVLY2dqRmZQM0JSM3ZFWXhvditRWGMyZ2htamVOVFdRQytoR0x3Z2VqYkI5V0lYS2pOS0h4OFRIN2VCS25QY2UyMUliTC9vdjUxZFpld2lTU3R3S1BYKzgrdDc3VFhDb2lwVExXS3lNeS9odGNIbjBkQkFCSUFOcGNaL3pUMGIxUkZ5NGtackdNU2R0azkvbVZ4c3p4N3hBVjF0Vm5Jc3N0bUlHVmk5SWR6R1M0NEE2bU9WQzIvWUFoQXpjNUdvdjZjcEdCYk8xbTZkRW40RktMZjRSNm5EdGp0bS9PV3FWMUw1MVgvcm8wS3d0ODRWRGlya2JYOU5yZ2RtZjdQa0pHM0ZnczFoalVWM2ZoaDA2QkZDMjRUOEJ3eXpkZlJycmhYaWtzY1ZFb2tvc2h6c1FBZXNQRFE9PSIsIm5vbmNlIjoiR1JOUktyZGN6M2NaN0pONTV1TDNrZz09In0sImVuY3J5cHRpb25NZXRhZGF0YSI6eyJwcm92aWRlciI6IkxPQ0FMIiwia2V5SWQiOiIxMjMiLCJlbmNyeXB0aW9uVGltZSI6IjIwMjUtMTAtMDdUMDA6MTg6MTAuMzIxODEyNTc4WiJ9fQ==", "schema": "null", "fileName": null, "globalTableConfigOptions": null, "supportedModelTypes": [ "EXTRACT" ] }, "modelingTransformations": [], "schema": { "tables": [ { "oid": "acc1d8b8-e1ca-421f-98c6-467aa27c79d9", "id": "Country.csv", "name": "Country", "type": "base", "schemaName": null, "displayName": null, "columns": [ { "oid": "77c56a40-59be-45c0-973c-56535e8b5568", "id": "Country", "name": "Country", "type": 18, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "21b42ec4-0cc8-46a1-ad88-abb7a4154ea5", "id": "Country ID", "name": "Country ID", "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [], "hidden": false, "vTag": "acc1d8b8-e1ca-421f-98c6-467aa27c79d9", "configOptions": { "Table": "Country.csv" }, "isMaterialized": false } ] }, "liveQuerySettings": null }, { "oid": "20da862b-f3e1-4a70-83a0-8ccf108d86d3", "fullname": "CSV:1614cad6-571b-4fde-959e-bc73ea0e427b", "database": "null", "type": "extract", "name": "1614cad6-571b-4fde-959e-bc73ea0e427b", "schemaName": "null", "connection": { "oid": "865daa4c-2e1a-416d-a888-8966a60b5c1c", "name": "Sample ECommerce - EC Group 2 1", "description": "", "id": null, "provider": "CSV", "parameters": "eyJlbmNyeXB0ZWREYXRhIjp7ImNpcGhlcnRleHQiOiJwbjBjWDB1NFZCd3gvR25ndWRpSFBaQ2tvdmpRQlV1SWFjQ2FsRyt0ZDFxNWJHTksrdzBETnVxbGtjcG04YWM5Vjh1ZnZ0azJlVlRvTnZMTFNlRU1aT1Vhd1VWNEFyaVo3Q2ZUK2x5T3ArOW1xZlpQRXYwV2laTWdaZEtEa1c5emlrL0cxbFBkcTlxSUh1SndhZGFDZmIrQ3p4M3NmVjJzejIxRFRCQm0wWkRjQ3NTMWp3OE5xdmFuZkRiOGRxOWI0N3UyVldZTDlUUWJOdFk4REpoSVkza3k4L1V3YjhZZWJnSnVkQUN4dkd4UVMrcG5qaWFsYTBnbWkzNGRMVFNXTWZoTnlpVithNlMxbE5pMnU5TGNzSzhrR09Xa25ialhOY0FIUGYyeFlsVVd0Z1ExREVNMFRvMXZqamtJejBRZUVBOHZ4VGJkMjRkZGxoVDh4SGJWNmxnRnl0VUp2enNWY2hWTExoNjVMbEw4cXRPRWx0bGlXWVB4dk8rTWtLd2pacGowTzVPcHBaMkl3Sk5EUjlST3lRQnlQTGQzSlBVVXJJaGx4Vng4SmxuSSs0Q1MxTWpuS3YwVUIzWHJQV05jcmJaQW8zYVlvMjlTWU1PUGg0NktmenplZzRoaEJxdHNIMnhUU3FPQWFDZUZGNnZwOTJrSVpoOVVhWXQwVUdad3ROdEpoMnU3WmN3T0JGWlBsT0N4QWc9PSIsIm5vbmNlIjoiVjdHd0RZa2RWRlpXSEp4Qmt5MzRmQT09In0sImVuY3J5cHRpb25NZXRhZGF0YSI6eyJwcm92aWRlciI6IkxPQ0FMIiwia2V5SWQiOiIxMjMiLCJlbmNyeXB0aW9uVGltZSI6IjIwMjUtMTAtMDdUMDA6MTg6MTAuMzIxODEyNjU4WiJ9fQ==", "schema": "null", "fileName": null, "globalTableConfigOptions": null, "supportedModelTypes": [ "EXTRACT" ] }, "modelingTransformations": [], "schema": { "tables": [ { "oid": "018be447-4774-449c-a595-9b46781ee371", "id": "Category.csv", "name": "Category", "type": "base", "schemaName": null, "displayName": null, "columns": [ { "oid": "c1f4d8d7-f91d-492b-ab49-3d6db1205f15", "id": "Category", "name": "Category", "type": 18, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "00aba5b5-8115-4502-8384-11a638d2a121", "id": "Category ID", "name": "Category ID", "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [], "hidden": false, "vTag": "018be447-4774-449c-a595-9b46781ee371", "configOptions": { "Table": "Category.csv" }, "isMaterialized": false } ] }, "liveQuerySettings": null }, { "oid": "0c497eea-c19f-4c87-a106-b51fb387bee7", "fullname": "97248206-49c6-440d-969d-81fbaecb1404", "database": "", "type": "custom", "name": "97248206-49c6-440d-969d-81fbaecb1404", "schemaName": "", "connection": { "oid": "8bf92793-0b9a-41be-9dd3-1d5e0f05f5e1", "name": null, "description": null, "id": null, "provider": "", "parameters": {}, "schema": null, "fileName": null, "globalTableConfigOptions": null, "supportedModelTypes": null }, "modelingTransformations": [], "schema": { "tables": [ { "oid": "e4fc2faa-f622-4b30-817c-c9a5ca2f8b69", "id": "New Custom Table (1)", "name": "Date", "type": "custom", "schemaName": null, "displayName": null, "expression": { "oid": "31468b97-bd0c-4422-bbc7-b8bd60652e64", "expression": "SELECT DISTINCT\n c.[Date],\n CASE \n WHEN c.[Date] >= start_next THEN GetYear(c.[Date]) + 1\n WHEN c.[Date] >= start_cur THEN GetYear(c.[Date])\n ELSE GetYear(c.[Date]) - 1\n END AS [Fiscal Year],\n CASE \n WHEN c.[Date] >= start_next THEN GetYear(c.[Date]) + 1\n WHEN c.[Date] >= start_cur THEN GetYear(c.[Date])\n ELSE GetYear(c.[Date]) - 1\n END AS [Fiscal Year to Compare],\n FLOOR(1 + DayDiff(c.[Date],\n CASE \n WHEN c.[Date] >= start_next THEN start_next\n WHEN c.[Date] >= start_cur THEN start_cur\n ELSE start_prev\n END\n ) / 7.0) AS [Fiscal Week Number]\nFROM (\n SELECT [Date],\n -- precompute fiscal year starts once\n CASE WHEN DayOfWeek(CreateDate(GetYear([Date]) - 1, 1, 1)) <= 3\n THEN AddDays(CreateDate(GetYear([Date]) - 1, 1, 1), -1 * DayOfWeek(CreateDate(GetYear([Date]) - 1, 1, 1)))\n ELSE AddDays(CreateDate(GetYear([Date]) - 1, 1, 1), 7 - DayOfWeek(CreateDate(GetYear([Date]) - 1, 1, 1)))\n END AS start_prev,\n CASE WHEN DayOfWeek(CreateDate(GetYear([Date]), 1, 1)) <= 3\n THEN AddDays(CreateDate(GetYear([Date]), 1, 1), -1 * DayOfWeek(CreateDate(GetYear([Date]), 1, 1)))\n ELSE AddDays(CreateDate(GetYear([Date]), 1, 1), 7 - DayOfWeek(CreateDate(GetYear([Date]), 1, 1)))\n END AS start_cur,\n CASE WHEN DayOfWeek(CreateDate(GetYear([Date]) + 1, 1, 1)) <= 3\n THEN AddDays(CreateDate(GetYear([Date]) + 1, 1, 1), -1 * DayOfWeek(CreateDate(GetYear([Date]) + 1, 1, 1)))\n ELSE AddDays(CreateDate(GetYear([Date]) + 1, 1, 1), 7 - DayOfWeek(CreateDate(GetYear([Date]) + 1, 1, 1)))\n END AS start_next\n FROM [Commerce]\n) c\nORDER BY c.[Date]", "isDatabaseDialect": false }, "columns": [ { "oid": "b16d5d6b-5a29-410b-821b-ae4a0658aa09", "id": "e164b0f2-4a3f-4545-ae86-b6c18c8f135b", "name": "Date", "type": 19, "size": 0, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "88d815ea-a527-4339-8b73-e96f0ac796ba", "id": "6be14db2-3849-4ec7-bd1e-ae32ae8255c5", "name": "Fiscal Year", "type": 8, "size": 0, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "145a2384-ae9d-45b8-8834-89aa4d506f0d", "id": "3a2de9d1-3824-480e-a70c-375e535bba1a", "name": "Fiscal Year to Compare", "type": 8, "size": 0, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "dc86aaa9-98e5-4772-b4b2-06eeb6d6f636", "id": "a3857110-1808-463d-a64b-15b3f353b68b", "name": "Fiscal Week Number", "type": 8, "size": 0, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [], "hidden": false, "vTag": "e4fc2faa-f622-4b30-817c-c9a5ca2f8b69", "isMaterialized": null } ] }, "liveQuerySettings": null }, { "oid": "2ef3fec3-62b0-4c0b-8ec1-16c86767917a", "fullname": "CSV:1a0ccdfa-e94c-4932-96fd-03c37e197a98", "database": "null", "type": "extract", "name": "1a0ccdfa-e94c-4932-96fd-03c37e197a98", "schemaName": "null", "connection": { "oid": "debe3275-ee4f-49ea-b735-4928e456be9e", "name": "Sample ECommerce - EC Group 2 3", "description": "", "id": null, "provider": "CSV", "parameters": "eyJlbmNyeXB0ZWREYXRhIjp7ImNpcGhlcnRleHQiOiJUaUNvTXh6Sk0rVmVIM3FJc2plQ1dqczlzSkx4Nnk0TXVEUzVkUEtRTm8rVDlGbjZWVGVzZWNQanVmNGJBcnJqS2ovckxNVFlQVjZjRzNZaEYxNVNyTDNDcFBEb1ZmeU5UMzdVcFFBblZmQzlzUDdIVDJ5RU1ZcFYxenZuenZaRGFSanlTblJQbyt0dnJKSUtpMDRyNWpMaFhQZFFsUzlXUEg4bGs5Uk9UVk81QkVoNFZmQU92NmcxeEsxTXRqdlkzUmo0OWN5WitYVVQ1eTdZNWFGYWt1WUU3SUY2Y1pEYVN5UUtVNElkTkdmMlhjZTZnSFhDWWc3QVZ3RXJkbzZkNUdqSERvVHVKSGx0Y3BRaFgwRHR2bUI0ckdvakpGVEgvRXhINHMwd3laNkRlTlo0SFJVOVdFZjhYTDdsM2RnM1hUR2FYOGlmdWJabzgxY1ZJRDRPcVJFZ2Nwbmw5K295d3puSEVnU295bUE5YkozMUlHZHBEL0dTYUZIL3Z4SnRmZGQyVy9LRFRtbUdZL3JpbVV5dFZJWEZ4bkFUL1JzWEZFMTMwOEkrR3R3NTcvNUhnYzF1b3dVdmY5L1B4RnhhNVlFREIxWldpRExCYlhKSWkwSzNVL0JoSmVkZFA1MUdWZHZuNTVWU3pLNXdMaVFMbk4xcVlVT2k3MW1keDV2OVgyMFBZTi9JeThVVWFSTUpMYWw1bXc9PSIsIm5vbmNlIjoiOFlrajR0ZVhmV015c2ZlbFlLd2Nudz09In0sImVuY3J5cHRpb25NZXRhZGF0YSI6eyJwcm92aWRlciI6IkxPQ0FMIiwia2V5SWQiOiIxMjMiLCJlbmNyeXB0aW9uVGltZSI6IjIwMjUtMTAtMDdUMDA6MTg6MTAuMzIxODEyNTg4WiJ9fQ==", "schema": "null", "fileName": null, "globalTableConfigOptions": null, "supportedModelTypes": [ "EXTRACT" ] }, "modelingTransformations": [], "schema": { "tables": [ { "oid": "93fe8e39-4807-4f50-9faa-88b6540be785", "id": "Brand.csv", "name": "Brand", "type": "base", "schemaName": null, "displayName": null, "columns": [ { "oid": "f12dd884-a876-4210-a446-5c637e358d2d", "id": "Brand", "name": "Brand", "type": 18, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "b4b5ad7a-db68-4ccf-95d4-8c4b86438f8b", "id": "Brand ID", "name": "Brand ID", "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [], "hidden": false, "vTag": "93fe8e39-4807-4f50-9faa-88b6540be785", "configOptions": { "Table": "Brand.csv" }, "isMaterialized": false } ] }, "liveQuerySettings": null }, { "oid": "ec9f7a4c-c51c-4f26-9011-89439f263477", "fullname": "CSV:f5510e7d-d7bd-4fb8-b65f-b509d5dd0e42", "database": "null", "type": "extract", "name": "f5510e7d-d7bd-4fb8-b65f-b509d5dd0e42", "schemaName": "null", "connection": { "oid": "41a05547-b810-46d1-8864-7db9d821ce34", "name": "Sample ECommerce - EC Group 2 4", "description": "", "id": null, "provider": "CSV", "parameters": "eyJlbmNyeXB0ZWREYXRhIjp7ImNpcGhlcnRleHQiOiJXZWdxYWNldDdET0IwcmFlUThtSVY2cXdRTnBldUN6MjJkUExVTi9rYzFzVTM2QjNWdXoyNDExbWtwWXhTSFAyTFdaeDZsTU1hUWFmZWRyZUpzMXNRM2l0VkxocXB2WTJZOVJNcUVKbkxHbFNyZTB3Y1VVMWgvNnR6eXFMWGFMd2VybG5YM0h1d2NGalQzaVAwQ2JJUkl3QlJmVDFSczR0UzJFeXN6N0FhdmpzWkN6cCtVcVI4OU42YUZkeUl6dG13OE11OXdhSlRtZ3pwTE5OQnB1eE1Ra1JsQm5MT3FxUlBsbU9NeGlSd0tFU0pkTS9NN2RqZmlESmZWVTA0blNySkZmZUx4cVd0QzhTWkRwellhQi9FR3htVHlYc1pDZTk0RmlOZWlNR1FYbmRQNE02S2tIWHE4MUVRYXVtaUxQb1pCSWJSSnQyRGJPWlJoVEpWSkNCeEhLS1hkWjJkc3piaVNFYUZncnpwRXVIYWNoVm9SR2dWZkYwT3lJL3h1RFN0aFNOWGxYZEoyVzRDaExqQWJoVzd3b3M3c0x4TUVuQ1ltYTZXM2wzZ0w0dVpCV3MyVDhTZ2ZlSER1S1lSK05ZR1k1S0VYNmJqcm9hZjRzSU9YWCt3Rk1yU3VjUGlaeWtMc1lqSXBWNkhvSjhIaE4vWmo3bHZub3l6V05FbGRJL2hRT0hHMWpwQzJzNVkyRTkrOWh2TGc9PSIsIm5vbmNlIjoic095dFFKNmwyVzFXZTBJZzJobitWQT09In0sImVuY3J5cHRpb25NZXRhZGF0YSI6eyJwcm92aWRlciI6IkxPQ0FMIiwia2V5SWQiOiIxMjMiLCJlbmNyeXB0aW9uVGltZSI6IjIwMjUtMTAtMDdUMDA6MTg6MTAuMzIxODEyNTc4WiJ9fQ==", "schema": "null", "fileName": null, "globalTableConfigOptions": null, "supportedModelTypes": [ "EXTRACT" ] }, "modelingTransformations": [], "schema": { "tables": [ { "oid": "f6924374-5007-4e76-88bf-0b696296f096", "id": "Commerce.csv", "name": "Commerce", "type": "base", "schemaName": null, "displayName": null, "columns": [ { "oid": "ae3ff43e-ae34-4e72-9148-f5c1ef4f0d96", "id": "Age Range", "name": "Age Range", "type": 18, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "ad809d56-81f6-4f51-b792-1dec7de8270f", "id": "Cost", "name": "Cost", "type": 5, "size": 50, "precision": 16, "scale": 16, "hidden": false, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "633bc015-b149-4ae3-9f38-2524f5366eeb", "id": "Brand ID", "name": "Brand ID", "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "6623fd0c-5153-485c-94c3-6e356a8971b6", "id": "Category ID", "name": "Category ID", "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "00265c0b-86c2-40c5-aed8-34777d1a5456", "id": "Condition", "name": "Condition", "type": 18, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "316db54a-d575-4cd3-99d1-357107081b2b", "id": "Country ID", "name": "Country ID", "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "464844ca-0333-4bc2-82a7-0d3901ab39c6", "id": "Date", "name": "Date", "type": 4, "size": 8, "precision": 0, "scale": 0, "hidden": true, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "54e5cced-829a-48d4-a69b-2d11d8958bac", "id": "Gender", "name": "Gender", "type": 18, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": true, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "ce19e09a-2665-4e7c-954f-f31dcb1f609e", "id": "Quantity", "name": "Quantity", "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "9c448f6c-76cd-4ae0-a794-6d372344eb55", "id": "Revenue", "name": "Revenue", "type": 5, "size": 50, "precision": 16, "scale": 16, "hidden": false, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null }, { "oid": "542414b1-fca4-49c4-a76e-39ac726b93df", "id": "Visit ID", "name": "Visit ID", "type": 8, "size": 50, "precision": 0, "scale": 0, "hidden": false, "indexed": false, "semanticIndex": null, "isUpsertBy": false, "displayName": null, "description": null } ], "buildBehavior": { "type": "sync", "accumulativeConfig": null }, "tupleTransformations": [ { "arguments": { "column": "464844ca-0333-4bc2-82a7-0d3901ab39c6", "name": "Date_old", "displayName": "Date_old" }, "type": "rename-column" }, { "arguments": { "id": "Date", "name": "Date", "type": 19, "size": 0, "scale": 0, "precision": 0, "oid": "7f71c004-48e6-4748-8db3-0be09ff31786", "hidden": false, "indexed": true, "isUpsertBy": false, "lastUpdated": "2023-06-28T18:20:58.723Z", "expression": { "oid": "56b23b72-52a9-4cc0-8def-074ec27fce82", "expression": "-- Shift the original dates to more recent dates.\n\nadddays([Date_old], daydiff(#2025-09-30#, #2013-12-04#))", "isDatabaseDialect": false, "lastUpdated": "1970-01-01T00:00:00.000Z" }, "displayName": "Date" }, "type": "add-column" } ], "hidden": false, "vTag": "f6924374-5007-4e76-88bf-0b696296f096", "configOptions": { "Table": "Commerce.csv" }, "isMaterialized": false } ] }, "liveQuerySettings": null } ], "analyticalEngine": { "queryAeMode": null, "customTranslationMode": null, "generateDependenciesMode": null }, "modelsLayouts": { "nodesPositions": [ { "id": "93fe8e39-4807-4f50-9faa-88b6540be785", "x": 0.24121378362178802, "y": 0.2070961594581604, "fixed": true }, { "id": "018be447-4774-449c-a595-9b46781ee371", "x": 0.19485433399677277, "y": -0.6581398248672485, "fixed": true }, { "id": "f6924374-5007-4e76-88bf-0b696296f096", "x": -1.855803370475769, "y": -0.45626595616340637, "fixed": true }, { "id": "acc1d8b8-e1ca-421f-98c6-467aa27c79d9", "x": 0.20862378180027008, "y": -1.5078750848770142, "fixed": true }, { "id": "e4fc2faa-f622-4b30-817c-c9a5ca2f8b69", "x": 0.1902264803647995, "y": 1.2094342708587646, "fixed": true } ] }, "dependencies": { "perspectives": [ { "_id": "68e459d2383aeadfc675cfed", "oid": "81bd6709-5563-4c9a-80d6-de1ff457dd0c", "datamodelOid": "81bd6709-5563-4c9a-80d6-de1ff457dd0c", "description": "", "isDefault": true, "name": "Default", "parentOid": null, "tables": [], "relationsTables": [] } ] } }