-
Clarification on Updating Model Calendar for New Financial Year
Hi Team, Could you please let me know the impact on model data when updating the time setting (model calendar) at the start of a new financial year? Additionally, I would appreciate it if you could share the precautions I should take before updating the "Current Fiscal Period" field to reflect the new financial year.…
-
Date into Time Period Month
I have a situation where i have a line item formatted as a date(lets name it dateLine), and another line item formatted as time period month(monthLine). Currently monthLine=Period(dateLine) which gives me result like :- jan 21, feb 21, etc. However because of Period function limitation of model calendar, for values going…
-
Use case of assign only
Can you share an example of where we would need Assign only action
-
Load FY-Level Data into specific month via Data Import Between Modules
Hi Community, I have a scenario where I need to push data from one module to another within Anaplan. Here's the setup: The source module contains data at the FY level (i.e., yearly summary), example FY25 The target module has the same dimensionality but is at a monthly granularity. I need to load the FY25 value into…
-
Delete from List Selection Action
We are trying to set up a Delete from List Selection Action. We have set up a Control module with a Boolean line item to determine what list items to delete. When we try to set up the Action, the control module is not displaying for selection purposes. The Selected using only refers to the one module: DAT01…” Both this…
-
How do I add Create action in NUX ?
Hello, I see one create action in "Actions" but cannot add that in NUX, how do I achieve this ? The same create action is in Classic dashboard though. Thanks in advance
-
What do someone follow while creating line item?
Rules to follow
-
Level 2 1.5.2 Activity: Import data into Beginning Inventory
Hi, I have problems importing the beginning inventory into DAT 01 module. Mapping looks like this. There is an extra column with numbers. What should I do with this column and how should it be mapped? I assume the beginning inventory and this extra column should be together, so that the first line should have a beginning…
-
Most Recent Duration (MS) is different for each User Same Import
In a Level 2, looking at the Actions panel, noticing the Most Recent Duration (MS) is different for each Model Builder in class. How is this number determined?
-
Saved views
We have a number of saved views across various modules in our model, does the number of saved views impact model performance at all?
-
番号付きリスト表での判別
下記のような、番号付きリストをディメンションにもつデータがあります。Answerの式を作りたいです。 まず、CheckにXがあるものを対象に、PRDとLineを確認し,さらにPRD-Line-Vesionがいくつあるか確認します。 例えば、A-1は、A-1-A2の1個しかないので、Answerは1とします。 A-2は、A-2-A2と、A-2-A3となります。この場合、1つめのA-2-A2には1,2つめのA-A2-A3には11とします。 さらに、FlgがTRUEなら、12とします。 お知恵をお貸しください
-
Multiple header (in different line) for same column
Expected output where each column has two header i.e account (in 1st line- green) and Description (in 2nd line - yellow) To achieve desire, result in Anaplan I have created two separate list account and description. It is giving me the expected result, but this module will be referred by multiple models. I will have to use…
-
Timesum check
I want to do a timesum for a value from first month of current year to last month of current but it is not returning value. I have used logic as TIMESUM(Amount,First month of CY, Last month of CY,SUM) Where amount is value, first month of CY is Jan 25 and last month of CY is Dec25. Amount line item has time on whereas for…
-
Model Calendar vs Time Ranges
Hi, My model calendar is currently using FY time with start period being Jul-June. For another module I need a time range that uses Calendar Year, Jan-Dec. I am not sure if it's possible. I tried the Time range function, but it defaults to Jul as a start period. Is there a way to accomplish this?
-
Architectural Use Cases for setting Action Imports / Import Data Sources to Production Data
There's only 1 practical architectural use case I can think of at the moment why you would consider setting actions as production data but would like to check in with others if there are other use cases I have not considered. The one use case I have considered is if you are splitting the same model in to regional models,…
-
Line Items not Showing for 'Create Shipping Export' in the Level 2 Conclusion
Hi - I know this is a frequently asked question but I believe there's something missing in all of this that I can't spot. I've been dwelling on this for days and this is due tomorrow. Can anyone help spot the issue(s) I'm encountering? All Modules: INV01 Table View: INV01 Blueprint View: INV05 Line Formula: TRA01 Grid…
-
Need help in formula to select specific month/year(cutoff date) to calculate larger calculation
share some exmample
-
Pulling a column into an Import Module
I need to pull data from one module into another. Here's a breakdown of my setup: Module1(G4 Metro Module): This module is dimensioned by G4 Metro list and includes a line item that maps 'Node classifications' to the G4 Metro items. Module 2 (Import Module): This module is dimensioned by a numbered list (UID) and has a…
-
Version as general list
In my model the version are built using general list. In this instance if for restatement i want to copy over the complete data from one version to a new version how can i do that?
-
Not able to track the historical changes for a formula cell
Hi People As per above SS for Lineitem 'C' I cannot see the history for this cell , whenever there is a change in values of input lineitems 'A' or 'B'. Also, even If I change the formula for 'C', then also cell history for the cell does not showup. Whereas when I check the 'History' from Settings panel then it just shows…