-
Current Date Update
Is there any other way that we can update the current date with out using cloud works, Anaplan connect, or any middle ware ETL tools. Through the anaplan system i need to update it not manually and not by uploading the excel file
-
Can I add in Cloudworks a Delete Process using Selection?
Hello, I want to do the dete function automaticly with Cloudworks. Can I do it with slelection? if Not, what options do I have? thanks
-
Filter / Drop Down Selection
Hey I´m trying to add a drop down selection to use as a filter on a grid I´m working on. The grid has data by client and each client has a zone as a atribiute, I wan to add the posibility to select a zone in the drop down selection and filter the clients based on the selected zone. Is this posible? I appriciate any help,…
-
Percentage Format issue on UX page
Description: I have a module with PV(dimension) Filters as dimension and I am displaying the Value line item on UX which is same as the Module dimension. But the Value line item is getting the data from other line item Actual vs Scenario 1 % which has ss_Actual vs Scenario 1% (dimension) - Which is a subset of PV filters…
-
Text to quarter ?
Hello Everyone, what is the best formula that we can use to go from this to this: Txt Period "Format Text" (Example: Q1 FY24) ===> Quarter "Format Quarter" (Example: Q1 FY24)
-
Show the code instead of the display name in dropdown list
Hello My client does not want to have any display name, just the # generated by anaplan. In the same time, it is very complicated to choose an item in a dropdown list seeing only #s. Is there a method for me to show code of the numbered list ( which is existant ) instead of the #? Thanks
-
Searching for community members-- functionality removed?
There used to be the ability to search for a name and find community members. Was this moved to another area? If it was removed, why? This helped to facilitate hiring, validations of certifications and more. You can still see someone's profile if you know their username or click through a link on an idea exchange. Please…
-
Tableau to Anaplan integration
Hi team, Could you please help me with best possible way to export data from Tableau and load it in Anaplan by writing script or something. Regards, Venkatesh
-
Conditional Formatting on User Access (Roles -> Modules)
The current interface for setting role access to module is difficult to read visually - if a model has many modules it can be difficult to spot if read and write access for roles has or hasn't been set up, or varies between modules/roles: Would it be possible to add default conditional formatting to the system that…
-
Report/Board: Table Row and Column Height
There are four options for row height in a table output in the Report Designer/Board Designer. Even with the "default/standard" option, there is significant white space between rows. It would be helpful to have a "narrow" height option for table rows, or similar to my request around fonts, and adjustable row height based…
-
Do you feel it will be good to have Supply Chain related functions ?
Since Supply chain use cases are picking up, do you feel it will be good to have supply chain specific functions in Anaplan. If yes, then kindly promote the new idea I posted.
-
Facing error in line item name referring in formula
Hi Community, We have been working on copied model and trying to replicate the same line items and formulas as well wherein we are facing an error wherein it is reflecting Line item is not identified line item or list member. Example line item name: Historic range? when we refer this name in formula we are facing error…
-
Idea for a session: Anaplan Support
Hi all, I have got an idea. What if we organize a meeting with Anaplan Support team representatives so they can share their experience of dealing with Anaplan users and modelers and we could share our feedback? Please share your thoughts. I can help to lead this @becky.leung
-
For a beginner, need guidance, and a Anaplan workspace
Dear All, I am new to Anaplan, and want to learn it, self paced. As I was venturing more into it, I realized that I need a Anaplan workspace. And then, I reached out to Talent Builder Program, which I now see is on hold. Can anyone please guide me?
-
Level 2: Model Builder - 3.3.5.2 Inventory Ordering Module Formulas
Hi everyone, I am not getting the results as expected. Does anyone of you know where my mistake is? for the first Row "Beginning Inventory" I am only getting values for Week 1. For row "Shipping Time Weeks" I am getting 0 as the result. But expected is the value 4 (for Week 1). Here are my formulas: Thank you. KR Tobi
-
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
-
link text-formatted line item
Hi All, I have a question from a partner.., Can you please confirm that it is not possible to link to a file destination in Anaplan using a link text-formatted line item. The link text-formatted line-item defaults to http// and the file destination our client uses has a different prefix using backslashes (\\). The links…
-
Query on Efficient List Creation Method
I'm seeking advice on the quickest method for creating lists in Anaplan: using the UX Page "Form action" or the backend Actions for Creating List Item. Which approach is more efficient?
-
anaplan level 2 sprint 1 activity 1.5.6.1
Hi all, I have problem while importing data into Historic Volumes Module. The csv source file contains data (image 1), but when I run importing into modules (image2&3), there's no data at all (image 4). What should I do to fix this problem? And by the way, I do not get why we select "Column Headers" for "Volumes". I got…
-
L3 Sprint 2 User story
Hi Everyone, I am in L3 in lesson 4.4 as per below screenshot. I have used the same csv file to import the data in Data Hub model and created the list G4Territroy>Accounts# and pushed it into spoke model (Sales Planning model). Just need one confirmation as per below SS it mentions we have to import into Sales Planning…
-
How to reduce huge dimensions
Hello, I'm having a lot of issues with workspace size, with models going above 150/200gb in size and I'm not sure how to reduce it, to give some context, I have three main lists (size considering subtotals): Products (~1,5k) Countries (>100) Customers (>270) The issue is that if we apply all of them to a module what we get…
-
Mapping modules dimensioned differently
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?
-
How to set automatic refresh when filter is updated to new value
Hi All, As I was building the UX Pages and came across on roadblock wherein each time when I change country and segment in field card I had to refresh the page again to get new country and segment values. Please requesting for inputs on how to set automatic refresh when I change the filter to new country and segment Below…
-
Adding specific number to imported data
What's the best possible way of adding '0's to imported data? Eg: Data > Required Data 156 > 00156 23 > 00023 62797 > 62797 0 > 00000
-
L3 Sprint 2 building the list: G4 Territory > Account#
Hi Community, I started L3 wherein we have to build G4 Territory > Account# list in Sales Planning model I followed below steps as per training Firstly, loaded the Download: Territory Data.csv into Data Hub model into Territory Flat List system and built system module below is the image attached of both list and sys module…
-
Adding instructions to Line items
Hi Community, Curios to learn on how to add instructions to line items of module on UX Page. Kindly requesting for your inputs on how to setup on UX. Please refer to below screenshot for more information
-
Unable to onboard whole data into Anaplan
Unable to onboard whole data into Anaplan Source data: Translate business process into Anaplan components Expected Result: Translate business process into Anaplan components Onboarded data into Anaplan: Translate business process Please guide me!!
-
How to Delete a column data if data is imported action
Hi Community, Requesting for your inputs wherein, I need to delete a column data wherein to create a empty staging module which in turn will be used a import action to main module in L3. Requirement : to delete Override Sales Target column data Below is the attached screenshot for more reference Thanks.
-
Anaplan API Python Connection
Anyone has tried to do a Anaplan API Python connection? I have an idea that I want to build scenarios in the magnitude of 100,000s. This will not be possible if we are using the inbuilt version page. My idea is to store the parameters of the 100,000 scenarios in cloud (for example azure) and run it in Anaplan and output it…
-
Anaplan Last year values Summary(Formula)
I have two modules A, B. Module A has time ranges of Week, Month, Quarter, Year. Module B has time ranges of Month, Quarter, Year. What would be the best practice to get last year values from module A to Module B and have them reflected for Month, Quarter, Year? (I tried OFFSET, POST, but got error while changing summary…