Modeling

Snapshotting Issue - Formula Summary for Time Periods
Hello! We are doing snapshots for some key metrics, and I'm facing an issue where a few of the source line items are %ages with a Formula summary for Time period. When these are being imported into the snapshot modules, the quarter value is being messed up because that can't have a Formula summary. I figured I could create…
Open the saved view if you save a view
When creating a saved view, it will not open by default, but you need to open the saved view in order to finetune it. It will benefit the model builders, because now a lot of times you create a saved view and you need to remember to open it again before making more changes to the view and continue saving. A lot of times…
Changing switchover is giving circular references error
Hello - I'm trying to move forward the switchover date for 1 version in a model and I'm getting a circular reference error message. This is the first time that this has happened. Any ideas what would be causing this / how to fix? FYI - the error message shows a giant list of references that it says are impacted. Thanks,…
Model Settings, and lesson 13 help
Does anyone know how we can access our model the way we have been doing this whole time? I have attached pictures of what my model looks like when I log in, and where did the versions, modules, etc settings disappear? I've also circled that under View, there is no save option like there was yesterday? How do I complete…
OFFSET v LAG v LEAD
Hi All, I understand each of these functions but could someone succinctly explain the difference. I would naturally lean towards using OFFSET when looking to pull and push data from different time periods so I have never actually used LAG or LEAD in a live build. Where would LAG or LEAD be used over OFFSET?
Help Level 2 Sprint 3 - Access driver set up for Product replenishment dashboard
Can some one help me identify what am doing wrong here My formula for Override Amount looks right and aligns with description but am confused on the highlighted piece. Please see my formula and description below. Override Amount – Write? : 'Submit Purchase Order - Write?' AND 'INV01 Inventory Ordering'.Submit Purchase…
Optimizer functionality
Has there been any discussion on incorporating multi-objective linear programming in the optimizer moving forward? I'm trying to find a way to incorporate soft constraints into the current optimizer but haven't had any luck. Thanks
Enable placement (Before, After, Top, Bottom) of new module upon Insert of module.
Similar to the drop down list when adding a new member to a list, it would reduce steps if I could add the new module to the Bottom of the display or After a selected module. In order to list modules sequentially, eg. SYS01, SYS02, SYS03, I must insert the module, then go back to the modules list and Reorder.
TEXTLIST over USER-list
Hi all, They TEXTLIST-function isn't allowed over the USER-list while this would be helpful in some cases. Can this be altered? All the best,
New UX Idea - Show History while drill down
New UX is missing one useful feature presented in classic. Show history while drilling down is available in classic. But not in New UX:
Move values from flat list to hierarchical list
Hello, Everyone! Please, help me to solve the issue. I have a Flat list with the -1 and 1 values. I have a Hierarchical list consisted from the same code from the flat list but in the hierarchy. There are more than 15 levels. I want to assign every -1 or 1 from the flat list to every element in the hierarchical list. The…
Level 2 Sprint 1 1.5.7.3
Hi Team, When reviewing 'Check your Work' my output is similar with the exception of the dimension at the top. Check your Work in the content section has no time dimension at the top only 'Has Data'?. My output includes a date, namely the relevant week. When I try to omit a time dimension, in this case 'week', I'm unable…
I want to find if a List item is present in a Line item(formated as earlier List) in a module
Use Case: Users enter values in a module M1 with dimension Project P1. They also enter their name in Line Item LI1 formated as ListUser L1 for projects they update values. Now I want to find with boolean in ListUser Module M2 whether they entered any values or not. So I need to search in LI1 in M1 and return true in M2 if…
Native Version Filtering
Hi, Is there a way i can add the native version that has formula in my filtering ? See example below, i need to activate the boolean in my "Act vs FC" version. Thanks in advance for helping. Regards, Tom
Level 2 Sprint 3 AD02 query
In Level 2 Sprint 3 I have the following formulae for the boolean line items in AD02 Submit Purchase Order - Write?'INV01 Inventory Ordering'.Submit Purchase Order Request?Override Shipping - Write?'INV01 Inventory Ordering'.Override Shipping Method? AND 'Submit Purchase Order - Write?'Override Amount - Write?'INV01…
About Automated Outlier Correction
こんにちは、統計予測を試みていますが、外れ値について質問があります。このプロセスでは、外れ値を標準で設定できます。偏差。しかし、私はこの設定を使用できないと思います、時系列データには正規分布がないためです。これについてどう思う。
Search Actions in the New Modelling Experience
Hi Team The new modelling experience is great, giving a fresh feel to the design. I like the search option centralized as i don't have to do many clicks. Currently it has Modules, Dashboards and Lists. Can you include Actions too ? Thanks Kudi
Line Items Related to Purchase Orders : Confirmed PO Delivery (Level 2 Sprint 3)
* Set the Confirmed PO Delivery line item to use the PO Submitted 1 value and OFFSET it based on the number of weeks between the order and delivery. For example, if a PO Submitted has a value in Week 1 and the Shipping Time Weeks has a value of 2, there would be a value of 1 in the Confirmed PO Delivery line item in Week…
Upload local image on to UX pages or Dashboard
Hi, I have an image(JPEG file) in my desktop given by user which need to be displayed on UX pages. I can see URL option is available in Anaplan to upload images. Is there any other way for uploading local image files?. Thanks, Suman.
Keyboard shorcuts.
Hi, for newcomers to Anaplan, a tip I posted 4 years ago and that I find worth being posted again with some actualisation. I am using keyboard shortcuts all the time on Anaplan. CTRL C / CTRL V are obvious for anyone, and very efficient in Blueprint for properties copy and paste. I find two other shortcuts very usefull and…
Display only the items created by a user (within a list dimension)
Hello, Here's what I'm trying to achieve: Person A: John Smith (john.smith@hello.com) List Item: Department: Finance When John opens the App, he should only see the 4 products he created under the Finance Department list dimension.…
New Modeling Experience - Enhancements to Syntax Highlighter / Formula Editor
The syntax highlighter in the formula editor (new modeling experience) is good for simple formulas but in general too basic in comparison to the A+ plugin or any standard syntax highlighter used in coding tools. As a model builder I want to have the following additional features in place - see IF THEN ELSE with line breaks…
Filter what appears in the dropdown for a list-formatted line item with a boolean
Current state Currently, you can filter a list using the "Selective access" and "Dependent" checkboxes when you go to the Format property of a line item, or you can create a list subset. It may happen that you want to have more control over what appears in the list than the checkboxes allow... but applying a subset comes…
Level 2 Model Building: Sprint 3, INV01 Inventory Ordering
Why are my values for forecast demand and suggested order amount for the month slightly off (by 2 units) at the SKU level? The amounts are off by larger amounts at the "All Products" level. Also, how do I make it so that the Safety Stock Target will only show at the SKU level?
Level 2 sprint 3 activity 3.3.4 TRA01
I have been trying to figure out the formulas in this activity, I know that YEARVALUE function would be used with LOOKUP function. I am not able to figure out so as to what the mapping dimensions should be for LOOKUP as P3 SKU and G3 Locations are not lists. These are only dimensions I can think of as of now. Please guide…
Is it possible to override number formatted line item default value to BLANK
Hi, Is it possible to override number formatted line item default value to BLANK? Suman.
Add properties to line item subset
Description of the enhancement required: Add List Properties for Line items subset and a full menu (like ordinary Lists have). Currently there is only one “Description” property available An example of the enhancement: Adding properties section for a line item subset would allow the business to store non numeric…
Retrieve the current user from another module
Dear Expert, Good day! Is it possible to get/retrieve the current user from Module 1 to Module 2 even there's no Users list used in Module 2? So that the user will no longer select/choose on the dropdown in Module 2. The reason why we didn't put the Users list in Module 2 because of workspace size issue. Please see…
Formula for subsidiary view item
Hi! I have a question about formula in subsidiary view. I have a line item with different dimensions. What should I refer to in the formula so it would work (and can be seen) in subsidiary view item? Other items in the module are in regular dimensions.. And I would like to use them in the formula for subsidiary view item.…
L1 Model building - 6.6.5
Hi, I'm trying to add the formula 'SYS00 Time Settings'.Forecast Period? to mi line item but I keep getting an error pop up. If somebody knows what's wrong thank you in advance.

Modeling

Discussion List