Getting data from a module with no time dimension to a module with time dimension

fssebastian
fssebastian
in Integrations and extensibility

My source module has no time dimension but with month list, and period in line item.

 

My target module has a time dimension Month Period, (ex. Jan 19, Feb 19, etc)

 

How can I get the data from My source module?

Tagged:

Best Answer

  • anand.shekhawat
    anand.shekhawat
    Answer ✓

    @fssebastian 

     

    Lets assume you have a source module as below

    anandshekhawat_0-1664799031682.png

    Your Target module would look something like this

    anandshekhawat_1-1664799085062.png

    You would be required to sum the data wrt the month line item.

     

    Please let me know if it helps

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

Answers

  • TimWard70
    TimWard70

    If it is numeric data then using your period formatted line item you should be able to SUM the data into your target

  • Badam
    Badam

    Hi fssebastian,

     

    You need to build a reference line item at the source module to map the time dimension against the time list as per the below image:

    Badam_0-1664807838317.png

    In your target you need to use sum as mentioned below to pull the data from source to target.

    Badam_1-1664807909950.png

     

    If you need still any help, please let us know.

     

    Thanks & Regards

    Badam Anjani Prasad

    Matasma Digital

  • fssebastian
    fssebastian

    It worked! Thanks a lot!

Categories