-
Filter data on criteria that can change month to month
I'm fairly new to Anaplan and I'm sure if I'm approaching this issue correctly so I thought I'd ask here. We have sales rep data that shows what "compensation group" they belong to for a specific month, along with what they sold and earned in that month. I'm trying to create a FYTD report on this that shows each…
-
To get Boolean true after every 2 or 3 months
Hi All, I want to make a boolean check after every two months. (Based on estimate and budget customized version ). How this can be achieved via formula? (It should not be static when the year changes automatically the boolean should move according to time range) Thanks
-
Question on Calculating the Redistribution Factor
Hi, I would like to know if the way I'm calculating the distribution factor is correct? The only problem I believe would be the denominator, because I only want the product values and not the product values total. Any advise would help. Thank you
-
Survey Invitation: Dresner Wisdom of Crowds EPM Market Study
Hello, Model Contributors! Anaplan Customer Marketing is currently on the hunt for a handful of Anaplan enthusiasts to inform the research behind the upcoming Dresner Advisory Services Wisdom of Crowds EPM market study: please consider participating in its 2022 end-user survey. By Thursday, March 31, 2022, please take…
-
Level 3 Spring 1 User story 1,6
I am struggling to understand what I need to do for this activity. I created a module with G2 Country and Segment dimension but I am not able to populate this module. Am I missing something? Attached screenshot Is this what the activity is asking for?
-
DEMO MODEL FOR TRAINING
I have not been able to download a demo model for my Anaplan training using the below ....and this option also is not showing where may I get a model which I can work on while doing my training please? Thank you.
-
Link version formula to other module
Hi Anaplan community, In my FP&A model I am using Anaplan native version for tracking actuals, forecast, budget and forecast vs actuals and budget vs actuals. The business end users want the budget vs actuals to be calculated as "Budget - Actual", whereas the end users with controlling functions rather want to see it…
-
New UX Performance
I am experiencing slow performance with the New UX. I have bench marked some times between Classic and New UX...see below. Classic appears near instantaneous in its response time from user interaction. However, there is some marked response delay in the new UX Are there enhancements in the pipeline that will enhance…
-
INV 01 Shipping Time Week
Hi I'm stuck with this formula for last 2 hours. Pls help clarify what is wrong with this? INV01 Shipping Time Week - I'm getting "Format of mapping used for lookup doesn't match any dimension of the source" 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product,LOOKUP: Shipping Method]
-
Designate a dummy module as a Group, show alternate formatting for clearer model building experience
Similar to how you can set a line item to different formats to help readability and organization, I would like to have similar functionality in the module view window. Organizing the module view in a similar way would be really helpful as module count grows in large models. Currently the "best practice" is to create a…
-
Tree View Available even if we have large lists
Hi, Tree View have to be available even if the list is large. Anaplan could show it on different pages. It's a big limitation to the client if they can't see the tree view list.
-
Tree View List Limit
Is there a particular reason why I lose the ability to view a list in tree when I exceed a certain number of list items? Does anyone know what the limit is on the number of items I can add to a list before I lose the ability to see it in tree view. Thanks, Mark
-
Using saved text strings to speed up blueprint configuration
This is an addition and update to a existing community article using similar methods now in the latest modeling experience. As a model builder, you have to define line item formats over and over. Using saved text strings, you can speed up the configuration of modules. When you add a new Line Item, Anaplan sets it by…
-
Find Highest value
How to find the highest value for the regions amongst the 3 months and show that highest value in module Test Case 2?
-
Central model up-/downtime management
After @DaanishSoomar posted this article , I wondered why there is actually no central admin setting to wake-up a model automatically. Most customers I know with larger models have either hourly imports during working hours or they run specific wake-up scripts. Particularly larger, complex models can take 10-15 minutes…
-
LI PY Country and Product Family Sales
Hi, I have been stuck on this problem for quit sometime now. I know my formula is correct and my dimensions of mapping between my modules are correct, so I do not understand why I'm still getting a dim error when conducting the following formula below. Please assist. Formula: 'DAT02 PY Revenue to CY'.PY Revenue to…
-
Use Page Selectors to Select Data for Export via Export Actions
As an End User I need to be able to select data for exporting using Page Selectors in the UX, providing a common navigation experience for interacting with data in Anaplan. Currently to select data for exporting I need to use selection criteria (Booleans or List Formatted Line Items) to select what I want to export. It is…
-
Anaplan Cloudworks License
Hi, Do we need a separate license for Anaplan Cloudworks or is it part of our existing package? Also can we use cloudworks to directly integrate with Big query? Thanks
-
Subsidiary View List Drop down
I am creating a subview drop down list of a products view so i can easily select one of the items in the list. however, when i go into the subview to select the item, nothing appears for me to select. i have removed all applies to and switched the time scale to non applicable. i have this same line item in another module…
-
NewUX view Source Module
In the NewUX, you cannot go directly to the source module. When selected it takes you to your default dashboard page in the classic version. This is not helpful for users that aren't model builders with access to everything. This functionality and the Drill to Transaction is needed in order to make the NewUX functional for…
-
NUX : Selector - Equal treatment of direct change and hierarchical filtering
There is some unconvincing behaviour regarding the difference in handling of direct selector changes and selector changes as a result of hierarchical filtering. There is a hierarchical structure consisting of G1 Region, G2 Country and G3 Location. There is a board page like this one, on which two cards are placed. The…
-
TAR01 Level 3 Model Building
Hi, Would like to know if my DAT02 Formula and Dim are correct. I'm not able to LOOKUP or SUM in Country and P1 Product Family into my TAR01 Module and it is saying because Dimensionality. Below is a screen shot. dim is A2 Account>Product Thank you
-
Calculation Error for Formula
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 2 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Data import
How to import data from FY21 (datahub) to FY22 (Spoke model). Any inputs would be highly appreciated.
-
if formula question
I want to make if formula.. if 値変更入力欄 have values(not blank), show 値変更入力欄's value else(値変更入力欄 doesn't have value) show 前回値's value how can i make this formula? please help me...T-T
-
Level 1 Model Building Activity 5/6. Super Stuck - Need Help
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 1.5 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Level 3 Model Build TAR01 Module/SYS03 Module
Hi, I'm having trouble with putting together the TAR01 Module. I understand the task is to get the Total Revenues of my Products (P1 List) by Country and it's "Children" (G2 List), and then fine the percentage of that by dividing by total annual revenue of a country (Total Annual Revenue by Country and Product / Total…
-
Formula Help
Hi Everyone, I’m trying to do something really simple but failing. I’ve got a list of loans and each loan has a starting date. Interest is payable every x months from the starting date. I want to create a Boolean every x months from the starting date. How do I do this? I can put a boolean in the first repayment date but…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Please suggest the process to avoid the errors...see the screenshot attached.
-
Another row has already been processed with this key
Is there any way to suppress messages after importing into a List that are a result of the 'Another row has already been processed with this key'