Modeling

Publish Line Item as Page Selector to Dashboard
Hi team, Are you able to publish a Line Item from a module to a Dashboard as a Page selector that will act in the same manner as the dimensions published? e.g. the line item will change with the line item selected? Each time I attempt to 'Publish the Selected Line Items to Dashboard' the value of the line item is…
INVO1 SHIPPING TIME(WEEKS)
Hi, I am getting an error putting this formula to the shipping time(weeks). 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product,LOOKUP:'SYS07 Distribution Center Details'.Default Shipping] error:Dimension of mapping used for lookup doesn't match any dimension of the result can…
3.5.4.2 Activity - Beginning Inventory Figures
The beginning inventory in this exercise seems off. I even checked other comments on the board and I have followed what I could. the second screenshot shows the set up for the INV01 Module for the beginning inventory line item. The formula is correct. but maybe something to do with the summary set up ?
Remove ability to edit Formula column on Line Items in Blueprint Mode
I've always been told as best practice to not edit formulas for line items directly in the formula column of blueprint view, instead to click on the line item and then activate the formula bar on the top of the page. However, we recently had a new model builder, who had not yet heard about this best practice, copy and…
Closing/Opening Balance Summary Method for Booleans
Simple request, please can closing balance and opening balance time summaries be made available to boolean formatted line items.
Combing 2 input values under one column
Hi, I would like to add up the 2 input values from "Sales" and "Marketing" into the new column called "Sales and Marketing". The reason is because there has been a change in the categories of business and the previously separated "Sales" and "Marketing" are now combined as one single category "Sales and Marketing". Is…
Time
Hi good day1 How can I make this as a row in a module? Because when I use time as a dimension, it aggregates the same date. Thank you.
Model to Model transfer action not working for full access user
Hi, I have created an import action from Model A to Model B and both are in same worksapce. Please see the below details of Model A & B. Model A: It is source model for an import action. I have used saved view for a module which is having User List as a dimension and with few line items. One line item is having their…
Copying Same Data Line Item to other Formulated Line Item
Dear All, I have a scenario as follows : I have a Module with SKU, Company as dimensions. Sales Volume is an input. List Items in Company are GST, TMB, BCC. Now, I want the data in line items to be copied to the company as follows: The output module should contain the input value as well as the copied data value. Thanks,…
Not able to rename Default Organization List
I was going through the training module and it says we can rename Organization List by double click on that, but I am double click is not resulting anything. How can I rename it.
Updating the data in Anaplan
Hi All, We are facing a challenge in Anaplan where user edits some data in anaplan but after some time there is a scenario that user might want to revert the changes back. Currently we are driving it will a boolean which user will confirm to update a row post that user will run an action which will populate the form which…
Create a report view based on its criteria
Hi Everyone, I have a question on how to do a linkage between 3 modules (Source Module, Mapping and Target) The image below is my mapping, basically, each Lane is connected to each Slottage Type based on each column. eg: if a lane is AA1AO "SC In - Consortium" should appear in the line item "Chartered In Exp - Initial…
Anaplan Documentation
Hi All, Please let me know if there is any documentation available to download as PDF or Word file. Thanks, Mahesh
Collect() function results zero values - why?
Hello, I used collect() function to take data from the source module. I created LISS from the source module and then used as dimension in the target module. The dimension are the same in the both module, unfortunately I see zero values after using collect(). Can you help me understand why? Thank you. Best regards, Dominika
MAX MIN based on Multiple dimension
Hi All, i was trying to find out Max and Min Salaries based on Country, Legal entity and Department. I tried using the Max function based on all three dimension but gave a output value as infinity. Is there any way the output can be achieved?
Import user list with a button, dev model vs Production model
Hello Everyone, I have a production and development models. But I can't import users with a csv file in the deployed model (but I can add manually users one by one...) , so I wanted to create a action with a button in a dashboard in the dev model, so I created the action. But contrary to a standard import, with this button…
4.6.4
Hello! For some reason the downloaded data file "countries.csv" will not populate into my module. Please advise. Thank you!!
Help! Activity 8.8.4
I am currently stuck on Activity 8.8.4. I have definitely entered formulas multiple times, but I am getting an error when trying to copy and paste the formula. I have entered it manually the way it was shown on the video as well. Any suggestions? I have included screenshots.
How to set up time filtered chart to automatically update when model time period extends?
We have several dashboards with ~30 charts all have time on the x-axis and a dynamic time filter on (trailing 13 months). The time filter is set up following the recommended steps by many users (set boolean for all time periods as "TRUE" > publish the charts > apply filter logic). However, the time periods for these charts…
Post transaction after 2 working days
Hi Community, I need a help to post transaction after 2 working days. I have a daily collection amount as a line item in a input module. I want to post these daily collection amount in a calculation module after two working days. For e.g. Monday, 1 March 2021 collection amount will be posted on Wednesday, 3 March 2021 and…
Handling dummy levels in a Composite Hierarchy
Hi Community! I have a quite large organization hierarchy (12 levels) that I´ve converted from ragged to balanced. The original hierarchy has profit centers in every level, starting from level 4. So this means that I have had to create a lot of dummy levels to balance out the hierarchy. Example: Hierarchy…
3.3.6 Activity: Test the Shipping Cost Formulas
Hi, I am trying to update the confirm purchase order receipt formula with a POST function. I believe I am again, not understanding the intuition behind this. can you please guide me in the right direction? IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, 1) ELSE 0
Level 1 - Lesson 13.6.5 - modify graph in UX
Hello, I am practising lesson 13.6.5 to have the forecast margin in the chart. Would someone please advise how do I get rid off the full year total? And how do I add a label in the Y axis please? Many thanks Rachael
Level 2 Sprint 3.3.5.3
Hi, Why is the Suggested Order Amount for the Month line item be off by 2?
Ranges/allowable values for number input
It would be handy to restrict a number format. This will save additional validation checks/visualizations. e.g: - Number needs to be positive - Number should be an integer -The number should be within the range of 0-10 This is like a dependent drop-down list, however now restricting the number formatted input.
Data format change from List to Text
Hi We have two columns in a General list ,i.e SKU Config Group and Config Group. The SKU Config Group is having format type of List and the Config Group is in text format. Our requirment is to copy the value from SKU Config Group column into Config Group. The reason being there are formulas already buit in the modules…
SUM by Quarter
I want to sum the milestone values by each quarter in a different module(Line item). NOTE: Quarter period(Line item format)in Quarter line item is from time scale and not model calendar. Source Module has three dimensions: Target module where sum of milestone values need to be calculated has two dimensions: NOTE: Neither…
2.4.6.1 Create AD01 P3 by Account by Week Module
Is this correct? I followed the directions and wrote the formula into the AD01 P3 module as indicated (screenshot below). However, I am not getting the square check boxes in the DEM03 Demand Forecast module. I did a select the correct item under the write access driver column within the DEM03 Demand Forecast module
Convert Text to Date Time format
Hi All, I have a simple one to ask. Source system is sending a date value which contains both date and time and it is storing in Anaplan Text line item in a module. Need to convert this text to date format and post this need to convert it again into IST or other time zone format. Kindly help here. Example: Source date…
Level 2 - 2.3.8.4 Activity
I used the following formula to return the monthly value to weeks; MONTHVALUE('DEM01 Volume Growth Rates'.Growth %). I would have assumed that the monthly figure would be divided by 4 for each of the weeks. However, it is reflecting the same monthly value across all of the weeks. Maybe i'm missing the intuition behind…

Modeling

Discussion List