-
Optimizer - Forcing one product to remain at one plant despite optimisation
Hi, I have a Model and have successfully optimised our data 3 Plants 100 locations Costs from each plant to each location Total Demand volume by location (we have product but don't use it currently*) Constraints Volume cannot exceed plant Capacity and Location Demand must be met This all works as expected *What I want to…
-
Tableau and Anaplan Connection using Certificate Authentication
Hi, I want to check if it is possible to use certificate authentication method with Anaplan Connector for Tableau. I am aware about the procurement process , just trying to understand if this is possible with Tableau. If yes, can anyone share the steps? Regards, Aakash Sachdeva
-
Wrong date when doing an import
Hi everyone, I am importing data into a module which gives me the employment date of a list of employees (among other info). The module doesn't use time as a dimension. The import goes perfectly well, it doesn't mention any error. But then some of the dates are wrong. So I tried to copy these directly from Excel (simple…
-
Bolean condition based on Season
Hello everyone, i've been recently struggling with a dev. I have a list in my model called Season (I work in the retail industry). This season list is composed of items that are like this : 23SS, 23FW,... that correspond to the seasonality of the product (for instance : 23SS stands for spring/summer 2023, 23FW stands for…
-
Switchover and FY year settings
Is there a workaround on: 1 Updating Switchover period from the NUX App 2 Is there a workaround on updating the Current Fiscal Year of the Time Settings from the NUX. Please your reply will be really helpful.
-
Lag Function without Time Demensions
Hi Anaplanners, I am trying to model a queue building up in Anaplan and I am wondering if there is any way I can use the Lag function to return the adjacent value without time dimensions. The principle is to add the queue from the previous segment and add to the current segment, however the model does not have any time…
-
Clubbing multiple excel exports
Hello All, We have a requirement from user where they want to club multiple excel exports from Anaplan as a single file (meaning each sheet in excel having the respective export from Anaplan). Is this possible? IF yes, can you suggest how to proceed. Report 1 -> Sheet1 of excel Report 2 -> Sheet2 of (of same excel)..and so…
-
UX User-Filter & Context Selector Issue
Hi, I have a user filter that was working correctly before (and still working in some old UX pages) but it seems that after the last Anaplan update a bug had happened and I am not able to apply the filter anymore. In my UX page shown below, the user-dimensioned selector (Blue box) filters the context on the page (green…
-
Calculating line item based on diffferent values in the list
Hi Anaplanners, I have a module dimensioned with 2 lists, loc1 and sample. Sample has two line items Sample 1 and Sample 2. There is a line item called Transportation. I want to add another line item called Transportation Sample1 vs Transportation Sample2 which should be Transportation for Sample 1 - Transportation for…
-
can someone help me understand the difference between structural information and production data
-
How can I Filter out certain Time Periods in my Time Filter?
Hello, I'm trying to include the following time periods - Month, Quarter, and Year totals while excluding Half Year. Because of other use cases I cannot remove Half Year from the time scale. Has anyone encountered this before and how did you solution it? Thanks!
-
Model Optimization : List Sort Order
Hello everyone, Is there any further documentation to read regarding optimizing the model. We saw this in the checklist. Does this mean we have to Sort the List? If yes, via what property of the list (Code, Display Name or Numbered List arrangement) Thank you very much.
-
Create a list out of on data inputs
Hello Community, I am quite new to ANAPLAN so a bit lost sometimes and not all knowledgeable yet! I have created a simple list of numbers (#1, #2, #3…) to allow our users to input data into a table (inputs module), in different fields. After the data is in, a line item picks up a final description with a concatenation and…
-
Anaplan formula to Lookup Balance Sheet description
Hi Anaplan Community Please see email attachment with all details for my question relating to. I have an “Account Major Properties” module with a line item of “B/S Line Item” where I want to populate the valid Balance Sheet line name, from the list “Balance Sheet Lines – NEW”, based on the Account Major (e.g. GL Account)…
-
How to Move From Custom Time Amortization list to Line item with Time Range Mapping
Hi All, Can any one Help me to copy data from line item 1 to line item 2. Format for the both line item is number only. Dimensions : Line item 1 - Product list, Amortization Month list, Line item 2 - Product List, Time. Issue : I created a module, where I have a mapping between amortization month(used as module dimension)…
-
Need to set a particular list item as default in Dashboard, other than ALL
Hello Everyone, I have Flat List by name: ABC, This list i have selected in a Module:1. This Module1 i have published on classic DB. The list contains list items 1,2,3 and ALL. Requirement: I want to set 1 as default list item on DB, whenever any user opens this DB they should see the default as 1 as the list item. But in…
-
Bringing prior year loss into current year income calculation
I have a requirement to include the net loss of a product in the next year income calculation, but only if it is a loss. I keep running into circular references. Any suggestions? Year 1 Year 2 Year 3 Year 4 Revenue 100 120 140 160 Expense -150 -90 -80 -100 Prior Year Loss 0 -50 -20 0 Total -50 -20 40 60
-
How to truncate or make this formula more efficient
Hi, This formula in our model is possible slowing down the load time of our model. The formula has the logic we need but I believe it can be written better for loading time in our model. Formula: IF 'S04 Version Mapping'.Budget THEN IF 'S01 Time Settings'.Funding Holidays? THEN IF 'S01 Time Settings'.Weekdays? THEN IF…
-
Have a Budgeting scenario to streamline client's process - Recommendations on multiple models?
Is it recommended to have multiple models where aim is almost similar throughout for all regions but the way of calculations are different for each cost center.
-
Have to design a model with L5 hierarchy but Business says sometimes they might have an input at L6
Have to design a model with L5 hierarchy but Business says sometimes they might have an input at a level below for some regions. So should I be creating L6 or create a separate list and link it the values to Its level 5/parent in some other way around.