Forum Stats

  • 3,825,065 Users
  • 2,260,464 Discussions
  • 7,896,401 Comments

Discussions

Issue while loading data into different scenario in Data management

Ashima Rajput
Ashima Rajput Member Posts: 69
edited Mar 3, 2020 11:43PM in Financial Data Management

Hi All,

I have a question that how we can load data on different scenario from one data load rule.

i have enabled scenario as generic dimension in target application and then define scenario as one hard code scenario name 'scn'

then i have applied multidimensonal mapping for that scenario based on account like for ex

WHEN account is 1100 then scenaio should map with 'ActualBS'

WHEN account is 2100 then scenaio should map with 'ActualPL'

my data file contains both kind of accounts balance sheet and PnL. But we don't have scenario in the file we need to identify scenario based on accounts.

I have tried this by creating 2 data load rule but got failed when in source file it contains only PnL accounts.

I have followed this blog but this approach doesn't work for me

https://blogs.perficient.com/2018/07/02/fdmee-use-scenario-as-a-generic-dimension-class/

Thanks in Advance

Answers