社区知识库

"},"updateUserID":23002,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":37,"score":4,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/111177\/oeg-best-practice-model-cut-over-checklist","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/111177\/oeg-best-practice-model-cut-over-checklist","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":110436,"type":"discussion","name":"PlanIQ - How to manage NULL values?","excerpt":"­­­­In real-world forecasting applications, it is common for datasets to contain null values, which represent missing values for specific points in time. There can be multiple reasons for the presence of missing values. For example, a transaction may not have occurred, or a device or service that monitors data may have…","categoryID":40,"dateInserted":"2021-06-10T16:12:32+00:00","dateUpdated":"2022-12-22T17:36:21+00:00","dateLastComment":"2021-06-10T16:12: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":2631,"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":9,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/110436\/planiq-how-to-manage-null-values","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/110436\/planiq-how-to-manage-null-values","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":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":110383,"type":"discussion","name":"PlanIQ - Algorithm selection by item: mix and match your forecast","excerpt":"What is algorithm selection by item? Algorithm selection by item is the use of more than one algorithm to produce optimal forecasts across multiple items. Instead of using forecasts generated by a single algorithm for all items in the historical data module, where the algorithm is selected based on best overall performance…","categoryID":40,"dateInserted":"2021-06-10T16:09:15+00:00","dateUpdated":"2022-12-22T17:36:53+00:00","dateLastComment":"2021-06-10T16:09:15+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":2631,"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":8,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/110383\/planiq-algorithm-selection-by-item-mix-and-match-your-forecast","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/110383\/planiq-algorithm-selection-by-item-mix-and-match-your-forecast","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":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":110123,"type":"discussion","name":"PlanIQ - New product introduction: all you ever wondered about starting your forecast from scratch","excerpt":"New Product Introduction (NPI) or Cold Start in time series forecasting is a scenario where forecasts should be produced for new items (e.g. new SKU) for which there is limited historical data, or no historical data at all. The advanced neural networks machine learning algorithms supported by PlanIQ can generate…","categoryID":40,"dateInserted":"2021-06-10T16:07:40+00:00","dateUpdated":"2022-12-22T17:37:18+00:00","dateLastComment":"2021-06-10T16:07:40+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":2631,"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":20,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/110123\/planiq-new-product-introduction-all-you-ever-wondered-about-starting-your-forecast-from-scratch","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/110123\/planiq-new-product-introduction-all-you-ever-wondered-about-starting-your-forecast-from-scratch","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/_image_1__110123.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"_image_1_.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":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":110438,"type":"discussion","name":"PlanIQ - How to use item attributes to refine your forecast","excerpt":"Metadata attributes are static, non-time dependent categorical text features that describe the items in the historical time series data. Examples for attributes could be style, category, geographic location, size, item hierarchy level etc. The advanced neural network machine learning algorithms supported by PlanIQ can…","categoryID":40,"dateInserted":"2021-06-10T16:03:47+00:00","dateUpdated":"2022-12-22T17:37:49+00:00","dateLastComment":"2021-06-10T16:03:47+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":2631,"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":13,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/110438\/planiq-how-to-use-item-attributes-to-refine-your-forecast","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/110438\/planiq-how-to-use-item-attributes-to-refine-your-forecast","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1622823739861_110438.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Example of an Attribute Module"},"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":110386,"type":"discussion","name":"PlanIQ - Probabilistic forecasting using forecast quantiles","excerpt":"Probabilistic forecasts & forecast quantiles PlanIQ produces probabilistic forecasts. This means that PlanIQ algorithms output a distribution of possible values, rather than a single point forecast typically outputted by other solutions. This distribution can be divided into quantiles. Applied to forecasting, quantiles…","categoryID":40,"dateInserted":"2021-06-10T15:57:21+00:00","dateUpdated":"2022-12-22T17:38:08+00:00","dateLastComment":"2021-06-10T15:57: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":2631,"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":7,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/110386\/planiq-probabilistic-forecasting-using-forecast-quantiles","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/110386\/planiq-probabilistic-forecasting-using-forecast-quantiles","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1622762538672_110386.png?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1622762538672.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":109840,"type":"discussion","name":"OEG Best Practice: PlanIQ: Design and build your item list for forecasting","excerpt":"* What is the best practice for concatenation in Anaplan? * Step-by-step overview * Level 1 – code inefficient * Level 2 – code better * Level 3 – Code to use * Level 4 – Optimized code to use * How do we handle items with limited to no history? * Adding “Cold Start” Items Before diving in, if you need to refresh your…","categoryID":40,"dateInserted":"2021-06-10T15:51:03+00:00","dateUpdated":"2023-02-09T21:29:35+00:00","dateLastComment":"2021-06-10T15:51:03+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":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":43,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/109840\/oeg-best-practice-planiq-design-and-build-your-item-list-for-forecasting","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/109840\/oeg-best-practice-planiq-design-and-build-your-item-list-for-forecasting","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1622239816749_109840.png?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1622239816749.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"}],"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":110874,"type":"discussion","name":"Anaplan Connect 2.0 - Approaches to Anaplan integration using On-Prem integration platforms","excerpt":"This article is the last one on our series about Anaplan Connect 2.0. To refresh your memory on Part 1 & 2, go here and there. There are several On-Prem integration platforms that are popular amongst Anaplan customers. These include Informatica Power Center, IBM InfoSphere DataStage, and Talend Studio. However, none of…","categoryID":40,"dateInserted":"2021-06-09T10:21:41+00:00","dateUpdated":"2022-12-22T16:45:28+00:00","dateLastComment":"2021-06-09T10:21:41+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":2631,"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":52,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/110874\/anaplan-connect-2-0-approaches-to-anaplan-integration-using-on-prem-integration-platforms","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/110874\/anaplan-connect-2-0-approaches-to-anaplan-integration-using-on-prem-integration-platforms","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1623193184480_110874.png?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1623193184480.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":110861,"type":"discussion","name":"Anaplan Connect 2.0 - Advanced Scripts","excerpt":"This article is the 2nd part of our 3-blogs series on Anaplan Connect 2.0. If you missed part 1, go here. Disclaimer:The scripts and examples in this article have been fully tested by our team, but they are not supported by Anaplan; if you have any issue, please use the comments below. Target Audience: Integration…","categoryID":40,"dateInserted":"2021-06-09T10:19:06+00:00","dateUpdated":"2022-12-22T16:45:54+00:00","dateLastComment":"2021-06-09T10:19:06+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":2631,"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":82,"score":6,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/110861\/anaplan-connect-2-0-advanced-scripts","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/110861\/anaplan-connect-2-0-advanced-scripts","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1623187852091_110861.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1623187852091.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":110824,"type":"discussion","name":"[Start Here] Anaplan Connect 2.0 and JDBC Connectivity","excerpt":"* What is Anaplan Connect? * What is covered in this article? * What is NOT covered in this article? * What pre-requisites do I need? * Deep Dive on Integration * Integrating with SAP HANA Cloud * Integrating with Snowflake * Integrating with Azure SQL Database * Integrating with Google Cloud (GCP) BigQuery * Integrating…","categoryID":40,"dateInserted":"2021-06-09T10:13:11+00:00","dateUpdated":null,"dateLastComment":"2021-06-09T10:13:11+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":332,"score":6,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/110824\/start-here-anaplan-connect-2-0-and-jdbc-connectivity","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/110824\/start-here-anaplan-connect-2-0-and-jdbc-connectivity","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1623181235320_110824.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1623181235320.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":110495,"type":"discussion","name":"Transactional APIs - Part 2: Use Cases","excerpt":"* Introduction * Following use cases will be presented in this section: * How to retrieve id for a given dimension\/list & list member from its name or code * How to retrieve allocated & consumed space for a Workspace & Model * Workspace Sizing Use case * Model Memory Usage Use case * How to retrieve permitted number of…","categoryID":40,"dateInserted":"2021-06-04T16:33:46+00:00","dateUpdated":"2023-01-09T21:35:16+00:00","dateLastComment":"2021-06-08T08:39:57+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":17847,"lastUser":{"userID":17847,"name":"Khanna","url":"https:\/\/community.anaplan.com\/profile\/Khanna","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/17847.jpeg","dateLastActive":"2021-12-08T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":98,"score":6,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/110495\/transactional-apis-part-2-use-cases","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/110495\/transactional-apis-part-2-use-cases","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1622848544880_110495.png?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1622848544880.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":719,"urlcode":"Developer","name":"Developer"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":110120,"type":"discussion","name":"[Start Here] Transactional APIs – Part 1: The Basics","excerpt":"Welcome! We’re so glad you’re here. We’re shining the spotlight on Anaplan's Transactional APIs and we’ve crafted this blog post to cover the basics like what it is, who is it for, and a high level overview of some use cases for them. Let’s get right to it! What are Anaplan Transactional APIs? Data integration is a key…","categoryID":40,"dateInserted":"2021-06-04T16:33:24+00:00","dateUpdated":"2023-01-09T20:36:08+00:00","dateLastComment":"2021-06-04T16:33:24+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":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":56,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/110120\/start-here-transactional-apis-part-1-the-basics","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/110120\/start-here-transactional-apis-part-1-the-basics","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1622581467870_110120.png?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1622581467870.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":719,"urlcode":"Developer","name":"Developer"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":109782,"type":"discussion","name":"[Start Here] - BYOK","excerpt":"Interested in securing your data? Anaplan's cloud-based encryption technology lets you encrypt and control any data in the cloud before incorporating it into your planning models. This blog presents a consolidated list of resources that will guide you in implementing Anaplan’s Bring Your Own Key (BYOK) technology. We…","categoryID":40,"dateInserted":"2021-05-28T11:27:33+00:00","dateUpdated":"2022-12-22T16:49:37+00:00","dateLastComment":"2021-05-28T11:27:33+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":2631,"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":5,"score":null,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/109782\/start-here-byok","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/109782\/start-here-byok","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":26,"urlcode":"Security-and-Administration","name":"Security and Administration"},{"tagID":376,"urlcode":"How-to","name":"How to"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":109447,"type":"discussion","name":"How to use Talend with CA Certs and Transactional APIs","excerpt":"In this article, we will illustrate an example of real-life scenario involving Anaplan's Transactional APIs with Talend and CA Certs. If you haven't already, we recommend to start your CA Certs journey here and then there. Pre-requisites * Talend Open Studio Knowledge * Anaplan REST API * REST API & JSON * Python…","categoryID":40,"dateInserted":"2021-05-28T11:13:35+00:00","dateUpdated":"2023-01-09T21:51:05+00:00","dateLastComment":"2021-05-28T11:13:35+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":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":64,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/109447\/how-to-use-talend-with-ca-certs-and-transactional-apis","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/109447\/how-to-use-talend-with-ca-certs-and-transactional-apis","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1621987665878_109447.png?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1621987665878.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":719,"urlcode":"Developer","name":"Developer"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":109439,"type":"discussion","name":"How to leverage sample codes to generate authentication strings from CA Certs?","excerpt":"In Part 1 of this blog series, we presented “under the hood” details on how CA Certs are used to authenticate to Anaplan. Let’s recap what we learned in Part 1. Anaplan Integration APIs requests require an authentication token (AnaplanAuthToken) in its headers. Anaplan authentication service API is used to generate this…","categoryID":40,"dateInserted":"2021-05-28T11:10:01+00:00","dateUpdated":"2022-12-22T16:50:28+00:00","dateLastComment":"2021-05-28T11:10: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":2631,"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":200,"score":1,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/109439\/how-to-leverage-sample-codes-to-generate-authentication-strings-from-ca-certs","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/109439\/how-to-leverage-sample-codes-to-generate-authentication-strings-from-ca-certs","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1621975661464_109439.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1621975661464.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":108592,"type":"discussion","name":"[Start Here] Anaplan Optimizer","excerpt":"In this series, we will teach you what Optimizer is, how it can help your organization solve complex business challenges, and when to use it. We will approach this in 2 steps: * Where to start with Optimizer? (this article) * How to setup Optimizer – hands-on exercises* For territory assignment * For transportation * And…","categoryID":40,"dateInserted":"2021-05-26T09:28:14+00:00","dateUpdated":"2022-12-22T17:43:24+00:00","dateLastComment":"2021-05-26T09:28:14+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":2631,"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":107,"score":7,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/108592\/start-here-anaplan-optimizer","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/108592\/start-here-anaplan-optimizer","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1621290838021_108592.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1621290838021.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":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":109550,"type":"discussion","name":"Run your integrations on Camel","excerpt":"Integration is one of the key implementations for most enterprise solutions. It involves connecting different applications and transforming a huge amount of data on a daily or ad-hoc basis. Different iPass tools are available in today's market to make the integration easy to use without any coding. They provide a good user…","categoryID":40,"dateInserted":"2021-05-26T04:56:07+00:00","dateUpdated":null,"dateLastComment":"2021-05-26T04:56:07+00:00","insertUserID":10442,"insertUser":{"userID":10442,"name":"karthik_kumar","url":"https:\/\/community.anaplan.com\/profile\/karthik_kumar","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/10442.jpeg","dateLastActive":"2021-05-26T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":4,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/109550\/run-your-integrations-on-camel","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/109550\/run-your-integrations-on-camel","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/image_109550.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":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":94889,"type":"discussion","name":"OEG Best Practice: The MOBILE way: Best practices for building in the UX for mobile devices","excerpt":"To achieve the ultimate Connected Planning experience, Anaplan users can use the mobile app to stay on top of their data from anywhere. With Anaplan at your fingertips, creating pages with mobile in mind has never been more important. To design and build pages that look and work great on mobile, use the MOBILE method to…","categoryID":40,"dateInserted":"2021-01-11T07:16:17+00:00","dateUpdated":"2023-02-09T20:13:34+00:00","dateLastComment":"2021-05-19T06:57: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":23002,"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-03-01T11:09:08+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":34,"score":11,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/94889\/oeg-best-practice-the-mobile-way-best-practices-for-building-in-the-ux-for-mobile-devices","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/94889\/oeg-best-practice-the-mobile-way-best-practices-for-building-in-the-ux-for-mobile-devices","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Screenshot_2020-12-01_at_14.53.47_94889.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2020-12-01 at 14.53.47.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":1123,"urlcode":"user-experience","name":"User Experience"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":106157,"type":"discussion","name":"Update Current Period Action","excerpt":"From April 24, 2021, model builders will be able to update Current Period via an action. Workspace Administrators (WSAs) can always update the Current Period manually via the Model Calendar, however, this may not always be convenient. The Update Current Period action enables the WSAs to increase efficiency and reduce…","categoryID":40,"dateInserted":"2021-04-26T08:36:51+00:00","dateUpdated":null,"dateLastComment":"2021-05-18T09:39:23+00:00","insertUserID":12120,"insertUser":{"userID":12120,"name":"dafinkapancheva","url":"https:\/\/community.anaplan.com\/profile\/dafinkapancheva","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/12120.png","dateLastActive":"2021-10-22T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":10247,"lastUser":{"userID":10247,"name":"pvijayteja","url":"https:\/\/community.anaplan.com\/profile\/pvijayteja","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/10247.png","dateLastActive":"2022-08-03T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":32,"score":16,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/106157\/update-current-period-action","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/106157\/update-current-period-action","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/dafinkapancheva_0-1619449660511_106157.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"dafinkapancheva_0-1619449660511.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":54309,"type":"discussion","name":"OEG Best Practice: Line item subsets demystified","excerpt":"Line item subsets are one of the most powerful and efficient features in Anaplan, yet one of the least understood. The COLLECT() function is probably the only “black box” function within Anaplan as is it not immediately apparent what it is doing or where the source values are coming from. In the following article, I will…","categoryID":40,"dateInserted":"2019-11-13T10:21:23+00:00","dateUpdated":"2023-02-09T21:48:58+00:00","dateLastComment":"2021-05-18T09:00:38+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":13393,"lastUser":{"userID":13393,"name":"abhay.kanik","url":"https:\/\/community.anaplan.com\/profile\/abhay.kanik","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/13393.jpeg","dateLastActive":"2023-02-02T15:39:40+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":612,"score":32,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/54309\/oeg-best-practice-line-item-subsets-demystified","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/54309\/oeg-best-practice-line-item-subsets-demystified","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Picture_1_54309.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Picture 1.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":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":106027,"type":"discussion","name":"Summary Calculations With the User List","excerpt":"Even though the Users list does not have a top member assigned to it, with the release on April 24, 2021, model builders will be able to use the following summary functions with the Users List: SUM, LOOKUP, ISFIRSTOCCURRENCE, CUMULATE, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK. Lookup First, let’s look…","categoryID":40,"dateInserted":"2021-04-26T08:03:24+00:00","dateUpdated":null,"dateLastComment":"2021-05-18T00:35:44+00:00","insertUserID":240,"insertUser":{"userID":240,"name":"rob_marshall","url":"https:\/\/community.anaplan.com\/profile\/rob_marshall","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/240.jpeg","dateLastActive":"2023-03-01T21:27:51+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":11772,"lastUser":{"userID":11772,"name":"kavinkumar","url":"https:\/\/community.anaplan.com\/profile\/kavinkumar","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/11772.jpeg","dateLastActive":"2023-02-26T14:03:27+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":62,"score":25,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/106027\/summary-calculations-with-the-user-list","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/106027\/summary-calculations-with-the-user-list","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Picture1_106027.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"},{"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":108512,"type":"discussion","name":"Understanding Errors and Rejected Lines When Importing Data Via APIs","excerpt":"The objective of this article is to provide a quick explanation on the responses that APIs can provide when an import is submitted, in particular regarding the dump logs generated. This content is suitable for Model Builders comfortable with APIs. * When Does an Import Create a Dump File? * Import in a Module * ‘Failed’…","categoryID":40,"dateInserted":"2021-05-17T10:48:45+00:00","dateUpdated":"2022-12-22T17:45:01+00:00","dateLastComment":"2021-05-17T10:48:45+00:00","insertUserID":101715,"insertUser":{"userID":101715,"name":"AnaplanOEG","url":"https:\/\/community.anaplan.com\/profile\/AnaplanOEG","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/AKCCM7USWMRM\/n1EGQRZGHE2WA.png","dateLastActive":"2023-02-14T17:14:29+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":2631,"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":134,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/108512\/understanding-errors-and-rejected-lines-when-importing-data-via-apis","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/108512\/understanding-errors-and-rejected-lines-when-importing-data-via-apis","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_24-1619721290044_108512.png?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_24-1619721290044.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":106516,"type":"discussion","name":"Reducing Saves in Data Hubs","excerpt":"Data Hubs typically include large lists or numerous lists; both contribute to longer save durations. Model saves block other model actions, so we want to reduce the frequency of saves as much as possible. Reduce the Frequency of Saves First, put the data hub model into Deployed Mode. Learn more here: Enabling and Disabling…","categoryID":40,"dateInserted":"2021-04-27T11:43:28+00:00","dateUpdated":null,"dateLastComment":"2021-05-07T06:21:55+00:00","insertUserID":220,"insertUser":{"userID":220,"name":"MarkWarren","url":"https:\/\/community.anaplan.com\/profile\/MarkWarren","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/220.png","dateLastActive":"2023-03-01T10:22:07+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"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-03-01T18:52:32+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":31,"score":6,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/106516\/reducing-saves-in-data-hubs","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/106516\/reducing-saves-in-data-hubs","format":"html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":37,"urlcode":"Modeling","name":"Modeling"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":1118,"urlcode":"data-integration","name":"Data Integration"},{"tagID":1125,"urlcode":"application-lifecycle-management","name":"Application Lifecycle Management"}],"reactions":[{"tagID":1079,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":1085,"urlcode":"Like","name":"Like","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":105881,"type":"discussion","name":"Memory usage from text concatenation","excerpt":"We know that2.02-04 Text Strings are bad for Anaplan models and that text functions and formulas using text are the slowest (slow in comparison to similarly-sized numeric formulas). One of the biggest contributing factors to the poor performance of text is the impact on the memory used by Anaplan. The following diagrams…","categoryID":40,"dateInserted":"2021-04-21T10:49:30+00:00","dateUpdated":null,"dateLastComment":"2021-05-07T05:29:16+00:00","insertUserID":220,"insertUser":{"userID":220,"name":"MarkWarren","url":"https:\/\/community.anaplan.com\/profile\/MarkWarren","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/220.png","dateLastActive":"2023-03-01T10:22:07+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":568,"lastUser":{"userID":568,"name":"nikolay_denisov","url":"https:\/\/community.anaplan.com\/profile\/nikolay_denisov","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/568.jpeg","dateLastActive":"2023-01-31T13:35:36+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":93,"score":30,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/105881\/memory-usage-from-text-concatenation","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/105881\/memory-usage-from-text-concatenation","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/POWERPNT_2021-04-13_15-44-45_105881.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Performance Cost by Cell type"},"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":105533,"type":"discussion","name":"Retail: Markdown Planning","excerpt":"Summary As a buyer, you are responsible for managing your price reductions to a monthly markdown budget. But markdown management at your company is not that straightforward. You must also adhere to the company’s pricing policies when considering a new price for your items, including having to use price tiers, percentage…","categoryID":40,"dateInserted":"2021-04-19T06:45:02+00:00","dateUpdated":null,"dateLastComment":"2021-04-19T06:45:02+00:00","insertUserID":22354,"insertUser":{"userID":22354,"name":"JaredDolich","url":"https:\/\/community.anaplan.com\/profile\/JaredDolich","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/22354.png","dateLastActive":"2023-03-01T16:06:00+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":6,"score":2,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/105533\/retail-markdown-planning","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/105533\/retail-markdown-planning","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/JaredDolich_1-1613241097462_105533.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"JaredDolich_1-1613241097462.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":42821,"type":"discussion","name":"Increase end user adoption with smart filters","excerpt":"* Problem statement * How do we solve this with smart filters? * Customer examples * How to model smart filters * Size and performance considerations * Upcoming functionality * Conclusion Problem statement Anaplan users are often moving from an Excel environment (with the flexibility to filter, search, and sort data…","categoryID":40,"dateInserted":"2019-03-19T09:04:48+00:00","dateUpdated":null,"dateLastComment":"2021-04-17T17:11:11+00:00","insertUserID":71,"insertUser":{"userID":71,"name":"guillaume_arnau","url":"https:\/\/community.anaplan.com\/profile\/guillaume_arnau","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/71.png","dateLastActive":"2023-02-13T03:35:34+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":20966,"lastUser":{"userID":20966,"name":"rkumar","url":"https:\/\/community.anaplan.com\/profile\/rkumar","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/20966.png","dateLastActive":"2023-02-28T20:30:15+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":157,"score":45,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/42821\/increase-end-user-adoption-with-smart-filters","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/42821\/increase-end-user-adoption-with-smart-filters","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/Picture2_42821.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Picture2.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":104928,"type":"discussion","name":"Anaplan Connect: Master Script","excerpt":"Prerequisites: * This article is designed for those more advanced with Anaplan Connect. * Utilizing CA Certificates is the best practice for Anaplan Data Integrations. The Master Script is best leveraged with CA Certificate authentication in the individual scripts for security purposes. If you would like to learn more…","categoryID":40,"dateInserted":"2021-04-13T06:30:00+00:00","dateUpdated":null,"dateLastComment":"2021-04-13T06:30:00+00:00","insertUserID":32495,"insertUser":{"userID":32495,"name":"DaanishSoomar","url":"https:\/\/community.anaplan.com\/profile\/DaanishSoomar","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/uploads\/userpics\/7JWF28IC7IL6\/nET3BLU34HVYB.jpeg","dateLastActive":"2023-02-11T02:30:45+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":13,"score":6,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/104928\/anaplan-connect-master-script","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/104928\/anaplan-connect-master-script","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/dsoomar002_0-1613080216531_104928.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"dsoomar002_0-1613080216531.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":40,"name":"Community Knowledge Base","url":"https:\/\/community.anaplan.com\/categories\/knowledge-base","allowedDiscussionTypes":["discussion"]},"tags":[{"tagID":26,"urlcode":"Security-and-Administration","name":"Security and Administration"},{"tagID":27,"urlcode":"Importing-and-Exporting-Data","name":"Importing and Exporting Data"},{"tagID":376,"urlcode":"How-to","name":"How to"},{"tagID":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":104362,"type":"discussion","name":"[Start Here] Power BI - This is how we use it. Part 1: The basics.","excerpt":"Welcome to the best practices series about the Anaplan Connector for Microsoft Power BI. This is the first of a three-part series designed to help you understand why and how to use the Power BI connector by covering the basics, the set-up, and a real use case. Let’s begin with Part 1: The Basics. What is the connector for…","categoryID":40,"dateInserted":"2021-04-07T07:00:00+00:00","dateUpdated":"2022-12-22T17:46:37+00:00","dateLastComment":"2021-04-09T08:45:48+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":2631,"lastUserID":8284,"lastUser":{"userID":8284,"name":"DonSrini","url":"https:\/\/community.anaplan.com\/profile\/DonSrini","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/8284.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":1,"countViews":27,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/104362\/start-here-power-bi-this-is-how-we-use-it-part-1-the-basics","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/104362\/start-here-power-bi-this-is-how-we-use-it-part-1-the-basics","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_1-1617395858520_104362.png?large?v=v2&px=999","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_1-1617395858520.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":104368,"type":"discussion","name":"Power BI - This is how we use it. Part 3: Use Case - Leveraging Power BI Service.","excerpt":"Now that you know the basics of the Power BI connector and how to set it up, let us move to a real use case; Why using Power BI Service could help you to get the most of the Power BI connector? The blocking nature of exports When a user performs an export, the model is blocked from usage (entering or manipulating data).…","categoryID":40,"dateInserted":"2021-04-07T07:00:00+00:00","dateUpdated":"2022-12-22T17:46:53+00:00","dateLastComment":"2021-04-07T07:00:00+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":2631,"lastUserID":4,"lastUser":{"userID":4,"name":"ScottR","url":"https:\/\/community.anaplan.com\/profile\/ScottR","photoUrl":"https:\/\/us.v-cdn.net\/6037036\/av\/4.png","dateLastActive":"2021-11-12T00:00:00+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":3,"score":3,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/104368\/power-bi-this-is-how-we-use-it-part-3-use-case-leveraging-power-bi-service","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/104368\/power-bi-this-is-how-we-use-it-part-3-use-case-leveraging-power-bi-service","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1617398083908_104368.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1617398083908.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":104365,"type":"discussion","name":"Power BI - This is how we use it. Part 2: Setup [Updated March 2022]","excerpt":"[Update: March 2022 - Limit increased to 5GB] In Part 2 of our Power BI - This is How We Use It series, we're diving into how to setup the Power BI connector. Need a refresher on the basics of Power BI? See Part 1. Ready? Let's start. Anaplan export setup Anaplan connector for Power BI supports Export actions to extract…","categoryID":40,"dateInserted":"2021-04-07T07:00:00+00:00","dateUpdated":"2022-12-22T17:46:09+00:00","dateLastComment":"2021-04-07T07:00:00+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":2631,"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":41,"score":4,"hot":3336927496,"url":"https:\/\/community.anaplan.com\/discussion\/104365\/power-bi-this-is-how-we-use-it-part-2-setup-updated-march-2022","canonicalUrl":"https:\/\/community.anaplan.com\/discussion\/104365\/power-bi-this-is-how-we-use-it-part-2-setup-updated-march-2022","format":"html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6037036\/img\/annejulie_0-1617396419290_104365.png?medium?v=v2&px=400","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"annejulie_0-1617396419290.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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">