About MarkWarren

I've not heard of any issues recently, try asking our Support Team at support@anaplan.com ... View more

We can do that in a similar way using our newly created max value. I put this together to demo it better: In the source we find the data value that matches the max (from target module) and for that value show the month period; this line item needs first non-blank summary type. Note here that if second product had the same max value we'd show the month from the first product. Here's the data: and the result:   ... View more

What is the select in Funding Dayification Totals? (You should just put that formula in Funding Dayification Daily, no need to "daisy chain" it.) It looks like you recreate the value of D04 Total Funding on C06b, and just copying it across Days. ... View more

As far as I know it is working (see screenshot) There were some SSO issues in the past but the product team  released a fix/change around September 2021.  ... View more

Appreciate you closing the loop on this @aakash! ... View more

1 approach is to simply remake that line item in a separate module with the desired dimensions. This will eliminate the subsidiary view and maintain better user experience. Regarding your question about list dimension - if you add it as a dimension to the module it would add that many number of cells. If you don't need it, consider storing the line item in a separate module. Here is a Planual principle related to this: https://community.anaplan.com/t5/Chapter-2/2-01-06-Avoid-Using-Subsidiary-Views/ta-p/76835 ... View more

Hello @hollernaffirm,   Hope you are doing well. I had a chance to review this thread and tried this in my own scratch model.   I wanted to try to understand why your solution worked - here are my takeaways. I have included screenshots if anyone wants to reproduce.   1. Here is how I setup my time settings.                    2. Here is my Version settings. Notice the switchover set to Jun 22. 3. Here is how the module visually appears with switchover enabled. Notice that the numbers from Actuals are feeding into the Forecast up until the Switchover month of Jun 22. Everything prior to Jun 22 is greyed out and not editable.   4. I created some dummy source data. 5. If I try to load this source data, only data from Jun 22 onwards will be updated as everything prior is not editable due to Switchover. Here are my results. Notice the Forecast line has updated after Jun 22. 6. Now if I turn off Switchover, notice how everything becomes editable.    7. After I run the import again, notice how all forecast data gets updated.   I hope this provides a comparison into the behavior with switchover on and off. The reasoning for why your load was not working with switchover on is because the cells become uneditable prior to the Switchover month. There are several use cases for why you would want switchover turned on as if there is Actuals data present, there may not be a need to have a forecast.    If we think about this from a business standpoint, I will echo some of Mark Warren's questions from above. Some things to think about:    1) Why are there versions enabled on a module with only Data?  2) Is there a need for the Actuals and Forecast data to be different prior to the switchover period if you want versions enabled?    Hope this helps provide an explanation and point you in the right direction. ... View more

To optimize Filter transformations, use simple integer or true/false expressions in the filter condition. The Filter transformation filters data within a mapping. The Filter transformation filters rows from any type of source. The customized data object filters rows from relational sources. My CC Pay ... View more

Hi Mark Thanks for your response. Please email to me the date and help me to enroll. I am very much interested to learn Anaplan.   Thanks Kazi ... View more

Export names can't be dynamic in Anaplan, but you can create the export in Anplan and then export via an API or Anaplan Connect and name the file whatever you want. You could create a script that pulls information from Anaplan via the Transactional API and uses it for the export name via the Bulk API. Data integrations - Anaplan Technical Documentation ... View more

You could use AVERAGE or MAX (or MIN) in this case, where all the child values are the same. ... View more

@khoonks : The purpose of FINDITEM function is to transform a text into a list element. It is up to the model builder what TEXT to use as a parameter in the FINDITEM function.    If on the same row of your data, you have values only in one of the 3 columns: Column1 or Column2 or Column3, you can use the concatenation: Finditem( List, Column1 & Column2 & Column3 )   If on the same row, you can have values in more than one column. then you will need to create a priority between column1, column2 or column 3 to choose what is the value to be used in Finditem.    Hope it helps Alex   ... View more

Nicely done @MarkWarren . As always OEG knocking it out of the ground and down the road... ... View more

What validations are you doing? Could some of it be handled in the UX layer? Configure character types for a form - Anaplan Technical Documentation Would normally recommend boolean line items combined with conditional formatting for validation. Do you need to drive the validation parameters from a system module? ... View more

Here's a new column to add; a count on the number of mappings in a SUM, where X[SUM:Y, SUM:Z] would return 2. =IFERROR((LEN(MID(C3,FIND("[SUM:",C3),FIND("]",C3,FIND("[SUM:",C3))-FIND("[SUM:",C3))) - LEN(SUBSTITUTE(MID(C3,FIND("[SUM:",C3),FIND("]",C3,FIND("[SUM:",C3))-FIND("[SUM:",C3)),"SUM:","")))/ LEN("SUM:"), 0)   Look at that repetition, this formula needs optimizing!  😂 This only does the first SUM function in a formula. Maybe someone can improve on this? Maybe it would need VBA? ... View more

In addition to what Mark posted, these articles might be beneficial as well: To Version or Not to Version? Inside the Hyperblock Data Hubs: Purpose and Peak Performance ... View more

Yes, Anaplan support team investigating the cause of this issue. ... View more

Hi @VDurgaPriya, What are you trying to achieve? If I undestand you correctly, you created subsidiary view (boolean filter) with Time dimension, in the module without Time dimension. But I don't get it why you want to now have Time page selector for this module - if you need it, then add it as a dimension to the module. ... View more

The model open analysis is a service that Anaplan Support can offer for anyone having modelling performance issues - contact support@anaplan.com Other types of analysis (including concurrency testing) can be done through Anaplan Professional Service teams and you can contact your Anaplan customer account person, or work through a partner to set this up. The third level of model analysis is available to all Hypercare customers, speak to your dedicated Hypercare advisor to set up. In terms of what they offer, the model open analysis is the most basic. It does show all the calculations in the model, done in full, when the model is loaded. Some of these may be relevant to the particular performance issue you are chasing. It shows the total processing time, rather than duration. Other model analysis can be more targeted towards specific user actions, showing only what is triggered when a user change is made. This allows for very targeted optimizations to be done. The model open is a hammer, the targeted analysis is a scalpel! ... View more

Thanks a lot @MarkWarren  ... View more

Why do you think this needs to be done by an import, what is the reasoning? If the data was connected via line items then only the cells you are changing will be used in the calculations to other modules.    If you need to do it this way you are looking at adding in a filter based on User selections, this adds a large performance cost and is usually not a good tradeoff. ... View more

Hi Mark,   Sorry for the late reply. I did get registered. Saw my acceptance letter in my inbox a couple days ago. Looking forward to the boot camp!   Regards,   Joshua ... View more

Love the tip about breaking down the formula into separate calculations, this can make the error tracing much more digestible then trying to find the mistake in multiple rows of text.   The open model analysis is also wildly helpful, you don't often realize the impact that one sub-optimal formula can have on overall model performance.   ... View more

Hi @melliott, I assume it's always imported as an 8-digit number, with all leading zeros included (so it's unambiguous that i.e. 1112022 is 1/11/2022, and 11/1/2022 would be 11012022). Also in my answer I assume format MMDDYYYY, and I do conversion just on numbers (without converting back and forth to text): Blueprint:       ... View more

@Hayk    Do you have some examples or topics you would like us to explore?  Trying to get some ideas.   Rob ... View more