社区知识库

"},"updateUserID":75258,"lastUserID":25808,"lastUser":{"userID":25808,"name":"JenniferC","url":"https:\/\/community.anaplan.com\/profile\/JenniferC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/25808.png","dateLastActive":"2023-02-28T00:24:25+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":0,"countViews":27,"score":1,"hot":3355076143,"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. Problem While 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-02-23T16:41:10+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-02-24T13:54:58+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":75258,"lastUserID":4770,"lastUser":{"userID":4770,"name":"andrewtye","url":"https:\/\/community.anaplan.com\/profile\/andrewtye","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4770.jpeg","dateLastActive":"2023-02-28T09:33:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":1,"countViews":49,"score":3,"hot":3354658389,"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":"Rich","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":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-02-22T20:53:07+00:00","dateLastComment":"2023-02-23T17:07:47+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-02-28T09:57:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":75258,"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-02-28T09:09:12+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":2,"countViews":543,"score":11,"hot":3354274626,"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":"Rich","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":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. 1. Common preparation Many platforms with a hierarchical structure have that hierarchy as an 'adjacency…","categoryID":40,"dateInserted":"2023-02-16T06:58:20+00:00","dateUpdated":"2023-02-16T16:19:53+00:00","dateLastComment":"2023-02-16T06:58:20+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-02-28T00:20:51+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":75258,"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-02-28T00:20:51+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":true,"pinLocation":"recent","closed":false,"sink":false,"countComments":0,"countViews":78,"score":1,"hot":1676531000,"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":"Rich","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":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-01-27T22:48:08+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-02-03T19:15:45+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":101733,"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-02-03T19:15:45+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":true,"pinLocation":"recent","closed":false,"sink":true,"countComments":0,"countViews":172,"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":"Rich","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":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-02-24T09:20:40+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-02-24T09:20:40+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":63,"score":19,"hot":3338566817,"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":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-02-22T05:57:13+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":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-02-28T05:48:24+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":6340,"score":10,"hot":3335359033,"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":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-02-27T22:34:33+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-02-28T05:40:45+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":44,"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-02-10T06:52:07+00:00","banned":0,"punished":0,"private":true,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":12,"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-02-08T10:35:24+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-02-08T10:35:24+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":46,"score":null,"hot":0,"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-02-03T13:33:49+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":102,"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-02-03T16:04:29+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-02-24T09:41:30+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"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-02-24T09:41:30+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":192,"score":6,"hot":3350805860,"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":"Rich","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":"Introduction With 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":null,"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-02-27T09:58:05+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"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-02-27T09:58:05+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":23,"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":"Rich","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":622,"urlcode":"Community-Perspectives","name":"Community Perspectives"},{"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-02-28T05:48:24+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":290,"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-02-07T11:00:21+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-02-07T11:00:21+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":96,"score":2,"hot":1675121612,"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-02-27T19:52:25+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-02-27T19:52:25+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":145,"score":7,"hot":3350313447,"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-02-24T04:41:19+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-02-24T04:41:19+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":95,"score":1,"hot":3349606225,"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":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\/av\/11122.png","dateLastActive":"2023-02-27T22:13:08+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\/av\/11122.png","dateLastActive":"2023-02-27T22:13:08+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":62,"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}]},{"discussionID":125039,"type":"discussion","name":"Matrix Inverse using Optimizer","excerpt":"In the following article, we will discuss how to use Anaplan Optimizer to compute Matrix Inverse. Matrix Inverse as a functionality can be used to solve a Multi Linear Regression Problem in Anaplan. Using Matrix Inverse, we are going to solve the following Multi Linear Regression equation: Y = b0 + b1x1 + b2x2 + b3x3 +…","categoryID":40,"dateInserted":"2021-12-02T07:23:48+00:00","dateUpdated":"2022-12-22T16:25:04+00:00","dateLastComment":"2023-01-16T14:15:40+00:00","insertUserID":14230,"insertUser":{"userID":14230,"name":"AnkitGupta","url":"https:\/\/community.anaplan.com\/profile\/AnkitGupta","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/14230.jpeg","dateLastActive":"2022-05-04T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":2631,"lastUserID":21250,"lastUser":{"userID":21250,"name":"MaciejD","url":"https:\/\/community.anaplan.com\/profile\/MaciejD","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/21250.png","dateLastActive":"2023-01-30T09:56:56+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":48,"score":3,"hot":3312309868,"url":"https:\/\/community.anaplan.com\/discussion\/125039\/matrix-inverse-using-optimizer","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/125039\/matrix-inverse-using-optimizer","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Line_Item_Formulas_125039.jpg?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Line Item Formulas.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":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":137853,"type":"discussion","name":"How to use “LOOKUP” with summary elements","excerpt":"In the following article, I would like to discuss a common case of model building: the LOOKUP function doesn’t work with summary elements of hierarchical lists. Among other things, this forces model builders to use SELECT and not configure Production Data for some lists. I want to present to you an alternative approach.…","categoryID":40,"dateInserted":"2022-05-25T07:00:00+00:00","dateUpdated":null,"dateLastComment":"2023-01-13T10:42:43+00:00","insertUserID":8906,"insertUser":{"userID":8906,"name":"AntonMineev","url":"https:\/\/community.anaplan.com\/profile\/AntonMineev","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8906.jpeg","dateLastActive":"2023-02-03T06:20:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":102083,"lastUser":{"userID":102083,"name":"PhilippJung","url":"https:\/\/community.anaplan.com\/profile\/PhilippJung","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/JL5TT3OQ856S\/n8FUMR1FYHN99.jpeg","dateLastActive":"2023-01-19T16:46:51+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":165,"score":26,"hot":3327080563,"url":"https:\/\/community.anaplan.com\/discussion\/137853\/how-to-use-lookup-with-summary-elements","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/137853\/how-to-use-lookup-with-summary-elements","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/AntonMineev_0-1652694110871_137853.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"AntonMineev_0-1652694110871.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":33544,"type":"discussion","name":"OEG Best Practice: The model design process","excerpt":"The process of designing a model will help you: * Understand the customer’s problem more completely * Bring to light any incorrect assumptions you may have made, allowing for correction before building begins * Provide the big picture view for building This process includes the following steps: * Understand the…","categoryID":40,"dateInserted":"2018-05-31T12:13:24+00:00","dateUpdated":"2023-02-09T22:46:49+00:00","dateLastComment":"2023-01-12T18:01:21+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":466,"lastUser":{"userID":466,"name":"pam_pervenanze","url":"https:\/\/community.anaplan.com\/profile\/pam_pervenanze","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/466.jpeg","dateLastActive":"2023-02-27T20:36:14+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":866,"score":45,"hot":3201333585,"url":"https:\/\/community.anaplan.com\/discussion\/33544\/oeg-best-practice-the-model-design-process","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/33544\/oeg-best-practice-the-model-design-process","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"}],"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":81648,"type":"discussion","name":"OEG Best Practice: Top five design best practices for UX: Desktop and mobile","excerpt":"Follow our UX team's recommendations and guidelines to leverage the UX to its fullest potential. Desktop best practices Our top five: * Minimize time to decision * Progressive disclosure * Smart grouping * Help and guide * Consistency Minimize time-to-decision Focus on the outcome your users are attempting to arrive at and…","categoryID":40,"dateInserted":"2020-08-26T09:05:53+00:00","dateUpdated":"2023-02-09T18:42:21+00:00","dateLastComment":"2022-12-21T07:31:31+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":101180,"lastUser":{"userID":101180,"name":"RobertGriffin","url":"https:\/\/community.anaplan.com\/profile\/RobertGriffin","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/101180.png","dateLastActive":"2022-12-16T08:03:22+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":164,"score":49,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/81648\/oeg-best-practice-top-five-design-best-practices-for-ux-desktop-and-mobile","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/81648\/oeg-best-practice-top-five-design-best-practices-for-ux-desktop-and-mobile","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Minimize_TtD_81648.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Executive Summary Board"},"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":153883,"type":"discussion","name":"Community perspective: Version switchover management from UX Page with API","excerpt":"The Anaplan API offers many improvements to model management, which can help improve the data quality and make work more efficient by eliminating repetitive tasks, which are error prone. One area where I have found myself doing repetitive tasks is switchover management. Especially when dealing with multiple models it…","categoryID":40,"dateInserted":"2022-12-14T08:00:00+00:00","dateUpdated":"2023-01-11T19:23:45+00:00","dateLastComment":"2022-12-15T01:56:54+00:00","insertUserID":71843,"insertUser":{"userID":71843,"name":"Lehtohen","url":"https:\/\/community.anaplan.com\/profile\/Lehtohen","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/71843.png","dateLastActive":"2023-01-25T09:06:57+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":8914,"lastUser":{"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":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":73,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/153883\/community-perspective-version-switchover-management-from-ux-page-with-api","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/153883\/community-perspective-version-switchover-management-from-ux-page-with-api","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Sieppaa_153883.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Sieppaa.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"},{"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":95876,"type":"discussion","name":"CloudWorks—This is how we use it, Part 2: setup","excerpt":"In Part 2 of our CloudWorks—This is how we use it series, we're diving into how to set up CloudWorks. Need a refresher on the basics of CloudWorks? See Part 1. Before starting anything, you need to identify and create an Integration Administrator (Learn more here: Access Control).Ready? Let's start Before we dive in, this…","categoryID":40,"dateInserted":"2021-01-26T06:56:03+00:00","dateUpdated":"2022-12-15T00:00:00+00:00","dateLastComment":"2022-12-15T00:23:38+00:00","insertUserID":84,"insertUser":{"userID":84,"name":"annejulie","url":"https:\/\/community.anaplan.com\/profile\/annejulie","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/84.jpeg","dateLastActive":"2023-02-01T23:07:56+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":2631,"lastUserID":48320,"lastUser":{"userID":48320,"name":"Shawnm","url":"https:\/\/community.anaplan.com\/profile\/Shawnm","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/48320.png","dateLastActive":"2022-11-24T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":174,"score":2,"hot":3282712181,"url":"https:\/\/community.anaplan.com\/discussion\/95876\/cloudworks-this-is-how-we-use-it-part-2-setup","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/95876\/cloudworks-this-is-how-we-use-it-part-2-setup","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Screen_Shot_2021-01-21_at_2.51.11_PM_95876.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2021-01-21 at 2.51.11 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":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":153938,"type":"discussion","name":"Use categories to stay organized","excerpt":"","categoryID":40,"dateInserted":"2022-12-12T10:08:33+00:00","dateUpdated":"2023-01-10T20:17:16+00:00","dateLastComment":"2022-12-12T10:08: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-27T19:54:54+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":2631,"lastUserID":22611,"lastUser":{"userID":22611,"name":"JamiesonC","url":"https:\/\/community.anaplan.com\/profile\/JamiesonC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22611.jpeg","dateLastActive":"2023-02-27T19:54:54+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":21,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/153938\/use-categories-to-stay-organized","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/153938\/use-categories-to-stay-organized","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/28147689\/p7uBK1LQzEG84Vwc2zbXS9wk3yJYWN0U_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Use categories to stay organized"},"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":138310,"type":"discussion","name":"Dynamic renaming of line items","excerpt":"Consider the following situation: As part of a planning process, a planning user requires the following items to be presented in the module: * Current year revenue actuals - year to date, needed to plan for the next year around the third-quarter quarter mark of the year * Current year revenue projection, based on the run…","categoryID":40,"dateInserted":"2022-06-01T07:00:00+00:00","dateUpdated":"2022-12-11T00:00:00+00:00","dateLastComment":"2022-12-11T23:44:57+00:00","insertUserID":10909,"insertUser":{"userID":10909,"name":"UpaliKW","url":"https:\/\/community.anaplan.com\/profile\/UpaliKW","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/U7KPINIL6RPM\/nFI96GPNOK5XB.jpg","dateLastActive":"2023-02-08T11:28:44+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":25760,"lastUser":{"userID":25760,"name":"twan.laan@sbb.ch","url":"https:\/\/community.anaplan.com\/profile\/twan.laan%40sbb.ch","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/25760.png","dateLastActive":"2022-09-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":100,"score":35,"hot":3324881397,"url":"https:\/\/community.anaplan.com\/discussion\/138310\/dynamic-renaming-of-line-items","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/138310\/dynamic-renaming-of-line-items","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/CY_View_138310.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"CY View.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":153548,"type":"discussion","name":"Dynamic chart using line item subset","excerpt":"* Problem statement * Solution approaches * Selection on the chart * Using line item subsets * Step 1: * Step 2 * Step 3 * Step 4 * Conclusion Problem statement A customer from the banking industry recently posed this requirement: \"As a reviewer, I want to compare different metrics. Some are absolute, and some are…","categoryID":40,"dateInserted":"2022-12-08T09:00:00+00:00","dateUpdated":"2023-01-11T19:25:37+00:00","dateLastComment":"2022-12-08T09:00:00+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-02-27T22:34:33+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":1507,"lastUser":{"userID":1507,"name":"anikdas","url":"https:\/\/community.anaplan.com\/profile\/anikdas","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/1507.png","dateLastActive":"2023-02-27T22:34:33+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":54,"score":8,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/153548\/dynamic-chart-using-line-item-subset","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/153548\/dynamic-chart-using-line-item-subset","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/anikdas_0-1670285123806_153548.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"anikdas_0-1670285123806.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"}],"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":153620,"type":"discussion","name":"PlanIQ: Using a backtest window to assess performance","excerpt":"In almost all cases, computing forecast accuracy requires a calculation of the difference between forecast versus actuals. One of the best ways to approximate the future accuracy of the forecast is to use a backtest window. With a backtest window, you can simulate “what if” you had run a PlanIQ forecast with the data…","categoryID":40,"dateInserted":"2022-12-07T12:30:55+00:00","dateUpdated":"2023-01-11T18:48:26+00:00","dateLastComment":"2022-12-07T12:30:55+00:00","insertUserID":34718,"insertUser":{"userID":34718,"name":"NatalieC","url":"https:\/\/community.anaplan.com\/profile\/NatalieC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/34718.png","dateLastActive":"2022-11-23T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":23002,"lastUserID":34718,"lastUser":{"userID":34718,"name":"NatalieC","url":"https:\/\/community.anaplan.com\/profile\/NatalieC","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/34718.png","dateLastActive":"2022-11-23T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":69,"score":2,"hot":3343879761,"url":"https:\/\/community.anaplan.com\/discussion\/153620\/planiq-using-a-backtest-window-to-assess-performance","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/153620\/planiq-using-a-backtest-window-to-assess-performance","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/backtest_153620.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"backtest.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":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":151486,"type":"discussion","name":"[First Look] Formula Autocomplete","excerpt":" Feature: Formula Autocomplete Release Date: November 2022 Impact Assessment: Ease of Modeling - Not Optional What is changing? The autocomplete functionality is a new way to build formulas that automatically searches for matching functions, modules, line items, lists, and list properties as you type. What are the…","categoryID":40,"dateInserted":"2022-11-14T16:10:07+00:00","dateUpdated":"2022-12-06T00:00:00+00:00","dateLastComment":"2022-12-06T20:07:01+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":17460,"lastUser":{"userID":17460,"name":"rohan.deo","url":"https:\/\/community.anaplan.com\/profile\/rohan.deo","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17460.jpeg","dateLastActive":"2022-11-21T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":73,"score":23,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/151486\/first-look-formula-autocomplete","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/151486\/first-look-formula-autocomplete","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/eschera_0-1667859415296_151486.png?image-dimensions\/686x337\/****-exif-data\/true?v=v2","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"eschera_0-1667859415296.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":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":153499,"type":"discussion","name":"Build: Scrolling Sync","excerpt":"","categoryID":40,"dateInserted":"2022-12-05T10:42:43+00:00","dateUpdated":"2023-01-09T22:16:28+00:00","dateLastComment":"2022-12-05T10:42: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-27T19:54:54+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":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/153499\/build-scrolling-sync","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/153499\/build-scrolling-sync","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/cdn.vidyard.com\/thumbnails\/32383369\/j29Cp_vE_Q6dGZ80UVBJCbY4KI1-lsFG_play_button_small.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Scrolling sync"},"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">