-
Problem of inporting a List from Model to an other
Hello Anaplan Community, I want to import the same list from a model 1 to model B but I have this message that pops up every time. Can you tell me the reason behind this ? Thanks in advance !
-
Sum on dynamic filter selections
Looking for a way to sum off a data module based on dynamic user selections. My dashboard has a filter(dimensioned by user). Users select any combination of these dimensions(except amount and account). Sometimes fields are blank so a simple SUM wouldn't work. Ultimately the summation would live in a P&L statement so also…
-
Module with no dimensions
Is it possible to build a module with no dimensions that will allow us to import a file with thousands of rows? The current file we receive does not have a unique code. We would like to import this file into an ANAPLAN module and then create a unique code using the data in the line items so that we could then create a…
-
Adding lines of data from a list to a single line in a module
Hello all, Could anyone advise of an easy way to add multiple lines from a list or module based on my list to another module in a single line? So my list is a list of products, descriptions, etc and in the list-based module I have a boolean to select specific products, I then would like the list of data to appear in the…
-
Level 2 Sprint 1 1.3.10.3 Import Data into G3 Location List
Having trouble importing from a saved model. I've searched through the community for answers but still stuck. Can't seem to figure out how to get the column with the Boolean list. This is the activity and the end result: This is what mine looks like and the error I'm getting: Any help would be appreciated.
-
How can I get data to be imported to the next open row
I am trying to get a row of data to be automatically uploaded to a row that has not been filled yet. (I currently have it set up where you have to manually select the row every import) Also is it possible for the "ALL TRANSACTIONS" grid to automatically create new rows of transactions when all rows are filled? Here is an…
-
Training - Import Data into E2 Employees# List
Hello I'm having issues to import the data into Employees list. Instead of showing the employees names its showing a number with # in front of it. Could you please help me?
-
YTD Workaround?
I have an issue with the way Anaplan calculates YTD and need help figuring out a workaround. The YTD value in Anaplan includes the current week, which is NOT how I would like it or need it. i am in a weekly system and do not have actuals for the week I am in. So when comparing YTD Actuals against YTD Forecast it is always…
-
Trying to SUM revenue by account and product, getting datatype mapping error
I am trying to sum the revenue data in the "PY Account and Product Revenue" line item by account. Source and target module are both dimensioned by the same account>product combo list. I keep getting the same "Datatype mapping used for aggregation doesn't match any dimension of the result" error. Line item types are all…
-
How do i stop Summaries being sorted in a new UX grid
HI, i have a grid in the New Ux and i have data summarised by the Country in the hierarchy If i sort the data by Change the summaries get sorted amongst the data, and that is not useful. I want the summaries to remain at the top, and the other line items to be sorted. How would I do this please?
-
Shifting a Boolean line item
Hey, I am trying to make a boolean filter so you only see the columns with data plus x number of empty columns. So I have the Boolean Has Data? that is true if any line item has data. So, what I want to see is the Display? Boolean to be true for the next 2 numbered list items.
-
年がTrueの場合、QuarterもTrueとしたい
ラインアイテムが二つあり、 ひとつめのラインアイテムはTimeがYearで、1つの年にチェックが入っています。 二つ目のラインアイテムでTimeをQuarterとし、ひとつめのラインアイテムを参照してそのQuarterすべてがTrueとなるような式を作りたいです。 方法を教えてください。
-
Performance scenario analysis -IF early exist
Hi all , I am trying to make model not to (re)calculate in some scenarios a variable and (re)calculate only when a boolean is ticked . I did some performance scenarios analysis of calculations (counting seconds on new input ) using boolean and if statement and what i do not understand is why the calculation time after an…
-
L1 Model Building - Lesson 7 Data Mapping issue.
Hi Everyone, I am stuck at 7.2.3 Activity: Import Data into Employee Details Module. The instructions are not clear how to map E2 Employee# list ,which is a numbered list, to the .CSV file. There is Hint in the lesson which clearly says this: * HINT: The E2 Employees# list is a numbered list and each record is assigned a…
-
How to exclude a year while calculating the projection
I have a requirement where in i have to exclude the year 2020 while calculating the cy projection sales for 2024. Hence when i calculate, i choose a last 5 year period (2019-2023). However in this last 5 year period 2020 gets included. I need to calculate for all years excluding 2020. How do i do this? also for the last 5…
-
"Level Mismatch on Common Dimension" Error when Changing Parent of List
Originally we had A1 Expense Group, A2 Expense Category, and A3 Expense Account. We added A3 Subcategory and changed the naming of A3 Expense Account to A4 Expense Account. We have been unable to change the Parent of A4 Expense Account to be A3 Expense Subcategory. Attempting to change this gives the error "Level Mismatch…
-
changing dimension of a module once its created
I'm trying to add a column to an existing module in Anaplan, but I can't seem to find the option to do so. The only modifications I can make are to the lists, time scale, and version of the module. How can I add a new column to a module once it's already created? Any guidance would be appreciated!
-
Filter for selected native versions in saved view
Hi I would like to have a filter for native versions (i.e Current Forecast and Budget versions only) for an import view. I have set up a version system module where I can tick the boolean against the current forecast and budget version and use this filter but whenever I bulk copy current forecast to another version, the…
-
First Occurrence on module with multiple lists in "applies to"
Hello, Does anyone know if it's possible to do a firstoccurrence formula on a module with 2 lists in the 'applies to'? Thanks! Josh Brass
-
[Select: Time. All Periods] works for Model calendar and Time ranges
Hi All, [Select: Time. All Periods] works for Model calendar and Time ranges? Somehow, its working for Model Calendar but not for Time Ranges. Do we have any similar function for Time Ranges? Thanks AB
-
[Guide] Multi Level filter selection on composite hierarchy
If you are using a multi level composite hierarchy as your main reporting list (as you should vs ragged), you have encountered the need to filter it and display many levels of it in many different dashboards. Recently re-discovered a solution that I find quite handy and decided to share it here. Here's the result. As you…
-
Import is zeroing out a field that it shouldn't be
Hi team, Got one that for the life of me I cannot solve. I import the below file and the numbers load as intended. You can see the imported numbers below and the mapping from the import The trouble I run into is when I run a second import. looking at the data im importing, there is no line going to CC 3602 and GL 65566,…
-
SYS07 Distribution Center Details | Default Shipping empty
Hello everyone, I’m stuck because the column 'Default Shipping' in the Supply Chain Model is not populated after I run the import from SYS07 Location Details —> Import Distribution Center Details saved view (Data Hub Model). Can anyone help me please? Thank you
-
Datatype mapping used for aggregation doesn't match any dimension of the source?
I am trying to pulling billings from a calc modules, the source and target modules are both dimensioned by country but I keep getting this error. Note: I am trying to pull in billings from CALC02 which is sourced from CALC01. CALC01 is pulling from a flat data module. Please advise…
-
Ranking of Formula Performance
Is there any 1 place that does all the rankings of formulas in terms of performance? The formulas I am trying to rank are…. Moving sum, YTD sum, cummulate, and timesum. In ranking fastest to slowest, I would guess…. YTD Sum, Moving Sum, timesum, cummulate.
-
1.6.3.1 Create DAT04 Distribution Center Parameters Module
I don't find SKU flat list. What did I missed please
-
Creating General list from A module's line item
I have a module called Project. It has line item called "Project name". Project name line item contains only those projects which are approved (used formula to get these) My question is can we create an general list from the Project name line item, as i have to use this list as format to one of my screen. One possible…
-
Switch from Context Selector to Boolean - Scope of view
I'm trying to optimize a module for space. At current the module alone occupies 33 GB of space. The module is a cross dimension of 4 lists as seen in the picture above. with time month granularity. The idea is to reduce the dimension count to 3 by removing one list. The 9LE List shown in the applies to above. It has two…
-
L2 Conclusion | Create Shipping Export Module and Create a Saved View
Hello everyone, I'm stuck at this point. I entered all the formulas for the line items in the module but as you can see the shipping costs line item is zero value. Also in INV01 Module the shipping costs are zero and I can't understand why. Anyone who can help? Thank you very much.
-
End User unable to run action to update a subset
Hi All Have a super-user who is Full Access as model role but not a Workspace Admin and so therefore should be able to run updates to list subsets. Is there something in the depths of Anapedia that says that this isn't possible? I'm almost sure that we're doing this elsewhere in other models. Thanks Andrew