Community Knowledge Base

"},"updateUserID":23002,"lastUserID":50358,"lastUser":{"userID":50358,"name":"ndavis299","url":"https:\/\/community.anaplan.com\/profile\/ndavis299","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/50358.jpeg","dateLastActive":"2023-06-05T17:37:10+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":2862,"score":41,"hot":3218123826,"url":"https:\/\/community.anaplan.com\/discussion\/35993\/oeg-best-practice-best-practices-for-module-design","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/35993\/oeg-best-practice-best-practices-for-module-design","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/plans_35993.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"plans.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":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":40359,"type":"discussion","name":"OEG Best Practice: Statistical forecasting","excerpt":" Overview The following is a guide for the Statistical Forecasting Calculation Engine Models (monthly and weekly). It includes enablement videos, practice data import exercise, model documentation, and specific steps when using the model for implementations. 1. Enablement videos and practice exercise…","categoryID":40,"dateInserted":"2019-01-22T12:35:34+00:00","dateUpdated":"2023-02-09T21:27:09+00:00","dateLastComment":"2023-04-18T22:49:20+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":69512,"lastUser":{"userID":69512,"name":"ScottA","url":"https:\/\/community.anaplan.com\/profile\/ScottA","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/69512.jpeg","dateLastActive":"2023-07-11T16:21:36+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":916,"score":16,"hot":3230028894,"url":"https:\/\/community.anaplan.com\/discussion\/40359\/oeg-best-practice-statistical-forecasting","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/40359\/oeg-best-practice-statistical-forecasting","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Stat_Forecasting_Banner_v4_40359.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Stat Forecasting Banner_v4.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":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":33595,"type":"discussion","name":"Save incomplete changes when synchronizing in ALM","excerpt":"Imagine this scenario: You are in the middle of making changes in your development model and have been doing so for the last few weeks. The changes are not complete and are not ready to synchronize. However, you just received a request for an urgent fix from the user community that is critical for the forthcoming monthly…","categoryID":40,"dateInserted":"2018-05-31T14:09:30+00:00","dateUpdated":null,"dateLastComment":"2023-04-13T22:10:51+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-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":18799,"lastUser":{"userID":18799,"name":"WanchenTsai","url":"https:\/\/community.anaplan.com\/profile\/WanchenTsai","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/18799.png","dateLastActive":"2023-05-25T05:11:08+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":15,"countViews":923,"score":31,"hot":3209217921,"url":"https:\/\/community.anaplan.com\/discussion\/33595\/save-incomplete-changes-when-synchronizing-in-alm","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/33595\/save-incomplete-changes-when-synchronizing-in-alm","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/alm20170419_33595.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"alm20170419.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":33667,"type":"discussion","name":"OEG Best Practice: Reduce calculations for better performance","excerpt":"Reducing the number of calculations will lead to quicker calculations and improve performance. However, this doesn’t mean combining all your calculations into fewer line items, as breaking calculations into smaller parts has major benefits for performance. Learn more about this in the Formula structure for performance…","categoryID":40,"dateInserted":"2018-06-04T09:37:26+00:00","dateUpdated":"2023-02-09T21:52:24+00:00","dateLastComment":"2023-04-13T09:53:25+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":43780,"lastUser":{"userID":43780,"name":"Ganza","url":"https:\/\/community.anaplan.com\/profile\/Ganza","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/43780.png","dateLastActive":"2023-07-11T11:18:56+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":1049,"score":26,"hot":3209494851,"url":"https:\/\/community.anaplan.com\/discussion\/33667\/oeg-best-practice-reduce-calculations-for-better-performance","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/33667\/oeg-best-practice-reduce-calculations-for-better-performance","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Reduce_Calculations_0_33667.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Reduce Calculations 0.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"},{"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":56477,"type":"discussion","name":"Calculate the difference between two dates (days\/months)","excerpt":"Calculating the difference between two dates is a common requirement and one that you will likely need to do at some point. Below you will find the best practice for calculating the difference between two days, and the best practice for calculating the difference between two months. While there are multiple ways to get to…","categoryID":40,"dateInserted":"2019-12-17T08:16:09+00:00","dateUpdated":null,"dateLastComment":"2023-04-11T14:27:52+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-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":53711,"lastUser":{"userID":53711,"name":"MirBorishkevich","url":"https:\/\/community.anaplan.com\/profile\/MirBorishkevich","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/53711.jpeg","dateLastActive":"2023-05-17T17:59:57+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":986,"score":10,"hot":3257802241,"url":"https:\/\/community.anaplan.com\/discussion\/56477\/calculate-the-difference-between-two-dates-days-months","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/56477\/calculate-the-difference-between-two-dates-days-months","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/DS1_56477.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"DS1.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":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":155406,"type":"discussion","name":"Community perspective: Automate List Nodes Selective Access","excerpt":"Consider the following situation: There are times when we need to enable selective access for flat list nodes. Although Anaplan has native Users settings tab to manage list nodes access but if the number of list items are huge then managing the security using Users settings tab becomes challenging. This article will cover…","categoryID":40,"dateInserted":"2023-04-11T04:58:25+00:00","dateUpdated":"2023-05-01T20:38:54+00:00","dateLastComment":"2023-04-11T04:58:25+00:00","insertUserID":21665,"insertUser":{"userID":21665,"name":"riteshkumar3","url":"https:\/\/community.anaplan.com\/profile\/riteshkumar3","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/21665.jpeg","dateLastActive":"2023-05-04T06:04:09+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":75258,"lastUserID":21665,"lastUser":{"userID":21665,"name":"riteshkumar3","url":"https:\/\/community.anaplan.com\/profile\/riteshkumar3","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/21665.jpeg","dateLastActive":"2023-05-04T06:04:09+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":148,"score":2,"hot":3362419360,"url":"https:\/\/community.anaplan.com\/discussion\/155406\/community-perspective-automate-list-nodes-selective-access","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155406\/community-perspective-automate-list-nodes-selective-access","format":"Rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/2WFKT7DXMHYM\/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":605,"urlcode":"User-Access","name":"User Access"},{"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":154925,"type":"discussion","name":"Community perspective: Building two approaches to ragged hierarchy","excerpt":"In Two approaches to ragged hierarchy, I presented two ways to fix a ragged hierarchy into a balanced one. Now let's proceed with building based on these two approaches. 👀 Blueprints are included for your reference. Building Hierarchy - Loop20230207.xlsx 1. Common preparationMany platforms with a hierarchical structure…","categoryID":40,"dateInserted":"2023-02-16T06:58:20+00:00","dateUpdated":"2023-05-12T16:22:16+00:00","dateLastComment":"2023-04-07T00:53:01+00:00","insertUserID":22448,"insertUser":{"userID":22448,"name":"Amaya","url":"https:\/\/community.anaplan.com\/profile\/Amaya","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/HSV9LKHQZWDS\/nMCDD12L3IISS.jpg","dateLastActive":"2023-07-10T00:36:04+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":67811,"lastUserID":22448,"lastUser":{"userID":22448,"name":"Amaya","url":"https:\/\/community.anaplan.com\/profile\/Amaya","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/HSV9LKHQZWDS\/nMCDD12L3IISS.jpg","dateLastActive":"2023-07-10T00:36:04+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":251,"score":1,"hot":3357360981,"url":"https:\/\/community.anaplan.com\/discussion\/154925\/community-perspective-building-two-approaches-to-ragged-hierarchy","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154925\/community-perspective-building-two-approaches-to-ragged-hierarchy","format":"rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/2LDYIDGHVOGO\/pic1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Pic1.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":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":140866,"type":"discussion","name":"Get to know the model experience as an end-user","excerpt":"Welcome to the updated Anaplan model experience! The Anaplan functionality you are used to, now with a modernized appearance and simplified navigation. In February 2023, the updated model experience will become the default for all users. When you access Anaplan your models from Home or the Models screen, the new look and…","categoryID":40,"dateInserted":"2022-07-20T08:00:00+00:00","dateUpdated":"2023-01-19T13:08:03+00:00","dateLastComment":"2023-03-31T08:34:27+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":28092,"lastUserID":3012,"lastUser":{"userID":3012,"name":"Alessio_Pagliano","url":"https:\/\/community.anaplan.com\/profile\/Alessio_Pagliano","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/3012.jpeg","dateLastActive":"2023-07-11T13:05:51+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":8605,"score":11,"hot":3338566167,"url":"https:\/\/community.anaplan.com\/discussion\/140866\/get-to-know-the-model-experience-as-an-end-user","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/140866\/get-to-know-the-model-experience-as-an-end-user","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/eschera_0-1657923429963_140866.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"eschera_0-1657923429963.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":154980,"type":"discussion","name":"Community perspective: How to achieve multi-app accessibility from a single dashboard","excerpt":"As Anaplan moves forward, many companies are implementing Connected Planning across their entire organisations. This means that as the Anaplan implementation grows - multiple models or multiple functional areas across a single model- generally arise. This is currently being resolved through the use of multiple Apps to…","categoryID":40,"dateInserted":"2023-02-22T20:34:19+00:00","dateUpdated":"2023-05-12T16:27:13+00:00","dateLastComment":"2023-03-23T10:40:52+00:00","insertUserID":64111,"insertUser":{"userID":64111,"name":"BrunoRodriguez","url":"https:\/\/community.anaplan.com\/profile\/BrunoRodriguez","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/64111.jpeg","dateLastActive":"2023-07-09T20:53:27+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":67811,"lastUserID":28081,"lastUser":{"userID":28081,"name":"EmilyJ","url":"https:\/\/community.anaplan.com\/profile\/EmilyJ","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/28081.png","dateLastActive":"2023-07-10T09:32:34+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":1011,"score":16,"hot":3356674511,"url":"https:\/\/community.anaplan.com\/discussion\/154980\/community-perspective-how-to-achieve-multi-app-accessibility-from-a-single-dashboard","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154980\/community-perspective-how-to-achieve-multi-app-accessibility-from-a-single-dashboard","format":"rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/PYG6U76BNGZV\/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":52,"urlcode":"UX","name":"UX"},{"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":33530,"type":"discussion","name":"OEG Best Practice: PLANS: This is how we model","excerpt":"PLANSPLANS is the new standard for Anaplan modeling—“the way we model.” This covers more than just the formulas and includes and evolves existing best practices around user experience and Data Hubs. It is a set of rules on the structure and detailed design of Anaplan models. This set of rules will provide both a clear…","categoryID":40,"dateInserted":"2018-05-31T11:23:01+00:00","dateUpdated":"2023-05-23T18:25:29+00:00","dateLastComment":"2023-03-20T19:39: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":75258,"lastUserID":75258,"lastUser":{"userID":75258,"name":"GingerAnderson","url":"https:\/\/community.anaplan.com\/profile\/GingerAnderson","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/75258.png","dateLastActive":"2023-07-11T17:55:46+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":3079,"score":35,"hot":3212648610,"url":"https:\/\/community.anaplan.com\/discussion\/33530\/oeg-best-practice-plans-this-is-how-we-model","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/33530\/oeg-best-practice-plans-this-is-how-we-model","format":"rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/NI6GF30EKJ7J\/plans-main-33530.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"PLANS_Main_33530.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":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":33177,"type":"discussion","name":"OEG Best Practice: Formula structure for performance","excerpt":"Thinking through the results of a modeling decision is a key part of ensuring good model performance; in other words, making sure the calculation engine isn’t overtaxed. This article highlights some ideas for how to lessen the load on the calculation engine. Formulas should be simple; a formula that is nested, or uses…","categoryID":40,"dateInserted":"2018-05-10T12:11:45+00:00","dateUpdated":"2023-02-09T21:56:57+00:00","dateLastComment":"2023-03-16T15:25:32+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":29831,"lastUser":{"userID":29831,"name":"kumarshubham","url":"https:\/\/community.anaplan.com\/profile\/kumarshubham","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/29831.png","dateLastActive":"2023-04-06T04:47:22+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":1028,"score":46,"hot":3204953837,"url":"https:\/\/community.anaplan.com\/discussion\/33177\/oeg-best-practice-formula-structure-for-performance","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/33177\/oeg-best-practice-formula-structure-for-performance","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/FormulaStructure1_33177.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"FormulaStructure1.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":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-07-11T23:01:22+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":1381,"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":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-07-06T15:30:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":438,"score":45,"hot":3324529322,"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-07-10T22:58:07+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-07-10T22:58:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":193,"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":120636,"type":"discussion","name":"Easily Get Current Date Using CloudWorks","excerpt":"Almost any model builder has had to come up with a solution to get the current date in Anaplan. We used to build integrations and use API for that. @JaredDolich posted a great article about using python for getting today's date. But this approach has some cons: * You must learn to code or involve someone who can do it.…","categoryID":40,"dateInserted":"2021-09-30T06:19:51+00:00","dateUpdated":null,"dateLastComment":"2023-03-03T16:16:47+00:00","insertUserID":9870,"insertUser":{"userID":9870,"name":"Hayk","url":"https:\/\/community.anaplan.com\/profile\/Hayk","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9870.jpeg","dateLastActive":"2023-06-28T07:44:35+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":36225,"lastUser":{"userID":36225,"name":"ClovisB","url":"https:\/\/community.anaplan.com\/profile\/ClovisB","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/36225.png","dateLastActive":"2023-06-15T13:52:16+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":856,"score":27,"hot":3310857098,"url":"https:\/\/community.anaplan.com\/discussion\/120636\/easily-get-current-date-using-cloudworks","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/120636\/easily-get-current-date-using-cloudworks","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Hayk_0-1629440853340_120636.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Hayk_0-1629440853340.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":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":155032,"type":"discussion","name":"PlanIQ – Considerations Before Starting to Forecast","excerpt":"Before starting to forecast with PlanIQ, there are a few topics we recommend considering around the data, properties of the forecast, and forecast evaluation. While it is important to define clear goals for each forecasting scenario, PlanIQ's forecast accuracy will mostly be determined by the quality of the available data.…","categoryID":40,"dateInserted":"2023-02-27T22:24:51+00:00","dateUpdated":"2023-03-08T20:54:48+00:00","dateLastComment":"2023-02-28T19:58:40+00:00","insertUserID":25808,"insertUser":{"userID":25808,"name":"JenniferC","url":"https:\/\/community.anaplan.com\/profile\/JenniferC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/25808.png","dateLastActive":"2023-03-29T22:03:43+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":75258,"lastUserID":10352,"lastUser":{"userID":10352,"name":"EmilyS","url":"https:\/\/community.anaplan.com\/profile\/EmilyS","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/10352.jpeg","dateLastActive":"2023-06-02T14:33:31+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":285,"score":6,"hot":3355847979,"url":"https:\/\/community.anaplan.com\/discussion\/155032\/planiq-considerations-before-starting-to-forecast","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/155032\/planiq-considerations-before-starting-to-forecast","format":"Rich","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":99,"urlcode":"PlanIQ","name":"PlanIQ"},{"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":154994,"type":"discussion","name":"Community perspective: Time Settings impact on PERIOD function","excerpt":"When changing the model calendar or available time ranges beware of the unintended consequence on any PERIOD functions in your model. Here are the details on what caused a phantom issue at a customer and how we solved it. ProblemWhile working with a customer to reduce model size we took a hard look at how they were using…","categoryID":40,"dateInserted":"2023-02-23T15:13:12+00:00","dateUpdated":"2023-05-12T16:19:45+00:00","dateLastComment":"2023-02-27T09:54:57+00:00","insertUserID":8256,"insertUser":{"userID":8256,"name":"BrentOrr","url":"https:\/\/community.anaplan.com\/profile\/BrentOrr","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8256.jpeg","dateLastActive":"2023-07-11T20:39:51+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":67811,"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-07-12T07:29:42+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":138,"score":11,"hot":3355477973,"url":"https:\/\/community.anaplan.com\/discussion\/154994\/community-perspective-time-settings-impact-on-period-function","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154994\/community-perspective-time-settings-impact-on-period-function","format":"rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/5NYHDJ8AT0M4\/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":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"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":140736,"type":"discussion","name":"How to traverse hierarchies: The power of loops","excerpt":"Introduction Whenever you use a hierarchy, there will often be times when you are required to seek specific information which will necessitate some way to traverse the nodes and map out their connections. What you seek may be a list entity, a specific value, or a unique identifier, and this can become complicated if the…","categoryID":40,"dateInserted":"2022-08-24T08:00:00+00:00","dateUpdated":null,"dateLastComment":"2023-02-24T09:15:17+00:00","insertUserID":11974,"insertUser":{"userID":11974,"name":"AdamCookson","url":"https:\/\/community.anaplan.com\/profile\/AdamCookson","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11974.jpeg","dateLastActive":"2023-07-04T08:41:12+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":11974,"lastUser":{"userID":11974,"name":"AdamCookson","url":"https:\/\/community.anaplan.com\/profile\/AdamCookson","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11974.jpeg","dateLastActive":"2023-07-04T08:41:12+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":329,"score":20,"hot":3338567117,"url":"https:\/\/community.anaplan.com\/discussion\/140736\/how-to-traverse-hierarchies-the-power-of-loops","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/140736\/how-to-traverse-hierarchies-the-power-of-loops","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/AdamCookson_0-1656438937180_140736.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"AdamCookson_0-1656438937180.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":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":136057,"type":"discussion","name":"Demystify non-linear optimization: Episode 1","excerpt":"Prologue The Anaplan community has been facing more and more interesting optimization problem statements every day while they solve complex business problems. Business challenges often involve finding optimal assignments such as sales reps to customers, demand to production capacity, or workers to shifts – all while…","categoryID":40,"dateInserted":"2022-05-26T08:16:33+00:00","dateUpdated":null,"dateLastComment":"2023-02-09T06:42:44+00:00","insertUserID":1507,"insertUser":{"userID":1507,"name":"anikdas","url":"https:\/\/community.anaplan.com\/profile\/anikdas","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/1507.png","dateLastActive":"2023-07-12T01:44:15+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":51129,"lastUser":{"userID":51129,"name":"Tazio","url":"https:\/\/community.anaplan.com\/profile\/Tazio","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/51129.png","dateLastActive":"2023-07-10T15:44:15+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":168,"score":7,"hot":3329484257,"url":"https:\/\/community.anaplan.com\/discussion\/136057\/demystify-non-linear-optimization-episode-1","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/136057\/demystify-non-linear-optimization-episode-1","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/post-image\/anikdas_0-1650513366106.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"anikdas_0-1650513366106.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":215,"urlcode":"Intelligence","name":"Intelligence"},{"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":78413,"type":"discussion","name":"Automatic DocuSign Workflows","excerpt":"The native DocuSign integration with Anaplan makes it simple to share information between Anaplan and Docusign, but the process to issue envelopes or track changes back in Anaplan can sometimes be quite manual and time-consuming as envelope counts begin to increase. This article will walk through a script to automate this…","categoryID":40,"dateInserted":"2020-08-11T06:37:05+00:00","dateUpdated":null,"dateLastComment":"2023-02-08T03:07:02+00:00","insertUserID":1184,"insertUser":{"userID":1184,"name":"jesse_wilson","url":"https:\/\/community.anaplan.com\/profile\/jesse_wilson","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/1184.jpeg","dateLastActive":"2022-04-19T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":53538,"lastUser":{"userID":53538,"name":"anildudam","url":"https:\/\/community.anaplan.com\/profile\/anildudam","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/53538.png","dateLastActive":"2023-07-06T08:26:18+00:00","banned":0,"punished":0,"private":true,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":43,"score":null,"hot":3272955247,"url":"https:\/\/community.anaplan.com\/discussion\/78413\/automatic-docusign-workflows","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/78413\/automatic-docusign-workflows","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Screenshot_2020-07-02_at_11.55.05_78413.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"User Variables"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"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":154844,"type":"discussion","name":"Building Anaplan CoE","excerpt":"After spending 6-7 years with Anaplan in different roles I would like to share some of my practical knowledge on setting up a CoE. In a series of videos I will try to help you ask the right questions that hopefully will help you with your CoE. The first one is on Anaplan being Business vs IT Asset. I am planning to talk…","categoryID":40,"dateInserted":"2023-02-07T10:21:42+00:00","dateUpdated":"2023-02-08T10:28:44+00:00","dateLastComment":"2023-02-07T10:21:42+00:00","insertUserID":23553,"insertUser":{"userID":23553,"name":"Nikita_S_Gnilozub","url":"https:\/\/community.anaplan.com\/profile\/Nikita_S_Gnilozub","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23553.png","dateLastActive":"2023-05-05T08:01:36+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23553,"lastUserID":23553,"lastUser":{"userID":23553,"name":"Nikita_S_Gnilozub","url":"https:\/\/community.anaplan.com\/profile\/Nikita_S_Gnilozub","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23553.png","dateLastActive":"2023-05-05T08:01:36+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":87,"score":1,"hot":3351617726,"url":"https:\/\/community.anaplan.com\/discussion\/154844\/building-anaplan-coe","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154844\/building-anaplan-coe","format":"Rich","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":1106,"urlcode":"center-of-excellence","name":"Center of Excellence"}],"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":33591,"type":"discussion","name":"Production Lists and Ragged Hierarchies Logic","excerpt":"Assume the following Non-Composite list, ragged hierarchy, needs to be set to Production Data. We need to refer to the ultimate parent to define the logic calculation. In the example, we have assumed that children of Parent 1 and Parent 3 need to return the 'logic 1' value from the constants module below, and those under…","categoryID":40,"dateInserted":"2018-05-31T14:07:26+00:00","dateUpdated":null,"dateLastComment":"2023-02-03T15:48:20+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-05-10T18:49:38+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":23683,"lastUser":{"userID":23683,"name":"CommunityMember117943","url":"https:\/\/community.anaplan.com\/profile\/CommunityMember117943","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/23683.png","dateLastActive":"2023-02-16T17:40:45+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":406,"score":3,"hot":3203217646,"url":"https:\/\/community.anaplan.com\/discussion\/33591\/production-lists-and-ragged-hierarchies-logic","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/33591\/production-lists-and-ragged-hierarchies-logic","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/01_33591.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"01.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":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":154815,"type":"discussion","name":"Community perspective: Smart Data Storage","excerpt":"We’ve all been faced with that question: to version or not to version. The requirements you face, together with your previous experience, will be taken into consideration to make that decision for each new model. But whatever route you decide to take, I think we can all agree that versions shouldn’t be used as storage.…","categoryID":40,"dateInserted":"2023-02-02T18:29:51+00:00","dateUpdated":"2023-05-12T16:12:38+00:00","dateLastComment":"2023-02-03T10:00:05+00:00","insertUserID":9525,"insertUser":{"userID":9525,"name":"lis.degeus","url":"https:\/\/community.anaplan.com\/profile\/lis.degeus","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9525.png","dateLastActive":"2023-06-05T07:56:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":67811,"lastUserID":9525,"lastUser":{"userID":9525,"name":"lis.degeus","url":"https:\/\/community.anaplan.com\/profile\/lis.degeus","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/9525.png","dateLastActive":"2023-06-05T07:56:56+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":363,"score":10,"hot":3359274749,"url":"https:\/\/community.anaplan.com\/discussion\/154815\/community-perspective-smart-data-storage","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154815\/community-perspective-smart-data-storage","format":"rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/TLIFHPI109KY\/image-01.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Image 01.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":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":154782,"type":"discussion","name":"Alternative Uses for the Management Report UX Page","excerpt":"IntroductionWith the addition of the Report UX page type, it is now possible to create highly formatted, customized slides to deliver key insights and clear reporting to your organization. As with many Anaplan features, our customers always come up with innovative ways to use this feature and this post will look at two of…","categoryID":40,"dateInserted":"2023-01-31T14:55:25+00:00","dateUpdated":"2023-05-10T17:52:32+00:00","dateLastComment":"2023-01-31T14:55:25+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-07-05T12:00:05+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":67811,"lastUserID":7892,"lastUser":{"userID":7892,"name":"billdowling","url":"https:\/\/community.anaplan.com\/profile\/billdowling","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/7892.jpeg","dateLastActive":"2023-07-05T12:00:05+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":90,"score":null,"hot":0,"url":"https:\/\/community.anaplan.com\/discussion\/154782\/alternative-uses-for-the-management-report-ux-page","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154782\/alternative-uses-for-the-management-report-ux-page","format":"rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/RK0XK3WHFQL7\/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":52,"urlcode":"UX","name":"UX"},{"tagID":1117,"urlcode":"management-reporting","name":"Management Reporting"}],"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":145950,"type":"discussion","name":"How to prepare for the change to the default Modeling Experience - FAQs","excerpt":"What is happening? The New Modeling Experience will become the default experience in February 2023. It is replacing the Classic Modeling Interface but not eliminating Classic Dashboards or forcing you to use the UX Apps and Pages. What does that mean? Simply, the modeling interface is getting an update to the look and feel…","categoryID":40,"dateInserted":"2022-08-31T10:52:36+00:00","dateUpdated":"2023-02-13T18:45:36+00:00","dateLastComment":"2023-01-31T10:15:27+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":67811,"lastUserID":62476,"lastUser":{"userID":62476,"name":"ibg1989","url":"https:\/\/community.anaplan.com\/profile\/ibg1989","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/62476.png","dateLastActive":"2023-07-12T05:21:42+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":392,"score":2,"hot":3337104483,"url":"https:\/\/community.anaplan.com\/discussion\/145950\/how-to-prepare-for-the-change-to-the-default-modeling-experience-faqs","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/145950\/how-to-prepare-for-the-change-to-the-default-modeling-experience-faqs","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/images\/vidyard.jpeg?Fs6tXkBcfT1WtjCrJ9DM9P.html?","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":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":154775,"type":"discussion","name":"Multi-select filters and their extension","excerpt":"If you are asked to name a few features which you use very often in Anaplan, there is a high chance that FILTERS will find its way to that list. There are so many places where they are used: saved views for imports\/exports, report creation, calculations, and the list goes on. They are basically ubiquitous! Premise: Ability…","categoryID":40,"dateInserted":"2023-01-30T23:23:32+00:00","dateUpdated":null,"dateLastComment":"2023-01-30T23:23:32+00:00","insertUserID":14648,"insertUser":{"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-06-10T15:24:07+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-06-10T15:24:07+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":143,"score":3,"hot":1675121912,"url":"https:\/\/community.anaplan.com\/discussion\/154775\/multi-select-filters-and-their-extension","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154775\/multi-select-filters-and-their-extension","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/ASOTM2MCDJGI\/picture1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Picture1.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"}],"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":154759,"type":"discussion","name":"When do your integrations require workspace administrator privileges?","excerpt":"Generally, you don’t need to have Workspace Administrator (WSA) privileges to run integrations; however, there are still some specific instances when they are required. This guide will provide an overview of when your integration user requires WSA privileges. Anaplan user types involved in integrations First off, let us…","categoryID":40,"dateInserted":"2023-01-27T19:38:37+00:00","dateUpdated":"2023-02-03T22:23:50+00:00","dateLastComment":"2023-01-27T19:38:37+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-07-10T16:51:31+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":365,"lastUserID":365,"lastUser":{"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-07-10T16:51:31+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":463,"score":8,"hot":3350313747,"url":"https:\/\/community.anaplan.com\/discussion\/154759\/when-do-your-integrations-require-workspace-administrator-privileges","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154759\/when-do-your-integrations-require-workspace-administrator-privileges","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/RL5TAVYFBYFN\/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":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":154747,"type":"discussion","name":"How to apply Conditional Formatting on multiple line items using one rule","excerpt":"I found this cool hack to apply similar conditional formatting to multiple line items by using just one rule! Generally, we need to make a line item for each conditional formatting or add one rule each line item which gets very tedious when there are more than 20, 30 of them. Here’s a simple yet effective hack to make this…","categoryID":40,"dateInserted":"2023-01-27T06:59:20+00:00","dateUpdated":"2023-01-27T07:06:05+00:00","dateLastComment":"2023-01-27T06:59:20+00:00","insertUserID":91134,"insertUser":{"userID":91134,"name":"Shaivya","url":"https:\/\/community.anaplan.com\/profile\/Shaivya","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/NQ5T1J6LR4PH\/n7YPM4F37Q4PB.png","dateLastActive":"2023-05-08T18:53:50+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":91134,"lastUserID":91134,"lastUser":{"userID":91134,"name":"Shaivya","url":"https:\/\/community.anaplan.com\/profile\/Shaivya","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/NQ5T1J6LR4PH\/n7YPM4F37Q4PB.png","dateLastActive":"2023-05-08T18:53:50+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":146,"score":2,"hot":3349606525,"url":"https:\/\/community.anaplan.com\/discussion\/154747\/how-to-apply-conditional-formatting-on-multiple-line-items-using-one-rule","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154747\/how-to-apply-conditional-formatting-on-multiple-line-items-using-one-rule","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/V52OXC2GKUDF\/cf-img.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"cf img.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"},{"tagID":455,"urlcode":"Dashboard","name":"Dashboard"},{"tagID":1091,"urlcode":"UX-Designer","name":"UX Designer"},{"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":154743,"type":"discussion","name":"Community perspective: Performing FVSchedule Excel function in Anaplan","excerpt":"When searching for FVSchedule in Anaplan Community there was seemingly method for\/content about this. There are always multiple methods to achieve the same result but this method has provided the required outcome and may be useful for anyone hoping to tackle an FVSchedule or similar calculation in Anaplan. What is FV…","categoryID":40,"dateInserted":"2023-01-26T23:53:11+00:00","dateUpdated":"2023-05-12T16:23:01+00:00","dateLastComment":"2023-01-26T23:53:11+00:00","insertUserID":27073,"insertUser":{"userID":27073,"name":"CalebW_77","url":"https:\/\/community.anaplan.com\/profile\/CalebW_77","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/27073.jpeg","dateLastActive":"2023-07-12T05:07:35+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":67811,"lastUserID":27073,"lastUser":{"userID":27073,"name":"CalebW_77","url":"https:\/\/community.anaplan.com\/profile\/CalebW_77","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/27073.jpeg","dateLastActive":"2023-07-12T05:07:35+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":true,"countComments":0,"countViews":193,"score":2,"hot":3349637479,"url":"https:\/\/community.anaplan.com\/discussion\/154743\/community-perspective-performing-fvschedule-excel-function-in-anaplan","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154743\/community-perspective-performing-fvschedule-excel-function-in-anaplan","format":"rich2","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/DTK7M6KXDQI4\/screen-shot-2023-01-26-at-3-33-02-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2023-01-26 at 3.33.02 PM.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":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"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":154732,"type":"discussion","name":"Export Anaplan Data with Non-WSA User","excerpt":"A customer’s Anaplan COE needed to share planning data with an internal department. The solution below leveraged a non-WSA (Workspace Administer) user account with Model specific access and an Anaplan Connect script to deliver the required data. 1. Create a non-WSA user ‘service account’ as an Internal user, although this…","categoryID":40,"dateInserted":"2023-01-25T13:41:48+00:00","dateUpdated":"2023-01-31T19:23:37+00:00","dateLastComment":"2023-01-25T13:41:48+00:00","insertUserID":11122,"insertUser":{"userID":11122,"name":"ChrisStauffer","url":"https:\/\/community.anaplan.com\/profile\/ChrisStauffer","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/U3A8XC6O5QBA\/nYD95YB2CKOGI.jpg","dateLastActive":"2023-07-10T14:55:03+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":11122,"lastUserID":11122,"lastUser":{"userID":11122,"name":"ChrisStauffer","url":"https:\/\/community.anaplan.com\/profile\/ChrisStauffer","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/U3A8XC6O5QBA\/nYD95YB2CKOGI.jpg","dateLastActive":"2023-07-10T14:55:03+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":85,"score":1,"hot":3349308634,"url":"https:\/\/community.anaplan.com\/discussion\/154732\/export-anaplan-data-with-non-wsa-user","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/154732\/export-anaplan-data-with-non-wsa-user","format":"Rich","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/uploads\/MK4W4US31FPO\/picture1.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Picture1.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":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":209,"urlcode":"Extensibility","name":"Extensibility"},{"tagID":605,"urlcode":"User-Access","name":"User Access"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">