How to consider only 1 month when importing data from a module into list

Guilhermecord10
Guilhermecord10
in Modeling

Hi Guys!

I would like import "IDs" from a module into list but my module have time with dimension and it is a problem haha (yet)

I import "CODE ID CMP" into list, all "CODE ID CMP" are equals in all months

image.png

When i try import i have success but so many errors happen:

image.png

Analyzing the errors, we have:

image.png
image.png

How i can do import only data from "Jan 25"? If i get it my stakeholders will no longer complain that the process has errors :) :)

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓

    @Guilhermecord10

    It looks like there are a couple of issues here. One, I believe you need a IsFirstOccurence() on the code to only bring in first member (no duplicates). Second, Code, Cost Center, and Code ID CMP should not be dimensionalized by Time as they don't change from Jan to Feb. A better way to do this is create a SYS module using this list:

    image.png

    This way, you will not have issues with Time nor Forecast.

Answers

Categories