-
How to add a button that creates a new line item in the GL that has a hierarchal structure
The current button we have in place has us add in a new SUB-GL/ vendor item to a numbered list. That numbered list uses an OpEx subset that layers in each new vendor into its respective opex area such as adding "Anaplan 2.1" under Software subscriptions in the GL. The problem im running into is that this current structure…
-
assets & Predictive Insight Modelsin anaplan
Where can we sue this option of Assets and predective insight models in anaplan
-
Level mismatch in trying to bring data
Hi I have this scenario where I need to bring in data from a source which is dimensionalized by Product L3 (leaf) level and Account to a target which is dimensionalized by Product L3 (leaf) level and Area. Mapping table has Product L1 (Top level of Product) and Account. It has Area as list formatted line item for mapping…
-
Omit the calculate lineitems by using Lineitem subsets
Hi, I want to omit calculate Lineitems by using Lineitem subset. I have these Lineitems. I have to calculate each(A,B,C…) error(= Forecast - Actual) . But in this table , I have to create at least 4Lineitems and input formulas. Category Lineitem Value Forecast A_forecast 100 B_forecast 10 C_forecast 200 ・・・ ALL_forecast…
-
Boolean with summary : "all", true for parent with no child?
Why is a Boolean line item with summary set to ALL true for Parent even when there are no child items? I noticed that a boolean line item was true for a parent in the hierarchy automatically if summary was set to ALL even if it had no children. Why is this so? I thought if summary is set to ALL the parent would be true if…
-
Need help filtering a Module
Hi Community!! I am having issues in one of my Modules and Page, as I need to filter out groupings of Country/Region/Area depending on the Territories the user has assigned. Can anyone provide advise? I have tried with DCA but I cannot seem to get it right. Screenshots attached. Thank you!
-
Cloudworks not working
Hello everyone, I tried to automatize a process through Cloudworks, the process do to following thing : it pushes boolean values from one Line Item in the Model A to a Line Item in the Model B. So i created the action (that i encapsulated in a process) in the Model B, then i went to CloudWorkds and did the correct setting…
-
Mail anaplan report to email as attachment
Hi, Is there any possibility to schedule anaplan report everyday as attachment to user email…
-
Summary settings to Formula Issue
Hi All, I have a module dimensioned with 4 lists, version and time. In one of the line-item I have this formula below, which has a division:- IF ITEM('L2 One-off Components') = 'sys99_Lookups'.Care THEN 'dat20_One-off Credits Actuals'.Revenue / Days in Month ELSE 0 The issue I'm having is that when I go to the summary…
-
I have created a ranked formula but when I go to sum the total it brings in the sum of all accounts
I am dimensioned across account, time, and practice. My formula looks like this IF Top Account Filter THEN 'Actual + Expected' ELSE 0. It seems to work with out a time dimension.
-
Doubt in Modeling: Team + User + Project + Project Category
Anaplanners, Summary of items: P1 Project List # (List of projects created in the system) A20 Fake user List # (Custom built users List) A10 Team List (Teams within the organization) R3 Project Category List (Important, Not Important, Semi Important) 1) Project Category is an attribute of Project List, this is assigned…
-
1.4.3 Activity - Line Item not showing
Level 2 Sprint 1 - 1.4.3 Activity to create/import SYS12 SKU Details. I created and imported all items successfully, and I can check all records are loaded properly. But by some reasons, I cannot see the last line item, Distribution Center' from the view. What am I doing wrong here, can anyone please help?
-
Schedule vs. Snapshot of Line Items
I have a schedule with two line items below showing exactly how the parenthesis should be. When the snapshot is taken, the parenthesis shows differently (second screenshot). Does anyone have an idea of why there would be a difference in the line items after the snapshot has been taken?
-
How to spread a cost from a father to his son in the hierarchy?
Hi all, I am having a hard time spreading costs along the hierarchy. My hierarchy is composed this way: BU responsible BU R&D project What I am trying to do is to spread a general cost across each BU using a driver and then to spread that BU cost again across its R&D projects using a second driver. The drivers need to be…
-
Adding a top level hierarchy list within existing hierarchy
Hello, In our current model, we have an existing hierarchy with let's call A and its child B. We want to add a new hierarchy list as X, and X will be the parent of A. As far as I know, adding a top hierarchy list should not cause any issues for the current modules with list A and list B dimensions and shouldn't ruin any…
-
Advice wanted
Hi, I have expense list (5 list items) and one line item (Key fig list formatted).So for each expense list I need to assign one key fig. Suppose for travel expense list item If I have assigned Key fig1 and for the next expense also i have assigned key fig 1 then it should show in blue color indicating that each expense…
-
Better Formula Editor for Anaplan; A Chrome/Firefox/Edge Extension
Hello all! A while back I made a Google Chrome and Firefox extension that enhances Anaplan formula editing by using the Monaco editor (currently 700 users). This is the editor used by Anaplan's new modelling experience. My extension works with this new experience adding enhancements over and above what Anaplan have done.…
-
How to get Previous week vales
HI I want to get prevous year week values . Without hardcoiding means week-52 How can i achevie that Previous year is week format & when ever the 53 week comes that data come that show not go current year 1 st week
-
To Select Q1 (Boolean checked) - From the Input year
Hi All, Need your help! I have an input Line Item Say "A", Year Format. I selected FY23. Now i want only Quarter Q2FY23 to be selected. (Boolean checked). I do not want rest of the quarter to be selected. If the input will be set to FY24 then i want Quarter Q2FY24 to be selected. How this can be achieved? Thanks.
-
Date Line Item using Min Summary
Hello I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same. I am facing issues where if there is no date in my list P6, i am getting 12/31/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding. Regards MO