-
Cumulate a moving target
Hey Anaplanners! Hopefully a fun one and not just my own short-circuiting. I'm working through a capacity allocation rankcumulate, where my list items(SKUs) have a target for a month, and multiple sites that can produce units towards that target. My issue is that the cumulation is correctly grouping by SKU group (family)…
-
Syncing Issue From Dev model to Live model
Hi all, I am having some issue on Numbered List syncing from DEV to LIVE correctly. I have a saved view used for import to create a numbered list in the DEV marked as a production List. When synced to LIVE model it works but the Mapping source does not map correctly in the LIVE. Does anyone know what the issue might be and…
-
Data Hub to Spoke Model Line Items or Subset
I am building a data hub and spoke models. Currently, I have: built a data hub with system shared lists. It holds flat lists that only consist of list items and list codes. used modules in the data hub to assign line items which act as parents, grandparents and other metadata to the flat lists. saved specific views to pull…
-
Cost center as Time dependent dimension
Hello, Our client has been working with a cost center structure that is going to change totally. We would like to keep historical data with the old structure for the reporting view. Is it possible in Anaplan to indicate that a dimension is time dependent so that we can ensure to keep historical data and update the new…
-
Lookup of a boolean line item using top level (parent) not producing results
Hi. I have a multi-dimension module. I created a filter line item that checks to see if a value in Devices dimension is <0 for any one of these devices. I set the sum method to Any, Time: None. So I get the expected result: The formula for this: 'Deployment (LIS)' < 0, and the results work perfectly as expected. Next I…
-
Doubt about modules with a common dimension
I have an issue when I change a scenario in modules with common dimensionality. Example: In the case of modules A, B, and C with a common dimension (e.g., Cases). The List Cases considers Cases 1, 2, 3, and 4. Should the other two switch to the same Case if I select a Case in one of the modules? For example, after…
-
Is there a limit (250 GB ?) on model size within HyperModel workspace?
-
How to implement a multiple-criteria-mapping into a formula
Hi, I am trying to make this mapping work in the best way possible. I have 3 criterias: RV1 Revenue, RV3 Revenue, Product Class. I need to have, as a final outcome, the same Revenue BU of the mapping in this final module: How can I achieve this? Is the IF THEN ELSE concatenation the only solution possible? Thanks, Luca
-
How can I filter a time dimensioned module using data from a sys module
Hi, We have 2 modules - a) SYS Module Dimensions - 1) List A (have numbers 1,2,3,4…,so on) 2) Line Items (various line items like region, status, name, etc.) b) Time dimensioned module Dimensions - 1) List A 2) Months 3) Line Items (All numbered formatted ) We have both the modules published on the same NUX. We want to…
-
Issues for L2 Model Building (Activity: Import Data into FP&A Model)
May I knowwhat might hve cause the issue? I downloaded the G3 location list as instructed in the L1 Model.
-
Excel equivalent for TEXTBEFORE
Need to pull text out of a string. Starting from the beginning but going varying # of characters. Last character will always be immediately before an underscore. So in Excel I could use the TEXTBEFORE function. No exact counterpart in Anaplan but wondering if someone has already solved this with a workaround?
-
Date format
I want to change the format of the column header to be the actual date in format MM/DD/YYYY. A user in another country set everything up in format DD/MM/YY and I want to change it.
-
How create an Assortment List with more than 6 Dimensions?
I am trying to Create an Product Assortment List based on 6 different dimensions, but I just want to create the elements for which I have information (an Input from the user). The problem I am facing is that, when I add into consideration Line Items to use as filter for the elements and to create the concatenated code for…
-
Date not pulling through
Hi I've got one module with data - timescale by quarter and 2 lines: Early repayment period - quarter format Early repayment date - date format Then I've got another module, no timescale, with 2 lines: Early repayment period - quarter format - formula to link to the module above: C_Early Repayment Period.Early Repayment…
-
Sum based on the Two time scale
-
Error when changing list dimension to subset
HI, I have a list as dimension in one of my modules, and I am trying to change that dimension to a subset of the same list. However, when I try to do that, I get the following error message; "To serve as an access driver, a Top Level Item must be present on any line item dimensions that don’t match those of the target…
-
Create Demand Export Module and Create a Saved View - Level 2 conclusion
I am having an issue of this - Though the formula is being put. I have no idea why it returns as empty values for all the cells. Thank you.
-
Filtering with nested dimension
Hi Anaplan community, I need help setting up a filtered view to only display list items with value in any of the time periods in the selected Fiscal Year. And by any, I mean Q1 or Q2 or Q3 or Q4 or FY. Because for a line iten such as Headcount - there could be a value in Q1, but the corresponding FY has a zero value…
-
Import values from previous period into current period
Hi, I am trying to build an import which should take the values from a month to the next one, in order to create a baseline the user would then modify as he pleases. Once he's done so, he should then import the new values into the next months. The import seems to work, however, it deletes the value from the previous month.…
-
Is it possible to check capacity for each Module?
So I want to change my module. But I want to know how much capacity before and after implement new changes. Current now I only knew that we only can see the capacity for a whole model. Please someone, could you tell me about this information? Thank you!! 😄 BR, Dian Suci
-
Stock Re-balancing between Stores
Hi Anaplan Experts, I'm trying to calculate the re-balancing of stocks from one store to another based on the logic below. Step 1: Rank Supplying Stores based on their available stock to give (OUT) Step 2: Rank Requesting Stores based on their needed stock to take (IN) Step 3: Re-allocate available stocks from Supplying…
-
Distribution Center Summary UX Page
Hi all, I have a few questions on the UX expereince dashboard How do i replicate the filter exactly like the example? I think there are no SKUs in the exception summary module (first table - New York/San Francisco / US). How does the filter broadcasted to there How do i have a summary value like it shows there for US? it's…
-
Subset-based display
Hello everyone, I have a module that is dimensioned by a store list. Each store belong to one or more comparison groups (each comparison group is a subset). I'd like to be able to select a comparison group and, depending on this selection, update the list of stores displayed. Do you know if ANAPLAN allows this? I hope my…
-
How to get data from current period -1 of current period
Hello, I need to get data from Aug 21 to Sept 21, but i dont want to use "Previous month", if not something like "current month -1", it´s possible? Thanks
-
3.3.5.4 Update INV01 Inventory Ordering to Allow Override of Order Amount
I got a circular reference for the below action. Redirect the formula for this line item that currently references the Suggested Order Amount for the Month line item to the Final Shipment Amount line item instead.) This is the original formula for Confirmed Purchase Order Receipt IF Confirmed PO Delivery > 0 THEN…
-
L1 Model Training
hi all, I am trying to get the region for the employee and used the following formula What's the issue with it and what's the best practice of getting the formula? Thank you! Best
-
Level 2 1.4.3.1- Products List is not showing the Data in the Grid rather getting a selection list
-
Level 2 3.3.5.3 INV01 Inventory Ordering
Hi, I am struggling with figuring out where I went wrong with the INV 01 module. When checking my work, I'm all good up to Week 5, when the reorder flag isn't checked for me. I thought I did all the formulas right, and I'm stuck with where to look next. My work: Vs. what it should be: Can anyone help me understand where I…
-
what would be the formula for referring Previous year value in current year ?
For example, I want to refer the value of last year july 2022 in current month July 23. the line item is Past year revenue where I just want to show same month revenue from previous year, how could I achieve that?
-
Line item with Month Format, need to repeat for all the period after it is calculated
Hello, I have a line item with Month Format (Maternities Month M_paid leaves calc) and need to repeat it until another line item with boolean format is true (Maternity). Tried with lastnonblank formula. Thank you for your help!