Ajaykumar08ns

Hello Folks, I have a question regarding pulling data from one module to another for a particular period. Please find the details here: Source Module Lists: Time FY22 - FY25 (Months), Custom versions and Products Target Module Lists: Time FY22 - FY25(Quarters), Custom Versions and Products. The issue here is, I have 8 items in version dimension. I want to check 2 versions, If they are true then I need to fetch data only for FY24 (should be dynamic based on current year boolean) only for those 2 versions and rest all others we fetch data for all periods. I created 2 line items "Current Year?" is to check the Current year and "Current Year" (format:Time.Quarters) is to get the parent of the month. After this I wrote a formula in the target module: IF    SYS Simulation.'Simulation?' AND 'SYS01: Time Setting (Month)'.Current Year? THEN     'SourceModule'.Lineitem[LOOKUP: SYS scenario.Mapping, SUM: 'SYS01: Time Setting'.Current Year,  SUM: 'SYS Product'.'L4 mapping'] ELSE     IF         ITEM(Time) < 'SYS: Time '.Planning Quarter     THEN         'Source Module'.Units Adjust[LOOKUP: 'Sys Scenario'.Actuals, SUM: 'SYS Product'.'L4 mapping']     ELSE         'Different Module'.Line item[SUM: 'Time'.Real time mapping Qtr, SUM: 'SYS Product'.'L4 mapping']. All the logic is fine, But in the first IF, THEN condition when I am using SUM for SYS01: Time Setting'.Current Year I am getting error and when I use Lookup It is fetching for all periods. Is there any solution for this without creating any new module or line items in the source and target modules.

Activity

  • Ajaykumar08ns
    Ajaykumar08ns earned the Name Dropper badge.
    Mentioning someone in a discussion (like this: @Name) is a great way to encourage dialog and let them know who you’re talking to.
    February 22
  • Ajaykumar08ns
    Ajaykumar08ns, chaitanyakesarla, LeiCuntapay, MJM, adrienne.canter and 18 others were promoted to General Contributor.
    February 21
  • Ajaykumar08ns

    Hello Folks, I have a question regarding pulling data from one module to another for a particular period.

    Please find the details here:

    Source Module Lists: Time FY22 - FY25 (Months), Custom versions and Products

    Target Module Lists: Time FY22 - FY25(Quarters), Custom Versions and Products.

    The issue here is, I have 8 items in version dimension. I want to check 2 versions, If they are true then I need to fetch data only for FY24 (should be dynamic based on current year boolean) only for those 2 versions and rest all others we fetch data for all periods.

    I created 2 line items "Current Year?" is to check the Current year and "Current Year" (format:Time.Quarters) is to get the parent of the month.

    After this I wrote a formula in the target module:

    IF   
    SYS Simulation.'Simulation?' AND 'SYS01: Time Setting (Month)'.Current Year?
    THEN    
    'SourceModule'.Lineitem[LOOKUP: SYS scenario.Mapping, SUM: 'SYS01: Time Setting'.Current Year,  SUM: 'SYS Product'.'L4 mapping']

    ELSE   
     IF       
     ITEM(Time) < 'SYS: Time '.Planning Quarter    
    THEN        
    'Source Module'.Units Adjust[LOOKUP: 'Sys Scenario'.Actuals, SUM: 'SYS Product'.'L4 mapping']    
    ELSE       
     'Different Module'.Line item[SUM: 'Time'.Real time mapping Qtr, SUM: 'SYS Product'.'L4 mapping'].

    All the logic is fine, But in the first IF, THEN condition when I am using SUM for SYS01: Time Setting'.Current Year I am getting error and when I use Lookup It is fetching for all periods.

    Is there any solution for this without creating any new module or line items in the source and target modules.

    February 21
Avatar