-
Ideas on the best way to forecast when system has been configured at lowest level
Please give me ideas on the best way to forecast when the system has been configured at the lowest level. For example, we can only forecast at an item, location, and account chain level. Also, we can enter the forecasts only by week. What advice would you give to overcome this hurdle? Only look at certain items at certain…
-
Calculation Waves
Hi Team, I'm hoping to find further information regarding Calculation Waves in regards to best model performance & best practice I have some models whereby the performance is not optimal & I think this maybe partly due to excess calculation waves. Is there any information regarding what effects waves have on performance?…
-
How to get data from source module using time range dimension
Hi, Question please. How can I get data from source module using time range dimension to target module with model calendar time dimension? Scenario: I need to get the beginning balance of FY18 from the module to be able to transfer it to the target module which calendar year starts with FY19. Please ss. SYS Time Source…
-
Run an Import process via postman
Hello Experts , I'm new to Anaplan and currently exploring the Rest API's . I'm doing a POC on the below requirement . The requirement is to send a csv file from a SAP system to ANAPLAN using an Import action (Expectation is the details of the csv file gets updated in the import table in ANAPLAN) . Below steps have been…
-
YTD Average
Looking to create a YTD average on a module line item. Could someone please help? Thanks
-
Customer Potential Assumptions
Currently we are prorating the stretch goal based on the customer's PY actual % share/ Overriding accounts where needed, is there any other factor which we need to put in our assumptions to determine the growth potential of the customer within the model or would it be out of model and used through hold and/ or overrides?
-
Unicorn Candy Company - Territory assignment to account
Hi Chris, Pertaining to the territory assignment, currently we have weight based on 2 factors, could you provide some additional description of these factors: 1. Revenue (Potential/ Actual based on final target value): Is this based on the Sales reps present in each territory and their previous experience and capacity in…
-
Formula for different levels
Hi, I have a list which is a Flat list but has different levels(Note- we cannot make it as a hierarchy, it has to be a Flat list). List has list items like below.(Column A). And Line items Column B,C,D. Here, Asia and Europe are at top most level(level 1). They have child items like 1.1 China,2.1 France etc. Similarly…
-
Data Cleaning
Hi, Is there a way to clean all data from different modules at one go? Is there a script or command which needs to be followed? Thanks AB
-
Find the import ID from file ID
Hello Experts , I'm new to Anaplan and trying to integrate anaplan using Rest API . We are sending data to anaplan for which I would need an import ID . However , I have been provided with a file ID by ANAPLAN . Could anyone guide as to how import ID can be retreived from a file ID ? Also if someone can explain the…
-
Formula related issues
Hi, I have two issues as descried below. Please can you help me on it. Problem 1: I have a line item A having some data and Time scale for 4 years (in months). I want a formula on the line item B which can check if all time periods for line item A have only the value 0 and no other data. Please can you let me know if there…
-
Level 2 Sprint 3 Check your System Module
Hi Team, @einas.ibrahim I was verifying my SYS01 module line item with what was given in training exercise I found discrepancies over theirs. IN my module line items like 1st Week of timescale? & Weeks only? line item are not present. For the 1st week timescale? line item I directly use OFFSET formula in Not 1st-week…
-
Prior Year data Pull with diffrent time range
Hi All, Need a function help here, I have 2 modules Module 1 and Module 2 both uses time dimension and different time range. In my Lineitem A for Module 1 in (FY20) ,I want to Pull in previous year data value from module 2 lineitemB i,e (FY19) data. Line Item A = Module 2.Line item B( but this should pick my prior year…
-
Ratio Format
Hi, How can I present the ratio in the following format? D/E RATIO 0.00:1 NET D/E RATIO 0.00:1 INTEREST COVER 8x Thank you.
-
Subsidiary views
Hi, Can anyone advise me how subsidiary views works? I have 2 modules & both of them have different dimensions Module 1 - Has a composite list as a dimension (Account>Product) Module 2 - Standard list as a dimension (Account)* has country details I want to pull Country details from module 2 to module 1, but I'm unable to…
-
INV01 Totals for Level 2 Sprint 3
Hi, I was just wondering whether I have gone wrong with my totals, or the example given is incorrect. Under the 'Review the INV01 Line Item Formulas and Summary Method Settings' on Sprint 3, the totals for 'All Products' in Feb are different to what I have. I have attached what Anaplan have and what I have. Please let me…
-
New UX: Update and Edit List Properties
As an user, I need to be able to edit list properties in page, like I currently can on my classic UX dashboards. While I can create forms and new additions by entering in list properties. After I've created a list member, there is no way in the New UX to update my existing list properties. The biggest pain point for this…
-
Subsets or Hierarchy lists?
I have 2 master data (size category and size) to design. I think both Subsets and Hierarchy can meet the needs. But which one is better? Please tell if there are differences or impact in later use I haven't been aware of. I'll greatly appreciate your help! <data example> We have size of S, M, L which belong to size…
-
Module calculation - Sum values from column
Hi All! I'm new with Anaplan model building have one specific doubt, looking to the screen below i have budget, mx and campaingn columns these are columns created through a list i called dimension, i need know sum these three columns getting the quantity (K) line item, what is the best solution for this calculation ? I…
-
variance for different line items
LE Operational Plan Variance Capex Lifecycle (OP-LE)/LE Expex Lifecycle (OP-LE)/LE Feasex Lifecycle (OP-LE)/LE Opex Lifecycle (OP-LE)/LE TotalExp Lifecycle (OP-LE)/LE How to bring data from different module for all the line items, Please hel
-
New UX: Edit/Change pre-existing Notification Action
With the introduction of the Notification action in the New UX, it would be great to have the ability to edit these actions once created. At the moment, once the notification worksheet action has been created there is no ability to tweak it further - you have to redo the whole thing again.
-
Show Subsets in the General List area in settings under the List they belong to
I would love to see the subsets created under the list they belong to in the General List area in settings. It would make using them and maintaining them easier. And, when learning new models, it's really hard to tell the difference b/n a subset and a list and to what list the subset belongs to.
-
Level 2 Sprint 2 - Off Set Volumes for first forecast year
Hi I'm currently working through Sprint 2 on Anaplan's Lvl 2 training course and I'm having an issue with my OFFSET formula. The formula itself is correct (as the course later confirms) though it doesn't seem to pull through any data from the Volume line item? (See attached) Line item formula: IF 'SYS01 Time Settings By…
-
Issue in creating Asymmetric view
I have 3 lists : 1 - L3 Project 2 - Project Name 3 - Project Manager. I want to create a module with Dimensions - L3 Project, Time and Lineitems (or Line item subset) to show project name and Project Manager along with L3 Project without time whereas the line items (Cost, Revenue, Invoice) are with time. Any suggestions ?…
-
Level 2 Sprint 3 Product Replenishment dashboard - Summary setting
Hi Team, I am facing a problem with the summary settings and their display on my DB. Problem Statement: Values not Displaying in my Month Column for line items like "Final Shipment amount" /"Shipping Cost"/"Final Shipment cost" 1) Course Example summary file - This is an example given in the course, the values need to be…
-
Ensuring Validity of Time Filters After Time Labelling
We've recently released the ability to change the two-character prefix for time labels. If you have a hardcoded filter referencing a time formatting line item, it is possible that changing the Time Label will invalidate the filter. This occurs if the filter is referring directly to the name of the time period; changing the…
-
Changing the display view of Parent/child structure
Hi Please find the attached screenshot showing the display view of Parent/child structure in a Module. (PC3-12800 is the parent of 4GB/8GB/16GB/32GB PC3-12800). I want to display the parent at the top of the children instead of below the children. Anybody can suggest how to achieve this? Thanks Regards Prabakaran
-
Use Left Equation on Lineitem with Quarter Format
Hi, I am trying to take the first 2 characters from the "Quarter Code" lineitem so that I can identify the correct quarter for my week Time dimension. I tried using Left equation but it's not allowing me (tried using TEXT() on the quarter code but returned an error). Does anyone know a way that I can retrieve the first 2…
-
Progress Bar in the New UX?
Hi Community! I recently saw a demo in the New UX that showed a progress bar as Anaplan stepped through various actions after clicking the action button. The progress bar appeared to be dynamically updating after each action was run. Does anyone have any examples they can point me to that shows how this can be done,…
-
Workspace Admin hampering Report Access
Hi, I have a Dashboard which has a grid with some data on it. I see all the rows (the dimension is in the rows and LI in columns) when I have the Workspace Administrator access but I see nothing in the rows when I remove the Workspace Administrator access. With Workspace Admin access: Without Workspace admin access: Can…