Importing and Exporting Data

"},"updateUserID":365,"lastUserID":54023,"lastUser":{"userID":54023,"name":"gfraviseo","url":"https:\/\/community.anaplan.com\/profile\/gfraviseo","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/54023.png","dateLastActive":"2023-09-19T16:32:23+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":708,"score":null,"hot":3235419471,"url":"https:\/\/community.anaplan.com\/discussion\/43589\/sap-s-4-hana-sap-po-to-anaplan-integration-best-practices","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/43589\/sap-s-4-hana-sap-po-to-anaplan-integration-best-practices","format":"rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2019-04-01T14:04:59+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":38501,"type":"idea","name":"Set the fields in a certain order that will not change for exports and have alias headers","excerpt":"For downstream systems, the headers must have specific names that are not related to how the Planners use Anaplan. Also, some of the downstream systems are very specific about the order of the fields in the export. When Anaplan has to adapt to business changes, the export to the downstream systems has to remain constant or…","categoryID":164,"dateInserted":"2018-11-08T15:15:08+00:00","dateUpdated":null,"dateLastComment":"2023-04-10T07:40:01+00:00","insertUserID":5661,"insertUser":{"userID":5661,"name":"AlineKoch","url":"https:\/\/community.anaplan.com\/profile\/AlineKoch","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/5661.png","dateLastActive":"2022-10-13T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":34300,"lastUser":{"userID":34300,"name":"licx13","url":"https:\/\/community.anaplan.com\/profile\/licx13","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/34300.png","dateLastActive":"2023-08-29T03:23:28+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":1,"score":1,"hot":3222804009,"url":"https:\/\/community.anaplan.com\/discussion\/38501\/set-the-fields-in-a-certain-order-that-will-not-change-for-exports-and-have-alias-headers","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/38501\/set-the-fields-in-a-certain-order-that-will-not-change-for-exports-and-have-alias-headers","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":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-04-10T07:32:30+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-08-29T21:16:20+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":80710,"lastUserID":76451,"lastUser":{"userID":76451,"name":"Manisharani","url":"https:\/\/community.anaplan.com\/profile\/Manisharani","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/76451.svg","dateLastActive":"2023-09-13T06:15:13+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":53,"score":null,"hot":3358139105,"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":155365,"type":"question","name":"Does file ID change if I update the import source for an action?","excerpt":"Hi all, We are testing bulk API's data import, on which I had 2 queries. Suppose I create an action in Anaplan for a file and then data in loaded using bulk API's, but later I went to manage import data sources and updated the import source of that action with a new file. Will this change the file ID of the file which is…","categoryID":21,"dateInserted":"2023-04-05T12:07:52+00:00","dateUpdated":null,"dateLastComment":"2023-04-06T08:01:55+00:00","insertUserID":48320,"insertUser":{"userID":48320,"name":"Shawnm","url":"https:\/\/community.anaplan.com\/profile\/Shawnm","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/48320.png","dateLastActive":"2023-09-11T13:19:34+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":29855,"lastUser":{"userID":29855,"name":"pyrypeura","url":"https:\/\/community.anaplan.com\/profile\/pyrypeura","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/QTL29AQOL3AO\/n9J3A3U1AHAFF.jpg","dateLastActive":"2023-09-19T17:27:55+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":null,"hot":3361465187,"url":"https:\/\/community.anaplan.com\/discussion\/155365\/does-file-id-change-if-i-update-the-import-source-for-an-action","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155365\/does-file-id-change-if-i-update-the-import-source-for-an-action","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-06T08:01: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"},{"tagID":214,"urlcode":"CloudWorks","name":"CloudWorks"},{"tagID":461,"urlcode":"Data","name":"Data"},{"tagID":1108,"urlcode":"data-hub","name":"Data Hub"},{"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":155372,"type":"idea","name":"Building Imports quicker\/Implement import button in Imports tab","excerpt":"Hello, We had a need to trace the data flows into a number of modules and line items. In the case where there is a formula relationship, it does not present difficulties, but not in case of imports creation. We do have access to information from the Imports tab, from the Actions section. But it is only helpfull when you…","categoryID":164,"dateInserted":"2023-04-06T05:53:05+00:00","dateUpdated":null,"dateLastComment":"2023-04-06T05:53:05+00:00","insertUserID":109320,"insertUser":{"userID":109320,"name":"Yerzhan","url":"https:\/\/community.anaplan.com\/profile\/Yerzhan","photoUrl":"https:\/\/we.vanillicon.com\/v2\/e713ea749b3d935e46c22d5c0b4bf37b.svg","dateLastActive":"2023-05-18T05:29:17+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":109320,"lastUser":{"userID":109320,"name":"Yerzhan","url":"https:\/\/community.anaplan.com\/profile\/Yerzhan","photoUrl":"https:\/\/we.vanillicon.com\/v2\/e713ea749b3d935e46c22d5c0b4bf37b.svg","dateLastActive":"2023-05-18T05:29:17+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":11,"score":2,"hot":1680760985,"url":"https:\/\/community.anaplan.com\/discussion\/155372\/building-imports-quicker-implement-import-button-in-imports-tab","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155372\/building-imports-quicker-implement-import-button-in-imports-tab","format":"Rich2","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/HAXY7BV02LJD\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.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"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":100824,"type":"question","name":"MB Level 2 Sprint 1: 1.5.2 Activity: Import Data into Beginning Inventory","excerpt":"Hi, I currently trouble importing data into the DAT01 Beginning Inventory module. Kindly advise.","categoryID":182,"dateInserted":"2021-03-11T01:19:45+00:00","dateUpdated":"2023-03-17T00:52:30+00:00","dateLastComment":"2023-04-06T05:29:55+00:00","insertUserID":43436,"insertUser":{"userID":43436,"name":"DarrenS","url":"https:\/\/community.anaplan.com\/profile\/DarrenS","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/43436.png","dateLastActive":"2021-08-15T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":365,"lastUserID":93268,"lastUser":{"userID":93268,"name":"mathallica","url":"https:\/\/community.anaplan.com\/profile\/mathallica","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/93268.png","dateLastActive":"2023-05-31T21:57:27+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":281,"score":null,"hot":3296192980,"url":"https:\/\/community.anaplan.com\/discussion\/100824\/mb-level-2-sprint-1-1-5-2-activity-import-data-into-beginning-inventory","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/100824\/mb-level-2-sprint-1-1-5-2-activity-import-data-into-beginning-inventory","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2021-03-11T01:22:41+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":182,"name":"Academy 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":155194,"type":"idea","name":"Transactionnal API - Direct Query with JSON Line \/ Parsing ?!?","excerpt":"Hello, I am looking currently at the Transactionnal API. I see great usage associated to Transactionnal API reading function for direct reporting through third party tool (ex : POWERBI), which offer more thank BULK API. This call help you to direct query a view : Currently, the documentation show a limitation of cells able…","categoryID":164,"dateInserted":"2023-03-16T15:29:00+00:00","dateUpdated":null,"dateLastComment":"2023-04-04T19:43:06+00:00","insertUserID":28300,"insertUser":{"userID":28300,"name":"Nico","url":"https:\/\/community.anaplan.com\/profile\/Nico","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/X7DDKQBFAGT2\/nAPVQW1BO0PM3.jpeg","dateLastActive":"2023-07-17T13:50:25+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\/uploads\/userpics\/JZ20AV78NWHQ\/nU4U3WC5L4KKL.jpg","dateLastActive":"2023-09-18T04:24:57+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":41,"score":2,"hot":3359620326,"url":"https:\/\/community.anaplan.com\/discussion\/155194\/transactionnal-api-direct-query-with-json-line-parsing","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155194\/transactionnal-api-direct-query-with-json-line-parsing","format":"Rich2","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/Y8D8ODAGPMCX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.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":29,"urlcode":"Reporting-and-Analytics","name":"Reporting and Analytics"},{"tagID":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"tagID":719,"urlcode":"Developer","name":"Developer"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1111,"urlcode":"anaplan-community","name":"Anaplan Community"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155166,"type":"question","name":"Import Sources","excerpt":"Hello Anaplan community, There are several notions related to import sources that I have trouble comprehending. These are : Source Labels, Source object, Source model (in Actions) and Source models. I can not understand what each term means, what is the difference between them, how should I manage the import sources in ALM…","categoryID":19,"dateInserted":"2023-03-14T13:13:37+00:00","dateUpdated":"2023-03-14T13:19:26+00:00","dateLastComment":"2023-04-04T12:48:57+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-09-19T15:00:21+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":84448,"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-09-19T15:00:21+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":71,"score":null,"hot":3359413354,"url":"https:\/\/community.anaplan.com\/discussion\/155166\/import-sources","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155166\/import-sources","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-15T08:20:09+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":1125,"urlcode":"application-lifecycle-management","name":"Application Lifecycle Management"}],"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":155327,"type":"discussion","name":"Share your experiences: Preparing Data for Anaplan","excerpt":"The Anaplan User Experience Research team is looking to speak with users who are involved in the data preparation process: determining what data is required, getting data correctly formatted, ingesting data to Anaplan, etc. We invite you to join us for a 60-minute, remote research interview during which you will be asked…","categoryID":192,"dateInserted":"2023-03-31T07:48:36+00:00","dateUpdated":"2023-04-06T17:00:46+00:00","dateLastComment":"2023-03-31T07:48:36+00:00","insertUserID":61288,"insertUser":{"userID":61288,"name":"KatO","title":"Principal UX Researcher","url":"https:\/\/community.anaplan.com\/profile\/KatO","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/61288.jpeg","dateLastActive":"2023-09-05T09:33:27+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":67811,"lastUserID":61288,"lastUser":{"userID":61288,"name":"KatO","title":"Principal UX Researcher","url":"https:\/\/community.anaplan.com\/profile\/KatO","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/61288.jpeg","dateLastActive":"2023-09-05T09:33:27+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":true,"pinLocation":"category","closed":false,"sink":false,"countComments":0,"countViews":11,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/155327\/share-your-experiences-preparing-data-for-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155327\/share-your-experiences-preparing-data-for-anaplan","format":"Rich2","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":192,"name":"User Research Group","url":"https:\/\/anaplan.vanillacommunities.com\/group\/62-user-research-program","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":461,"urlcode":"Data","name":"Data"},{"tagID":644,"urlcode":"UX-Research","name":"UX Research"},{"tagID":1108,"urlcode":"data-hub","name":"Data Hub"},{"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":130666,"type":"question","name":"Anaplan SAP Integration","excerpt":"Hi Community, we want to integrate SAP and Anaplan, but client has asked not to use any files for integration, so is it possible to load the data from SAP to Anaplan with API in json format? and how to map the fields. Please suggest","categoryID":21,"dateInserted":"2022-01-24T23:03:41+00:00","dateUpdated":null,"dateLastComment":"2023-03-30T13:41:50+00:00","insertUserID":39644,"insertUser":{"userID":39644,"name":"swapnil_J","url":"https:\/\/community.anaplan.com\/profile\/swapnil_J","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/39644.png","dateLastActive":"2023-08-01T07:03:45+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":107469,"lastUser":{"userID":107469,"name":"virendevi","url":"https:\/\/community.anaplan.com\/profile\/virendevi","photoUrl":"https:\/\/we.vanillicon.com\/v2\/ed39678bcdda43384f2c4ec415dd3053.svg","dateLastActive":"2023-04-18T13:16:53+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":1293,"score":null,"hot":3323250931,"url":"https:\/\/community.anaplan.com\/discussion\/130666\/anaplan-sap-integration","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/130666\/anaplan-sap-integration","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-24T23:36:00+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":155214,"type":"idea","name":"Possibility to put a process into a process","excerpt":"Right now we have a large integration process with ~240 actions importing data from 8 different models into our Data Hub. As you might imagine, it's difficult to determine the right order of actions with the current interface. I would like to have 8 sub-processes (e.g. 1 per model) to have a better overview of the content.…","categoryID":132,"dateInserted":"2023-03-20T13:28:45+00:00","dateUpdated":null,"dateLastComment":"2023-03-27T18:47:40+00:00","insertUserID":16180,"insertUser":{"userID":16180,"name":"DEFLOTHE","url":"https:\/\/community.anaplan.com\/profile\/DEFLOTHE","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/16180.png","dateLastActive":"2023-08-31T08:15:17+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-05-05T20:41:51+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":4,"hot":3359264785,"url":"https:\/\/community.anaplan.com\/discussion\/155214\/possibility-to-put-a-process-into-a-process","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155214\/possibility-to-put-a-process-into-a-process","format":"Rich2","groupID":null,"statusID":10000,"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":214,"urlcode":"CloudWorks","name":"CloudWorks"},{"tagID":1097,"urlcode":"New","name":"New"},{"tagID":1108,"urlcode":"data-hub","name":"Data Hub"}],"reactions":[{"tagID":1087,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":155269,"type":"question","name":"Exports into .txt file","excerpt":"Hello, I have a module dimensioned by fake time and need to export it into a .txt file. Because of business processes, I need fake time and the line items in columns unested. Is there a way for Anaplan to accomplish this? Thanks.","categoryID":19,"dateInserted":"2023-03-27T14:11:23+00:00","dateUpdated":null,"dateLastComment":"2023-03-27T16:53:36+00:00","insertUserID":93643,"insertUser":{"userID":93643,"name":"JR1010","url":"https:\/\/community.anaplan.com\/profile\/JR1010","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/93643.png","dateLastActive":"2023-07-11T14:54:10+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":64111,"lastUser":{"userID":64111,"name":"BrunoRodriguez","url":"https:\/\/community.anaplan.com\/profile\/BrunoRodriguez","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/64111.jpeg","dateLastActive":"2023-09-13T10:02:33+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":12,"score":null,"hot":3359862899,"url":"https:\/\/community.anaplan.com\/discussion\/155269\/exports-into-txt-file","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155269\/exports-into-txt-file","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-27T16:53:36+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":62498,"type":"idea","name":"'Used in Dashboards' and 'Used in Action\/Import' for SAVED VIEWS","excerpt":"When performing model clean-up's OR revising actions \/ New UX dashboards, it would REALLY helpful to have a view within the model settings area to review the full list of SAVED views along with the following key information; * 'Used in Dashboards' * 'Used in Actions\/Processes' * 'Used in New UX Dashboards' ","categoryID":164,"dateInserted":"2020-03-05T00:49:45+00:00","dateUpdated":null,"dateLastComment":"2023-03-27T06:38:30+00:00","insertUserID":8248,"insertUser":{"userID":8248,"name":"Jcorlett","url":"https:\/\/community.anaplan.com\/profile\/Jcorlett","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8248.jpeg","dateLastActive":"2022-10-05T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":76451,"lastUser":{"userID":76451,"name":"Manisharani","url":"https:\/\/community.anaplan.com\/profile\/Manisharani","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/76451.svg","dateLastActive":"2023-09-13T06:15:13+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":16,"countViews":91,"score":102,"hot":3263308695,"url":"https:\/\/community.anaplan.com\/discussion\/62498\/used-in-dashboards-and-used-in-action-import-for-saved-views","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/62498\/used-in-dashboards-and-used-in-action-import-for-saved-views","format":"html","groupID":null,"statusID":0,"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":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":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-03-22T13:41:47+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":"2023-09-18T18:49:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":3647,"lastUser":{"userID":3647,"name":"alexpavel","url":"https:\/\/community.anaplan.com\/profile\/alexpavel","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3647.jpeg","dateLastActive":"2023-09-13T07:25:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":141,"score":68,"hot":3226459312,"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":155227,"type":"discussion","name":"Share your Experiences of Data Preparation Processes in Anaplan","excerpt":"The Anaplan User Experience Research team is looking to speak with users who are involved in the data preparation process: determining what data is required, getting data correctly formatted, ingesting data to Anaplan, etc. We invite you to join us for a 60-minute, remote research interview during which you will be asked…","categoryID":192,"dateInserted":"2023-03-22T09:27:59+00:00","dateUpdated":"2023-04-06T17:00:45+00:00","dateLastComment":"2023-03-22T09:27:59+00:00","insertUserID":61288,"insertUser":{"userID":61288,"name":"KatO","title":"Principal UX Researcher","url":"https:\/\/community.anaplan.com\/profile\/KatO","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/61288.jpeg","dateLastActive":"2023-09-05T09:33:27+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":67811,"lastUserID":61288,"lastUser":{"userID":61288,"name":"KatO","title":"Principal UX Researcher","url":"https:\/\/community.anaplan.com\/profile\/KatO","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/61288.jpeg","dateLastActive":"2023-09-05T09:33:27+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\/155227\/share-your-experiences-of-data-preparation-processes-in-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155227\/share-your-experiences-of-data-preparation-processes-in-anaplan","format":"Rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/FEZN61T0KGCU\/officeandbusiness-twopersondiscussion3-1600x900-imageonly.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"office and business two person discussion"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":192,"name":"User Research Group","url":"https:\/\/anaplan.vanillacommunities.com\/group\/62-user-research-program","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":461,"urlcode":"Data","name":"Data"},{"tagID":644,"urlcode":"UX-Research","name":"UX Research"},{"tagID":1108,"urlcode":"data-hub","name":"Data Hub"},{"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":155174,"type":"question","name":"Selective Access and Tabular Multiple Column Exports","excerpt":"I have defined an export using the Tabular Multiple Column layout, filtering using a Boolean from a separate module. The module being exported uses a list with Selective Access. When I try to limit my access and run the export, to test how an end user would interact with the export, the model exports rows for ALL members…","categoryID":21,"dateInserted":"2023-03-14T18:18:55+00:00","dateUpdated":null,"dateLastComment":"2023-03-20T18:22:36+00:00","insertUserID":11066,"insertUser":{"userID":11066,"name":"dameyer01","url":"https:\/\/community.anaplan.com\/profile\/dameyer01","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11066.jpeg","dateLastActive":"2023-09-18T14:48:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":11066,"lastUser":{"userID":11066,"name":"dameyer01","url":"https:\/\/community.anaplan.com\/profile\/dameyer01","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11066.jpeg","dateLastActive":"2023-09-18T14:48:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":41,"score":null,"hot":3358155691,"url":"https:\/\/community.anaplan.com\/discussion\/155174\/selective-access-and-tabular-multiple-column-exports","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155174\/selective-access-and-tabular-multiple-column-exports","format":"Rich2","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-20T18:22:36+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":48,"urlcode":"Model-Builder","name":"Model Builder"},{"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":34351,"type":"idea","name":"Export line item codes","excerpt":"Description of the enhancement: To be able to export the line item codes instead of only the line item name. Description of business use: I have a financial statement report module where I have accounts as line items. This is because some of the accounts are calculated. We have a need to export this module with account…","categoryID":164,"dateInserted":"2018-07-16T07:09:47+00:00","dateUpdated":null,"dateLastComment":"2023-03-20T12:21:03+00:00","insertUserID":11518,"insertUser":{"userID":11518,"name":"AnaplanIdeas","url":"https:\/\/community.anaplan.com\/profile\/AnaplanIdeas","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11518.png","dateLastActive":"2019-08-21T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":28300,"lastUser":{"userID":28300,"name":"Nico","url":"https:\/\/community.anaplan.com\/profile\/Nico","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/X7DDKQBFAGT2\/nAPVQW1BO0PM3.jpeg","dateLastActive":"2023-07-17T13:50:25+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":195,"score":17,"hot":3211052750,"url":"https:\/\/community.anaplan.com\/discussion\/34351\/export-line-item-codes","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/34351\/export-line-item-codes","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":114801,"type":"question","name":"Anaplan API 2.0 Python Library Certificate Error","excerpt":"Hi, We are trying to change from basic authentication to using a certificate. I am using the Anaplan API 2.0 Python Library. When running AnaplanConnection function I am getting the following error that I traced to the anaplan_auth.py. TypeError: from_buffer() cannot return the address of a unicode object I have tried…","categoryID":21,"dateInserted":"2021-07-21T09:01:31+00:00","dateUpdated":null,"dateLastComment":"2023-03-16T16:55:12+00:00","insertUserID":52127,"insertUser":{"userID":52127,"name":"forestsummers","url":"https:\/\/community.anaplan.com\/profile\/forestsummers","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/52127.png","dateLastActive":"2023-08-30T21:18:39+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":29225,"lastUser":{"userID":29225,"name":"madeline.rasch","url":"https:\/\/community.anaplan.com\/profile\/madeline.rasch","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/29225.png","dateLastActive":"2023-07-13T18:41:29+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":64,"score":null,"hot":3305846803,"url":"https:\/\/community.anaplan.com\/discussion\/114801\/anaplan-api-2-0-python-library-certificate-error","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/114801\/anaplan-api-2-0-python-library-certificate-error","format":"html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2021-09-15T08:37:56+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":103434,"type":"question","name":"How to move or copy an excel spreadsheet without loosing connection","excerpt":"I'd like to merge 2 excel files. Both have anaplan connections. How can I move or copy excel spreadsheets to another file withour loosing my anaplan connection? ","categoryID":21,"dateInserted":"2021-03-30T08:13:31+00:00","dateUpdated":null,"dateLastComment":"2023-03-16T01:21:04+00:00","insertUserID":34604,"insertUser":{"userID":34604,"name":"dleamare","url":"https:\/\/community.anaplan.com\/profile\/dleamare","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/34604.png","dateLastActive":"2022-06-07T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":107556,"lastUser":{"userID":107556,"name":"markdrucker","url":"https:\/\/community.anaplan.com\/profile\/markdrucker","photoUrl":"https:\/\/w2.vanillicon.com\/v2\/2d22eb70796fa5c62a5d6306e94928eb.svg","dateLastActive":"2023-03-16T16:03:26+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":1,"hot":3296022575,"url":"https:\/\/community.anaplan.com\/discussion\/103434\/how-to-move-or-copy-an-excel-spreadsheet-without-loosing-connection","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/103434\/how-to-move-or-copy-an-excel-spreadsheet-without-loosing-connection","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-16T01:21:04+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":147268,"type":"question","name":"CloudWorks","excerpt":"Hi, I have just started using CloudWorks, it's a great Anaplan in-built tool for integrations and processes but does anyone have any idea how can we run subsequent process in it. for ex. I have a process A and process B in my model and I want to run in a manner that as soon as process A is complete, Process B should start…","categoryID":21,"dateInserted":"2022-09-19T01:22:53+00:00","dateUpdated":"2023-01-09T21:39:26+00:00","dateLastComment":"2023-03-15T19:31:28+00:00","insertUserID":26144,"insertUser":{"userID":26144,"name":"anmol1111","url":"https:\/\/community.anaplan.com\/profile\/anmol1111","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/26144.png","dateLastActive":"2022-11-17T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":17053,"lastUser":{"userID":17053,"name":"david.savarin","url":"https:\/\/community.anaplan.com\/profile\/david.savarin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/JZ20AV78NWHQ\/nU4U3WC5L4KKL.jpg","dateLastActive":"2023-09-18T04:24:57+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":112,"score":null,"hot":3342464061,"url":"https:\/\/community.anaplan.com\/discussion\/147268\/cloudworks","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/147268\/cloudworks","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-19T02:12:47+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":719,"urlcode":"Developer","name":"Developer"},{"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":33579,"type":"discussion","name":"RESTful API How To","excerpt":"You can interact with the data in your models using Anaplan's RESTful API. This enables you to securely import and export data, as well as run actions through any programmatic way you desire. The API can be leveraged in any custom integration, allowing for a wide range of integration solutions to be implemented. Completing…","categoryID":40,"dateInserted":"2018-05-31T13:32:46+00:00","dateUpdated":"2023-03-20T19:42:05+00:00","dateLastComment":"2023-03-15T18:11:09+00:00","insertUserID":302,"insertUser":{"userID":302,"name":"rupert_tagnipes","url":"https:\/\/community.anaplan.com\/profile\/rupert_tagnipes","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/302.png","dateLastActive":"2021-12-07T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":75258,"lastUserID":19357,"lastUser":{"userID":19357,"name":"bhill5","url":"https:\/\/community.anaplan.com\/profile\/bhill5","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/19357.jpeg","dateLastActive":"2023-09-07T19:42:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":1791,"score":8,"hot":3206681035,"url":"https:\/\/community.anaplan.com\/discussion\/33579\/restful-api-how-to","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/33579\/restful-api-how-to","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"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":65412,"type":"question","name":"SKU.csv file on level 1 exam","excerpt":"In the first part of the level 1 certification exam it tells you to create a new list using the SKU.csv file they give you. The SKU.csv file you download ends up being multiple files in one folder. When I try to import the one of the attached files (SKU) into my new list (P3 SKU) nothing happens on my screen. Then on the…","categoryID":21,"dateInserted":"2020-03-27T18:51:38+00:00","dateUpdated":null,"dateLastComment":"2023-03-14T04:58:04+00:00","insertUserID":28580,"insertUser":{"userID":28580,"name":"dl704756","url":"https:\/\/community.anaplan.com\/profile\/dl704756","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28580.png","dateLastActive":"2020-03-29T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":12489,"lastUser":{"userID":12489,"name":"AjayM","url":"https:\/\/community.anaplan.com\/profile\/AjayM","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/2WH9L4BNP18W\/n6X0H5VUY6ILY.jpg","dateLastActive":"2023-09-15T05:57:36+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":201,"score":null,"hot":3264108582,"url":"https:\/\/community.anaplan.com\/discussion\/65412\/sku-csv-file-on-level-1-exam","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/65412\/sku-csv-file-on-level-1-exam","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-03-27T19:15:29+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":52666,"type":"question","name":"How to calculate Anaplan model size?","excerpt":"Hi Guys I am using below calculation to find model size 1000000000 cells = 9.3 GB 1 cell = 9.3\/1000000000 Total cells exported from module export = 6206436639 which gives me 57.71986074 GB's problem is Anaplan shows model size as 39.29 Gb's ?. I have used this calculation on 8 models and all of these comes close to model…","categoryID":21,"dateInserted":"2019-10-03T00:21:41+00:00","dateUpdated":null,"dateLastComment":"2023-03-10T14:12:54+00:00","insertUserID":4578,"insertUser":{"userID":4578,"name":"karank_*4578","url":"https:\/\/community.anaplan.com\/profile\/karank_%2A4578","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4578.jpeg","dateLastActive":"2021-08-17T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":101908,"lastUser":{"userID":101908,"name":"Lolen","url":"https:\/\/community.anaplan.com\/profile\/Lolen","photoUrl":"https:\/\/w3.vanillicon.com\/v2\/32f29c75ea0cceef64d5d005e7e1b880.svg","dateLastActive":"2023-06-27T07:37:17+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":22,"countViews":1411,"score":null,"hot":3248532875,"url":"https:\/\/community.anaplan.com\/discussion\/52666\/how-to-calculate-anaplan-model-size","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/52666\/how-to-calculate-anaplan-model-size","format":"html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2019-10-03T00:38:08+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":154780,"type":"question","name":"Anaplan is not allow my export showing message Excel workbooks cannot support more than 65536 rows?","excerpt":"","categoryID":19,"dateInserted":"2023-01-31T12:13:49+00:00","dateUpdated":null,"dateLastComment":"2023-03-09T06:59:33+00:00","insertUserID":61630,"insertUser":{"userID":61630,"name":"AbhishekChatterjee14","url":"https:\/\/community.anaplan.com\/profile\/AbhishekChatterjee14","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/61630.jpeg","dateLastActive":"2023-03-31T11:48:07+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":54116,"lastUser":{"userID":54116,"name":"JohnnyC","url":"https:\/\/community.anaplan.com\/profile\/JohnnyC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/NOUUJGIYCSPF\/nNZ63N2J6Y0AV.jpg","dateLastActive":"2023-09-19T08:43:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":55,"score":null,"hot":3353514202,"url":"https:\/\/community.anaplan.com\/discussion\/154780\/anaplan-is-not-allow-my-export-showing-message-excel-workbooks-cannot-support-more-than-65536-rows","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154780\/anaplan-is-not-allow-my-export-showing-message-excel-workbooks-cannot-support-more-than-65536-rows","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/ZQI0N1L8N0DU\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-01-31T12:48:01+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":1111,"urlcode":"anaplan-community","name":"Anaplan Community"}],"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":104875,"type":"idea","name":"Google Sheets Add-on: Send formula driven figures back to Anaplan","excerpt":"The idea would be to receive information from Anaplan, have the ability to update the information using editable inputs (e.g increase sales forecast by 10%) and then send the result (of Anaplan data * 10%) back to the Anaplan module.","categoryID":164,"dateInserted":"2021-04-12T04:42:35+00:00","dateUpdated":null,"dateLastComment":"2023-03-09T04:26:21+00:00","insertUserID":3134,"insertUser":{"userID":3134,"name":"Paul","url":"https:\/\/community.anaplan.com\/profile\/Paul","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3134.jpeg","dateLastActive":"2023-09-19T16:01:23+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":107234,"lastUser":{"userID":107234,"name":"SachinAgarwal","url":"https:\/\/community.anaplan.com\/profile\/SachinAgarwal","photoUrl":"https:\/\/w8.vanillicon.com\/v2\/8e40eb1749421a8f09d9b035737978d7.svg","dateLastActive":"2023-03-09T08:34:22+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":58,"score":20,"hot":3296547536,"url":"https:\/\/community.anaplan.com\/discussion\/104875\/google-sheets-add-on-send-formula-driven-figures-back-to-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/104875\/google-sheets-add-on-send-formula-driven-figures-back-to-anaplan","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":24,"urlcode":"Extensions","name":"Extensions"},{"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":111077,"type":"question","name":"Import Shipping Expenses into OTH01 Module","excerpt":"Hi everyone, I'm still struggling with the import into the FP&A model (Level 2 Conclusion) Here's the mapping I have had: And here is the error I have got: Here's how my INV05 Shipping Export module looks like in a Blueprint mode: Is there any chance someone could help me, please?","categoryID":21,"dateInserted":"2021-06-10T06:22:44+00:00","dateUpdated":null,"dateLastComment":"2023-03-09T02:23:22+00:00","insertUserID":52676,"insertUser":{"userID":52676,"name":"katarina129","url":"https:\/\/community.anaplan.com\/profile\/katarina129","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/52676.png","dateLastActive":"2021-06-28T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":14648,"lastUser":{"userID":14648,"name":"Vinay VaradarajM","url":"https:\/\/community.anaplan.com\/profile\/Vinay%20VaradarajM","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14648.png","dateLastActive":"2023-08-24T02:46:33+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":399,"score":null,"hot":3301637166,"url":"https:\/\/community.anaplan.com\/discussion\/111077\/import-shipping-expenses-into-oth01-module","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/111077\/import-shipping-expenses-into-oth01-module","format":"html","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/2021-06-09_(4)_111077.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"2021-06-09 (4).png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-11-23T21:29:03+00:00","dateAnswered":"2021-06-10T07:33: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":155122,"type":"idea","name":"Clear all items reset to \"Match items in source\" when a dimensions mapped on \"Fixed item in\" or info","excerpt":"Recently I had and issue with a Model where the import setting “Which target items to clear prior to import?” was set to “All items” but not visible in the import screen because the Diemension was remaped to single item. Altough the Dimensions was mapped to a single item, it was still cleared all items but that setting was…","categoryID":132,"dateInserted":"2023-03-08T16:35:28+00:00","dateUpdated":null,"dateLastComment":"2023-03-08T16:35:28+00:00","insertUserID":1474,"insertUser":{"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-09-15T13:36:06+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-09-15T13:36:06+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":31,"score":2,"hot":1678293928,"url":"https:\/\/community.anaplan.com\/discussion\/155122\/clear-all-items-reset-to-match-items-in-source-when-a-dimensions-mapped-on-fixed-item-in-or-info","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155122\/clear-all-items-reset-to-match-items-in-source-when-a-dimensions-mapped-on-fixed-item-in-or-info","format":"Rich2","groupID":null,"statusID":10000,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/0SL56DYL2KW8\/clearallsettings.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ClearAllSettings.jpg"},"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":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":133155,"type":"discussion","name":"OEG Best Practice: Data integration decision app","excerpt":"We built this app to make getting started on your Anaplan data integration journey simple with a quick questionnaire and helpful information and links. A common question that arises during Anaplan implementations (or even after go-live) is \"How can I automate data feeds into and out of Anaplan?\" While the ultimate decision…","categoryID":40,"dateInserted":"2022-03-03T08:04:54+00:00","dateUpdated":"2023-01-18T17:52:39+00:00","dateLastComment":"2023-03-07T19:02:08+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"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-09-12T18:15:40+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":503,"score":46,"hot":3324529622,"url":"https:\/\/community.anaplan.com\/discussion\/133155\/oeg-best-practice-data-integration-decision-app","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/133155\/oeg-best-practice-data-integration-decision-app","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/anaplancommunity.s3.us-east-2.amazonaws.com\/VANILLA-Images\/data-integration-decision-app.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"},{"tagID":1137,"urlcode":"oeg-best-practice","name":"OEG Best Practice"}],"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":155114,"type":"discussion","name":"Community perspective: Flat-file Data Load - CSV Encoding Issues","excerpt":"Problem: In the same way we cannot load .txt files (usually tab-delimited) through a data load action originally created with a .csv (comma delimited file), trying to load .csv files with different encoding parameters can result in an issue too. This is the error message you will get in both cases (attempting to load a…","categoryID":40,"dateInserted":"2023-03-07T16:19:29+00:00","dateUpdated":"2023-05-12T16:24:29+00:00","dateLastComment":"2023-03-07T16:19:29+00:00","insertUserID":4836,"insertUser":{"userID":4836,"name":"AlejandroGomez","url":"https:\/\/community.anaplan.com\/profile\/AlejandroGomez","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4836.jpeg","dateLastActive":"2023-09-18T08:38:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":67811,"lastUserID":4836,"lastUser":{"userID":4836,"name":"AlejandroGomez","url":"https:\/\/community.anaplan.com\/profile\/AlejandroGomez","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4836.jpeg","dateLastActive":"2023-09-18T08:38:01+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":221,"score":9,"hot":3357192278,"url":"https:\/\/community.anaplan.com\/discussion\/155114\/community-perspective-flat-file-data-load-csv-encoding-issues","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155114\/community-perspective-flat-file-data-load-csv-encoding-issues","format":"Rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/VRW7U4SUOVGR\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"}],"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":155077,"type":"question","name":"Export data to .csv file from a module with page selector and filter is not working","excerpt":"Hi, Exporting data to CSV file from a module with page selector and filter is exporting incorrect results: Sample Data as per my example below, Anaplan is applying the filter (amount<>0) to the first month March 23 only. Zero's are getting exported for the intersections data available in first month (filter is not applied…","categoryID":19,"dateInserted":"2023-03-02T23:54:05+00:00","dateUpdated":"2023-03-03T16:10:12+00:00","dateLastComment":"2023-03-06T09:08:23+00:00","insertUserID":31140,"insertUser":{"userID":31140,"name":"Esa","url":"https:\/\/community.anaplan.com\/profile\/Esa","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/31140.png","dateLastActive":"2023-08-30T02:28:31+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":75258,"lastUserID":4770,"lastUser":{"userID":4770,"name":"andrewtye","url":"https:\/\/community.anaplan.com\/profile\/andrewtye","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/CGW5Z3W6P4BX\/nT7G5PS2GCDTY.jpg","dateLastActive":"2023-09-19T18:52:16+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":106,"score":null,"hot":3355896748,"url":"https:\/\/community.anaplan.com\/discussion\/155077\/export-data-to-csv-file-from-a-module-with-page-selector-and-filter-is-not-working","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155077\/export-data-to-csv-file-from-a-module-with-page-selector-and-filter-is-not-working","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/7HK0WR81VVCB\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-03T09:42:23+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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">