-
Level 2 Sprint 2 Model Calendar question, data not showing
Hi everyone, I followed sprint 2 step by step until I found out my data was not showing in DEM03, so I was searching for recommendations in the community and tried editing my model calendar. However, I think I messed up because, after a few changes, even my DEM01, DEM02, and DAT03 aren't showing data anymore. I tried…
-
SUMMARY Formula on ITEM(Time Period)
Hi team, I created a ITEM line item in a Time Map (Months) module & set the SUMMARY to formula. I expected it to return the FY but instead it returned the 1st item in the period. EG for FY19 it returned Jul 18 Any ideas on why this is not returning FY19? Thanks
-
Things to consider when building a robust import action
Import actions are foundational elements of an Anaplan model. Import actions can be scheduled via integration or can be called on demand via dashboards within an Anaplan model. Imports could happen from different sources such as lists, modules, saved views, and files (CSV, TXT). Import primarily import data into target…
-
Edit to and from Periods
Hi, I have a module with timescale in quarters. I only have actuals as my version and have set my edit from Q2 2020 i.e. July 20 to end of timescale. I've asked a colleague to test this (it seems as model builder I'm able to still update regardless of settings?) - and they were still able to edit all periods? Why is this?…
-
Nex UX - Compare more than one data series in a Scatter Graph
Currently I can only compare one set of data in the Scatter Plot graphs. However, it would be useful to compare different data series, as that would allow me to plot different trendlines and compare the expected performance of different scenarios. Otherwise the functionality of the new tool could be very limited.
-
New UX - My Pages User Role
Is it possible to enable/disable My Pages based on user role? My client is asking to make it available only for specific roles. I believe it is only model specific, but wanted to be sure. Thanks!
-
Circular References and 5 year Forecast
Hi, Circular References and 5 year Forecast. I am trying to use the Prior Year's final forecast as the starting point for the new year and get circular references because of the calculations in between. I am using the Previous year's Actuals as the starting point which is fine as this line does not relate to the…
-
Logging comments in Anaplan
Are there Anaplan folks who have worked with comment (text) logging in Anaplan for end users? The business prefers to log comments in the financial forecasting in Anaplan on multiple versions. Does anyone have a best practice in this? Building it myself rightnow, but curious whether people have best practices and tips!…
-
NUX - Card Configuration - Multiple item selection
As a page builder, I would like the ability to select multiple items in the card configuration. For example, to change the below items from line to column, I have to click through each item individually. I work with customers that have charts made of hundreds of items. If they need to edit the chart, they would have to go…
-
Can anyone help me with the below mentioned activities?
Hello comrades, Can anyone help me figure out : 1-How to create an employee drop down list to select display name? 2-
-
Specify Resulting Value for COMPARE Function
It would be helpful if the COMPARE function could be modified to specify different resulting values. Currently, the formula returns 0 if there is a match and -1 or 1 if there is a match. Ideally you could specify any values, but returning 1 if there is a match and 0 if there is not a match would provide a useful…
-
Payment every year
Dear Anaplaner, I would like to forecast the payments of supplier contracts. Example: -a contract should be paid every year starting Nov 19. -so next payment would be, Nov 20, Nov 21, Nov 22.... I would like to use boolean to indicate which month should be paid ? Thank you for your help.
-
Copy data from 1 Year to Next 2 Years
Hi Experts, I have been trying to test some scenarios in Anaplan. One scenario is I have to pick Actuals from Last Year for all periods and copy them to all periods to Current Year and Next Year For instance Current Year is 2020 Last Year is 2019 Next Year is 2021 Data of all periods from 2019 must be copied to all periods…
-
Ability to create Version subsets allowing to have many different versions without impacting size
Hi Anaplan, As Anaplan grows users will require to create multiple versions allowing them to look at historical information without creating many archived models. The solution to this is to have many versions and be able to subset version lists, therefore saving on space and being able to view historical information…
-
Formula for current user
It would be useful to have a formula to determiner a user from the users list so I could write lookup statements to source data from modules with users list in dimensions
-
Where to put the END() Formula/Trying to get a formula to retrieve the end of the month total
Hi, I'm trying to get a formula to retrieve the end of the month total of the line item. I know I need to use the END() function but not sure where to put it in my formula. my formula is below. Thank you IF 'S01 Time Filter'.Allocate to new line item? THEN MIN('Barrowing Base (payment for prior day loans)' + Cash Collected…
-
Adding a list subset in dimentions while making a module (Level 1 - 10.2.5)
I am on this activity from Level 1 training at the moment, making a module as per below. And it says to add Active? List subset as well as E2 Employees# and Time to the dimensions. I took it as doing this: But I got the following error message instead: I am not too certain what I should be doing from here to accomplish the…
-
Data Import
Hey I am having trouble with level 1 importing employee data in syso8 it says the following: Import into SYS08 Employee Details module failed: The column headers in the file you are attempting to import do not match the import definition.1 Line Item identifier(s) ("Active?") were not mapped and…
-
HELP
Hi! I have gotten a little behind because I am a little confused. I completed lessons 1-6 but still have not created a model. Would anyone be willing to help me?
-
Look Up Function Functionality in practicality
In how many ways can we use Look Up function in Anaplan model in real time ?
-
Question on Formula
Hi, I'm trying to create a Line Item Formula in where every 10th of the Month/ or next business day, Money comes out of another Line Item. Please advice. Thank you
-
Having trouble writing Boolean Line Item
Hi, I'm having trouble writting a Boolean Item that checks true if it is the 10th of the Month or the next business day if the 10th falls on a Weekend. The following is the formula I was using but not working. Thank you INPERIOD('S01 Time Filter'.Start of the Month + 9, 'S01 Time Filter'.Month)
-
How to apply conditional formatting in new UX?
Hello, I am working with the new UX and struggling with the conditional formatting, I have applied the conditional formatting in Anaplan module, however,I am unable to see the same once I publish that on Page. Please find the attachment, I have added the screenshot.
-
How to filter duplicate records and take latest record
Hi Have below scenario -- There are multiple entries for single employee from source . I need to pick latest record and create hierarchy based on that . Below is the example from source -- Emp…
-
override value for '0'
Hi I have 3 Line items 1st -expense(number format) 2nd-Override Value(number format) 3rd-Final Expense(number Format) formula for final expense is IF OVERRIDE VALUE > 0 THEN OVERRIDE VALUE ELSE EXPENSE So if want to override expense value with 0 then how can I modify the formula for final expense with out using any extra…
-
Sort Not Working
Hi Team, I'm trying to sort a List Subset but the values are appearing to what seems to be in random order The hierarchy has been removed & I'm struggling to understand what would be driving this I saw previously there was a bug regarding sorting on list sub-sets but it was stated as fixed
-
Model too big
Hi I am getting the error - Model change has been rejected to prevent the workspace exceeding its size limit. I have attached the screenshot please assist to fix THanks
-
How to Detect Retail Sales Trends in Anaplan
Retail Knowledge | Detecting Trend INTRODUCTION Using machine learning to detect a sales trend is a science and an art. Obviously no computer program or set of calculations could ever know everything that’s going on with your business. The creative side of detecting a trend is built upon your familiarity with the way your…
-
FIRST COLUMN ISSUES - MODEL 1 / SECTION 4.8.2 - NUMBERS INSTEAD OF NAMES
I'm about 89% done with section 4.8.2 - E2 Employee, (of the first model). I've had a successful upload, (green check and all), but the first column shows # instead of Names. I can't get rid of the #'s, and just have the names. The last picture represents how it's suppose to look. I did attempt to research the problem, but…
-
Level 1 Time Setting
When I try to use the filter function, in the SYS00 Time Settings module, I found that all of the "Actual period?" is False. I compared my settings with the template but I didn't found any difference. Why this situation happens?