Passing parameters to system modules

LalithaPerumal · 2025-02-04T22:40:29+00:00

There was an error rendering this rich post.

I have more than five modules where "reporting date" is a line item and I import values for them. In each of those modules I have another line item to calculate the reporting period based on the reporting dates. Here is the formula for that.

IF DAY(reporting date) <= 15 THEN PERIOD(reporting date) ELSE PERIOD(reporting date) + 1.

Currently i have this formula in each of those 5 modules. Is it possible to centralize this calculation done in a line item of a system module and call it from the 5 modules by passing the reporting date as a parameter. That way if we need to change the formula later, I can modify it one module, rather than 5 modules. I might be able to centralize the threshold days (15) in system module, but I want to know if I can centralize the entire formula.

Any help is appreciated!!

Accepted answers

All comments

luke_e

Short answer is yes, and it is the preferred approach to model building where you 'calculate once, reference many times'.

Benefits include better performance (or rather, less calculations), fewer lines (resulting in lower cell count) and lower maintenance overhead as you can just update the one line instead of making the same change in multiple places.

As you've noted, having a system module is ideal, particularly for things like time-based calculations or where the logic is common across many modules.

See the below which explains some common scenarios in more detail,

https://community.anaplan.com/discussion/158385/calculate-once-and-reference-model-optimization-team-series

devrathahuja

Hi @LalithaPerumal ,
Yes, that is the preferred approach. Import it to a SYS module & have the period formula there. You can then refer it in the 5 modules as you rightly mentioned.

LalithaPerumal

Thank you for the responses. Above examples explain optimization within the same module. It doesn't explain how I pass a variable (Reporting Date - which is a stored value from import) from calling module to the system module without using lookup function. If I use lookup function, then I need to import and store reporting dates from all 5 modules into system module as a line item.

seymatas1

Hi @LalithaPerumal,

It depends on your module dimensions and your model-building choices. Let me show you different builds in a simple Sales Data module. I assume you cannot change the source data and you reporting dates are different for each month but the same for each country.

Current Build:

You have Sales Amount, Reporting Date, and Reporting Period line items in the Sales Data module.

Your cell count is 3x72=216.

Another Option:

Change the Reporting Period line item into a subsidiary view.

Your cell count is 72 + 119+ 12 = 203.

Note: Subsidiary views are generally not best practice, but you can use them here because they show data in the main module view.

When it comes to cell sizes, it depends on your time and list dimensions so you will decide if it is worth it. You can consider formula options instead of turning on summaries.

You can also take the Reporting Period line item into a system module.

If changing the source data is possible, you can consider making an import action change.

If your Reporting Date line item is dimensionless and your module doesn't have a time dimension, this structure changes.

I hope this helps.

Seyma 🌷🙂

devrathahuja

Hi @LalithaPerumal ,
In that case, you can create a system module at day dimension / custom list with all the dates if your model timescale does not support it.

Write the formula in this system module for the period, it should not be performance heavy as it is a single dimension module with not a complex formula.

You can then always lookup the period for ANY reporting date across the model by referring to this new line item & also control it centrally.

You can further optimise the process by switching the line item where you import the dates from date format to this list format instead so that you can skip the finditem step for mapping date to your custom list & directly lookup on that member.

Hope this helps! :)

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…