About MarkWarren

" I want to summarize that information on SKU-level, so for each SKU I want to mention which sites produce it." A better way to do this would be to have a boolean where volume > 0 in your source module. It would show all the sites for each SKU rather than limiting it to 4. Pivot the view so you have SKU's on rows and Sites as columns. This use of textlist and subsequent text manipulation will have a large performance cost. ... View more

In terms of best practice and performance you could also create a line item to add some of the values together before using in the IF statement. You could also make a system module for Package and calculate the booleans once there. Create an intermediate line item: X = IF SYS Package.Purchase Order Type OR SYS Package. Subcontractor Type THEN B1 + B2 + B3 + B5 + B6 ELSE 0 The system module would replace the use of Type line item in your module Then your line item would be: IF SYS Package.Purchase Order Type THEN X + B4 ELSE IF SYS Package. Subcontractor Type THEN X ELSE 0 The principles here are to do as few calculations as possible, part of this is achieved by using a System module; the naming convention should be clear so future developers will understand where to look for properties relating to that list. ... View more

How are you currently creating the code? You're using a numbered list, so you can make a module dimensioned by that list and use a line item in that module to create the display name. Typically it might be part of the import data, but you could construct it. For example, you could use: number = CUMULATE(1, FALSE, list) to create a number sequence in one line item and code = "CER-" & RIGHT(TEXT(10000 + number), 4) Then use the code for the display name... ... View more

If you have a line item dimensioned by a line item subset you would apply a filter to hide any values from the subset you didn't want to display. Or you just take those line items out of the subset or create another line item subset with only the line items needed for that module. What is it you are trying to achieve, perhaps we can understand more to be able to find the right solution? ... View more

The next step would be to use an API or via Anaplan Connect to run that export outside of Anaplan and supply it to some code, a script, or another system that can email the file based on your list of suppliers. The list of suppliers could even be exported via Anaplan, then iterated over whilst exporting data relevant to each one. This is not something that can be done in the Anaplan itself, it needs some external tools/programming to achieve. ... View more

You should just directly reference the source, in fact you are already doing that for System Sales. I must be missing something, what do you need in the target? ... View more

Can you show the formulas involved? I should think you would need to sum on a custom time list, then use a mapping to lookup that value into the real timescale. But fake weeks to real months... ... View more