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.

Overview

Overview
Roles
Member
Badges12

About Me

About Me

Analytics

24
201
55

Reactions

Activity

  • Not much happening here, yet.
Avatar

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In

Badges

  • 10 Comments
  • Fourth Anniversary
  • Name Dropper
  • Third Anniversary
  • Level 1 Model Building
  • Level 2 Model Building
  • Anaplan Way
  • New UX Training
  •  Certified Model Builder
  • Second Anniversary
  • First Anniversary
  • First Comment