-
3.5.5 Activity: Create Distribution Center Summary UX Page
HI, struggling a little to create below view I am able to achieve below using DAT01 but not able to remove the summaries.
-
Option to not include current period in YTD calculation but in YTG instead
Description of the enhancement required: YTD calc should NOT include the current week and YTG should include the current week. How would this engancement improve your processes: I do several YOY indexes and they are all incorrect because of this. When I compare YTD this year to YTD prior year there is always extra data in…
-
2.02-12 No Hardcoding to List members
Avoid direct references to list item. E.g. IF ITEM(list)=list.xx. Instead, attempt to use a SYS module with a line item having a boolean format as this makes the formula more dynamic (multiple members can use the same logic).
-
Quick Sum not working in Pages (in some cases)
I have published a module in Page after adding certain filters. After publishing, when I click on the column header, Quick Sum Bar behaves erratically. It some time shows the sum/other details but most of the time shows the error "Your selection exceeds the amount of data that can be retrieved from the sever". The error is…
-
Converting numbers to text without losing decimals
Hi! I am trying to create a reporting module with mixed line items (numbers and percentages) so I am converting the numbers to text for display purposes only. We need 1 decimal and have very small numbers eg. 0.0001 which should then be displayed as 0.0 however during the process the decimal is lost. Same issue with…
-
Convert Values from a 445 Calendar to a Normal, Monthly Gregorian Calendar
Summary As a supply chain Anaplan modeler, you might be asked by finance to convert your 445-monthly forecasts into a normal, Gregorian calendar since their general ledger accounts are usually set up that way. This user-story will provide a solution using a one-year model that uses a 445-monthly calendar. This solution was…
-
how to download L1 & L2 certification
I have completed two exam and i didn't saved certification how to download
-
Scenario Planning.
Hi, I need some help in building a scenario model. For example, In the P&L report, there are 2 scenarios the user can switch. In what-if scenario 1 user can update the Unit price/Unit cost and the changes will reflect in Revenue and COGS. And in what if Scenario 2 User gets to change the volume and changes reflects in Rev…
-
Loading file with different file names for the same action in deployed model
Hi All, I am trying to run the action through Anaplan Connect with different files in deployed model. But the action is running only for the file that matches with the source label of that action and if I use the different file name scripting is failing. Attaching the screenshots for reference. Screenshot1:File name same…
-
items number
Is there a limitation on the number of line items in a module?
-
Restore deleted native version
Hi - is there a way we can restore back a deleted native version? Thanks, Tom
-
Financial Year + Calendar Year Reporting
Hi - looking for some thoughts on how best to support financial reporting in Anaplan where there's a requirement to faciliate financial year reporting (Jul - > Jun) and calendar year reporting. By default, we use a financial year (Jul - > Jun) timescale and as far as I'm aware, there's no feature to apply a different basis…
-
Renaming the saved views without disturbing modules or creating new views
Hello Everyone, So found this easy of way of renaming the views without disturbing the module or creating a new saved view. Path to rename the saved view View > Manage views > Rename the required saved view > save
-
Today() Function
I'm wondering why in Anaplan we can only have to input current period in Time. As we're using Anaplan as Supply Chain planification tools and we work really at planning on days level. So it's necessary for us to determine "today"'s date. The solution we use now is to launch an automatic import and update the "Today" item.…
-
L2Sprint3 Test
All the other tests say two attempts, but you can take it pretty much as many times as needed. Does this hold true for the L2S3 test as well? Thanks, MPW
-
Is there any other method of enabling summarize function in anaplan?
Trying to figure out how to enable the summarize function. As the module does not have a time dimension changing it on blueprint view is not possible. I'm trying not to use the sum formula either. Can someone help me out and suggest any other way?
-
Workspace capacity: Subsets Calc / Applies To
Hello Anaplanners, I'm currently working on a model of workspace simulator of another Model. I'm having some difficulties to find an optimum way of : Splitting my “Applies To” - I cant find a formula to help split the Dimensions which are in the following state; “Dim01, Dim02, Dim03” I want to have each dimension in a…
-
Lv.1 8.5.3 Importing volume inputs
Hi, is anyone help me what is wrong with my module? I'm trying to import data for "REV02 Volume Imputs module" from "Volume+Imputs.csv", but I am not sure what should I select for "Time" and "REV02 Volume Inputs Line Items" from mapping sorce. If I mapped like above, "REV02 Volume Inputs Line Items tab" shows like below…
-
REP03 Profit & Loss Report module
While mapping the budgeted/Forecast details from the sheet, the mapping page does not show the Forecast details at the bottom.. It only shows the Actual details....Pls suggest
-
User access
I have a scenario where the user has to see his own details only in few Dashboards and in 1 DB he should see his associate details, If I restrict the associate to the user in the users the first option is working fine however the last DashBoard he is unable to see his associates. If we provide all associates in Associate…
-
L2MB - 1.3.4 - SYS06
Hi all Regarding step 1.3.4, I'm having issues populating SYS06 module. Going through different threads regarding this topic, I see my source data has 3 levels to map, and not 2. This is causing the region to not be linked to the code in the file. Can someone advise? KR Yannik
-
UX Filter Issue
Hi all, I'm having a hard time trying to build a UX filter. I have two lists: SS No ITC Customer SS No Product | Customer No Trading partner In particular, the SS No Product | Customer No Trading partner list is a concatenation of product and customer (yes, the same customer of SS No ITC Customer). What I want to do is to…
-
Lesson 1 8.6.4 Activity: Margin % is blank
Hi, I have added in the correct formula for Margin % but when I leave the blueprint and check my answers, the margin % row is all blank. Please can someone let me know what is it am I doing wrong?
-
4.6.5 Sale Planning Model: DAT02 module question
hi . i hope you all are doing well. i have a problem in level 3 activity 4.6.5 Sale Planning Model: DAT02 module . i tried all possible solution but could not find the answer.in this example i had to build module DAT01 first with two dimension product flat @& A1 account and FY19 ( PICTURE 1) . then i imported values from…
-
Date Format - Custom Mapping
Hi! I am having trouble in importing a file with a YYYYMMDD date format and it says that I can set the data as a custom mapping for those line items when I map the source to target before mapping. I mean how I can successfully upload it without revising my upload file?
-
Workspace % Full notifications in "New Experience"?
Hello, Not sure if I'm missing something, but it appears that the "Workspace % Full" notification that shows in Classic mode DOES NOT SHOW in the New Experience. Is this on purpose? The screenshots below are of the same model, just Classic vs. New Experience. Making this no longer at the forefront of the interface is not…
-
2.3.9.3 Update Historic Volumes for Baseline Forecast
For this activity my formula is not returning any value and I'm not sure where I'm going wrong. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 this is my formula that I've used but I'm not getting any results.
-
Maximize your Anaplan experience: Tips to unlock the power of the platform
Author: Shivankur Sharma is a Certified Master Anaplanner and assistant manager in the consulting industry. Anaplan is a versatile cloud-based planning and performance management platform that empowers businesses to make informed decisions and drive operational excellence. But it can be overwhelming to get started in the…
-
Time based IRR Calculation
Hi All, I've list of transactions and data is day wise. I need to calculate IRR on time basis . I want calculate IRR on day basis and at the end the summarized level IRR i.e Quarterly, Yearly. Also I want to calculate Asset wise and fund wise IRR. Can anyone have idea about how to do it? For your reference please find the…
-
Undefined_onFileChange Error
I am getting an undefined_onFileChange error while importing data from .csv file to flat file.