-
Filters on the IMPORTS - Source Object and Target Object columns
Trying to find a source or target for an import is a long process as you cannot filter them. Currently we copy and paste all the imports to excel, then filter then go back and search for the import action. Very tedious Just need a filter on the Imports page, so we can select a target list and see all imports into it..…
-
Horizontal scrollbar does not work when freeze columns (1-15) or more.
When freeze columns (1-10), horizontal scrollbar works well. However, when freeze more columns such as (1-15) or (1-20), it does not work as above picture.
-
Rename/Delete/Change Parent/Insert options on grid from additional insight
Currently, these additional features are available only on the main grid within worksheet page. Since we can also set another card from additional insights, to be opened by default, can we enable similar options on this additional grid card as well - to be able to rename a list item, delete the item, change its parent, or…
-
OEG Best Practice: Line item subsets demystified
Line item subsets are one of the most powerful and efficient features in Anaplan, yet one of the least understood. The COLLECT() function is probably the only “black box” function within Anaplan as is it not immediately apparent what it is doing or where the source values are coming from. In the following article, I will…
-
Customizable date display format
It would be great if we could customize the date display format by line item such as with DD MMM or DD MMM YY, to present a view to the users that is easily interpreted, especially if it is a number heavy report. Currently we do it with workarounds using custom lists and mapping to the dates, however, it does add…
-
Why is my data not showing up for SYS08 SKU Details Module?
-
Anaplan Connect: Wake-Up Script
Preface: Utilizing CA Certificates is the best practice for Anaplan Data Integrations. The wake-up script is best leveraged with CA Certificate authentication in the individual scripts for security purposes. If you would like to learn more about CA Certificates, click on this guide. Note: Basic Authentication used for demo…
-
get inventory per country per sku
I have an Invenotry ordering module where i have beginnening inventory, i want to get the inventory in a new moudule by country and by country and sku both i have a sku details module which has country made in as lst item and sku as a dimension i tried using this formula but got no data 'INV01 Inventory Ordering'.Beginning…
-
Level 1 Lesson 7.2.3 - Why is Department grayed out?
There is no way for me to map Dept Code to Department as Department in the Target Items is grayed out. Anybody knows why this is the case?
-
Create Shipping Export Module and Create a Saved View
In Level 2 Model Building : Conclusion, there's an 'Activity: Prepare Data Exports' that tell us to Create Shipping Export Module and Create a Saved View. I've made the formula and choose the format and summary method but I'm not sure if it was right. Here is the blueprint of my INV05 And here is the screenshot of the…
-
Ability to access multiple tenants with Power BI Connector
Currently with the Power BI Connector you can only access your default tenant but would like the ability to access multiple tenants during log in.
-
7 Inspiring Books: Anaplan Community Reading List
Tomorrow is World Book Day—a day to celebrate the power of a good book and the impact it can have on our lives! A book that uplifts, excites, and changes us is also a book that we inevitably want to share with others. So, in recognition of this global event, we asked Anaplan leadership to share titles that have affected…
-
Please add filters to the IMPORT actions columns.
Trying to find a source or target in a list of 500+ imports is quite a time consuming process. Adding a filter or a sort to the columns would be such a big improvement I used to copy and paste the import actions into excel, but now it seems you have changed the format of the table and this is no longer possible, so now…
-
Instructions on how to develop a Model Schema
Hi there, Can someone please provide step by step instructions on how to develop a Model Schema per project (DISCO base). Thanks in advance, Siva.
-
August 2024 Community Member Spotlight: Timmy Thomas
This month, we are excited to feature @TimothyThomas as our Community Member Spotlight! Timmy has been a vital part of the Anaplan ecosystem for the past four years, bringing his expertise and passion as a Certified Solutions Architect and Community Boss. With over 125 comments in Community, Timmy is known for his…
-
Getting the total from another Module
Hi everyone i have a module [Employee Details] where i can filter the team center. for the below sample, i chose the Financial System which has 2 employees. whenever i choose Team Center, the amount will be selected in [Sum Selected] column. in my Testing 1 module, the only Total would reflect must be Financial System. but…
-
3.3.5.6 Update Inventory Ordering to Calculate Shipping Costs
I'm stuck trying to get the final shipping cost line item and shipping cost variance. Someone please help!
-
Data Quality Orchestration : a simple example with ADO & Workflow - Part 2/2
In this article, you'll find a simple but hopefully inspiring illustration of the power of Anaplan Data Orchestrator (ADO) combined with Workflow. This is a 2 parts article. The Part 1 focuses on the Workflow and the steps to achieve Data Quality tasks. This Part 2 is a deep dive on some details. Above is the final Object…
-
Certified Master Anaplanner Exam
Certifications offer a way to prove your skills. When you want to be recognized for achieving the highest level of skill, that of a Certified Master Anaplanner, you want to be sure the testing process is secure and that all applicants are treated fairly. To achieve that end, we have partnered with Kryterion Global Testing…
-
Formula change in Opening and Closing line items.
Hi Team, I needed small help to optimize the formula from Half-Year to Full-year. Current working System: If Jan 2021 (Budget) H1 Opening HC we were referring to Closing HC of Dec 2020(Actual) and IF July 2021(H2) we were referring to Jun 2021(Actual) Proposed System: If Jan 2021 (Budget) H1 Opening HC we were referring to…
-
How to have same function as Excel (Index Match)
3.3.5.2B Shipping Line Items Shipping Method: Show the standard shipping method for the SKU. Shipping Time Weeks: Show the shipping time associated with the shipping method. What formula can show the distribution center is Paris when beginning inventory is more than 1.
-
Find common text between another modules without List
Hi, I want to find common text between another modules. I have two modules A&B. Each module has order Number and Product(Text format) I want to find Product(ModuleB) in ModuleA. It's Common Text. In this case, we can find product by finditem formula, by making product List. But I don't want to use product List, because it…
-
NUX Line Item 'Style' Options
Currently the Anaplan NUX lacks options for line item 'Style' that are in the classic UI. Short-term need: As a minimum viable product customers are requesting these same options in the NUX. Examples include, bolding, italics, underlining, indentation etc. Full feature: In addition to the classic options, a full spectrum…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Can you please help me solve this. My output is as the below: The actual output needs to be as the below:
-
How to tackle duplication import into numbered list with list formatted properties ?
When importing into the list having properties as list formatted it create new list item with every import even if unique identifier already exists While importing transactional data into a List (Numbered List) which has properties Country formatted as Country, Year formatted as Year and Amount formatted as Number. In…
-
Displaying Line Item Based on Date Range
i have a module where i have line items such as client number, agent name, start date, end date and months between end and start date now i have another module where i am using client number as an dimension also time(months) and agent as line item now i want to display the agent name from the first module to this module…
-
Issue with Ascii characters in Anaplan
I’ve encountered an issue while importing data into Anaplan where certain special characters, specifically ASCII characters like ü, ä did not show properly, it showed as question mark Instead of importing these characters correctly, the data gets corrupted or replaced with incorrect symbols. As shown below, Although it was…
-
anaplan api 401 Not Authorized using Postman
Using Postman: I can use Post and get an authorization token, but when I create the Get with Authorization = AnaplanAuthToken <token from Post> Content-type=application/json Basic Authentication and workspace ID and Model Id in URL https://api.anaplan.com/2/0/workspaces/<workspace id>/models/<model id> I get: { "status": {…
-
1.4.5.2 Import from Saved View
Can anyone help me with the mapping of this?
-
Importing Values to Booleans via Model to Model
Hello, I hope you are all doing well and good. I would like to ask about a challenge that I'm currently experiencing. Situation is, I need to create an action, just a simple action that will be published to the NUX. This will be an Import action within the same module via a Saved View. Please refer to the encircled line…