-
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
-
Sum based on Boolean
Hello, Hopefully a simple one. Our P&L has 50 cost centres, each of which have staff costs assigned. In a separate module I want to bring in the staff costs from 15 of these - is there a simple way to do this, for instance by having a separate module with the cost centres included and a boolean line item to determine which…
-
Use of PREVIOUS function
I'm sure I've used the "PREVIOUS" function before without any problems but on trying to use recently it doesn't now seem to be returning the values I would expect As you can see the formula Previous(Volume) is specified, which I would have expected it to return the FY23 volume value of 218,116; however, this doesn't seem…
-
Set up custom time scale
Hi My current model is using a fiscal calendar e.g. FY23: 1 Jul 2022 – 30 Jun 2023. However, I have a specific use case, where I need to build a module that uses a calendar year e.g. FY23: 1 Jan 2022 – 31 Dec 2022. Is there a way to resolve this use case? Based on current research, I would need to create a fake time…
-
export Anaplan data decimals precision to PowerBI
Hi Anaplan Community, I am trying to export data from Anaplan into Power BI using the Anaplan Connector. I manage to get my values into PBI, however, I miss the decimals precision which I see in Anaplan. Example: in Anaplan my number format is set to show 3 decimal places, so 594.450 (US notation), five hundred ninety four…