-
REQUEST: allow for left/right/center formatting on a KPI in Management Reporting
top/middle/bottom, as well
-
[Start Here] PlanIQ overview and resources
* First things first * What is PlanIQ? * Who is it for? * Use case examples * Now, let's go under the hood * To get started * Once you get more comfortable * Deep dive on algorithms * Support You are interested in starting time series forecasting with PlanIQ on Anaplan, but you don’t know where to start? You have come to…
-
formula to get total salary by role and region
Hello, what is the correct formula to get the total salary by role and region? in the source module EMP02, the timecard is "month" and in the target module REP04, it is "year". Aside from the timecard difference, my formula is not correct. any advice?
-
UX Page Search while on a page
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Though one is able to search for a UX page within the App contents, when one is on a page in the UX the drop-down does not have a…
-
How to Prorate Weeks Across Months in Anaplan?
I need to create a monthly filter for a grid that uses TIMESUM in Anaplan. I'm struggling because some weeks span across two months. For example: January (Expected): Start week: Jan 1 (Sunday) End week: Feb 3 (Sunday) Current Value: Start week: Jan 1 (Sunday) End week: Jan 21 (Sunday) How can I prorate the weeks in Anaplan?
-
Selecting the Time to import data from other model - edit prompt
Hi, I have an action to import data from one model to another. When press to start this action I have a prompt page to select the Time, it means I need to choose the year of the budget that I want to import. The year that I need to import does not appear in the Time dropdown list of the action prompt. I checked the modules…
-
INV01 Inventory ordering Module
For some reason i couldn't able to pull the data for beginning inventory line item . My logic and formula for the line item "Beginning Inventory" is right but still i can't pull the data for week 1 FY 20 . refer my ss for work
-
Pushing data from SQL to Data Hub via ADF
Hi all, I am currently creating an environment in ADF to push data from SQL to an Anaplan module which in our current toolset (Informatica) works perfectly via the Anaplan API connector but not so much via ADF having had to do the work manually given there is no connector. Has anyone here done this and if so, do you have…
-
Help to input slabs
i am creating a model for tax calculation and it includes 2 regimes with different slab structure,i am calculating tax for 10 employees on their gross salary ,for regime i have a list includes old,new regime names and i have included a line item for selecting regimes of data type list.But i am unable to get an idea how to…
-
Rename of certification
is it possible? if i wanna rename due to an typo error
-
Integration tool to show Tree Map Graphs in UX or Dashboard
As we know, Anaplan don't have graph like Tree Map Graph to show Distribution decision like picture below Is there any option or integration to represent data from anaplan to Tree Map Graph like picture above?
-
Level 2 Sprint 3 3.3.7.2
I am struggling with adding DCA. Below are the instructions: Their example + formula hint: Blueprint from my AD02 module: And Blueprint from my Inventory module where I have enabled the access drivers: My problem is that when I add the access drivers, I'm not able to control anything in the grid view. For example, I'm not…
-
OEG Best Practice: Pre-allocation in lists (and impacts to model performance)
What is pre-allocation in lists? Pre-allocation in lists is a mechanism in Anaplan that adds a buffer to list lengths. It is not added by default for lists; it becomes enabled when a role is set on a list. Please follow 1.03-01 though. Only add roles when needed. When it is enabled, a 2 percent buffer is added to the list,…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hello All, I am currently working on an exercise to import data into the DAT03 Historic Volumes module in my Supply Chain model L2: sprint 2: (2.3.9.1) Can someone please help me fix this import. I cant understand where I am going wrong and why it won't import. The time ranges have been selected as FY19-FY20 for the line…
-
Incorrect decimal placement importing from csv file
Hi, I've noticed strange behaviour when importing into a number formatted cell in Anaplan from a csv file. My csv file is directly exported from a Workday report, and the csv file contains 2 decimal places for some entries, but some entries are rounded to 0.dp where the two d.ps are ".00". Anaplan is incorrectly putting…
-
【2024年6月】プラットフォームアップデート
プランニング&モデリング ・Anaplan Modeling Showcase セキュリティ ・Audit(監査)コメントの新しい監査イベント
-
How to add Button Optimizer in Dashboard
Hi, I want add Button Optimizer (Red Rectangle) like picture below in my dashboard please assist me how to do it. I got this picture on anaplan academy Course Optimizer, but on that course not explain how to add button optimizer into UX Web course : https://learning.anaplan.com/mod/scorm/view.php?id=17307
-
How to Substitute out Quotes
I am trying to write a substitute formula that simply deletes double-quote characters Example: Text1 Start: This is a "note" text field Text2 After Formula: This is a note text field Is this possible? It appears anytime I try and reference a " anaplan recognizes that as a syntax and not a character.
-
Conditional Formatting by Time for Actuals / Forecast Distinction
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: creating line conditional formatting for large modules to indicate actual vs forecast is ridiculously time consuming for modules with…
-
Noted! Using model notes in Anaplan
Author: Hillary Sich is a Certified Master Anaplanner and Consultant Manager at Allitix. We use sticky notes, OneNote, Evernote…. Even if we can’t agree on the type of notes we use in everyday life, we can all agree that notes are an important tool. We use them for organization and communication. The big question here is,…
-
Variance impact calculator
Author: Anya Skvortsova is a Certified Master Anaplanner and CoE Lead at Asana. Purpose FP&A is often asked to calculate the impact of variables on the total variance. There is more than one way to go about it. I’d like to share a variety that uses the typical Salary/HC reporting modules output to define the contributions…
-
Level 2- Sprint 1- 1.3.6
Hey everyone, I am hoping someone would be able to provide some clarification for me. I am on lesson 1.3.6 of Sprint 1 for Level 2 and it states that the following items need to be in the saved view. What are the subset line items? "Include: Code, Parent, and subset line items" Thank You, Laura
-
Level 2 Sprint 1 1.3.10.3
I keep getting error when I try to import data from SYS07 Location Details module Build Location to G3 Location. Can someone tell me why I keep getting this error? If more screenshots are needed, please let me know.
-
Careers in Planning You Didn't Know Existed
Are you focused, organized, and able to stay calm under pressure? Can you see the big picture, while paying attention to the details? Do you have a natural ability to listen and understand others? Planning might just be the career path for you. With so many jobs that align well with the tendencies of a natural-born…
-
PROFILE is not behaving as expected! need fix!
Anaplan team - I'm raising a bug which causes the model building experience as well as user experience from back tracking standpoint. it is about the function PROFILE which doesn't bring correct result whilst drill.. below image explains much: to explain once, as the below image shows that the drill was done on Consultant…
-
ALM explained—Part 1: compatibility
Introduction Application Lifecycle Management (ALM) has been available since late 2016, and it is used widely and successfully across the Anaplan-customer base. ALM is founded on certain fundamental rules and structures, which if followed, will ensure the integrity between development, test, and production models is…
-
Unlock Your Potential: Future Master Anaplanner Training at CPX
Are you ready to take your Anaplan skills to new heights? This year’s Connected Planning Experience (CPX) is the opportunity you’ve been looking for! Enjoy the comforts of a dedicated lounge, connect with some of the top Anaplan minds, and get the recognition you deserve when you become a Master Anaplanner. This year at…
-
404 error when using API imports endpoint
Hi! When I try to use the imports endpoint I only get a 404 not found error. The api documentation I have been following is I first noticed the issue when running this: https://github.com/qkeddy/anaplan-audit-history so I tried with Postman and I got the same error message. If I run a GET to the specific model or workspace…
-
Calculate Space Utilized depending on Format and cell count
Hello Anaplanners, I have small query regarding size calculation, like how size of model is calculated using cell count of lineitem depending upon format used.. I would be better if I can get example calculation explaining how size is calculated using different format. Thankyou
-
Anaplan Connect - Model size from script is more than actual size in manage models
Update: The metrics are Gib and not GB, so when converting from bytes it needs to be converted to Gib and then the results match. I am using the following command to get the model size: -debug -service %ServiceUrl% -auth %AuthUrl% -M This command is giving me Workspace ID, Workspace Name, Model ID, Model Name, Model Size…