-
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…
-
Anaplan Data Import Issue: Numbered List Code Mismatch
Hey Team, I'm facing a bit of a challenge trying to pull data from a source module into a target module. Here's the situation: The source module has a numbered list dimension, and I need to bring one specific module's data over. I've already determined that the target module also needs to use a numbered list because there…
-
In Level 2 - Supply chain model - do my time settings look right?
The only reason I ask is because I've been unable to achieve some of the UX pages and, asking in prior questions, I seem to have everything right but the UX pages still aren't working. Would someone mind taking a look at my time settings? Thanks in Advance!
-
Is there a way to filter the dropdown in a Report page similar to the Board page?
Hello, Is there a way to filter the dropdown in a Report page similar to the Board page? I don't have the same capacity when in the Report page. There's no Gear icon to filter: Below is the screenshot from the Board page where I was able to filter my toggle dropdown:
-
Is there a way to remove the extra empty columns in Report App?
Hello, I'm building report pages. Is there a way to auto-fit the data such that empty columns won't show? It would look so much better:
-
Identifying orphans in a composite hierarchy for deletion
Hi, I have an L2 list that is used to capture staging data. The parent to this list is L1. The user runs a import action via the UX and a csv file to load serial numbers into the L2 list (L2 is a numbered list) The user has been provided a template to upload the L2 list wherein they need to enter the parent and that is…
-
How to calculate number of months between two dates when one date falls outside of model time range
I am needing to calculate the number of months between two dates, one of the dates falls outside of the model time range. I am needing this so I can do a straight line depreciation cacluation but the # of months formula returns a blank value because of the date/time range isue.
-
ALMing multiple revision tags into Production environment
Hi, I have a scenario wherein I have multiple revision tags ALMed from Dev environment to the UAT environment. They have been synced in the correct order. I now need to sync to Production with UAT environment. I understand that revision tags are cumulative in nature but wanted to understand any possible implications of…