How to map 3 columns(line items) of data to one line item based off time

wdjurgs

I have a data set with multiple columns of data (2023 inforce premium, 2024 inforce premium, and 2025 inforce premium) that I want to map to a module and sum based off the corresponding year in the title. What would be the best way to map these line items in the data while avoiding a lengthy if statement that would need to be modified each year? My thinking is using a Line Item Subset to map the time aspect but I'm not sure the best way to implement it.

Source module with corresponding attributes/dimensions above. The target module will be dimensioned by year, and the corresponding dimensions in the source module.

rob_marshall

@wdjurgs

You need to architect this better as a Row ID (or Index number) is not the way to go.

There are 2 ways of doing this and it depends on the volume of data and/or engine. The preferred way (volume is low - less than 10 million rows in the Index list and/or you are using Polaris) is create a module dimensionalized by Platform, Product, and Time (at the year level), create a line item named Inforce Premium and load the data directly to that line item. This gets rid of the Row ID (Index) list and allows the engine to perform better. Attempt this way before attempting Option 2.

Option 2:

Create a list having the codes of Platform and Product concatenated together. Create a module dimensionalized by the previous list and Time (at the Year granularity) with a line item named Inforce Premium and import the data to that. This way, you will not need to update any line items or logic for the next year, when you add that year to the model timescale it will automatically be there.