-
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…
-
L3 User Story 2.4
Hi Community, In L3 User Story 2.4 requires the comments to be seen by others. Who should see the comments? That Country Sales Manager's ? and do we have to create a link or add an line item for comments associating with all accounts and then publish it do UX so end user can add comments along side of the accounts…
-
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 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…
-
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!!
-
Driver Line Item for Action Button
I have condition in card where user can input negative value. But when the value is negative, the button will disable to click. I have data Product as Context Selector, Time Period Month in Column, and Line Item to input Order Quantity Review in Row. User will input number of order quantity review, but when the value is…
-
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.
-
Formula to return the latest date and hour
Hello, I have a list with exports date and hours and minutes. I need a formula that will allow me to show on the UX, the latest date with hours and minutes. Is there such a formula? 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…
-
Referencing a line item that has formula summary method, not displaying correct number
Hello, In the example image, I am referencing a line item "TV Programming (Final)" in another module using an If statement IF XXXX THEN XXXX.'TV Programming (Final)' ELSE 0 However, it isn't pulling 4,063,964,538 as expected. I know its an issue with the summary method being set to formula because other line items are…
-
Time Dimension & Value not adding correct
I have a model which has the time dimension (in days) and line items which are date formatted. I'm trying to create a chart which correctly replicated the progress of time change but for some reason any value is not mapping to the x axis of the chart. I have attached a picture for better understanding. In the picture you…
-
Supply Chain Related Functions
Just like we have functions for Financial (COUPDAYBS, COUPDAYSNC, etc) and Call Center Planning (AGENTS,ANSWERTIME, ARRIVALRATE) can we have something similar to support Supply Chain Planning? Like End of Stock, Beginning Inventory, etc based on input parameters?
-
App has some pages unable to change model due to archive
Hi team, I have made a copy of a model and app and am attempting to change the source model from within the app. For some reason, every page is set to the same workspace and model, but 90% of the pages are saying the model is archived so I cannot update the source model. I have checked the original app and model and it has…
-
Need to know if we can take out some GB from 1 workspace and put that space into different workspace
Hi, I have a question where I want to split out like 30 GB from one of my workspace and put that 30 GB into different workspace. Current Situation Workspace 1= 130 GB Workspace 2= 300 GB Required Situation Workspace 1 = 160 GB Workspace 2= 270 GB If its possible how can we do this. Thanks
-
Minesweeper: How we Built it?
Do you remember the good old days when we used to play games like Solitaire, Minesweeper, Pin Ball, Checkers, etc in your big and bulgy desktop? Oh! Those were the golden times of youth, even though we cannot match the high-end technological development in graphics, storyline, real life game play, regular updates but the…
-
Anaplan Reporting Page: How can we keep line item filter for hierarchy filter selection?
i have made a line item filter with formula= RANK('ROTD - 3M', DESCENDING, SEQUENTIAL, TRUE, 'text l4 n 3lag') which gives me as shown in pic - 2. the second line item filter with formula = RANK('ROTD - 3M', DESCENDING, SEQUENTIAL, TRUE, 'Lag 3') which is the 4 line item in from the pic above. 3. Now in reporting page when…
-
Formulating and capturing the no of orders count based on orders placed between time scale.
Hello Community, Process explanation based on below screenshot is basically on the left part we have module in which time is recorded for the orders placed and we need to gather and capture the count or no. of orders placed between the time series. EX: Orders between 14-15 PM is placed at 14.30 PM and 14.45 PM we need to…
-
Export with different dimensions
Hello, I am trying to make an export. In my Export, I need to show on a column category Int and category Ext (both on same column). The problem that I have is that the domensions that I need to use for this information are in the Children of my dimension. Let me make a scheme; Dimension A - the one I have to use Dimension…
-
Action for Deleting an empty row in UX after running the process
Hello community, I have been working on creation of the group wherein employees roll up to a particular super group below are the 2 Screenshot in detail. Current Process: Below is when enter all the details and click on action called "Create Super Group" the new employee with its Super Group code is added to the below Grid…
-
UX Page action button and Grid Data
Hello community, I have been working on creation of the group wherein employees roll up to a particular super group below are the 2 Screenshot in detail. Current Process: Below is when enter all the details and click on action called "Create Super Group" the new employee with its Super Group code is added to the below Grid…
-
Get inspired — Community Bosses share their 2024 goals!
It’s the first week of the new year, and if you’re not yet in goal-setting mode, we’re here to inspire you with a few ideas from our Anaplan Community Bosses! We asked a few of our Bosses to share their perspective on any or all of the following questions: What are your Anaplan-related goals for 2024? What do you hope to…
-
"Reset" on UX Page
When a user clicks on the reset button, the ux page should reset any sort, filters, or pivots that are directly applied to a grid.
-
Is it easier to find a job after finishing model builder certificate ?
Hello Everyone I have been searching for a job for quite some time, and I came across anaplan and started learning it. Since I am switching my career from accounting and trying to find a job in operations, project management etc, I feel Anaplan can help in find the job easily with this skill set. I just wanted to ask this…