-
How to convert flat data into monthly - GL example
Confused on how to work with this flat data and derive monthly values from it. Appreciate the help! Each row is a unique combo of Account (GBAID), Ledger Type (GBLT) and Year (GBFY). The snippet attached is 4 entries for the same account and ledger type for 4 different years. GBAN01-12 are entries by month. For example,…
-
Delete items of list with no parents
Hello all, I'm trying to delete items of a list that are not linked to a parent. Therefore i cannot use "the delete from list using selection" action. Do you have any tips to achieve that ? The list is quite huge so it's difficult to do this clean-up manually. Thanks for your help, Maxime
-
Calculated Codes using Attributes - Best Practices
We are working on a project to migrate from an Employee Hierarchy to a Position Hierarchy in Anaplan and are looking from some input from the community on Code Creation best practices. Since we do not have a good external source of data for position code, we've decided to create our own Position code within Anaplan. At…
-
Allow for more control around duplicating, adjusting, and managing Exports
Imagine you need to update an export with a new column, but you want to retain the previous export for another group. In order to create this new use case, you now have to create an entire new export OR you have to inform the other team that you are adding in additional columns (even if you are allowed). Once you do fix…
-
Level 2 Completion
I have completed and passed all the 4 exams of Level 2 and have submitted the model history as well to be graded. Request to please let me know what are next steps i need to do to get the certification and have the Anaplan Certified Model Builder certificate Regard Shashank Gupta
-
Anaplan Model Opening Error
I am getting above error while opening the Anaplan Model. Request to please guide me on how to resolve the issue. Regards Shashank Gupta
-
Access to Anaplan Workspace
I am a student. Need access to Anaplan workspace to complete Model building courses.
-
3.3.7 Activity: Add DCA to Inventory Ordering
Hi Anaplan Moderators, Can someone help me out! to check if my formula and the results is right or wrong. Thank you The pics below is the results and the formula:
-
Add formula to a Has Data? Line item
Hello, I am new to Anaplan platform. Now I am working on Level 2 model building training. Here I have an issue to write a formula to line item. I don't have any kind of data in SYS13 Account Filter Module. I have data in DAT03 Historic Volumes Module. In DAT03 Module I have only one line item Volumes and I don't have any…
-
Drill Down
Hi, I have a formula applied to a line item which is not giving out the correct result, and if I drill down the formula, the pop-up screen is not considering he other modules for calculation which are there in the formula. Can you help where is the lag in the formula. Have attached a screenshot for reference. Thanks.
-
Improving Forecast Accuracy
Improving forecast accuracy often features the business value expected from a system implementation like Anaplan for demand planning. In reality, forecast accuracy is not a business value—but it contributes to business value in terms of better service levels and economic inventory levels. Often, customers want to improve…
-
Anaplan UX Pages Error
Hi, I have developed an app with several pages in it. Total 60 users are having access to this App and all are with same access. And i can see one user is getting an error when he opened a page in the app. Error message says: "We could not connect to the model"., Please find attached screenshot of error message. I could…
-
IMPORT failing - Not sure WHY?
Hi All, I am unsure why the Import is failing whilst import into dimensioned / non-dimensioned module.. Import snippet: 1st & 3rd columns are List Item Property Whilst Import it is failing due to duplicate values: The final output in module is the consolidated values of all number types.. Screenprint from BluePrint (not…
-
Level 1
Hi I'm on question 6 of Level 1 and I keep getting this error. I've double checked my format and names and think they are right so I don't know why i keep getting this error Medical Costs = EMP02 Employee Expenses.Medical Costs[SUM: SYS08 Employee Details.Region2, SUM: SYS08 Employee Details.Role2]
-
Update Historic Volumes for Baseline Forecast SPRINT-2
The formula for 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' is invalid: Datatypes do not match for 'IF' function: NUMBER, BOOLEAN I used the formula IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET('SYS01 Time…
-
RE: Where to build a model in anaplan
I started my journey in anaplan but have no clue where to start my build of the model Some please help on this
-
Number format in the line items
Hello, I have a problem with formatting a line item. In the source/input module I have a many line items, some of them are presented as % and some of them are as normal number (No problem here, because I change the format per line items accordingly). BUT In the OUTPUT model, I used these line items as LISS and pulled them…
-
Top Level Aggregation while Using Line Item Filters
Hi Anaplanners , I would appreciate if someone in the forum could help me to resolve the below modelling issue that i have. I have 4 dimension on which the business needs to do their planning ,forecasting process- Segment, Legal Entity, Department and Account. These dimensions are independent of each other and don't have a…
-
1.4.3.2 Import Data & Add Formula - Need Help
I am trying to populate this module and I have hit a road block (yet again with mapping) 😭😭😭 Can someone please explain what I did wrong - attached are screenshots of the mapping and the code I was supposed to put in.
-
NPV without an outflow
Good morning I am building a model consisting of future variable monthly cash outflows without any cash inflows. I need to calculate the NPV of that in order to convert that into a liability using the variable cash outflows as down payments.. The NPV formula require cash in and cash out. What are your suggestions?
-
1.4.3 Activity: Create System Module - Mapping
I am trying to populate this module and I have hit a road block (yet again with mapping) 😑 😪 Can someone please explain what I did wrong - attached are screenshots of the mapping and the code I was supposed to put in.
-
Implement Slow Changing Dimensions in Anaplan
Hello I am facing a scenario where I need to implement Slow Changing Dimension ( Time Validity using Start Data and End Date ) for product & customer combination. A product can be sold to more than one customer. And the price varies over time for each of these product customer combination. I need a module to track the…
-
Can i create a Time Range with 3 months
Hi, I am looking for a functionality to setup time ranges with 3 or four months, is it possible? Suman.
-
Hierarchy Build - Parent and Child are in same column
Hi All, I am faced with this hierarchy where P1 and P2 are parents and Prior Items are Children of it. I am bit confused how to build this hierarchy in system as data for both child are in same column in file. Does anyone has an idea how I can accommodate this? Consider structure of data exactly same as the image. Thanks…
-
3.4.3 create country summary module
while writing the formula for safety stock flag count line item i used this formula 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM:'SYS08 SKU Details'.Country Made In ] But it is giving error as data mistmach. can u help me
-
Level 2 Sprint 2 DEM03 and DAT03
Hi Team, When reviewing my latest workings and forecast per DEM03 and referencing this against the example for the baseline forecast DEM03 in sprint 2, I couldn't help but notice that my figures are different for the future periods commencing in Week 1 FY21. I'm not sure whether this is related to an error in DAT03. Please…
-
1.3.10.2 Import Data into G2 Country List - Mapping Issue
Hi - I'm trying to map data for 1.3.10.2 Import Data into G2 Country List Attached is my screenshot. Can someone explain what I'm doing wrong? I keep getting invalid parent. And if you can explain why we should map things to where they should go, that would really help for the future. Thanks!
-
Sort Module Overview in Settings by Cell Count
I was wondering if it is possible to sort the modules by their cell count in the settings. At the moment there is only the possibility to export the model overview and then sort it in Excel for example. This extra step would be saved by having a built-in sorting function. For me it is important to sort the modules by their…
-
Creating a new model - issue
I got stuck at one point in building a new module and I thought maybe someone could give me some advice. 1. I built an INPUT MODULE that has a lot of line items (about 30) - some of them are filled uploaded file and some are calculated based on other line items. For this INPUT MODULE data is loaded for two version…
-
Model Building Best Practices
Hi Everyone, Hope everyone doing good I am working on a best practice model building document and just wondering if you can recommend any checklist document before starting a new development I am aware of planual document but was looking for a shorter simple version so that the whole development team can follow the best…