Forum Stats

  • 3,875,196 Users
  • 2,266,853 Discussions
  • 7,912,106 Comments

Discussions

Load data on Account members

4180229
4180229 Member Posts: 1
edited Jan 31, 2020 9:06AM in Financial Data Management

Hi,

We have 2 accounts on which we want to load the data. We are not getting information from Source file for this.

Basically we need to set some default value for these 2 accounts.

Lets say : If account is Status then data value to be loaded on it is 1. And if account is 'Action' then data value to be loaded on it is 4.

How can we achieve this? Any guess?

Thanks

Tagged:

Answers

  • SH_INT
    SH_INT Member Posts: 3,193 Bronze Crown
    edited Jan 30, 2020 6:22PM

    You could manipulate the source file before it is imported into the FDMEE data tables to include data for these 2 accounts either manually before import or programatically in the BefImport event. Or you could use an event script to insert the data for those to accounts directly into the TDATASEG_T table. Either way you'll also need to specify field values that can be used to map all of the other required dimensions when crating the necessary data row entries for those 2 accounts

  • user6692921
    user6692921 Member Posts: 179 Silver Badge
    edited Jan 31, 2020 4:20AM

    You could use Logic Accounts to create the Status and Action accounts. Then use SQL maps to update the AMOUNTX column to the relevant value for each account eg

    CASE WHEN ACCOUNT = 'Status' THEN 'Status' END, AMOUNTX = CASE WHEN ACCOUNT = 'Status' THEN 1 END

    I haven't tested it but it should work.

  • SH_INT
    SH_INT Member Posts: 3,193 Bronze Crown
    edited Jan 31, 2020 9:06AM

    Problem with Logic accounts is that the criteria for creating them is based on the source accounts, so you will probably end up with not very intuitive and inefficient (performance wise) logic to create the 2 static accounts that you require