Issue while loading data into different scenario in Data management

Ashima Rajput

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

user111989

What happens when you run the data load rule with Multi dimension mapping? Do you get any errors?

Ashima Rajput

No I'm not getting any errors in workbench scenario mappings are mapped correctly.

Scn---> ActualBS

Scn--> ActualPL

No error while exporting as well but when i try to check data in smartview there is no data.

I tried this by taking Actual scenario in Data load rule but also applied multidimension mapping

so data mapped in workbench like this

Actual---> ActualBS

Actual--> ActualPL

but when we see in smartview it is coming only against Actual.

user111989

What is the column name for SCENARIO.

Also, can you check the .dat file which is generated?

Ashima Rajput

Please have a look:

scenario is UD7

And in .dat file it is taking 'Actual' Scenario which is define in data load rule and in pov

user111989

Can you set the data column for scenario as SCENARIO and then try ?

Ashima Rajput

Hi,

we don't have data table column name as scenario.

Thanks

DhawaShah

Hi,

Can you provide Data load workbench, Target application, and Multidimension mapping edit window snapshot if possible.

Thanks and Regards,
Dhawal Shah

Ashima Rajput

Hi Dawa,

Please see below.

Target application is FCCS.

workbench

Multidim mapping

Thanks

DhawaShah

Hi Ashmi,

What is mentioned in data table column name in Target application details.

Thanks and Regards,

Dhawal Shah