-
Level 2 Conclusion OTH01 Non Employee Expenses
Hello I'm on Level 2 Model Building: Conclusion, and it says: Import the Shipping Cost data from the Supply Chain model into the OTH01 Non Employee Expenses module, Shipping Cost line item. For department, import into the Sales department. Run the import. Results should have none ignored and 0 errors. Here is my saved view…
-
Level 2 Sprint 3 : AD02 Inventory Ordering Overrides
Hello, I am inLevel 2 Sprint 3 I have the following formula for the boolean line items in AD02. For the line : Override Amount - Write? My formula is : IF 'INV01 Inventory Ordering'.Submit Purchase Order Request? AND 'INV01 Inventory Ordering'.Override Suggested Order Amount? THEN TRUE ELSE FALSE Can anyone correcte my…
-
Dimentionality of a model
How is the dimension determined for a model? Here is a high level description and issue i am facing. Module (1) I have a list of entries considered the column looks like this (let's say 10 columns) Dimension ABCDE Metrics FGHIJ The cell count is 66,807,426 And Let's say column E is the project id which could be mapped with…
-
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…
-
How to turn on file upload toggle on classic dashboard or NUX.
I have created and import action of users through CSV file but unable to find same toggle in classic dashboard action to upload a new file and run action again to update my user list.
-
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…
-
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…
-
Organizational reporting structure in Anaplan: Seeking Input and Insights
Hello, I work at a company's headquarters, where we use Anaplan applications for reporting purposes. Some of these Anaplan models have been developed in-house, while others have been created by external consultants. This has resulted in a situation where we have multiple lists containing more or less identical…
-
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…
-
NPV with rolling start date
Hi - I am trying to build a module with an NPV calculation which in each month calculates the NPV of cashflows starting from the next month until the last time period in the module. So in Jan-24 it would calculate the NPV with cashflows from Feb-24 to the end of the module. Then in Feb-24 it would calculate the NPV from…
-
Is there a way to migrate existing classic workspace model to a Polaris workspace?
Another question, Can we build model to model import processes between classic and Polaris?
-
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…
-
How to hide line items in UX avoiding repetitive hide UX command
Hi all, I am facing an issue I'm pretty sure many of you already have dealt with. The columns Cost Center, Responsible, Employee Name, Labor Cost are line items. I wish I could show the cost center, responsible, employee name, labor cost line items only for the first project (1-Av-Bc - Argus V1); in short, I need to go…