-
Which role to assign for model builder
I have 2 model builder access for my workspace. How do i give the another model builder access? None of the role assignment has the right to change a model…. p.s. i am the tenant admin also. Thanks!
-
NPV with Rolling Period
Hi - I am trying to build a module with an NPV calculation which in each month calculates the NPV of cashflows starting from the next month until the last time period in the module. So in Jan-24 it would calculate the NPV with cashflows from Feb-24 to the end of the module. Then in Feb-24 it would calculate the NPV from…
-
Anaplan Connect csv files
Hi everyone, it would be very useful within Anaplan Connect (both Basic Authentication and OAuth2) to set the csv files generated from batch files visible to everyone (every user present in Anaplan Workspace) or only Admin users within Anaplan Workspace. This would prevent the restriction of having only one single user…
-
isblank
Hi how to apply ISBLANK in Boolean format for multiple columns. I am not getting error if it is one column but if it is for multiple columns Im getting error IF ISBLANK(Market) THEN TRUE ELSE FALSE
-
L2S3 Activity 3.3.12 Sys01 time settings by week module
May I know if I have this correct: Line Item Planning Period Filter: the formula is 'Sys00 Time settings by month'.planning period filter Line Item Planning period Filter weeks only: monthvalue('Sys00 Time settings by month'.planning period filter)
-
Case study: Exploring innovative use cases with Anaplan
Author: Kyle Sakowski is a Certified Master Anaplanner and Director of Anaplan Center of Excellence at Everest. In the realm of reinsurance and risk management, Everest Group LTD stands as a beacon of industry excellence. As the landscape evolves, Everest recognizes the imperative to not just adapt but actively seek new…
-
Level 3 Model Building: Schema Design - Part 2
Hi Team, Plz help me with the formula for Define in Active Subset? line item from chapter (4.2) List Subsets - Advanced Topics As I am unable to add subset in to the formula. @jared @Misbah
-
LM2 - Data Hub SYS13 - Formula Hint 2
Hi Team, In the Data Hub in module SYS13 Account SKU Filter you setup a Boolean line item to determine whether there is data in DAT03 My formula to be used would of been: TIMESUM(DAT03) > 0 or TIMESUM(DAT03) <> 0 The 2nd Anaplan formula hint is below: This is confusing as when/why would you use a Number (1/2) to determine…
-
Anaplan Connect - Script Import Files
Hello I used the following script provided by the Anaplan Connect guide to import files: set AnaplanUser="useremail:password"set ServiceUrl="https://api.anaplan.com" set AuthUrl="https://auth.anaplan.com" set WorkspaceId="8a81b09e5f88df6e015f9773e37c675f" set ModelId="FCDBA62F401B40E9B73A42983C4FDDCC" set Operation=-debug…
-
NPV with rolling start date
Hi - I am trying to build a module with an NPV calculation which in each month calculates the NPV of cashflows starting from the next month until the last time period in the module. So in Jan-24 it would calculate the NPV with cashflows from Feb-24 to the end of the module. Then in Feb-24 it would calculate the NPV from…
-
Budget vs Forecast Version
Hi, I have multiple versions in my model. (Actual, Budget, Forecast, Scenario 1) I was wondering about the best way (best practice) of pulling in values for one version, else formula. For example: IF version = Budget Then valuex ELSE formula I was wondering what the actual syntax would look like. I don't know how to make…
-
I am not able to Login to my Anapla to build models
I can login to view course, but when I try to login via this link it is repeatedly saying the pwd is incorrect. Im also not able to set it right as Im receiving no email. Do we need a business email or account to access this?
-
Anaplan bring data to future week
Hi, How can we calculate the collection of Revenue for future week? See example below, our Week13 fy24 data is to be collected in Week18 Fy24. Thanks in advance for helping. Regards, Tom
-
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…
-
My favorite new Anaplan features in 2023
Each year, Anaplan strives to not just maintain, but to enhance their platform in the form of periodic monthly new releases. This can take various forms. It could take the form of major sweeping updates like unveiling the New UX or Management Reporting pages. On the other hand, it could be focused on more micro-level…
-
L2 Course - Supply chain model INV05 Shipping Export
Hi, Any expert please help , I am stuck in Importing G3 location in "INV05 Shipping Export" module , I alreay crteated Subsidery view doe CODE line item , in this Module , but while importing Data from G3 location List , it is ignoring the Parents like "US", please help me to understand what is wrong in steps , please…
-
Question on Sprint 2 Detailed Demand Review Dashboard
Hi - UPDATE: 24 April 2019 - I had an error in one of my formulas (found out on Sprint 2 exam) that I corrected (retook test to ensure I had it fixed the issue). I had thought that by fixing that formula it would resolve the below discrepancy but it didn't. I have a question similar to this one posted in Anaplan Platform…
-
Training Level1,Level2 certification
Hi, I took Level1,Level2 training exam(attached file), but Level2 Sprint2 and conclusion exam are not be checked mark, so could you help what should I do?
-
I am hearing about custom versions these days and would love if someone provides an example of same
I am hearing about custom versions these days and would love if someone provides an example of same. Does we create any list for version or the versions tab for acheiving this
-
Parenth
Hi all, a simple one this time. I am trying to get the parenth member of the list. But I keep getting this error. my formula as i remember it is Parent(Item(L3 Department)). then i got an error on it Any idea what I am doing wrong. Appreciate the help on this one. Regards,
-
Add Filter Functionality to Modules Tab
The modules tab should have filter options for 'Functional Area', 'Applies To' and some other columns that allow the model builder to quickly search for a particular module(s). If I want to find all modules that are dimensioned by 'x' dimension, how do I find it quickly? Exporting to Excel and filtering there is time…
-
Account Assignment
Hello, I also have a question concerning assignment. I don't understand how it can be possible that an account may have more than one territory assignment. The account is unique and we assign a territory for it or change it but it remains only one territory by account from my understanding. Could you please explain what I…
-
Cloudwork export don't include the time stamp
Is there a way i could exclude the time stamp? i basically don't want anything that's from _January until 034607. Thanks.
-
My request to join Talent Builder Independent has been declined, what should I do?
Hi, I just got the Anaplan Way Course Certificate. I fullfill all the listed requisites as well, but the request to join the Talent Builder Independent Program was declined. I'm wondering if I did something wrong. Is there any chance of requesting, or getting these 90 days free trial access without having to wait 30 days?
-
Data Validation when using Anaplan API
One thing i've found quite challenging when doing API implementations (and at this point i've done well into my 20s of these) is, what is the best way to validate that my API calls are properly working? Specifically - how can I validate that file uploads are pushing in the right data? There are so many different variables…
-
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…
-
How to return null value for a list formatted line item
Is there a elegant way to do that? currently i am using one column to return text value and another column to find back the item. Because it won't allow me to enter if in tier = True then Item(Tenure) else "" because "" is not in the list of Tenure.
-
4.5.1 Activity: Rename Organization List, what to do:
Hello I am trying do the the Model 1 Lesson 4 but I am stuck. 4.5.1. In the model you are building, click the Lists icon on the model settings bar to open the General Lists tab. This allows you to see all of the Lists included in the model. When a new model is created, the Organization list is created by default. This list…
-
Cloudworks export to azure blob container
Is it possible to define the export to a folder directory within the blob container? Currently i can dump it into the container (i.e., not to a specific folder in the container) Thank you
-
workspace apply
Hi everyone, I am an Anaplan self-starter. But as of now, I don't have a free workbench. So much so that I can't do modeling etc. I hope someone who knows can tell me. Thanks to all!