Anaplan Community

Need help with better approach
Hi, I am facing issue with the below senario. If someone can help me out with what is the best possible approach I have hierarchy with lists from L1 to L6 levels and a flat list D with list items from D1 to D5 Current setup: There are several hundreds of modules with combination of flat list D with one of the hierarchy…
Celebrating 100K Community members!
Thank you, Community! We’re thrilled to announce that we have reached 100,000 registered users, all thanks to you — our incredible members! Your creativity, commitment to helping others and continued enthusiasm has made the Community a special place for our members. We know the Community is the one place within the entire…
Mapping time when importing csv file
Hello I have an issue when mapping the time when importing a csv file could you pleae help?
Mapping time when importing csv file
Hello community, I am blocked when mapping the time when importing a csv file: my model is set as Year and in my csv file I have a colum named Year with FY. I have error when mapping those, please see images below. Can you please give me some ideas?
App has some pages unable to change model due to archive
Hi team, I have made a copy of a model and app and am attempting to change the source model from within the app. For some reason, every page is set to the same workspace and model, but 90% of the pages are saying the model is archived so I cannot update the source model. I have checked the original app and model and it has…
Loading .csv File issue Numbers dots, commas
Hello, I have an issue when loading my .CSV file, the number I get they are not right: when importing, the system takes the dot from the numbers as being the number not the decimal. For ex, in the CSV file I have 22.2 so twenty-two point 2 and in Anaplan I get 222. Can anyone help with that please? thanks
3.4.3 Activity: Create Country Summary Module formula is wrong ?
hello I have put the formula for Safety Stock Flag Count but in the exam it says wrong when i pasted it . i dont why couple of times it got rejected ? any advice will be helpful
Date Line Item using Min Summary
Hello I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same. I am facing issues where if there is no date in my list P6, i am getting 12/31/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding. Regards MO
Ability to input text commentary with text formatting options in Management Reporting - New UX
While working on a project, a useful implementation emerged. Currently in Anaplan, via Management Reporting, it is possible to create documentation that cannot be customised by the user. In fact, the end user using the system can only look at the data and comments previously entered by the Page Builder. We tried creating a…
Selective Access on Flat List Subsets
Currently, selective access write permissions must be granted to a parent item for end users to modify an item's subset membership. In the case of a flat list, the items do not have a parent, which means users cannot modify the inclusion of these items in the subset. This has created challenges within my organization, as…
Adding comments for individual cell in UX page
Hi All, Can we able to add comment on individual cell in Anaplan. For example: let's say I have added 62 and I want to enter some info about override forecast. If I have not able to enter the comments on single cell then how can I achieve this. One way is we can comment in the grid level even if I have added any comments…
History - Anaplan
Hi everyone! The use case we are trying to achieve is that an end user should be able to quickly check history at any given point ; currently only 24hrs is enabled or the model history at the back end ; what we would like to do is get the source data from anaplan and model it with an AI ( kind of a chatbox e.g KOREAI) ;…
Efficiency of the lookup formula
I have some question about how efficient the lookup formula is I have a situation where we when we have new items have the ability to give that item a mapping to another item to pull some initial data for since we don't have anything for it yet. we used a lookup instead of just repopulating the initial data so the users…
Please add filters to the IMPORT actions columns.
Trying to find a source or target in a list of 500+ imports is quite a time consuming process. Adding a filter or a sort to the columns would be such a big improvement I used to copy and paste the import actions into excel, but now it seems you have changed the format of the table and this is no longer possible, so now…
Find common text between another modules without List
Hi, I want to find common text between another modules. I have two modules A&B. Each module has order Number and Product(Text format) I want to find Product(ModuleB) in ModuleA. It's Common Text. In this case, we can find product by finditem formula, by making product List. But I don't want to use product List, because it…
As tenant admin when you see last login of user if it is blank what does it mean - after the access
As tenant admin when you see last login of user if it is blank what does it mean - after the access is given the user did not login or something else ?
Create Shipping Export Module and Create a Saved View
Hi Team, I have been struggling for a long time here in the INV05 Shipping Export module below is the blueprint mode: Below is the layout for my INV01 Inventory Ordering module The formula for Shipping Costs is as below: Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 units'[LOOKUP: 'SYS08…
Is it easier to find a job after finishing model builder certificate ?
Hello Everyone I have been searching for a job for quite some time, and I came across anaplan and started learning it. Since I am switching my career from accounting and trying to find a job in operations, project management etc, I feel Anaplan can help in find the job easily with this skill set. I just wanted to ask this…
Anaplan Reporting Page: How can we keep line item filter for hierarchy filter selection?
i have made a line item filter with formula= RANK('ROTD - 3M', DESCENDING, SEQUENTIAL, TRUE, 'text l4 n 3lag') which gives me as shown in pic - 2. the second line item filter with formula = RANK('ROTD - 3M', DESCENDING, SEQUENTIAL, TRUE, 'Lag 3') which is the 4 line item in from the pic above. 3. Now in reporting page when…
Model Archives : Automation & Tenant administration
Hello ! It would be great to have automatic quick-wins regarding Model Archive Management ! ALM & Archives : When we need to move a large number of developments (or time management switch) into production, we always try to do a "Copy & Archive" first. However, this task is manual and potentially error-prone. It would be…
Access to the Anaplan workspace
I want to complete Anaplan level 3 for that i require Anaplan workspace access so i want to Connect with model builders for opportunities for model builder junior roles. Please help me.
"Reset" on UX Page
When a user clicks on the reset button, the ux page should reset any sort, filters, or pivots that are directly applied to a grid.
Need workspace access. Please advise how much time will it take to get access after applying for it?
I have applied for workspace last month, still not got access. Does it usually takes this much time to get access?
Delta Load
how I can implement delta load from datahub to Spoke model. the action pulling the delta load is running into the spoke model , then how to mark the transferred data from spoke model to datahub model ?
Unable to Dynamically change Line Items names
Hi all! I tried to follow the steps of this article about dynamic line item names change but I can't get it to work, so I would like some help on why it's not working. For context: I am building a Price/Volume/Mix analysis which I gave the end user the ability to pick which versions they want to see the comparison, naming…
What are the limitation of Cloudworks Integration?
Hello Community, I am new to the Anaplan cloud works. I just want to know what are the important points we should keep in mind, while creating cloud works integration. some where it is mentioned that per tenant the limit of integration is only 500. What does that mean? after 500 do I need to purchase any subscription for…
Combining line item number formats
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: For certain reporting elements I'm finding that I have to change number formatted line items to text to get the right prefixes and…
Issue with Cloudworks Scheduled Process Not Updating Target Modules
Hi Team, I am facing an issue with Cloudworks. When I run a process manually, it updates the data in the target modules. However, when I schedule the same process in Cloudworks, it runs successfully but the data is not copied to the target modules. There are no Selective Access or DCA applied. Is anyone else facing the…
How we built the famous word game : Wordle!
You all must be aware of the global phenomenon of “Wordle”. The way this little and simple word game struck the world is amazing! We loved this game so much, we tried to test our beloved software, Anaplan’s, limits yet again and tried to recreate this game on it. This is how we built Wordle on Anaplan inspired from…
Formula to return the latest date and hour
Hello, I have a list with exports date and hours and minutes. I need a formula that will allow me to show on the UX, the latest date with hours and minutes. Is there such a formula? Thanks

Anaplan Community

Discussion List