-
Level 2: Model Builder - 3.3.5.2 Inventory Ordering Module Formulas
Hi everyone, I am not getting the results as expected. Does anyone of you know where my mistake is? for the first Row "Beginning Inventory" I am only getting values for Week 1. For row "Shipping Time Weeks" I am getting 0 as the result. But expected is the value 4 (for Week 1). Here are my formulas: Thank you. KR Tobi
-
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
-
link text-formatted line item
Hi All, I have a question from a partner.., Can you please confirm that it is not possible to link to a file destination in Anaplan using a link text-formatted line item. The link text-formatted line-item defaults to http// and the file destination our client uses has a different prefix using backslashes (\\). The links…
-
Query on Efficient List Creation Method
I'm seeking advice on the quickest method for creating lists in Anaplan: using the UX Page "Form action" or the backend Actions for Creating List Item. Which approach is more efficient?
-
anaplan level 2 sprint 1 activity 1.5.6.1
Hi all, I have problem while importing data into Historic Volumes Module. The csv source file contains data (image 1), but when I run importing into modules (image2&3), there's no data at all (image 4). What should I do to fix this problem? And by the way, I do not get why we select "Column Headers" for "Volumes". I got…
-
L3 Sprint 2 User story
Hi Everyone, I am in L3 in lesson 4.4 as per below screenshot. I have used the same csv file to import the data in Data Hub model and created the list G4Territroy>Accounts# and pushed it into spoke model (Sales Planning model). Just need one confirmation as per below SS it mentions we have to import into Sales Planning…
-
How to reduce huge dimensions
Hello, I'm having a lot of issues with workspace size, with models going above 150/200gb in size and I'm not sure how to reduce it, to give some context, I have three main lists (size considering subtotals): Products (~1,5k) Countries (>100) Customers (>270) The issue is that if we apply all of them to a module what we get…
-
Mapping modules dimensioned differently
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?
-
How to set automatic refresh when filter is updated to new value
Hi All, As I was building the UX Pages and came across on roadblock wherein each time when I change country and segment in field card I had to refresh the page again to get new country and segment values. Please requesting for inputs on how to set automatic refresh when I change the filter to new country and segment Below…
-
Adding specific number to imported data
What's the best possible way of adding '0's to imported data? Eg: Data > Required Data 156 > 00156 23 > 00023 62797 > 62797 0 > 00000
-
L3 Sprint 2 building the list: G4 Territory > Account#
Hi Community, I started L3 wherein we have to build G4 Territory > Account# list in Sales Planning model I followed below steps as per training Firstly, loaded the Download: Territory Data.csv into Data Hub model into Territory Flat List system and built system module below is the image attached of both list and sys module…
-
Adding instructions to Line items
Hi Community, Curios to learn on how to add instructions to line items of module on UX Page. Kindly requesting for your inputs on how to setup on UX. Please refer to below screenshot for more information
-
Unable to onboard whole data into Anaplan
Unable to onboard whole data into Anaplan Source data: Translate business process into Anaplan components Expected Result: Translate business process into Anaplan components Onboarded data into Anaplan: Translate business process Please guide me!!
-
How to Delete a column data if data is imported action
Hi Community, Requesting for your inputs wherein, I need to delete a column data wherein to create a empty staging module which in turn will be used a import action to main module in L3. Requirement : to delete Override Sales Target column data Below is the attached screenshot for more reference Thanks.
-
Anaplan API Python Connection
Anyone has tried to do a Anaplan API Python connection? I have an idea that I want to build scenarios in the magnitude of 100,000s. This will not be possible if we are using the inbuilt version page. My idea is to store the parameters of the 100,000 scenarios in cloud (for example azure) and run it in Anaplan and output it…
-
Anaplan Last year values Summary(Formula)
I have two modules A, B. Module A has time ranges of Week, Month, Quarter, Year. Module B has time ranges of Month, Quarter, Year. What would be the best practice to get last year values from module A to Module B and have them reflected for Month, Quarter, Year? (I tried OFFSET, POST, but got error while changing summary…
-
Referencing a line item that has formula summary method, not displaying correct number
Hello, In the example image, I am referencing a line item "TV Programming (Final)" in another module using an If statement IF XXXX THEN XXXX.'TV Programming (Final)' ELSE 0 However, it isn't pulling 4,063,964,538 as expected. I know its an issue with the summary method being set to formula because other line items are…
-
Time Dimension & Value not adding correct
I have a model which has the time dimension (in days) and line items which are date formatted. I'm trying to create a chart which correctly replicated the progress of time change but for some reason any value is not mapping to the x axis of the chart. I have attached a picture for better understanding. In the picture you…
-
Supply Chain Related Functions
Just like we have functions for Financial (COUPDAYBS, COUPDAYSNC, etc) and Call Center Planning (AGENTS,ANSWERTIME, ARRIVALRATE) can we have something similar to support Supply Chain Planning? Like End of Stock, Beginning Inventory, etc based on input parameters?
-
Formulating and capturing the no of orders count based on orders placed between time scale.
Hello Community, Process explanation based on below screenshot is basically on the left part we have module in which time is recorded for the orders placed and we need to gather and capture the count or no. of orders placed between the time series. EX: Orders between 14-15 PM is placed at 14.30 PM and 14.45 PM we need to…
-
Export with different dimensions
Hello, I am trying to make an export. In my Export, I need to show on a column category Int and category Ext (both on same column). The problem that I have is that the domensions that I need to use for this information are in the Children of my dimension. Let me make a scheme; Dimension A - the one I have to use Dimension…
-
Action for Deleting an empty row in UX after running the process
Hello community, I have been working on creation of the group wherein employees roll up to a particular super group below are the 2 Screenshot in detail. Current Process: Below is when enter all the details and click on action called "Create Super Group" the new employee with its Super Group code is added to the below Grid…
-
UX Page action button and Grid Data
Hello community, I have been working on creation of the group wherein employees roll up to a particular super group below are the 2 Screenshot in detail. Current Process: Below is when enter all the details and click on action called "Create Super Group" the new employee with its Super Group code is added to the below Grid…
-
Get inspired — Community Bosses share their 2024 goals!
It’s the first week of the new year, and if you’re not yet in goal-setting mode, we’re here to inspire you with a few ideas from our Anaplan Community Bosses! We asked a few of our Bosses to share their perspective on any or all of the following questions: What are your Anaplan-related goals for 2024? What do you hope to…
-
UX Page cells data alignment
Hi all, I have published a Grid card on the UX page and I want the cell data to be centered in alignment as you can see in below image it is towards right corner and really want to know where to explore on these alignment options. Below is the screenshot of the grid card As I understand this is a basic function however,…
-
multiple developers are working on different enhancements to the same model
We have two approaches to manage scenarios where multiple developers are working on different enhancements to the same model, and we need to push their changes separately into the production model: 1. Rollback Method: After completing a build in the development model (in standard mode), the developer meticulously documents…
-
Finished LEVEL2
Hello Thank you to everyone who has answered my question and doubts and helped me understand and solve exercises. SO thats it? This is the model builder certificate? how to I get the model builder batch? Thank you ALL
-
Conclusion of Level 2 Model Building DATA02 SKU Volumes module
hello I'm stuck in this . can anyone help me from Level 1 FP&A module we have G3 and P3 SKU as dimnesions where is when importing from supply chain module it has different dimensions . how to import ? supply chain module if i use DATA 01 begining inventory module as data source , can you help me in fixing the import as i…
-
Create Shipping Export Module and Create a Saved View
The question dont know why it is empty Everything seems perfecrt but why there is only ZEROS ? Help please ?
-
Sprint 3 exam Doubt Country made in
hello for the exam question to find out stock expection for all the prodcuts for Mar 20 for countries . as per the data i have uploaded it shows me 14 and the list of the countires but in the options there are not more than 5 countires i dont know where i made mistake and i feel all my formulas are correcT . can anyone…