社区知识库

"},"updateUserID":null,"lastUserID":57287,"lastUser":{"userID":57287,"name":"sarahputriggf","url":"https:\/\/community.anaplan.com\/profile\/sarahputriggf","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/57287.png","dateLastActive":"2023-03-01T04:23:41+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":15,"score":6,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/147308\/first-look-pages-interface-modules","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/147308\/first-look-pages-interface-modules","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/post-image\/eschera_0-1663104251634.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"eschera_0-1663104251634.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":37,"urlcode":"Modeling","name":"Modeling"},{"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":148338,"type":"discussion","name":"Community perspective: IFO – UPPER and LOWER to the rescue","excerpt":"IFO is a very crucial formula to use when working with raw data, staged in Data Hub, to create lists from within the data's metadata. It truncates the metadata within its line item to \"Its First Occurrence\" to prevent duplicates being imported into its target list. This keeps the action results clean and optimizes…","categoryID":40,"dateInserted":"2022-10-06T09:00:00+00:00","dateUpdated":null,"dateLastComment":"2022-10-06T09:00:00+00:00","insertUserID":27786,"insertUser":{"userID":27786,"name":"CPAllen55_*27786","url":"https:\/\/community.anaplan.com\/profile\/CPAllen55_%2A27786","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/27786.jpeg","dateLastActive":"2022-11-14T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":6,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/148338\/community-perspective-ifo-upper-and-lower-to-the-rescue","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/148338\/community-perspective-ifo-upper-and-lower-to-the-rescue","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/CPAllen55_0-1664837153057_148338.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"CPAllen55_0-1664837153057.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":376,"urlcode":"How-to","name":"How to"},{"tagID":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"tagID":1110,"urlcode":"calculation-functions","name":"Calculation Functions"},{"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":81611,"type":"discussion","name":"Untangling Anaplan time mapping in imports","excerpt":"There are four cornerstones in The Anaplan Way, with data being one of them. We all know that we should spend at least 1\/3 of the project time on data alone because this is the cornerstone that we have no control over, and it needs to be thoroughly investigated and understood. One of the important things to consider about…","categoryID":40,"dateInserted":"2020-08-26T07:32:46+00:00","dateUpdated":null,"dateLastComment":"2022-10-06T00:47:01+00:00","insertUserID":9355,"insertUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-03-01T12:33:14+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":9355,"lastUser":{"userID":9355,"name":"Misbah","url":"https:\/\/community.anaplan.com\/profile\/Misbah","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9355.jpeg","dateLastActive":"2023-03-01T12:33:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":97,"score":8,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/81611\/untangling-anaplan-time-mapping-in-imports","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/81611\/untangling-anaplan-time-mapping-in-imports","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Misbah_0-1593508262138_81611.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Misbah_0-1593508262138.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":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":148593,"type":"discussion","name":"End User Feature: Show and Hide options within the content menu","excerpt":"","categoryID":40,"dateInserted":"2022-10-05T13:59:03+00:00","dateUpdated":"2023-01-10T14:54:49+00:00","dateLastComment":"2022-10-05T13:59:03+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/148593\/end-user-feature-show-and-hide-options-within-the-content-menu","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/148593\/end-user-feature-show-and-hide-options-within-the-content-menu","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/28324722\/D5b2bv9z3s8SVtF7gUuS1Tdiq0wERDU__play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Show and Hide options within the content menu"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":147860,"type":"discussion","name":"Management Reports: Table card formatting options","excerpt":"With the introduction of the table card in Management Reporting, you now have several formatting options available to determine how you want the table and data to appear on your report. This article will guide you through those options and guide you on when to use them. When looking to format the appearance of your Table…","categoryID":40,"dateInserted":"2022-10-03T08:00:00+00:00","dateUpdated":null,"dateLastComment":"2022-10-03T08:00:00+00:00","insertUserID":7892,"insertUser":{"userID":7892,"name":"billdowling","url":"https:\/\/community.anaplan.com\/profile\/billdowling","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/7892.jpeg","dateLastActive":"2023-02-27T09:58:05+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":53,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/147860\/management-reports-table-card-formatting-options","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/147860\/management-reports-table-card-formatting-options","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/billdowling_0-1664273724679_147860.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"billdowling_0-1664273724679.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":52,"urlcode":"UX","name":"UX"},{"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":140634,"type":"discussion","name":"OEG Best Practice: Blueprint analysis: Model analysis techniques using Excel","excerpt":"What? A model analysis technique using metadata from your Anaplan model imported in to Excel, utilizing purpose-built formulas to identify line items of interest Why? We do this so that we have some extra information with which to arm ourselves when trying to optimize a model. It lets us look at every line item, apply the…","categoryID":40,"dateInserted":"2022-06-28T04:16:38+00:00","dateUpdated":"2023-02-09T21:42:50+00:00","dateLastComment":"2022-09-28T02:54:52+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":220,"lastUser":{"userID":220,"name":"MarkWarren","url":"https:\/\/community.anaplan.com\/profile\/MarkWarren","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/220.png","dateLastActive":"2023-03-01T10:22:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":77,"score":21,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/140634\/oeg-best-practice-blueprint-analysis-model-analysis-techniques-using-excel","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/140634\/oeg-best-practice-blueprint-analysis-model-analysis-techniques-using-excel","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/MarkWarren_0-1655390353535_140634.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"MarkWarren_0-1655390353535.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":37,"urlcode":"Modeling","name":"Modeling"},{"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":84294,"type":"discussion","name":"ALM explained—Part 1: compatibility","excerpt":"Introduction Application Lifecycle Management (ALM) has been available since late 2016, and it is used widely and successfully across the Anaplan-customer base. ALM is founded on certain fundamental rules and structures, which if followed, will ensure the integrity between development, test, and production models is…","categoryID":40,"dateInserted":"2020-09-17T06:42:58+00:00","dateUpdated":null,"dateLastComment":"2022-09-26T05:26:42+00:00","insertUserID":157,"insertUser":{"userID":157,"name":"DavidSmith","url":"https:\/\/community.anaplan.com\/profile\/DavidSmith","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/157.jpeg","dateLastActive":"2023-02-03T13:33:49+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":240,"lastUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-03-01T21:27:51+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":217,"score":22,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/84294\/alm-explained-part-1-compatibility","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/84294\/alm-explained-part-1-compatibility","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/1-_Picture_1_84294.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"1- Picture 1.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":26,"urlcode":"Security-and-Administration","name":"Security and Administration"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"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":147309,"type":"discussion","name":"[First Look] Tab Split View","excerpt":" Feature: Tab Split View Release Date: September 2022 Impact Assessment: Optional Change What is changing? A tab split screen (view) will now be available for both Workspace Administrators and End Users. This functionality is comparable to the undock feature in the classic experience. What are the benefits? With the tab…","categoryID":40,"dateInserted":"2022-09-20T07:17:24+00:00","dateUpdated":null,"dateLastComment":"2022-09-23T07:02:06+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":null,"lastUserID":13687,"lastUser":{"userID":13687,"name":"whitby","url":"https:\/\/community.anaplan.com\/profile\/whitby","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/avatar\/13687.jpg","dateLastActive":"2023-02-20T08:08:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":57,"score":10,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/147309\/first-look-tab-split-view","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/147309\/first-look-tab-split-view","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/post-image\/eschera_4-1660216772888.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"eschera_4-1660216772888.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":37,"urlcode":"Modeling","name":"Modeling"},{"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":147310,"type":"discussion","name":"[First Look] Enhanced Object Search","excerpt":" Feature: Enhanced Object Search Release Date: February 2022 Impact Assessment: Quicker navigation & model building What is changing? The new Search functionality is a new and centralized way to explore model objects and simplify how you navigate throughout your models What are the benefits? A single search will find…","categoryID":40,"dateInserted":"2022-09-20T07:17:45+00:00","dateUpdated":null,"dateLastComment":"2022-09-20T07:17:45+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":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/147310\/first-look-enhanced-object-search","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/147310\/first-look-enhanced-object-search","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/post-image\/eschera_0-1661872061103.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"eschera_0-1661872061103.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":37,"urlcode":"Modeling","name":"Modeling"},{"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":147307,"type":"discussion","name":"[First Look] New Features in Modeling","excerpt":"Introducing new modeling features If you are looking for a brief overview of the new features available in modeling or the modeling experience, you have come to the right place. In this article, we will add links to new model building features and provide an overview of the essentials of the functionality. When possible,…","categoryID":40,"dateInserted":"2022-09-20T07:16:55+00:00","dateUpdated":null,"dateLastComment":"2022-09-20T07:16:55+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":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":88,"score":19,"hot":1663663915,"url":"https:\/\/community.anaplan.com\/discussion\/147307\/first-look-new-features-in-modeling","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/147307\/first-look-new-features-in-modeling","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":37,"urlcode":"Modeling","name":"Modeling"},{"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":147298,"type":"discussion","name":"Design: Utilizing all page types within a model","excerpt":"","categoryID":40,"dateInserted":"2022-09-19T09:49:43+00:00","dateUpdated":"2023-01-10T15:00:00+00:00","dateLastComment":"2022-09-19T09:49:43+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/147298\/design-utilizing-all-page-types-within-a-model","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/147298\/design-utilizing-all-page-types-within-a-model","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/28320781\/1nNeukDwdCbvbNxr0ua7RkIf5U_jSxqx_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Utilizing all page types within a model"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":86430,"type":"discussion","name":"OEG Best Practice: Import action management best practices","excerpt":"An import action section can quickly become disorganized, making ongoing management challenging. Learn why this happens and explore steps to take to prevent this from occurring. Import action section: why does it become disorganized? Anaplan saves every import action that you perform, no matter what. For a new build, the…","categoryID":40,"dateInserted":"2020-10-06T08:07:54+00:00","dateUpdated":"2023-02-09T18:57:12+00:00","dateLastComment":"2022-09-17T16:52:51+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":3020,"lastUser":{"userID":3020,"name":"TristanS","url":"https:\/\/community.anaplan.com\/profile\/TristanS","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3020.jpeg","dateLastActive":"2023-03-01T23:05:02+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":60,"score":12,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/86430\/oeg-best-practice-import-action-management-best-practices","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/86430\/oeg-best-practice-import-action-management-best-practices","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Good_vs._Bad_Example_86430.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Good vs. Bad Example.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":1118,"urlcode":"data-integration","name":"Data Integration"},{"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":123650,"type":"discussion","name":"Anaplan SCIM APIs in Postman","excerpt":"WHAT IS SCIM? System for Cross-domain Identity Management, is a REST and JSON-based protocol open standard created in 2011 that allows companies to securely automate the exchange of user identity data between an identity provider, such as OKTA or Azure Active Directory, and an enterprise SaaS application, such as Anaplan…","categoryID":40,"dateInserted":"2021-11-03T06:17:59+00:00","dateUpdated":"2023-01-09T21:38:49+00:00","dateLastComment":"2022-09-14T10:01:38+00:00","insertUserID":11122,"insertUser":{"userID":11122,"name":"ChrisStauffer","url":"https:\/\/community.anaplan.com\/profile\/ChrisStauffer","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11122.png","dateLastActive":"2023-03-01T13:53:13+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":78835,"lastUser":{"userID":78835,"name":"KrisC","url":"https:\/\/community.anaplan.com\/profile\/KrisC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/78835.svg","dateLastActive":"2023-02-01T13:56:52+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":47,"score":4,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/123650\/anaplan-scim-apis-in-postman","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/123650\/anaplan-scim-apis-in-postman","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/ChrisStauffer_0-1635794162478_123650.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ChrisStauffer_0-1635794162478.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":26,"urlcode":"Security-and-Administration","name":"Security and Administration"},{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"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":146813,"type":"discussion","name":"Build: Data Write","excerpt":"","categoryID":40,"dateInserted":"2022-09-12T11:46:33+00:00","dateUpdated":"2023-01-10T15:00:40+00:00","dateLastComment":"2022-09-12T11:46:33+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":2,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/146813\/build-data-write","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/146813\/build-data-write","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/30756201\/CKp1INrSacMBsBy_jLqh4iaSJVtGevCf_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Data Write"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":146024,"type":"discussion","name":"Community perspective: Data Hub organization","excerpt":"This article is intended to help assist and standardize Data Hub organization across the Anaplan platform. This methodology is intended to help the technical teams, not end users, navigate and create your Data Hub model and troubleshoot problems with individual data sources efficiently. Functional areas To begin, setup…","categoryID":40,"dateInserted":"2022-09-06T08:34:21+00:00","dateUpdated":null,"dateLastComment":"2022-09-06T08:34:21+00:00","insertUserID":22606,"insertUser":{"userID":22606,"name":"KBeltz","url":"https:\/\/community.anaplan.com\/profile\/KBeltz","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22606.png","dateLastActive":"2023-03-01T21:38:10+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":16,"score":10,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/146024\/community-perspective-data-hub-organization","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/146024\/community-perspective-data-hub-organization","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/KBeltz_0-1661988477122_146024.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"KBeltz_0-1661988477122.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":376,"urlcode":"How-to","name":"How to"},{"tagID":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"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":146301,"type":"discussion","name":"Design: Publish worksheets when appropriate","excerpt":"","categoryID":40,"dateInserted":"2022-09-06T07:56:58+00:00","dateUpdated":"2023-01-10T15:01:13+00:00","dateLastComment":"2022-09-06T07:56:58+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":2,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/146301\/design-publish-worksheets-when-appropriate","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/146301\/design-publish-worksheets-when-appropriate","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/29331140\/-FChOiTGN-WBd1J4IFHExNNb8x4uX8sI_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Publish worksheets when appropriate"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":93791,"type":"discussion","name":"Headcount alignment playbook","excerpt":"Table of contents: * Problem statement * Proposed solution * Stakeholders and responsibilities * Data sources and integration * Return on investment * Conclusion Problem statement Anaplan has had challenges getting our finance, human resources, and sales teams on the same page of what our headcount is and what our…","categoryID":40,"dateInserted":"2020-12-18T10:32:02+00:00","dateUpdated":"2022-12-22T17:54:05+00:00","dateLastComment":"2022-09-03T13:08:23+00:00","insertUserID":9461,"insertUser":{"userID":9461,"name":"joeymorisette","url":"https:\/\/community.anaplan.com\/profile\/joeymorisette","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9461.jpeg","dateLastActive":"2022-07-20T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":2631,"lastUserID":70785,"lastUser":{"userID":70785,"name":"KevinMoreno","url":"https:\/\/community.anaplan.com\/profile\/KevinMoreno","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/70785.jpeg","dateLastActive":"2022-10-20T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":165,"score":13,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/93791\/headcount-alignment-playbook","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/93791\/headcount-alignment-playbook","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/AonA_Hero1_HEADER2_93791.jpg?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"AonA_Hero1_HEADER2.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"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":33556,"type":"discussion","name":"OEG Best Practice: Formulas and their effects on model performance","excerpt":"Details of known issues Challenge Recommendations Performance issues with long nested formulas Need to have a long formula on time as a result of nested intermediate calculations. If the model size does not prevent from adding extra line items, it's a better practice to create multiple intermediate line items and reduce…","categoryID":40,"dateInserted":"2018-05-31T12:27:19+00:00","dateUpdated":"2023-02-09T17:05:35+00:00","dateLastComment":"2022-08-30T06:32:45+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":2229,"lastUser":{"userID":2229,"name":"adpinto","url":"https:\/\/community.anaplan.com\/profile\/adpinto","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/2229.png","dateLastActive":"2023-01-10T21:59:42+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":151,"score":8,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/33556\/oeg-best-practice-formulas-and-their-effects-on-model-performance","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/33556\/oeg-best-practice-formulas-and-their-effects-on-model-performance","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":37,"urlcode":"Modeling","name":"Modeling"},{"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":145875,"type":"discussion","name":"Build: View Designer page creation actions","excerpt":"","categoryID":40,"dateInserted":"2022-08-29T11:19:12+00:00","dateUpdated":"2023-01-10T15:01:40+00:00","dateLastComment":"2022-08-29T11:19:12+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/145875\/build-view-designer-page-creation-actions","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/145875\/build-view-designer-page-creation-actions","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/28324603\/PN-KI8IDN3-AKfQC3-277_kU2lZ7hKD8_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"View Designer page creation actions"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":145390,"type":"discussion","name":"Community perspective: Employee grouping for sales targets","excerpt":"Within sales and target setting use cases, there are often situations that require assigning specific targets to a group of employees. While this can be done manually or through a blanket allocation, it may be more advantageous to designate groups within regions or markets for the purpose of distributing targets. There are…","categoryID":40,"dateInserted":"2022-08-25T09:02:54+00:00","dateUpdated":null,"dateLastComment":"2022-08-25T09:02:54+00:00","insertUserID":4305,"insertUser":{"userID":4305,"name":"DavidEdwards","url":"https:\/\/community.anaplan.com\/profile\/DavidEdwards","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4305.jpeg","dateLastActive":"2023-02-06T19:06:44+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":1,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/145390\/community-perspective-employee-grouping-for-sales-targets","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/145390\/community-perspective-employee-grouping-for-sales-targets","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/DavidEdwards_67-1661213007458_145390.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"DavidEdwards_67-1661213007458.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":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"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":145328,"type":"discussion","name":"Design: Utilize customizable hex color codes for your charts within the UX","excerpt":"","categoryID":40,"dateInserted":"2022-08-22T09:27:29+00:00","dateUpdated":"2023-01-10T15:02:26+00:00","dateLastComment":"2022-08-22T09:27:29+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":4,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/145328\/design-utilize-customizable-hex-color-codes-for-your-charts-within-the-ux","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/145328\/design-utilize-customizable-hex-color-codes-for-your-charts-within-the-ux","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/28324484\/3Yhxw-VYfP6L4lo4Zxus-baX0V5ptVI4_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Utilize customizable hex color codes for your charts within the UX"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":144859,"type":"discussion","name":"Build: Using custom views for flexibility","excerpt":"","categoryID":40,"dateInserted":"2022-08-15T07:12:15+00:00","dateUpdated":"2023-01-09T22:24:55+00:00","dateLastComment":"2022-08-15T07:12:15+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":2,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/144859\/build-using-custom-views-for-flexibility","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/144859\/build-using-custom-views-for-flexibility","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/28323604\/lvClFFMJyw4TCbQfqOETjrMKYTOGVHvy_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Using custom views for flexibility"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":143592,"type":"discussion","name":"Applying \"transparent\" conditional formatting in the UX","excerpt":"When we apply conditional formatting to a grid in the UX, there is no option to set a transparent color. However, with some creative use of specific color codes, we can simulate the transparent effect. I will focus on two specific cases below: editable cells and read-only cells. Both of these cases follow the same approach…","categoryID":40,"dateInserted":"2022-08-09T08:30:00+00:00","dateUpdated":null,"dateLastComment":"2022-08-10T23:08:50+00:00","insertUserID":365,"insertUser":{"userID":365,"name":"ryan_kohn","url":"https:\/\/community.anaplan.com\/profile\/ryan_kohn","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/365.jpeg","dateLastActive":"2023-03-01T15:57:52+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":13687,"lastUser":{"userID":13687,"name":"whitby","url":"https:\/\/community.anaplan.com\/profile\/whitby","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/avatar\/13687.jpg","dateLastActive":"2023-02-20T08:08:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":11,"score":12,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/143592\/applying-transparent-conditional-formatting-in-the-ux","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/143592\/applying-transparent-conditional-formatting-in-the-ux","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/ryan_kohn_3-1659133050155_143592.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ryan_kohn_3-1659133050155.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":52,"urlcode":"UX","name":"UX"},{"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":143610,"type":"discussion","name":"Suppressing zeros in line charts","excerpt":"* Problem statement * Solution options * Line item format setting: Zero format * Chart configuration: Trailing zeros * Suppressing all zeros in line charts with NaN * Conclusion * Additional resources\/credits Problem statement Let's consider plotting a line chart for the following data set: For this example, I want to…","categoryID":40,"dateInserted":"2022-08-10T08:30:00+00:00","dateUpdated":null,"dateLastComment":"2022-08-10T08:30:00+00:00","insertUserID":365,"insertUser":{"userID":365,"name":"ryan_kohn","url":"https:\/\/community.anaplan.com\/profile\/ryan_kohn","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/365.jpeg","dateLastActive":"2023-03-01T15:57:52+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":95,"score":7,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/143610\/suppressing-zeros-in-line-charts","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/143610\/suppressing-zeros-in-line-charts","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/post-image\/ryan_kohn_6-1659135418973.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ryan_kohn_6-1659135418973.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":52,"urlcode":"UX","name":"UX"},{"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":91744,"type":"discussion","name":"Updating an import source file","excerpt":"Introduction The process to update the source file for an import action is not obvious—but it is simple. There are a number of reasons you may wish to update an import source file, and I have listed some below: * Adding or removing fields from your source file and target list or module * Changing the format of specific…","categoryID":40,"dateInserted":"2020-11-23T10:45:44+00:00","dateUpdated":null,"dateLastComment":"2022-08-03T14:27:35+00:00","insertUserID":2076,"insertUser":{"userID":2076,"name":"sean_culligan","url":"https:\/\/community.anaplan.com\/profile\/sean_culligan","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/2076.jpeg","dateLastActive":"2023-01-17T11:43:18+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":76023,"lastUser":{"userID":76023,"name":"ColinPorter","url":"https:\/\/community.anaplan.com\/profile\/ColinPorter","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/76023.jpeg","dateLastActive":"2023-02-14T15:01:53+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":76,"score":6,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/91744\/updating-an-import-source-file","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/91744\/updating-an-import-source-file","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/ss1_91744.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ss1.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":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":143320,"type":"discussion","name":"[Part 1] Validating user input in Anaplan: Approaches and challenges","excerpt":"* Pros\/cons of common approaches * Common approaches: Examples * Error logic * User experience * Example 1: Simple error messages * Example 2a & 2b: Nested IF statement * Example 3: Concatenation of multiple error messages * Example 4: Separate errors for each line item * Wrap-up of Part 1: Summary of common (sub-optimal)…","categoryID":40,"dateInserted":"2022-08-03T08:00:00+00:00","dateUpdated":null,"dateLastComment":"2022-08-03T08:00:00+00:00","insertUserID":365,"insertUser":{"userID":365,"name":"ryan_kohn","url":"https:\/\/community.anaplan.com\/profile\/ryan_kohn","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/365.jpeg","dateLastActive":"2023-03-01T15:57:52+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":30,"score":10,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/143320\/part-1-validating-user-input-in-anaplan-approaches-and-challenges","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/143320\/part-1-validating-user-input-in-anaplan-approaches-and-challenges","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/post-image\/ryan_kohn_4-1658946360688.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"ryan_kohn_4-1658946360688.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":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"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":143748,"type":"discussion","name":"Personas: Rights management for Pages","excerpt":"","categoryID":40,"dateInserted":"2022-08-01T10:09:48+00:00","dateUpdated":"2023-01-10T15:03:40+00:00","dateLastComment":"2022-08-01T10:09:48+00:00","insertUserID":22611,"insertUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-28T19:36:01+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":22611,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":2,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/143748\/personas-rights-management-for-pages","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/143748\/personas-rights-management-for-pages","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/29331137\/Lr60Y-rdBR7yM8GCg3WO34daHSAK0-0D_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Rights management for Pages"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"tagID":1095,"urlcode":"quicktip","name":"Quick Tip"}],"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":141317,"type":"discussion","name":"The art of the possible: Spend analysis","excerpt":"Finding opportunities to save is a universal priority and especially important in today’s unpredictable economy. As a single source of truth within an organization, Anaplan can enable meaningful analysis around how dollars are spent across an organization, allowing for insights that lead to real savings. Supplier spend is…","categoryID":40,"dateInserted":"2022-07-28T09:09:22+00:00","dateUpdated":"2022-12-06T19:02:57+00:00","dateLastComment":"2022-07-28T09:09:22+00:00","insertUserID":23002,"insertUser":{"userID":23002,"name":"DanielleC","url":"https:\/\/community.anaplan.com\/profile\/DanielleC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/3M4HI240KAOS\/nJGGCXIK9LHK8.png","dateLastActive":"2023-03-01T18:03:10+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":2,"score":4,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/141317\/the-art-of-the-possible-spend-analysis","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/141317\/the-art-of-the-possible-spend-analysis","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/images\/vidyard.jpeg?9DHtnXuPZqYF7VBMPG2Py5.html?second=130","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":52,"urlcode":"UX","name":"UX"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"}],"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":141556,"type":"discussion","name":"Automate current date import using Power Automate","excerpt":"As you all know, Anaplan cannot display the current time from a function, so it needs to be imported into a module by an import action. As described here it can be done via Python: Import and automate current date import to Anaplan. I would like to to show you an easier way of doing it when your organization has access to…","categoryID":40,"dateInserted":"2022-07-25T09:00:00+00:00","dateUpdated":null,"dateLastComment":"2022-07-25T09:00:00+00:00","insertUserID":8914,"insertUser":{"userID":8914,"name":"StevenBeerthuizen","url":"https:\/\/community.anaplan.com\/profile\/StevenBeerthuizen","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8914.jpeg","dateLastActive":"2023-02-26T18:38:31+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":42,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/141556\/automate-current-date-import-using-power-automate","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/141556\/automate-current-date-import-using-power-automate","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/CommunityMember129720_0-1657279334057_141556.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"CommunityMember129720_0-1657279334057.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":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":137568,"type":"discussion","name":"Use Power Query in Excel to leverage the power of the Anaplan API","excerpt":"When working on our quality assurance items, we realized that one of the items that could go wrong in our regular data loads was that the lists loaded to our data hub could be empty. We had to figure out a way of monitoring this in a simple and straightforward manner. So, I decided to go for the combination of Excel and…","categoryID":40,"dateInserted":"2022-07-18T08:00:00+00:00","dateUpdated":null,"dateLastComment":"2022-07-18T08:00:00+00:00","insertUserID":8914,"insertUser":{"userID":8914,"name":"StevenBeerthuizen","url":"https:\/\/community.anaplan.com\/profile\/StevenBeerthuizen","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8914.jpeg","dateLastActive":"2023-02-26T18:38:31+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/137568\/use-power-query-in-excel-to-leverage-the-power-of-the-anaplan-api","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/137568\/use-power-query-in-excel-to-leverage-the-power-of-the-anaplan-api","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/CommunityMember129720_0-1657006969280_137568.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"CommunityMember129720_0-1657006969280.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":26,"urlcode":"Security-and-Administration","name":"Security and Administration"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">