-
Data Import from Model A to Model B
Anaplanners, Had a query, i have data in Model A, in Revenue Module which is dimensioned by Country List, Time & KPIs as line item. I need to import this data into Model B, in same Revenue Planning Module, which is again dimensioned by Country, List, Time & KPIs as line item. However here we have an additional plan type…
-
Adjusting Statistical Forecasts: Utilizing different Methods for varying time horizons
Hello Anaplan Community, currently we have a very simple statistical forecast tool in Anaplan. We can select between 15 forecast methods for a forecast category. We generate the statistical forecast using a single method for the next 5 years. We aim to introduce a logic that enables selecting two distinct forecasting…
-
Sequential code creation with department(code+1 ?)
I have a requirement where I need to create sequential codes with department (based on user selection) in a list .The user will click "Add item" from the dashboard and codes will be created and added in the list in a sequential manner . Example : 1st time : New code : 6759_00000 2nd time : 6759_00001 Similarly starts from…
-
Number Scale formatting not working properly
Curious if anyone else have experienced this issue.. Front-end I have a lot of grids in various dashboards, for a lot of these grids, there are 50-100 line items, with large values in. I want to show these in thousands, using the Card Configuration → Format → Number Scale, and set to thousands. For about the first 45 rows…
-
Apply Dynamic Cell Access based on two modules
Hi, I need to add DCA to enable this functionality- I have a module (MODULE A) where budget is input by markets in a budget input line item. I have another module (MODULE B) where once the market has input the budget, they can check the boolean "Submit to HQ". Once the "Submit to HQ" boolean has been checked, the budget…
-
Optimizer OR
Dear Community, is there a possibilitly to use the logical OR in a constraint for the optimizer? I am trying to compare a variable to a constant. The constraint should default to TRUE if the varible equals zero or is the variable equals the constant. I came up with a non-linar equation (x * (x-y) = 0), but I do not know…
-
Multiple Selection like Excel Pivot
I want publish this below list on ux pages and give end user option to select multiple item from list like we have option in Excel Pivot table. Is this function available in Anaplan or can anyone suggest me alternative function can be used. There are multiple line item in the list. The final goal is to sum the number from…
-
Best Practise of creating List
Which is the best practice for creating List in a Spoke model from Data Hub model ? Is it a List to List import OR Saved View to List import ?
-
Filtered Picklist / Dependent Dropdown using values
Hi all Is it possible to set up a dependent dropdown based on a value? The scenario is that we have a list of orders with an order quantity, with a line item for the user to select the destination. However, we have a capacity constraint in the destinations, so we want the line item to only display the destinations with the…
-
Change in model size on importing
I have a prod model which is of almost 120 GB size. For some test purpose i simply imported the model to another workspace but now when i check the size of the model it is 75GB. When i checked at module level yes the cell count differs for some but not sure why the change in size. Kindly suggest.
-
SUM data in time dimensioned module based on Boolean
Hello Everyone, I have the following scenario, could someone please help me to solve this. I have a module dimensioned by Native time and I have 3 line items one is Boolean, Value and Target. Now I have to look at the Boolean line item if it is true then copy the current period value from value to target if its not true…
-
A case where general lists unique key were mapped to name or code now wants to map for code
A case where general lists unique key was mapped to name or code now company wants to map for code. There are 300 dimensions need to have this change. How the Downstream impacts for this change ? What are the cautious things need to keep in mind before making this change ? Please suggest .
-
Power BI connection to Anaplan -- multiple times credentials asked
In my project we have power BI linked with the Anaplan. Working in Power BI everytime there is some issue with the connection with the anaplan and it keeps asking for credentials. And also for password reset which is very frustrating. What can be done to have a secure connection?
-
Passing parameters to system modules
I have more than five modules where "reporting date" is a line item and I import values for them. In each of those modules I have another line item to calculate the reporting period based on the reporting dates. Here is the formula for that. IF DAY(reporting date) <= 15 THEN PERIOD(reporting date) ELSE PERIOD(reporting…
-
Unexpected Model Size Increase After Updating Custom Time Range
Hi Anaplan Community, I recently updated a custom time range in my model and noticed an unexpected increase in model size. Previously, my custom time range started in FY22 with 4 periods, and the total model size was 78 GB. After updating the start period to FY23 (keeping the number of periods at 4), the model size…
-
Workflow - Notify people on rejection
Hello, If you have a decision task in workflow and you choose "Continue after rejection", you don't get a choice of messages. If you choose not to continue then you can't add a notification telling people the task has been rejected. How would you notify someone that the decision was rejected?
-
Workflow adhoc triggering
Hi, we have workflow enabled now and I was looking at it for Invoice approval process. Some days we have no invoices, and then other days we may get multiple invoices arriving. From what I can see Workflow needs a schedule to run (daily, weekly, monthly etc), does that mean we can't trigger a workflow when we want to start…
-
Help with L1MB lesson 8.5.3 Activity: Import Data into Volume Inputs Module; Import not working?
Hello — I have been trying to import the data file Volume+Inputs into the REV02 Volume Inputs module with no success. Just a couple of disclaimers: I am in grid view when I try to import I have refreshed both the lesson view and the example view I have re-downloaded the file I have updated the grid view for the time being…
-
Summary values according to two list/line items
I have a module "details" dimensioned by a list 'orders' which is a hierarchal list . Structure of module looks like this :- one of the line items is 'Amount' and one is 'Plant location' in another module "Summary" i want to summarize the figures of this module according to plant, this module is also dimensioned by same…
-
Model Building - Avoiding Circular Reference
Working on a use case to reproduce following psuedo code in Anaplan Start Recommendation_given=0 for tranche 1 to 6 if tranche =1 then tranch_contribuiton = 0 else if tranch recommendation <= recommendation_given or tranch_recomendation = 0 then tranch_contribuiton = 0 else tranch_contribution = tranch recommendation -…