导入导出数据
讨论表
"},"updateUserID":77098,"lastUserID":77098,"lastUser":{"userID":77098,"name":"yukiosena","url":"https:\/\/community.anaplan.com\/profile\/yukiosena","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/SFKFLE9J9FSN\/nO14QELTB55XR.jpeg","dateLastActive":"2023-03-01T13:10:11+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/general+contributor.png\")
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":38,"score":4,"hot":3355311626,"url":"https:\/\/community.anaplan.com\/discussion\/155053\/%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E3%81%AEtoday%E9%96%A2%E6%95%B0%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E7%8F%BE%E5%9C%A8%E3%81%AE%E6%97%A5%E4%BB%98%E3%82%92%E7%89%B9%E5%AE%9A%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155053\/%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E3%81%AEtoday%E9%96%A2%E6%95%B0%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E7%8F%BE%E5%9C%A8%E3%81%AE%E6%97%A5%E4%BB%98%E3%82%92%E7%89%B9%E5%AE%9A%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/1WEED5H23JC6\/anaplan-1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"anaplan-1.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":341,"name":"ナレッジシェア Knowledge Share","url":"https:\/\/community.anaplan.com\/categories\/knowledge-share","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":79,"urlcode":"モデル構築","name":"モデル構築"},{"tagID":376,"urlcode":"How-to","name":"How to"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155029,"type":"question","name":"Import script as stopped working, but the manual import runs succesfully","excerpt":"I am importing data from Snowflake and successfully saving the csv file, this has worked for about 2 years They changed their column headers, I then downloaded the new format csv, and created a new import using this file, which works 100% However, when i add the new import to the script it crashes at the import stage…","categoryID":19,"dateInserted":"2023-02-27T17:30:04+00:00","dateUpdated":null,"dateLastComment":"2023-02-28T14:52:59+00:00","insertUserID":3490,"insertUser":{"userID":3490,"name":"DeveloperCYT","url":"https:\/\/community.anaplan.com\/profile\/DeveloperCYT","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3490.png","dateLastActive":"2023-03-01T08:19:33+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/trusted+contributor.png\")
"},"updateUserID":null,"lastUserID":3490,"lastUser":{"userID":3490,"name":"DeveloperCYT","url":"https:\/\/community.anaplan.com\/profile\/DeveloperCYT","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3490.png","dateLastActive":"2023-03-01T08:19:33+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":24,"score":null,"hot":3355117383,"url":"https:\/\/community.anaplan.com\/discussion\/155029\/import-script-as-stopped-working-but-the-manual-import-runs-succesfully","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155029\/import-script-as-stopped-working-but-the-manual-import-runs-succesfully","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-27T20:14:26+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155020,"type":"question","name":"Import failure: The dimensions in the target module do not match the import definition","excerpt":"Hi Anaplanners, I'm stuck with two imports which have the same settings, from saved views based on same module, and to the same target module. However, one works, but the other one always runs into a failure with message \"The dimensions in the target module do not match the import definition.\" I have two saved views from…","categoryID":21,"dateInserted":"2023-02-27T09:51:30+00:00","dateUpdated":null,"dateLastComment":"2023-02-28T02:36:27+00:00","insertUserID":22331,"insertUser":{"userID":22331,"name":"AmyX","url":"https:\/\/community.anaplan.com\/profile\/AmyX","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22331.jpeg","dateLastActive":"2023-03-01T08:00:55+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":22331,"lastUser":{"userID":22331,"name":"AmyX","url":"https:\/\/community.anaplan.com\/profile\/AmyX","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22331.jpeg","dateLastActive":"2023-03-01T08:00:55+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3355044477,"url":"https:\/\/community.anaplan.com\/discussion\/155020\/import-failure-the-dimensions-in-the-target-module-do-not-match-the-import-definition","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155020\/import-failure-the-dimensions-in-the-target-module-do-not-match-the-import-definition","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/LFHZQ60Z5J11\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-27T10:08:55+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":45540,"type":"idea","name":"Host Images Directly In Anaplan and Display on Dashboards Like Data and Files","excerpt":"Hi Anaplan! It would be great if Anaplan could store images directly and host them on the platform to dashboards. This would allow for easier hosting and one secure location. Also if there was a process assigned to uploading images this could help use cases for uploading multiple images at once in a bulk upload. Thanks,…","categoryID":164,"dateInserted":"2019-05-13T07:20:02+00:00","dateUpdated":null,"dateLastComment":"2023-02-27T18:50:31+00:00","insertUserID":8218,"insertUser":{"userID":8218,"name":"usman.zia","url":"https:\/\/community.anaplan.com\/profile\/usman.zia","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8218.jpeg","dateLastActive":"2023-02-07T11:41:49+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/exceptional+boss.png\")
"},"updateUserID":null,"lastUserID":89531,"lastUser":{"userID":89531,"name":"brigette","url":"https:\/\/community.anaplan.com\/profile\/brigette","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/89531.jpeg","dateLastActive":"2023-02-27T18:57:16+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/member.png\")
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":51,"score":65,"hot":3235283133,"url":"https:\/\/community.anaplan.com\/discussion\/45540\/host-images-directly-in-anaplan-and-display-on-dashboards-like-data-and-files","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/45540\/host-images-directly-in-anaplan-and-display-on-dashboards-like-data-and-files","format":"html","groupID":null,"statusID":10005,"attributes":{"idea":{"statusNotes":null,"statusID":10005,"status":{"name":"In Review","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1065,"urlcode":"In Review","name":"In Review"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":147295,"type":"question","name":"Cloudworks Integration \"There was an internal server error\" for BigQuery Data Source option","excerpt":"Hi experts, I was trying to export Anaplan data to BigQuery via Cloudworks. I have established a connection but when I am trying to set up the integration, I keep encountering the issue of \"There was an internal server error\" under the Data Source option. Can anyone provide any advice on how to resolve this? ","categoryID":21,"dateInserted":"2022-09-19T09:11:07+00:00","dateUpdated":null,"dateLastComment":"2023-02-27T01:33:57+00:00","insertUserID":93385,"insertUser":{"userID":93385,"name":"ColinNgSH","url":"https:\/\/community.anaplan.com\/profile\/ColinNgSH","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/93385.png","dateLastActive":"2022-11-08T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":7973,"lastUser":{"userID":7973,"name":"hendersonmj","url":"https:\/\/community.anaplan.com\/profile\/hendersonmj","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/7973.jpeg","dateLastActive":"2023-02-27T01:31:55+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/us.v-cdn.net\/6037036\/rank\/1.png\")
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":9,"score":null,"hot":3341041504,"url":"https:\/\/community.anaplan.com\/discussion\/147295\/cloudworks-integration-there-was-an-internal-server-error-for-bigquery-data-source-option","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/147295\/cloudworks-integration-there-was-an-internal-server-error-for-bigquery-data-source-option","format":"html","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/ColinNgSH_1-1663603785742_147295.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ColinNgSH_1-1663603785742.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-05T11:36:23+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":99484,"type":"discussion","name":"Volumes for DATA02 SKU","excerpt":"Hi team, I have mapped the data SKU.csv as per below screenshot. And under DATA02 sku line items mapped volumes However, only Jan 2019 and Jan 2020 data is visible in the sheet attached jpg, Please guide me with steps to rectify so that volumes are visible under each month.","categoryID":182,"dateInserted":"2021-02-28T20:48:09+00:00","dateUpdated":null,"dateLastComment":"2023-02-26T09:25:14+00:00","insertUserID":48133,"insertUser":{"userID":48133,"name":"adarshbarodia","url":"https:\/\/community.anaplan.com\/profile\/adarshbarodia","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/48133.png","dateLastActive":"2021-05-09T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/new+contributor.png\")
"},"updateUserID":null,"lastUserID":103283,"lastUser":{"userID":103283,"name":"Avanish123","url":"https:\/\/community.anaplan.com\/profile\/Avanish123","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a2b68b21016b5f6567673396f6322238.svg","dateLastActive":"2023-02-28T13:45:26+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":59,"score":null,"hot":3291952403,"url":"https:\/\/community.anaplan.com\/discussion\/99484\/volumes-for-data02-sku","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/99484\/volumes-for-data02-sku","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/adarshbarodia_0-1614573896976_99484.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"adarshbarodia_0-1614573896976.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":39999,"type":"idea","name":"Automatically generate Keys for Importing fact data into Data Hub module","excerpt":"Importing fact data into \"flat modules\" in a Data Hub is challenging when your data source is unable to provide a single unique Key to act as a List Item. That work ends up taking place between the extracted data and the import into Anaplan and oftentimes involves concatenating Key columns into a single column, sometimes…","categoryID":164,"dateInserted":"2019-01-08T09:50:05+00:00","dateUpdated":null,"dateLastComment":"2023-02-25T15:11:21+00:00","insertUserID":13899,"insertUser":{"userID":13899,"name":"paul.rosal","url":"https:\/\/community.anaplan.com\/profile\/paul.rosal","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/13899.jpeg","dateLastActive":"2022-11-21T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":17053,"lastUser":{"userID":17053,"name":"david.savarin","url":"https:\/\/community.anaplan.com\/profile\/david.savarin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17053.jpeg","dateLastActive":"2023-02-27T22:52:28+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":38,"score":66,"hot":3224303486,"url":"https:\/\/community.anaplan.com\/discussion\/39999\/automatically-generate-keys-for-importing-fact-data-into-data-hub-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/39999\/automatically-generate-keys-for-importing-fact-data-into-data-hub-module","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154859,"type":"question","name":"Clubbing multiple excel exports","excerpt":"Hello All, We have a requirement from user where they want to club multiple excel exports from Anaplan as a single file (meaning each sheet in excel having the respective export from Anaplan). Is this possible? IF yes, can you suggest how to proceed. Report 1 -> Sheet1 of excel Report 2 -> Sheet2 of (of same excel)..and so…","categoryID":19,"dateInserted":"2023-02-08T03:49:32+00:00","dateUpdated":null,"dateLastComment":"2023-02-24T17:03:30+00:00","insertUserID":28147,"insertUser":{"userID":28147,"name":"harshitha.narayan@sony.com","url":"https:\/\/community.anaplan.com\/profile\/harshitha.narayan%40sony.com","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28147.png","dateLastActive":"2023-02-27T03:56:30+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":28147,"lastUser":{"userID":28147,"name":"harshitha.narayan@sony.com","url":"https:\/\/community.anaplan.com\/profile\/harshitha.narayan%40sony.com","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28147.png","dateLastActive":"2023-02-27T03:56:30+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3353088182,"url":"https:\/\/community.anaplan.com\/discussion\/154859\/clubbing-multiple-excel-exports","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154859\/clubbing-multiple-excel-exports","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-08T04:55:37+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":191,"urlcode":"Excel","name":"Excel"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":138627,"type":"question","name":"Format while manually exporting data","excerpt":"When we manually export data from the anaplan model, several formats of the data can be exported. I want to know the difference between the two formats 1.Comma separated values(.csv) and Comma Separated values for Excel(.csv) 2.Excel(.xls) and Excel (.xls) not formatted 3.Excel Open XML(.xlsx) and Excel open XML(.xlsx) not…","categoryID":21,"dateInserted":"2022-05-27T03:26:20+00:00","dateUpdated":null,"dateLastComment":"2023-02-24T08:46:19+00:00","insertUserID":84618,"insertUser":{"userID":84618,"name":"medaganeshamanikanta","url":"https:\/\/community.anaplan.com\/profile\/medaganeshamanikanta","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/84618.jpeg","dateLastActive":"2023-03-01T11:35:30+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":52851,"lastUser":{"userID":52851,"name":"KiddXin","url":"https:\/\/community.anaplan.com\/profile\/KiddXin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/52851.jpeg","dateLastActive":"2023-02-26T07:49:42+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":14,"score":null,"hot":3330852159,"url":"https:\/\/community.anaplan.com\/discussion\/138627\/format-while-manually-exporting-data","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/138627\/format-while-manually-exporting-data","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-05-27T05:11:34+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154999,"type":"question","name":"Hi, I'm currently in 10.2.2 Activity: Import Data into Non Employee Expenses Module","excerpt":"In my first screenshot, you can see the source and target mapping for the data. In my second screenshot, I have correctly mapped the time corresponding to the format available. (See 1st screenshot in the column header for time to understand the format) In my third screenshot, there's an \"import failed\" window. I don't…","categoryID":182,"dateInserted":"2023-02-23T18:31:06+00:00","dateUpdated":"2023-02-23T18:31:36+00:00","dateLastComment":"2023-02-23T18:43:40+00:00","insertUserID":96720,"insertUser":{"userID":96720,"name":"AshishSomashekar","url":"https:\/\/community.anaplan.com\/profile\/AshishSomashekar","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/96720.png","dateLastActive":"2023-02-24T20:34:03+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":96720,"lastUserID":96720,"lastUser":{"userID":96720,"name":"AshishSomashekar","url":"https:\/\/community.anaplan.com\/profile\/AshishSomashekar","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/96720.png","dateLastActive":"2023-02-24T20:34:03+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":17,"score":null,"hot":3354356086,"url":"https:\/\/community.anaplan.com\/discussion\/154999\/hi-im-currently-in-10-2-2-activity-import-data-into-non-employee-expenses-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154999\/hi-im-currently-in-10-2-2-activity-import-data-into-non-employee-expenses-module","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-23T18:41:08+00:00","dateAnswered":"2023-02-23T18:40:16+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154972,"type":"question","name":"Compare numbers in different modules","excerpt":"Hi I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (captured in a DAT module) to suggest the payout %. For example the DAT module is as given below (not dimensionalised) The other…","categoryID":19,"dateInserted":"2023-02-22T00:32:35+00:00","dateUpdated":"2023-02-22T17:19:00+00:00","dateLastComment":"2023-02-23T11:24:28+00:00","insertUserID":80710,"insertUser":{"userID":80710,"name":"yatin.ajbani","url":"https:\/\/community.anaplan.com\/profile\/yatin.ajbani","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/80710.png","dateLastActive":"2023-02-28T00:15:23+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":80710,"lastUserID":21343,"lastUser":{"userID":21343,"name":"megha09","url":"https:\/\/community.anaplan.com\/profile\/megha09","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/21343.png","dateLastActive":"2023-02-28T13:02:51+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":40,"score":null,"hot":3354178023,"url":"https:\/\/community.anaplan.com\/discussion\/154972\/compare-numbers-in-different-modules","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154972\/compare-numbers-in-different-modules","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/GF0FEWK01DGD\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-24T16:20:47+00:00","dateAnswered":"2023-02-23T11:24:28+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":461,"urlcode":"Data","name":"Data"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154962,"type":"question","name":"Why several actions in process are not updated?","excerpt":"Hello, I have been importing data from a data hub daily for several months now. In the last days the last 2 actions of the process are ignored on the update. The actions are very simple. It is importing a date from the data hub. I can't understand the issue. All the other actions are working properly. When I am launching…","categoryID":21,"dateInserted":"2023-02-21T08:37:56+00:00","dateUpdated":null,"dateLastComment":"2023-02-23T09:50:07+00:00","insertUserID":84448,"insertUser":{"userID":84448,"name":"MoraruD","url":"https:\/\/community.anaplan.com\/profile\/MoraruD","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/84448.jpeg","dateLastActive":"2023-02-28T16:06:21+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":84448,"lastUser":{"userID":84448,"name":"MoraruD","url":"https:\/\/community.anaplan.com\/profile\/MoraruD","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/84448.jpeg","dateLastActive":"2023-02-28T16:06:21+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":16,"score":null,"hot":3354115683,"url":"https:\/\/community.anaplan.com\/discussion\/154962\/why-several-actions-in-process-are-not-updated","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154962\/why-several-actions-in-process-are-not-updated","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-21T09:41:58+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1108,"urlcode":"data-hub","name":"Data Hub"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154985,"type":"question","name":"Export ignoring show\/hide","excerpt":"Hi guys, I have created a saved view in one of my modules. my module has 4 dimensions + line items. Time, Cost center, GL account and version. My saved view has selected a few versions, cost centers and GL accounts. I use tabular single column for my export as I want all dimensions to be columns and only a single line item…","categoryID":19,"dateInserted":"2023-02-22T22:58:15+00:00","dateUpdated":"2023-02-22T22:59:02+00:00","dateLastComment":"2023-02-23T05:31:26+00:00","insertUserID":62855,"insertUser":{"userID":62855,"name":"MatthewWilcox","url":"https:\/\/community.anaplan.com\/profile\/MatthewWilcox","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/62855.png","dateLastActive":"2023-02-28T22:33:48+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":62855,"lastUserID":12489,"lastUser":{"userID":12489,"name":"AjayM","url":"https:\/\/community.anaplan.com\/profile\/AjayM","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/12489.png","dateLastActive":"2023-03-01T12:00:08+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":31,"score":null,"hot":3354237581,"url":"https:\/\/community.anaplan.com\/discussion\/154985\/export-ignoring-show-hide","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154985\/export-ignoring-show-hide","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-28T20:42:18+00:00","dateAnswered":"2023-02-23T05:31:26+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":49364,"type":"idea","name":"Applying filtering on Tabular Single Column Exports","excerpt":"Being an Anaplan builder\/user, I would like to be able use set on the view filters for export option \"Tabular Single Column\". Currently, if you prepare a view with set filters, if you run \"Tabular Single Column\" export, Anaplan will ignore filters and include all items from all dimensions in the extract. It has two major…","categoryID":164,"dateInserted":"2019-07-25T23:40:16+00:00","dateUpdated":null,"dateLastComment":"2023-02-22T23:05:35+00:00","insertUserID":10117,"insertUser":{"userID":10117,"name":"AndreyPol","url":"https:\/\/community.anaplan.com\/profile\/AndreyPol","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/10117.png","dateLastActive":"2020-06-25T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/community+boss.png\")
"},"updateUserID":null,"lastUserID":3139,"lastUser":{"userID":3139,"name":"Sukh_Sandhu","url":"https:\/\/community.anaplan.com\/profile\/Sukh_Sandhu","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3139.jpeg","dateLastActive":"2023-02-22T23:04:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":25,"score":27,"hot":3241218051,"url":"https:\/\/community.anaplan.com\/discussion\/49364\/applying-filtering-on-tabular-single-column-exports","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/49364\/applying-filtering-on-tabular-single-column-exports","format":"html","groupID":null,"statusID":10005,"attributes":{"idea":{"statusNotes":null,"statusID":10005,"status":{"name":"In Review","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1065,"urlcode":"In Review","name":"In Review"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":128350,"type":"question","name":"4.8.2 Activity: Import Data into E2 Employees# List","excerpt":"Hi Anaplan community, Had a bit of trouble importing employee details into the list. I followed all instructions given in the community regarding this and even tried deleting and importing the list multiple times but it still displays employee number instead of name. Hope someone can help. Thank you! ","categoryID":21,"dateInserted":"2021-12-27T20:48:01+00:00","dateUpdated":null,"dateLastComment":"2023-02-22T18:00:57+00:00","insertUserID":72652,"insertUser":{"userID":72652,"name":"julioarrastia","url":"https:\/\/community.anaplan.com\/profile\/julioarrastia","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/72652.png","dateLastActive":"2022-01-17T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":104379,"lastUser":{"userID":104379,"name":"Nomaan","url":"https:\/\/community.anaplan.com\/profile\/Nomaan","photoUrl":"https:\/\/w7.vanillicon.com\/v2\/764e8d96fd8ca0e780e0def3c089816f.svg","dateLastActive":"2023-02-28T05:36:11+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":3,"score":null,"hot":3317728738,"url":"https:\/\/community.anaplan.com\/discussion\/128350\/4-8-2-activity-import-data-into-e2-employees-list","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/128350\/4-8-2-activity-import-data-into-e2-employees-list","format":"html","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/julioarrastia_1-1640662591516_128350.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"julioarrastia_1-1640662591516.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2021-12-27T21:16:13+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":121476,"type":"question","name":"Update Current Period Action from Data Hub Not Working","excerpt":"I’m having trouble with Updating the Current Period action using an imported line item from the Data Hub. I created a systems module and added a Current Period, time formatted line item with no dimensions in the Data Hub and Spoke Model. I created the action to Update the Current Period in the Data Hub and it worked…","categoryID":21,"dateInserted":"2021-10-08T12:18:28+00:00","dateUpdated":null,"dateLastComment":"2023-02-20T09:54:37+00:00","insertUserID":56054,"insertUser":{"userID":56054,"name":"JessicaD","url":"https:\/\/community.anaplan.com\/profile\/JessicaD","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/56054.png","dateLastActive":"2022-11-22T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":19307,"lastUser":{"userID":19307,"name":"gplacona","url":"https:\/\/community.anaplan.com\/profile\/gplacona","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/19307.jpeg","dateLastActive":"2023-03-01T09:17:51+00:00","banned":0,"punished":0,"private":true,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":2,"score":null,"hot":3310585385,"url":"https:\/\/community.anaplan.com\/discussion\/121476\/update-current-period-action-from-data-hub-not-working","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/121476\/update-current-period-action-from-data-hub-not-working","format":"html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2021-10-08T14:51:07+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154951,"type":"question","name":"1.5.6.2 Import Data into Historic Volumes Module. Need some help","excerpt":"Hi, I am having some trouble trying to import data to the module: I ran the upload and it is successful. But then all the volumes data in my module is all the same, meanwhile in the import file each volumes are different. Any idea where I went wrong? Please help 😞 Thank you","categoryID":182,"dateInserted":"2023-02-19T01:36:40+00:00","dateUpdated":null,"dateLastComment":"2023-02-20T09:06:54+00:00","insertUserID":103631,"insertUser":{"userID":103631,"name":"mahendrawijaya","url":"https:\/\/community.anaplan.com\/profile\/mahendrawijaya","photoUrl":"https:\/\/w3.vanillicon.com\/v2\/3b3bb1f1cd0db8ac22d1b8b5908a237d.svg","dateLastActive":"2023-03-01T02:01:19+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":78268,"lastUser":{"userID":78268,"name":"jagadishdash","url":"https:\/\/community.anaplan.com\/profile\/jagadishdash","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78268.png","dateLastActive":"2023-02-26T08:43:17+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":31,"score":null,"hot":3353657614,"url":"https:\/\/community.anaplan.com\/discussion\/154951\/1-5-6-2-import-data-into-historic-volumes-module-need-some-help","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154951\/1-5-6-2-import-data-into-historic-volumes-module-need-some-help","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/MXWOFYM9E7VJ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-19T10:29:08+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":133112,"type":"discussion","name":"2.3.8.2 Import into DEM01 Module","excerpt":"Hello All I m stuck in this activity, can you tell me if my mapping is correct ? I think that the probleme is with the time mapping, i actually change the time scale to month bu stell have this error: Help me please , Thank you ","categoryID":182,"dateInserted":"2022-03-01T02:59:32+00:00","dateUpdated":null,"dateLastComment":"2023-02-20T02:24:33+00:00","insertUserID":71441,"insertUser":{"userID":71441,"name":"Dedef","url":"https:\/\/community.anaplan.com\/profile\/Dedef","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/71441.svg","dateLastActive":"2022-11-16T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":105623,"lastUser":{"userID":105623,"name":"anaka","url":"https:\/\/community.anaplan.com\/profile\/anaka","photoUrl":"https:\/\/w4.vanillicon.com\/v2\/470f3de2a43309e702575bb8811a94ba.svg","dateLastActive":"2023-03-01T03:27:09+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":74,"score":null,"hot":3322967645,"url":"https:\/\/community.anaplan.com\/discussion\/133112\/2-3-8-2-import-into-dem01-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/133112\/2-3-8-2-import-into-dem01-module","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Dedef_0-1646132145592_133112.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Dedef_0-1646132145592.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":69347,"type":"idea","name":"Import Saved View - Filter","excerpt":"Hi all, A bit surprised this topic isn't here as it's one of the most common frustrations, similar to the post here. When importing from a filtered saved view there are a lot of cases of missing values. We all encounter it, and the first time it takes very long to determine the root cause. We change the filters but then…","categoryID":164,"dateInserted":"2020-05-06T03:40:20+00:00","dateUpdated":null,"dateLastComment":"2023-02-18T15:18:29+00:00","insertUserID":17782,"insertUser":{"userID":17782,"name":"MaartenGijbels","url":"https:\/\/community.anaplan.com\/profile\/MaartenGijbels","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17782.png","dateLastActive":"2021-12-08T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":17053,"lastUser":{"userID":17053,"name":"david.savarin","url":"https:\/\/community.anaplan.com\/profile\/david.savarin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17053.jpeg","dateLastActive":"2023-02-27T22:52:28+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":2,"score":19,"hot":3265476829,"url":"https:\/\/community.anaplan.com\/discussion\/69347\/import-saved-view-filter","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/69347\/import-saved-view-filter","format":"html","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/MaartenGijbels_0-1588761537963_69347.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"MaartenGijbels_0-1588761537963.png"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154943,"type":"question","name":"Hello,","excerpt":"I have a module dimensioned by Accounts on the rows, Users on the columns, and 1 Boolean line item which allows users to select certain accounts that apply only for that user. I am trying to create an action that allows the user to clear all of their selection by simply clicking an action button, as opposed to have click…","categoryID":19,"dateInserted":"2023-02-17T13:55:18+00:00","dateUpdated":null,"dateLastComment":"2023-02-17T17:07:06+00:00","insertUserID":74972,"insertUser":{"userID":74972,"name":"ROliveros","url":"https:\/\/community.anaplan.com\/profile\/ROliveros","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/74972.png","dateLastActive":"2023-02-17T17:07:13+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":74972,"lastUser":{"userID":74972,"name":"ROliveros","url":"https:\/\/community.anaplan.com\/profile\/ROliveros","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/74972.png","dateLastActive":"2023-02-17T17:07:13+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3353296944,"url":"https:\/\/community.anaplan.com\/discussion\/154943\/hello","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154943\/hello","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-17T17:07:11+00:00","dateAnswered":"2023-02-17T14:08:06+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":48,"urlcode":"Model-Builder","name":"Model Builder"},{"tagID":58,"urlcode":"Workflow","name":"Workflow"},{"tagID":1111,"urlcode":"anaplan-community","name":"Anaplan Community"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":112945,"type":"idea","name":"Ability to combine processes across models in CloudWorks","excerpt":"The use case is to orchestrate a data integration workflow in one CloudWorks schedule containing steps executing model-to-model imports from many processes residing in various models, e.g. update DataHuab lists and modules, then update planning model lists and modules, then update reporting model lists and update.","categoryID":164,"dateInserted":"2021-06-30T02:35:34+00:00","dateUpdated":null,"dateLastComment":"2023-02-14T23:20:11+00:00","insertUserID":78,"insertUser":{"userID":78,"name":"Moritz","url":"https:\/\/community.anaplan.com\/profile\/Moritz","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78.jpeg","dateLastActive":"2021-09-08T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":52231,"lastUser":{"userID":52231,"name":"AshwinK","url":"https:\/\/community.anaplan.com\/profile\/AshwinK","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/52231.png","dateLastActive":"2023-02-28T23:04:25+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":33,"score":38,"hot":3301454145,"url":"https:\/\/community.anaplan.com\/discussion\/112945\/ability-to-combine-processes-across-models-in-cloudworks","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/112945\/ability-to-combine-processes-across-models-in-cloudworks","format":"html","groupID":null,"statusID":10007,"attributes":{"idea":{"statusNotes":null,"statusID":10007,"status":{"name":"On Roadmap","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":58,"urlcode":"Workflow","name":"Workflow"},{"tagID":1098,"urlcode":"On Roadmap","name":"On Roadmap"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":151469,"type":"idea","name":"Sort Workspaces in Model>Model Import View","excerpt":"When setting up an import and selecting the \"Connect to Anaplan Model\" option, if you need to navigate to a different Workspace, you may be in for a bit of a maze. The workspaces are randomly sorted today, when nearly every other view (manage models from home page, new breadcrumb navigation in updated modeling experience)…","categoryID":132,"dateInserted":"2022-11-07T13:34:39+00:00","dateUpdated":"2022-11-07T00:00:00+00:00","dateLastComment":"2023-02-14T22:24:54+00:00","insertUserID":14281,"insertUser":{"userID":14281,"name":"rachel.bisch","url":"https:\/\/community.anaplan.com\/profile\/rachel.bisch","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14281.png","dateLastActive":"2023-02-13T22:49:35+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":71046,"lastUser":{"userID":71046,"name":"SriG","url":"https:\/\/community.anaplan.com\/profile\/SriG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/71046.png","dateLastActive":"2023-02-14T22:18:46+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":3,"score":6,"hot":3344243973,"url":"https:\/\/community.anaplan.com\/discussion\/151469\/sort-workspaces-in-model-model-import-view","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/151469\/sort-workspaces-in-model-model-import-view","format":"Html","groupID":null,"statusID":1,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":132,"name":"Modeling Ideas","url":"https:\/\/community.anaplan.com\/categories\/Modeling-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":63951,"type":"idea","name":"Remove Line Item Mapping when Item is Removed from Import Data Source","excerpt":"Within the Line Items tab of the import dialogue, please can line item sources be removed when these are removed from the import data source. Take the below as an example: If I were to remove Revenue from the import data source, the Revenue line item source would still appear on the left to be mapped to a line item target.…","categoryID":164,"dateInserted":"2020-03-17T05:05:23+00:00","dateUpdated":null,"dateLastComment":"2023-02-11T11:12:47+00:00","insertUserID":22802,"insertUser":{"userID":22802,"name":"Nicolas Cadier","url":"https:\/\/community.anaplan.com\/profile\/Nicolas%20Cadier","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22802.jpeg","dateLastActive":"2023-02-12T12:39:28+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/CMA.png\")
"},"updateUserID":null,"lastUserID":89540,"lastUser":{"userID":89540,"name":"CandaceCranney","url":"https:\/\/community.anaplan.com\/profile\/CandaceCranney","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/89540.png","dateLastActive":"2023-02-26T23:05:38+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":2,"score":4,"hot":3260538490,"url":"https:\/\/community.anaplan.com\/discussion\/63951\/remove-line-item-mapping-when-item-is-removed-from-import-data-source","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/63951\/remove-line-item-mapping-when-item-is-removed-from-import-data-source","format":"html","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Line_Items_63951.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Line Items.png"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":47962,"type":"question","name":"Exporting data to different tabs in excel","excerpt":"I'd looking for something that I think I've seen in other systems referred to as \"explode\" functionality, which would effectively create a new excel tab for every list item and export to that tab. So, if I have a department list (for example), I'd like to export data to excel and have a tab show up with the data for each…","categoryID":21,"dateInserted":"2019-06-27T14:10:25+00:00","dateUpdated":null,"dateLastComment":"2023-02-10T03:11:58+00:00","insertUserID":7722,"insertUser":{"userID":7722,"name":"jbrass","url":"https:\/\/community.anaplan.com\/profile\/jbrass","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/7722.jpeg","dateLastActive":"2022-10-05T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":5598,"lastUser":{"userID":5598,"name":"neeti","url":"https:\/\/community.anaplan.com\/profile\/neeti","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/5598.png","dateLastActive":"2023-02-14T21:52:55+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/reliable+contributor.png\")
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3237645143,"url":"https:\/\/community.anaplan.com\/discussion\/47962\/exporting-data-to-different-tabs-in-excel","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/47962\/exporting-data-to-different-tabs-in-excel","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2019-06-27T14:52:32+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154874,"type":"discussion","name":"Wrong date when doing an import","excerpt":"Hi everyone, I am importing data into a module which gives me the employment date of a list of employees (among other info). The module doesn't use time as a dimension. The import goes perfectly well, it doesn't mention any error. But then some of the dates are wrong. So I tried to copy these directly from Excel (simple…","categoryID":19,"dateInserted":"2023-02-09T05:41:05+00:00","dateUpdated":"2023-02-09T16:30:18+00:00","dateLastComment":"2023-02-09T05:41:05+00:00","insertUserID":69098,"insertUser":{"userID":69098,"name":"FlavieBR","url":"https:\/\/community.anaplan.com\/profile\/FlavieBR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/69098.svg","dateLastActive":"2023-02-22T15:28:55+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":69098,"lastUser":{"userID":69098,"name":"FlavieBR","url":"https:\/\/community.anaplan.com\/profile\/FlavieBR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/69098.svg","dateLastActive":"2023-02-22T15:28:55+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":1,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/154874\/wrong-date-when-doing-an-import","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154874\/wrong-date-when-doing-an-import","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":144064,"type":"idea","name":"Workflow triggers Import\/Export","excerpt":"Having CloudWorks schedule imports between models is useful, but users still need to wait. Our users are participating in a workflow, data is ready to move from the source model when a workflow step is completed. Can we trigger imports or exports, or model-to-model imports from workflow?","categoryID":164,"dateInserted":"2022-08-04T08:06:42+00:00","dateUpdated":null,"dateLastComment":"2023-02-08T01:54:49+00:00","insertUserID":7970,"insertUser":{"userID":7970,"name":"michael.moore","url":"https:\/\/community.anaplan.com\/profile\/michael.moore","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/7970.jpeg","dateLastActive":"2023-02-28T13:38:31+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":52231,"lastUser":{"userID":52231,"name":"AshwinK","url":"https:\/\/community.anaplan.com\/profile\/AshwinK","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/52231.png","dateLastActive":"2023-02-28T23:04:25+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":9,"hot":3335424991,"url":"https:\/\/community.anaplan.com\/discussion\/144064\/workflow-triggers-import-export","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/144064\/workflow-triggers-import-export","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":58,"urlcode":"Workflow","name":"Workflow"},{"tagID":214,"urlcode":"CloudWorks","name":"CloudWorks"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":53560,"type":"idea","name":"Export - Data Source","excerpt":"Hi Community, I am thinking that would be very beneficial for model builders to have the possibility to view Data Sources for Export Definitions. For the large models with lots of external integrations and different export actions is pretty difficult to follow the source of a particular export if you can have dozens of…","categoryID":164,"dateInserted":"2019-10-28T08:39:19+00:00","dateUpdated":null,"dateLastComment":"2023-02-06T18:45:35+00:00","insertUserID":12380,"insertUser":{"userID":12380,"name":"Alexandru.Rosca","url":"https:\/\/community.anaplan.com\/profile\/Alexandru.Rosca","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/12380.png","dateLastActive":"2023-02-24T12:47:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":88494,"lastUser":{"userID":88494,"name":"DavidHunter","url":"https:\/\/community.anaplan.com\/profile\/DavidHunter","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/4124CEMOL8UW\/n2J171D7IDUAI.jpg","dateLastActive":"2023-02-16T22:10:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":13,"score":18,"hot":3247971294,"url":"https:\/\/community.anaplan.com\/discussion\/53560\/export-data-source","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/53560\/export-data-source","format":"html","groupID":null,"statusID":10005,"attributes":{"idea":{"statusNotes":null,"statusID":10005,"status":{"name":"In Review","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1065,"urlcode":"In Review","name":"In Review"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":93145,"type":"idea","name":"Export defined in a model should be connected to a view","excerpt":"Hello Team, Currently, when we create exports and save them in actions - they are disconnected from real module views. Example: if you create a new export definition, based on a current view (with a filter or smth else) it is not possible to revisit and amend this view after some time and see what view is feeding an export…","categoryID":164,"dateInserted":"2020-12-10T08:01:56+00:00","dateUpdated":null,"dateLastComment":"2023-02-06T18:42:05+00:00","insertUserID":568,"insertUser":{"userID":568,"name":"nikolay_denisov","url":"https:\/\/community.anaplan.com\/profile\/nikolay_denisov","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/568.jpeg","dateLastActive":"2023-01-31T13:35:36+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":88494,"lastUser":{"userID":88494,"name":"DavidHunter","url":"https:\/\/community.anaplan.com\/profile\/DavidHunter","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/4124CEMOL8UW\/n2J171D7IDUAI.jpg","dateLastActive":"2023-02-16T22:10:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":2,"score":1,"hot":3283297141,"url":"https:\/\/community.anaplan.com\/discussion\/93145\/export-defined-in-a-model-should-be-connected-to-a-view","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/93145\/export-defined-in-a-model-should-be-connected-to-a-view","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":106819,"type":"idea","name":"Update Current Timestamp by adding a New Action Type","excerpt":"As workspace admin, I would like to have the possibility to update the current timestamp in UTC timezone by having a New Action type created ( similar to the below picture ). This could work in a very similar way as the very nice new feature \"Update Current Period\": 1. Create in a module without any dimensions a line-item…","categoryID":164,"dateInserted":"2021-04-30T04:42:36+00:00","dateUpdated":null,"dateLastComment":"2023-02-06T17:49:24+00:00","insertUserID":3647,"insertUser":{"userID":3647,"name":"alexpavel","url":"https:\/\/community.anaplan.com\/profile\/alexpavel","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3647.jpeg","dateLastActive":"2023-02-27T06:10:08+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":1474,"lastUser":{"userID":1474,"name":"Antonio_Flor","url":"https:\/\/community.anaplan.com\/profile\/Antonio_Flor","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/1474.jpeg","dateLastActive":"2023-03-01T10:33:19+00:00","banned":0,"punished":0,"private":false,"label":"![](\"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/ranks\/respected+contributor.png\")
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":35,"score":33,"hot":3295477020,"url":"https:\/\/community.anaplan.com\/discussion\/106819\/update-current-timestamp-by-adding-a-new-action-type","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/106819\/update-current-timestamp-by-adding-a-new-action-type","format":"html","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/alexpavel_0-1619782111982_106819.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"alexpavel_0-1619782111982.png"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":150473,"type":"idea","name":"Power BI Enhancements\/Limitations","excerpt":"The following will be primarily based on my recent experiences with the Power BI Connector and Anaplan. Positives: 1. The Authentication has much improved and the use of SSO relieves a lot of data concerns when creating Power BI Reports. 2. Able to run multiple exports into the same model Negatives: In my experience and…","categoryID":164,"dateInserted":"2022-10-28T11:33:13+00:00","dateUpdated":null,"dateLastComment":"2023-02-04T12:06:37+00:00","insertUserID":8417,"insertUser":{"userID":8417,"name":"StevenK","url":"https:\/\/community.anaplan.com\/profile\/StevenK","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8417.jpeg","dateLastActive":"2023-02-09T15:20:11+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":17053,"lastUser":{"userID":17053,"name":"david.savarin","url":"https:\/\/community.anaplan.com\/profile\/david.savarin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17053.jpeg","dateLastActive":"2023-02-27T22:52:28+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":4,"hot":3342470990,"url":"https:\/\/community.anaplan.com\/discussion\/150473\/power-bi-enhancements-limitations","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/150473\/power-bi-enhancements-limitations","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":38,"score":4,"hot":3355311626,"url":"https:\/\/community.anaplan.com\/discussion\/155053\/%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E3%81%AEtoday%E9%96%A2%E6%95%B0%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E7%8F%BE%E5%9C%A8%E3%81%AE%E6%97%A5%E4%BB%98%E3%82%92%E7%89%B9%E5%AE%9A%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155053\/%E3%82%A8%E3%82%AF%E3%82%BB%E3%83%AB%E3%81%AEtoday%E9%96%A2%E6%95%B0%E3%81%AE%E3%82%88%E3%81%86%E3%81%AB%E7%8F%BE%E5%9C%A8%E3%81%AE%E6%97%A5%E4%BB%98%E3%82%92%E7%89%B9%E5%AE%9A%E3%81%99%E3%82%8B%E6%96%B9%E6%B3%95","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/1WEED5H23JC6\/anaplan-1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"anaplan-1.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":341,"name":"ナレッジシェア Knowledge Share","url":"https:\/\/community.anaplan.com\/categories\/knowledge-share","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":79,"urlcode":"モデル構築","name":"モデル構築"},{"tagID":376,"urlcode":"How-to","name":"How to"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155029,"type":"question","name":"Import script as stopped working, but the manual import runs succesfully","excerpt":"I am importing data from Snowflake and successfully saving the csv file, this has worked for about 2 years They changed their column headers, I then downloaded the new format csv, and created a new import using this file, which works 100% However, when i add the new import to the script it crashes at the import stage…","categoryID":19,"dateInserted":"2023-02-27T17:30:04+00:00","dateUpdated":null,"dateLastComment":"2023-02-28T14:52:59+00:00","insertUserID":3490,"insertUser":{"userID":3490,"name":"DeveloperCYT","url":"https:\/\/community.anaplan.com\/profile\/DeveloperCYT","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3490.png","dateLastActive":"2023-03-01T08:19:33+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":3490,"lastUser":{"userID":3490,"name":"DeveloperCYT","url":"https:\/\/community.anaplan.com\/profile\/DeveloperCYT","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3490.png","dateLastActive":"2023-03-01T08:19:33+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":24,"score":null,"hot":3355117383,"url":"https:\/\/community.anaplan.com\/discussion\/155029\/import-script-as-stopped-working-but-the-manual-import-runs-succesfully","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155029\/import-script-as-stopped-working-but-the-manual-import-runs-succesfully","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-27T20:14:26+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155020,"type":"question","name":"Import failure: The dimensions in the target module do not match the import definition","excerpt":"Hi Anaplanners, I'm stuck with two imports which have the same settings, from saved views based on same module, and to the same target module. However, one works, but the other one always runs into a failure with message \"The dimensions in the target module do not match the import definition.\" I have two saved views from…","categoryID":21,"dateInserted":"2023-02-27T09:51:30+00:00","dateUpdated":null,"dateLastComment":"2023-02-28T02:36:27+00:00","insertUserID":22331,"insertUser":{"userID":22331,"name":"AmyX","url":"https:\/\/community.anaplan.com\/profile\/AmyX","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22331.jpeg","dateLastActive":"2023-03-01T08:00:55+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":22331,"lastUser":{"userID":22331,"name":"AmyX","url":"https:\/\/community.anaplan.com\/profile\/AmyX","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22331.jpeg","dateLastActive":"2023-03-01T08:00:55+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3355044477,"url":"https:\/\/community.anaplan.com\/discussion\/155020\/import-failure-the-dimensions-in-the-target-module-do-not-match-the-import-definition","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155020\/import-failure-the-dimensions-in-the-target-module-do-not-match-the-import-definition","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/LFHZQ60Z5J11\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-27T10:08:55+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":45540,"type":"idea","name":"Host Images Directly In Anaplan and Display on Dashboards Like Data and Files","excerpt":"Hi Anaplan! It would be great if Anaplan could store images directly and host them on the platform to dashboards. This would allow for easier hosting and one secure location. Also if there was a process assigned to uploading images this could help use cases for uploading multiple images at once in a bulk upload. Thanks,…","categoryID":164,"dateInserted":"2019-05-13T07:20:02+00:00","dateUpdated":null,"dateLastComment":"2023-02-27T18:50:31+00:00","insertUserID":8218,"insertUser":{"userID":8218,"name":"usman.zia","url":"https:\/\/community.anaplan.com\/profile\/usman.zia","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8218.jpeg","dateLastActive":"2023-02-07T11:41:49+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":89531,"lastUser":{"userID":89531,"name":"brigette","url":"https:\/\/community.anaplan.com\/profile\/brigette","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/89531.jpeg","dateLastActive":"2023-02-27T18:57:16+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":51,"score":65,"hot":3235283133,"url":"https:\/\/community.anaplan.com\/discussion\/45540\/host-images-directly-in-anaplan-and-display-on-dashboards-like-data-and-files","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/45540\/host-images-directly-in-anaplan-and-display-on-dashboards-like-data-and-files","format":"html","groupID":null,"statusID":10005,"attributes":{"idea":{"statusNotes":null,"statusID":10005,"status":{"name":"In Review","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1065,"urlcode":"In Review","name":"In Review"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":147295,"type":"question","name":"Cloudworks Integration \"There was an internal server error\" for BigQuery Data Source option","excerpt":"Hi experts, I was trying to export Anaplan data to BigQuery via Cloudworks. I have established a connection but when I am trying to set up the integration, I keep encountering the issue of \"There was an internal server error\" under the Data Source option. Can anyone provide any advice on how to resolve this? ","categoryID":21,"dateInserted":"2022-09-19T09:11:07+00:00","dateUpdated":null,"dateLastComment":"2023-02-27T01:33:57+00:00","insertUserID":93385,"insertUser":{"userID":93385,"name":"ColinNgSH","url":"https:\/\/community.anaplan.com\/profile\/ColinNgSH","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/93385.png","dateLastActive":"2022-11-08T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":7973,"lastUser":{"userID":7973,"name":"hendersonmj","url":"https:\/\/community.anaplan.com\/profile\/hendersonmj","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/7973.jpeg","dateLastActive":"2023-02-27T01:31:55+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":9,"score":null,"hot":3341041504,"url":"https:\/\/community.anaplan.com\/discussion\/147295\/cloudworks-integration-there-was-an-internal-server-error-for-bigquery-data-source-option","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/147295\/cloudworks-integration-there-was-an-internal-server-error-for-bigquery-data-source-option","format":"html","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/ColinNgSH_1-1663603785742_147295.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ColinNgSH_1-1663603785742.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-10-05T11:36:23+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":99484,"type":"discussion","name":"Volumes for DATA02 SKU","excerpt":"Hi team, I have mapped the data SKU.csv as per below screenshot. And under DATA02 sku line items mapped volumes However, only Jan 2019 and Jan 2020 data is visible in the sheet attached jpg, Please guide me with steps to rectify so that volumes are visible under each month.","categoryID":182,"dateInserted":"2021-02-28T20:48:09+00:00","dateUpdated":null,"dateLastComment":"2023-02-26T09:25:14+00:00","insertUserID":48133,"insertUser":{"userID":48133,"name":"adarshbarodia","url":"https:\/\/community.anaplan.com\/profile\/adarshbarodia","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/48133.png","dateLastActive":"2021-05-09T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":103283,"lastUser":{"userID":103283,"name":"Avanish123","url":"https:\/\/community.anaplan.com\/profile\/Avanish123","photoUrl":"https:\/\/wa.vanillicon.com\/v2\/a2b68b21016b5f6567673396f6322238.svg","dateLastActive":"2023-02-28T13:45:26+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":59,"score":null,"hot":3291952403,"url":"https:\/\/community.anaplan.com\/discussion\/99484\/volumes-for-data02-sku","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/99484\/volumes-for-data02-sku","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/adarshbarodia_0-1614573896976_99484.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"adarshbarodia_0-1614573896976.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":39999,"type":"idea","name":"Automatically generate Keys for Importing fact data into Data Hub module","excerpt":"Importing fact data into \"flat modules\" in a Data Hub is challenging when your data source is unable to provide a single unique Key to act as a List Item. That work ends up taking place between the extracted data and the import into Anaplan and oftentimes involves concatenating Key columns into a single column, sometimes…","categoryID":164,"dateInserted":"2019-01-08T09:50:05+00:00","dateUpdated":null,"dateLastComment":"2023-02-25T15:11:21+00:00","insertUserID":13899,"insertUser":{"userID":13899,"name":"paul.rosal","url":"https:\/\/community.anaplan.com\/profile\/paul.rosal","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/13899.jpeg","dateLastActive":"2022-11-21T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":17053,"lastUser":{"userID":17053,"name":"david.savarin","url":"https:\/\/community.anaplan.com\/profile\/david.savarin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17053.jpeg","dateLastActive":"2023-02-27T22:52:28+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":38,"score":66,"hot":3224303486,"url":"https:\/\/community.anaplan.com\/discussion\/39999\/automatically-generate-keys-for-importing-fact-data-into-data-hub-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/39999\/automatically-generate-keys-for-importing-fact-data-into-data-hub-module","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154859,"type":"question","name":"Clubbing multiple excel exports","excerpt":"Hello All, We have a requirement from user where they want to club multiple excel exports from Anaplan as a single file (meaning each sheet in excel having the respective export from Anaplan). Is this possible? IF yes, can you suggest how to proceed. Report 1 -> Sheet1 of excel Report 2 -> Sheet2 of (of same excel)..and so…","categoryID":19,"dateInserted":"2023-02-08T03:49:32+00:00","dateUpdated":null,"dateLastComment":"2023-02-24T17:03:30+00:00","insertUserID":28147,"insertUser":{"userID":28147,"name":"harshitha.narayan@sony.com","url":"https:\/\/community.anaplan.com\/profile\/harshitha.narayan%40sony.com","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28147.png","dateLastActive":"2023-02-27T03:56:30+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":28147,"lastUser":{"userID":28147,"name":"harshitha.narayan@sony.com","url":"https:\/\/community.anaplan.com\/profile\/harshitha.narayan%40sony.com","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28147.png","dateLastActive":"2023-02-27T03:56:30+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3353088182,"url":"https:\/\/community.anaplan.com\/discussion\/154859\/clubbing-multiple-excel-exports","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154859\/clubbing-multiple-excel-exports","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-08T04:55:37+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":191,"urlcode":"Excel","name":"Excel"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":138627,"type":"question","name":"Format while manually exporting data","excerpt":"When we manually export data from the anaplan model, several formats of the data can be exported. I want to know the difference between the two formats 1.Comma separated values(.csv) and Comma Separated values for Excel(.csv) 2.Excel(.xls) and Excel (.xls) not formatted 3.Excel Open XML(.xlsx) and Excel open XML(.xlsx) not…","categoryID":21,"dateInserted":"2022-05-27T03:26:20+00:00","dateUpdated":null,"dateLastComment":"2023-02-24T08:46:19+00:00","insertUserID":84618,"insertUser":{"userID":84618,"name":"medaganeshamanikanta","url":"https:\/\/community.anaplan.com\/profile\/medaganeshamanikanta","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/84618.jpeg","dateLastActive":"2023-03-01T11:35:30+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":52851,"lastUser":{"userID":52851,"name":"KiddXin","url":"https:\/\/community.anaplan.com\/profile\/KiddXin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/52851.jpeg","dateLastActive":"2023-02-26T07:49:42+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":14,"score":null,"hot":3330852159,"url":"https:\/\/community.anaplan.com\/discussion\/138627\/format-while-manually-exporting-data","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/138627\/format-while-manually-exporting-data","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-05-27T05:11:34+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154999,"type":"question","name":"Hi, I'm currently in 10.2.2 Activity: Import Data into Non Employee Expenses Module","excerpt":"In my first screenshot, you can see the source and target mapping for the data. In my second screenshot, I have correctly mapped the time corresponding to the format available. (See 1st screenshot in the column header for time to understand the format) In my third screenshot, there's an \"import failed\" window. I don't…","categoryID":182,"dateInserted":"2023-02-23T18:31:06+00:00","dateUpdated":"2023-02-23T18:31:36+00:00","dateLastComment":"2023-02-23T18:43:40+00:00","insertUserID":96720,"insertUser":{"userID":96720,"name":"AshishSomashekar","url":"https:\/\/community.anaplan.com\/profile\/AshishSomashekar","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/96720.png","dateLastActive":"2023-02-24T20:34:03+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":96720,"lastUserID":96720,"lastUser":{"userID":96720,"name":"AshishSomashekar","url":"https:\/\/community.anaplan.com\/profile\/AshishSomashekar","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/96720.png","dateLastActive":"2023-02-24T20:34:03+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":17,"score":null,"hot":3354356086,"url":"https:\/\/community.anaplan.com\/discussion\/154999\/hi-im-currently-in-10-2-2-activity-import-data-into-non-employee-expenses-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154999\/hi-im-currently-in-10-2-2-activity-import-data-into-non-employee-expenses-module","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-23T18:41:08+00:00","dateAnswered":"2023-02-23T18:40:16+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154972,"type":"question","name":"Compare numbers in different modules","excerpt":"Hi I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (captured in a DAT module) to suggest the payout %. For example the DAT module is as given below (not dimensionalised) The other…","categoryID":19,"dateInserted":"2023-02-22T00:32:35+00:00","dateUpdated":"2023-02-22T17:19:00+00:00","dateLastComment":"2023-02-23T11:24:28+00:00","insertUserID":80710,"insertUser":{"userID":80710,"name":"yatin.ajbani","url":"https:\/\/community.anaplan.com\/profile\/yatin.ajbani","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/80710.png","dateLastActive":"2023-02-28T00:15:23+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":80710,"lastUserID":21343,"lastUser":{"userID":21343,"name":"megha09","url":"https:\/\/community.anaplan.com\/profile\/megha09","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/21343.png","dateLastActive":"2023-02-28T13:02:51+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":40,"score":null,"hot":3354178023,"url":"https:\/\/community.anaplan.com\/discussion\/154972\/compare-numbers-in-different-modules","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154972\/compare-numbers-in-different-modules","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/GF0FEWK01DGD\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-24T16:20:47+00:00","dateAnswered":"2023-02-23T11:24:28+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":461,"urlcode":"Data","name":"Data"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154962,"type":"question","name":"Why several actions in process are not updated?","excerpt":"Hello, I have been importing data from a data hub daily for several months now. In the last days the last 2 actions of the process are ignored on the update. The actions are very simple. It is importing a date from the data hub. I can't understand the issue. All the other actions are working properly. When I am launching…","categoryID":21,"dateInserted":"2023-02-21T08:37:56+00:00","dateUpdated":null,"dateLastComment":"2023-02-23T09:50:07+00:00","insertUserID":84448,"insertUser":{"userID":84448,"name":"MoraruD","url":"https:\/\/community.anaplan.com\/profile\/MoraruD","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/84448.jpeg","dateLastActive":"2023-02-28T16:06:21+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":84448,"lastUser":{"userID":84448,"name":"MoraruD","url":"https:\/\/community.anaplan.com\/profile\/MoraruD","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/84448.jpeg","dateLastActive":"2023-02-28T16:06:21+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":16,"score":null,"hot":3354115683,"url":"https:\/\/community.anaplan.com\/discussion\/154962\/why-several-actions-in-process-are-not-updated","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154962\/why-several-actions-in-process-are-not-updated","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-21T09:41:58+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1108,"urlcode":"data-hub","name":"Data Hub"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154985,"type":"question","name":"Export ignoring show\/hide","excerpt":"Hi guys, I have created a saved view in one of my modules. my module has 4 dimensions + line items. Time, Cost center, GL account and version. My saved view has selected a few versions, cost centers and GL accounts. I use tabular single column for my export as I want all dimensions to be columns and only a single line item…","categoryID":19,"dateInserted":"2023-02-22T22:58:15+00:00","dateUpdated":"2023-02-22T22:59:02+00:00","dateLastComment":"2023-02-23T05:31:26+00:00","insertUserID":62855,"insertUser":{"userID":62855,"name":"MatthewWilcox","url":"https:\/\/community.anaplan.com\/profile\/MatthewWilcox","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/62855.png","dateLastActive":"2023-02-28T22:33:48+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":62855,"lastUserID":12489,"lastUser":{"userID":12489,"name":"AjayM","url":"https:\/\/community.anaplan.com\/profile\/AjayM","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/12489.png","dateLastActive":"2023-03-01T12:00:08+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":31,"score":null,"hot":3354237581,"url":"https:\/\/community.anaplan.com\/discussion\/154985\/export-ignoring-show-hide","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154985\/export-ignoring-show-hide","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-28T20:42:18+00:00","dateAnswered":"2023-02-23T05:31:26+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":49364,"type":"idea","name":"Applying filtering on Tabular Single Column Exports","excerpt":"Being an Anaplan builder\/user, I would like to be able use set on the view filters for export option \"Tabular Single Column\". Currently, if you prepare a view with set filters, if you run \"Tabular Single Column\" export, Anaplan will ignore filters and include all items from all dimensions in the extract. It has two major…","categoryID":164,"dateInserted":"2019-07-25T23:40:16+00:00","dateUpdated":null,"dateLastComment":"2023-02-22T23:05:35+00:00","insertUserID":10117,"insertUser":{"userID":10117,"name":"AndreyPol","url":"https:\/\/community.anaplan.com\/profile\/AndreyPol","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/10117.png","dateLastActive":"2020-06-25T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":3139,"lastUser":{"userID":3139,"name":"Sukh_Sandhu","url":"https:\/\/community.anaplan.com\/profile\/Sukh_Sandhu","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3139.jpeg","dateLastActive":"2023-02-22T23:04:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":25,"score":27,"hot":3241218051,"url":"https:\/\/community.anaplan.com\/discussion\/49364\/applying-filtering-on-tabular-single-column-exports","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/49364\/applying-filtering-on-tabular-single-column-exports","format":"html","groupID":null,"statusID":10005,"attributes":{"idea":{"statusNotes":null,"statusID":10005,"status":{"name":"In Review","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1065,"urlcode":"In Review","name":"In Review"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":128350,"type":"question","name":"4.8.2 Activity: Import Data into E2 Employees# List","excerpt":"Hi Anaplan community, Had a bit of trouble importing employee details into the list. I followed all instructions given in the community regarding this and even tried deleting and importing the list multiple times but it still displays employee number instead of name. Hope someone can help. Thank you! ","categoryID":21,"dateInserted":"2021-12-27T20:48:01+00:00","dateUpdated":null,"dateLastComment":"2023-02-22T18:00:57+00:00","insertUserID":72652,"insertUser":{"userID":72652,"name":"julioarrastia","url":"https:\/\/community.anaplan.com\/profile\/julioarrastia","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/72652.png","dateLastActive":"2022-01-17T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":104379,"lastUser":{"userID":104379,"name":"Nomaan","url":"https:\/\/community.anaplan.com\/profile\/Nomaan","photoUrl":"https:\/\/w7.vanillicon.com\/v2\/764e8d96fd8ca0e780e0def3c089816f.svg","dateLastActive":"2023-02-28T05:36:11+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":3,"score":null,"hot":3317728738,"url":"https:\/\/community.anaplan.com\/discussion\/128350\/4-8-2-activity-import-data-into-e2-employees-list","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/128350\/4-8-2-activity-import-data-into-e2-employees-list","format":"html","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/julioarrastia_1-1640662591516_128350.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"julioarrastia_1-1640662591516.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2021-12-27T21:16:13+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":121476,"type":"question","name":"Update Current Period Action from Data Hub Not Working","excerpt":"I’m having trouble with Updating the Current Period action using an imported line item from the Data Hub. I created a systems module and added a Current Period, time formatted line item with no dimensions in the Data Hub and Spoke Model. I created the action to Update the Current Period in the Data Hub and it worked…","categoryID":21,"dateInserted":"2021-10-08T12:18:28+00:00","dateUpdated":null,"dateLastComment":"2023-02-20T09:54:37+00:00","insertUserID":56054,"insertUser":{"userID":56054,"name":"JessicaD","url":"https:\/\/community.anaplan.com\/profile\/JessicaD","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/56054.png","dateLastActive":"2022-11-22T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":19307,"lastUser":{"userID":19307,"name":"gplacona","url":"https:\/\/community.anaplan.com\/profile\/gplacona","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/19307.jpeg","dateLastActive":"2023-03-01T09:17:51+00:00","banned":0,"punished":0,"private":true,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":2,"score":null,"hot":3310585385,"url":"https:\/\/community.anaplan.com\/discussion\/121476\/update-current-period-action-from-data-hub-not-working","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/121476\/update-current-period-action-from-data-hub-not-working","format":"html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2021-10-08T14:51:07+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154951,"type":"question","name":"1.5.6.2 Import Data into Historic Volumes Module. Need some help","excerpt":"Hi, I am having some trouble trying to import data to the module: I ran the upload and it is successful. But then all the volumes data in my module is all the same, meanwhile in the import file each volumes are different. Any idea where I went wrong? Please help 😞 Thank you","categoryID":182,"dateInserted":"2023-02-19T01:36:40+00:00","dateUpdated":null,"dateLastComment":"2023-02-20T09:06:54+00:00","insertUserID":103631,"insertUser":{"userID":103631,"name":"mahendrawijaya","url":"https:\/\/community.anaplan.com\/profile\/mahendrawijaya","photoUrl":"https:\/\/w3.vanillicon.com\/v2\/3b3bb1f1cd0db8ac22d1b8b5908a237d.svg","dateLastActive":"2023-03-01T02:01:19+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":78268,"lastUser":{"userID":78268,"name":"jagadishdash","url":"https:\/\/community.anaplan.com\/profile\/jagadishdash","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78268.png","dateLastActive":"2023-02-26T08:43:17+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":31,"score":null,"hot":3353657614,"url":"https:\/\/community.anaplan.com\/discussion\/154951\/1-5-6-2-import-data-into-historic-volumes-module-need-some-help","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154951\/1-5-6-2-import-data-into-historic-volumes-module-need-some-help","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/MXWOFYM9E7VJ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-19T10:29:08+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":133112,"type":"discussion","name":"2.3.8.2 Import into DEM01 Module","excerpt":"Hello All I m stuck in this activity, can you tell me if my mapping is correct ? I think that the probleme is with the time mapping, i actually change the time scale to month bu stell have this error: Help me please , Thank you ","categoryID":182,"dateInserted":"2022-03-01T02:59:32+00:00","dateUpdated":null,"dateLastComment":"2023-02-20T02:24:33+00:00","insertUserID":71441,"insertUser":{"userID":71441,"name":"Dedef","url":"https:\/\/community.anaplan.com\/profile\/Dedef","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/71441.svg","dateLastActive":"2022-11-16T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":105623,"lastUser":{"userID":105623,"name":"anaka","url":"https:\/\/community.anaplan.com\/profile\/anaka","photoUrl":"https:\/\/w4.vanillicon.com\/v2\/470f3de2a43309e702575bb8811a94ba.svg","dateLastActive":"2023-03-01T03:27:09+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":74,"score":null,"hot":3322967645,"url":"https:\/\/community.anaplan.com\/discussion\/133112\/2-3-8-2-import-into-dem01-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/133112\/2-3-8-2-import-into-dem01-module","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Dedef_0-1646132145592_133112.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Dedef_0-1646132145592.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy and learning discussions","url":"https:\/\/community.anaplan.com\/categories\/academy-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":69347,"type":"idea","name":"Import Saved View - Filter","excerpt":"Hi all, A bit surprised this topic isn't here as it's one of the most common frustrations, similar to the post here. When importing from a filtered saved view there are a lot of cases of missing values. We all encounter it, and the first time it takes very long to determine the root cause. We change the filters but then…","categoryID":164,"dateInserted":"2020-05-06T03:40:20+00:00","dateUpdated":null,"dateLastComment":"2023-02-18T15:18:29+00:00","insertUserID":17782,"insertUser":{"userID":17782,"name":"MaartenGijbels","url":"https:\/\/community.anaplan.com\/profile\/MaartenGijbels","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17782.png","dateLastActive":"2021-12-08T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":17053,"lastUser":{"userID":17053,"name":"david.savarin","url":"https:\/\/community.anaplan.com\/profile\/david.savarin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17053.jpeg","dateLastActive":"2023-02-27T22:52:28+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":2,"score":19,"hot":3265476829,"url":"https:\/\/community.anaplan.com\/discussion\/69347\/import-saved-view-filter","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/69347\/import-saved-view-filter","format":"html","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/MaartenGijbels_0-1588761537963_69347.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"MaartenGijbels_0-1588761537963.png"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154943,"type":"question","name":"Hello,","excerpt":"I have a module dimensioned by Accounts on the rows, Users on the columns, and 1 Boolean line item which allows users to select certain accounts that apply only for that user. I am trying to create an action that allows the user to clear all of their selection by simply clicking an action button, as opposed to have click…","categoryID":19,"dateInserted":"2023-02-17T13:55:18+00:00","dateUpdated":null,"dateLastComment":"2023-02-17T17:07:06+00:00","insertUserID":74972,"insertUser":{"userID":74972,"name":"ROliveros","url":"https:\/\/community.anaplan.com\/profile\/ROliveros","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/74972.png","dateLastActive":"2023-02-17T17:07:13+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":74972,"lastUser":{"userID":74972,"name":"ROliveros","url":"https:\/\/community.anaplan.com\/profile\/ROliveros","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/74972.png","dateLastActive":"2023-02-17T17:07:13+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":22,"score":null,"hot":3353296944,"url":"https:\/\/community.anaplan.com\/discussion\/154943\/hello","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154943\/hello","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-17T17:07:11+00:00","dateAnswered":"2023-02-17T14:08:06+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":48,"urlcode":"Model-Builder","name":"Model Builder"},{"tagID":58,"urlcode":"Workflow","name":"Workflow"},{"tagID":1111,"urlcode":"anaplan-community","name":"Anaplan Community"},{"tagID":1123,"urlcode":"user-experience","name":"User Experience"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":112945,"type":"idea","name":"Ability to combine processes across models in CloudWorks","excerpt":"The use case is to orchestrate a data integration workflow in one CloudWorks schedule containing steps executing model-to-model imports from many processes residing in various models, e.g. update DataHuab lists and modules, then update planning model lists and modules, then update reporting model lists and update.","categoryID":164,"dateInserted":"2021-06-30T02:35:34+00:00","dateUpdated":null,"dateLastComment":"2023-02-14T23:20:11+00:00","insertUserID":78,"insertUser":{"userID":78,"name":"Moritz","url":"https:\/\/community.anaplan.com\/profile\/Moritz","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78.jpeg","dateLastActive":"2021-09-08T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":52231,"lastUser":{"userID":52231,"name":"AshwinK","url":"https:\/\/community.anaplan.com\/profile\/AshwinK","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/52231.png","dateLastActive":"2023-02-28T23:04:25+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":33,"score":38,"hot":3301454145,"url":"https:\/\/community.anaplan.com\/discussion\/112945\/ability-to-combine-processes-across-models-in-cloudworks","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/112945\/ability-to-combine-processes-across-models-in-cloudworks","format":"html","groupID":null,"statusID":10007,"attributes":{"idea":{"statusNotes":null,"statusID":10007,"status":{"name":"On Roadmap","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":58,"urlcode":"Workflow","name":"Workflow"},{"tagID":1098,"urlcode":"On Roadmap","name":"On Roadmap"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":151469,"type":"idea","name":"Sort Workspaces in Model>Model Import View","excerpt":"When setting up an import and selecting the \"Connect to Anaplan Model\" option, if you need to navigate to a different Workspace, you may be in for a bit of a maze. The workspaces are randomly sorted today, when nearly every other view (manage models from home page, new breadcrumb navigation in updated modeling experience)…","categoryID":132,"dateInserted":"2022-11-07T13:34:39+00:00","dateUpdated":"2022-11-07T00:00:00+00:00","dateLastComment":"2023-02-14T22:24:54+00:00","insertUserID":14281,"insertUser":{"userID":14281,"name":"rachel.bisch","url":"https:\/\/community.anaplan.com\/profile\/rachel.bisch","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14281.png","dateLastActive":"2023-02-13T22:49:35+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":71046,"lastUser":{"userID":71046,"name":"SriG","url":"https:\/\/community.anaplan.com\/profile\/SriG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/71046.png","dateLastActive":"2023-02-14T22:18:46+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":3,"score":6,"hot":3344243973,"url":"https:\/\/community.anaplan.com\/discussion\/151469\/sort-workspaces-in-model-model-import-view","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/151469\/sort-workspaces-in-model-model-import-view","format":"Html","groupID":null,"statusID":1,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":132,"name":"Modeling Ideas","url":"https:\/\/community.anaplan.com\/categories\/Modeling-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":63951,"type":"idea","name":"Remove Line Item Mapping when Item is Removed from Import Data Source","excerpt":"Within the Line Items tab of the import dialogue, please can line item sources be removed when these are removed from the import data source. Take the below as an example: If I were to remove Revenue from the import data source, the Revenue line item source would still appear on the left to be mapped to a line item target.…","categoryID":164,"dateInserted":"2020-03-17T05:05:23+00:00","dateUpdated":null,"dateLastComment":"2023-02-11T11:12:47+00:00","insertUserID":22802,"insertUser":{"userID":22802,"name":"Nicolas Cadier","url":"https:\/\/community.anaplan.com\/profile\/Nicolas%20Cadier","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22802.jpeg","dateLastActive":"2023-02-12T12:39:28+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":89540,"lastUser":{"userID":89540,"name":"CandaceCranney","url":"https:\/\/community.anaplan.com\/profile\/CandaceCranney","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/89540.png","dateLastActive":"2023-02-26T23:05:38+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":2,"score":4,"hot":3260538490,"url":"https:\/\/community.anaplan.com\/discussion\/63951\/remove-line-item-mapping-when-item-is-removed-from-import-data-source","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/63951\/remove-line-item-mapping-when-item-is-removed-from-import-data-source","format":"html","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Line_Items_63951.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Line Items.png"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":47962,"type":"question","name":"Exporting data to different tabs in excel","excerpt":"I'd looking for something that I think I've seen in other systems referred to as \"explode\" functionality, which would effectively create a new excel tab for every list item and export to that tab. So, if I have a department list (for example), I'd like to export data to excel and have a tab show up with the data for each…","categoryID":21,"dateInserted":"2019-06-27T14:10:25+00:00","dateUpdated":null,"dateLastComment":"2023-02-10T03:11:58+00:00","insertUserID":7722,"insertUser":{"userID":7722,"name":"jbrass","url":"https:\/\/community.anaplan.com\/profile\/jbrass","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/7722.jpeg","dateLastActive":"2022-10-05T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":5598,"lastUser":{"userID":5598,"name":"neeti","url":"https:\/\/community.anaplan.com\/profile\/neeti","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/5598.png","dateLastActive":"2023-02-14T21:52:55+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3237645143,"url":"https:\/\/community.anaplan.com\/discussion\/47962\/exporting-data-to-different-tabs-in-excel","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/47962\/exporting-data-to-different-tabs-in-excel","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2019-06-27T14:52:32+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":21,"name":"Integrations and extensibility","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":154874,"type":"discussion","name":"Wrong date when doing an import","excerpt":"Hi everyone, I am importing data into a module which gives me the employment date of a list of employees (among other info). The module doesn't use time as a dimension. The import goes perfectly well, it doesn't mention any error. But then some of the dates are wrong. So I tried to copy these directly from Excel (simple…","categoryID":19,"dateInserted":"2023-02-09T05:41:05+00:00","dateUpdated":"2023-02-09T16:30:18+00:00","dateLastComment":"2023-02-09T05:41:05+00:00","insertUserID":69098,"insertUser":{"userID":69098,"name":"FlavieBR","url":"https:\/\/community.anaplan.com\/profile\/FlavieBR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/69098.svg","dateLastActive":"2023-02-22T15:28:55+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":69098,"lastUser":{"userID":69098,"name":"FlavieBR","url":"https:\/\/community.anaplan.com\/profile\/FlavieBR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/69098.svg","dateLastActive":"2023-02-22T15:28:55+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":1,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/154874\/wrong-date-when-doing-an-import","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154874\/wrong-date-when-doing-an-import","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":19,"name":"Modeling","url":"https:\/\/community.anaplan.com\/categories\/modeling-discussions","allowedDiscussionTypes":["question"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":144064,"type":"idea","name":"Workflow triggers Import\/Export","excerpt":"Having CloudWorks schedule imports between models is useful, but users still need to wait. Our users are participating in a workflow, data is ready to move from the source model when a workflow step is completed. Can we trigger imports or exports, or model-to-model imports from workflow?","categoryID":164,"dateInserted":"2022-08-04T08:06:42+00:00","dateUpdated":null,"dateLastComment":"2023-02-08T01:54:49+00:00","insertUserID":7970,"insertUser":{"userID":7970,"name":"michael.moore","url":"https:\/\/community.anaplan.com\/profile\/michael.moore","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/7970.jpeg","dateLastActive":"2023-02-28T13:38:31+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":52231,"lastUser":{"userID":52231,"name":"AshwinK","url":"https:\/\/community.anaplan.com\/profile\/AshwinK","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/52231.png","dateLastActive":"2023-02-28T23:04:25+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":13,"score":9,"hot":3335424991,"url":"https:\/\/community.anaplan.com\/discussion\/144064\/workflow-triggers-import-export","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/144064\/workflow-triggers-import-export","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":58,"urlcode":"Workflow","name":"Workflow"},{"tagID":214,"urlcode":"CloudWorks","name":"CloudWorks"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":53560,"type":"idea","name":"Export - Data Source","excerpt":"Hi Community, I am thinking that would be very beneficial for model builders to have the possibility to view Data Sources for Export Definitions. For the large models with lots of external integrations and different export actions is pretty difficult to follow the source of a particular export if you can have dozens of…","categoryID":164,"dateInserted":"2019-10-28T08:39:19+00:00","dateUpdated":null,"dateLastComment":"2023-02-06T18:45:35+00:00","insertUserID":12380,"insertUser":{"userID":12380,"name":"Alexandru.Rosca","url":"https:\/\/community.anaplan.com\/profile\/Alexandru.Rosca","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/12380.png","dateLastActive":"2023-02-24T12:47:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":88494,"lastUser":{"userID":88494,"name":"DavidHunter","url":"https:\/\/community.anaplan.com\/profile\/DavidHunter","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/4124CEMOL8UW\/n2J171D7IDUAI.jpg","dateLastActive":"2023-02-16T22:10:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":13,"score":18,"hot":3247971294,"url":"https:\/\/community.anaplan.com\/discussion\/53560\/export-data-source","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/53560\/export-data-source","format":"html","groupID":null,"statusID":10005,"attributes":{"idea":{"statusNotes":null,"statusID":10005,"status":{"name":"In Review","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1065,"urlcode":"In Review","name":"In Review"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":93145,"type":"idea","name":"Export defined in a model should be connected to a view","excerpt":"Hello Team, Currently, when we create exports and save them in actions - they are disconnected from real module views. Example: if you create a new export definition, based on a current view (with a filter or smth else) it is not possible to revisit and amend this view after some time and see what view is feeding an export…","categoryID":164,"dateInserted":"2020-12-10T08:01:56+00:00","dateUpdated":null,"dateLastComment":"2023-02-06T18:42:05+00:00","insertUserID":568,"insertUser":{"userID":568,"name":"nikolay_denisov","url":"https:\/\/community.anaplan.com\/profile\/nikolay_denisov","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/568.jpeg","dateLastActive":"2023-01-31T13:35:36+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":88494,"lastUser":{"userID":88494,"name":"DavidHunter","url":"https:\/\/community.anaplan.com\/profile\/DavidHunter","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/4124CEMOL8UW\/n2J171D7IDUAI.jpg","dateLastActive":"2023-02-16T22:10:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":2,"score":1,"hot":3283297141,"url":"https:\/\/community.anaplan.com\/discussion\/93145\/export-defined-in-a-model-should-be-connected-to-a-view","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/93145\/export-defined-in-a-model-should-be-connected-to-a-view","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":106819,"type":"idea","name":"Update Current Timestamp by adding a New Action Type","excerpt":"As workspace admin, I would like to have the possibility to update the current timestamp in UTC timezone by having a New Action type created ( similar to the below picture ). This could work in a very similar way as the very nice new feature \"Update Current Period\": 1. Create in a module without any dimensions a line-item…","categoryID":164,"dateInserted":"2021-04-30T04:42:36+00:00","dateUpdated":null,"dateLastComment":"2023-02-06T17:49:24+00:00","insertUserID":3647,"insertUser":{"userID":3647,"name":"alexpavel","url":"https:\/\/community.anaplan.com\/profile\/alexpavel","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3647.jpeg","dateLastActive":"2023-02-27T06:10:08+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":1474,"lastUser":{"userID":1474,"name":"Antonio_Flor","url":"https:\/\/community.anaplan.com\/profile\/Antonio_Flor","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/1474.jpeg","dateLastActive":"2023-03-01T10:33:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":35,"score":33,"hot":3295477020,"url":"https:\/\/community.anaplan.com\/discussion\/106819\/update-current-timestamp-by-adding-a-new-action-type","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/106819\/update-current-timestamp-by-adding-a-new-action-type","format":"html","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/alexpavel_0-1619782111982_106819.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"alexpavel_0-1619782111982.png"},"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":150473,"type":"idea","name":"Power BI Enhancements\/Limitations","excerpt":"The following will be primarily based on my recent experiences with the Power BI Connector and Anaplan. Positives: 1. The Authentication has much improved and the use of SSO relieves a lot of data concerns when creating Power BI Reports. 2. Able to run multiple exports into the same model Negatives: In my experience and…","categoryID":164,"dateInserted":"2022-10-28T11:33:13+00:00","dateUpdated":null,"dateLastComment":"2023-02-04T12:06:37+00:00","insertUserID":8417,"insertUser":{"userID":8417,"name":"StevenK","url":"https:\/\/community.anaplan.com\/profile\/StevenK","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8417.jpeg","dateLastActive":"2023-02-09T15:20:11+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":17053,"lastUser":{"userID":17053,"name":"david.savarin","url":"https:\/\/community.anaplan.com\/profile\/david.savarin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17053.jpeg","dateLastActive":"2023-02-27T22:52:28+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":4,"hot":3342470990,"url":"https:\/\/community.anaplan.com\/discussion\/150473\/power-bi-enhancements-limitations","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/150473\/power-bi-enhancements-limitations","format":"html","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"New","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":164,"name":"Integration and Extensibility Ideas","url":"https:\/\/community.anaplan.com\/categories\/integrations-and-extensibility-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">