Modeling

Using Python results in Anaplan
Hi All, We are trying to build a model which would contain forecasting results flowing from Python. Please direct me to the best learning material from where I can work on this integration of Python / R with Anaplan Thanks and regards, Aishwarya
Introduction to Modeling UX Headcount
Hi, I'm working on the UX section of the introduction to modeling, and I cannot get the headcount module to populate with data when it's on the dashboard. Interestingly, there's data in the module itself and when I publish other modules to the dashboard they also show data. What could I be doing wrong? Thanks for your help…
Refresh of the list not happening after 'Delete List Item Action' on Dashboard
Hi I have a list which has records I published it to the dashboard as a page selector on the dashboard. I created a delete action to delete an item in the list based on drop down selection. Now after making delete selection in the delete Record and clicking the 'Delete the record' button. After the action has been run it…
formula
I have the problem .. i have a list on left and i have the formula like the picture .. half the list using formula and half again using formula but null value . how work for the problem?
Introduction to model building UX Dashboard Not Populating with Data
Hi, I'm working on the UX section of the introduction to modeling, and I cannot get the headcount module to populate with data when it's on the dashboard. Interestingly, there's data in the module itself and when I publish other modules to the dashboard they also show data. What could I be doing wrong? Thanks for your help…
Average of Daily Data
I am building a new model and have daily data. Our data is only for weekdays though. So when I use the average Sum method Anaplan averages in a zero for Saturday and Sunday which is obviously not what is required. Seems like there should be an option in Model Settings/Time to allow me to define what a week is but there is…
Capture logged in user name automatically?
Hi Every one, Just curious to know is there anyway that I can capture logged in users name in a lineitem by a formula ? Thanks, Dileepkumar
Invalid Parent While Importing in List
Hi, I am trying to import a product list which is a numbered list form another model say ICM. But while trying to import it,it shows the invalid parent entry.However the list is getting rolledup to the correct parent. Screenshot attached.
Line Item Format from module
It would be useful to see attributes of a line item without having to revert to the blueprint view I often build formulas in the normal view because I can see the results immediately. It would improve efficiency if I could see the list format, for example, without opening the blueprint view Maybe through a hover over or…
Filtering only summary items
Hi, I have a list that is used as rows in a module and the list has a parent hierarchy. I would like to filter out only the summary items when publishing to a dashboard, but can't seem to find a way to do that. What I tried to do is just set a value of 1 for the list items and then filter everything that's greater than 1,…
List
* I want to ask about List. i want to take code on Account L0 Flat List to Account L0 . Account L0 FLat is list format .. *
FINDITEM formula
Hi all, I have a list named "TAT Hours" and a line item "TOTAL HOURS" that is in number format. I used FINDITEM formula to get the number of hours (TAT Hours) in the list, here is the formula: FINDITEM(TAT Hours, TEXT(IF TOTAL HOURS <= VALUE(NAME(TAT Type.Min Hours[LOOKUP: 'TAT Type1'])) THEN VALUE(NAME(TAT Type.Min…
Optimizer Overview - Not Showing Correct/Optimized Results
Hi, I have a simple LP problem where in I need to check how many Units of Big Products and Small Products can I make in order to maximize my profits keeping constraints in mind. Objective : Units to Make for Big and Small Products Inputs: 1. Manpower for Big is 6 Hours and for Small it is 9 hours 2. Raw Materials is 1 Bag…
Line Item Subset for Text Formatted line item
Is there a workaround for selecting a non-number line item in a Line item Subset? I've created a filter for increasing and decreasing the number of lines shown in a dashboard table using David Smith's outline in this…
Select internal Source
When creating a new import, it would be useful to be able to specific the internal model at the outset, rather than having to wait for all potential models to be returned. Very often internal module views are used and it's frustrating to have to wait. the current model is the default anyway
Counting Multiple Countries Per Region
I have a module that needs to tell me whether a customer is present in more than one country in each region. For example, Customer A is only present in United States under AM region. This means that it is not an inter-region customer in AM. But in EU region, it is present in United Kingdom and Italy, so it is an…
Intermediate Model Building (OnDemand)
Am doing activity 20 scenario selection.How do i make the selection dynamic.this is how i mapped it.
Intermediate Model Building (OnDemand)
When i test for Brad Bonson i get CRE as well but looks like am only supposed to get CAE.Cannot figure out where i messed.
Section 12, Activity 17 - Ramp Line Item
Why is ramp format a number and not percentage?Am trying to appreciate the formula and output on this line item.
Filter and drill down in lists
As a model builder, it would be really useful the option to use filters in the properties of a list, as well as having the option of drill down in lists.
how to resize 'Published selected items to dashboard'
Hi, I published line item to a dashboard as page selectors using 'Publish selected items to dashboard' But I am unable to align the published line items. Now if you see Effective Commission Rate is appearing in 3 lines, but I want it in only one line. How do I do that? Thanks, Vamshidhar Reddy
Version formula
i'm using three versions in my module, here Actual, Forecast, Budget. i have the actual and budget data available and they can be manual entry data. Forecast data should be formula given. Actual Budget Forecast Jan Forecast Feb ---- until Forecast Dec Thank you,
Version Formulas
i have a question, on my project i have many versions such as Actual, Budget, and Forecast(Jan-Dec) . on Actual and Budget version will input by user but for Forecast this will retrieve data from another forecast module version? how is it done?
Abnormal increase in size and performance reduction due to multiple Versions
Hi All, I am currently seeing dramatic increase in size of the model probably due to the usage of the version. Due to the problem I am trying to solve I require many versions (upto 100). This leads to the model size increasing 10 times as fast as using other normal lists as dimensions. for example my mode has 17Mn cells…
102 Certification Employee Costs: Salary VS Gross Pay
Hi, I am doing 102 Cert for Employee Costs. Did anyone have any idea the different between salary ans gross pay? We cannot find any info on gross pay. Thanks!
Use SUM Rules Dimensioned by Users for Source Data not Dimensioned by Users
I recently posted a question on the forums in relation to a workaround for a bug in the LOOKUP formula. I wholeheartedly feel like the LOOKUP bug (where it doesn't work for parent items that are in the same list as the leaf-level members) should be fixed. And I recognize that there are some workarounds available (as…
Formulas
What is different about LOOKUP and SUM?
Rankcumulate till previous Rank
Hi All, In simple terms I want to know the total till the previous rank complicated by the fact that the last number depends on the rankcumulate till previous rank. Hence this is giving rise to Circular references. Let me give an example (see attached) * I have sales volume of SKU by date dimension ( though this data is…
FORMULA
HI Experts, We have line items Line item:1 : FCST_1 Line item:2 : FCST_2 based on FCST_1 convert into Rounded value. Both line items are text format. First item data in dot(".") format but we need to convert comma(",") And we need round off the FCST_1 line item. For suppose FCST_1 = 1.2498 then by using some formula we…
module with booleans based on user list & Selective Access
A system automatically generated 3 dimensional module (1-users, 2-hierarchy w/Selective Access, 3-LineItems) that contains booleans based on selective access user assignments. This would be helpful in creating views where a user is assigned write access to parent A and write access to a subset of children in a Parent B.

Modeling

Discussion List