Haven't worked with FDM in a long time. I used to run a process to load a months of data against a mapping table and the fishes go across the screen. Now I'm trying to help out on FDMEE and have a question.
What is a Logic Group and how does it relate to Logic Accounts and validating data? I read the admin guide but it's not making sense. I just need an answer in layman's terms so I can understand. Here's what I think it is and I'm probably way off:
Logic Accounts are setup to group together accounts from the source into parent values. For instance the level 0 text file might have 6 accounts that roll up to Travel Expense in the outline. So you would create logic account 'Travel Expense' and then when you load the text file via FDM, it can calculate 'Travel Expense' and then it can validate somehow?
basically, you can see Logic Accounts as additional records FDMEE will generate when you import data (generate additional data that is not coming from the source)
They can be used for many different purposes and you can decide if they are exported into your target (i.e HFM) or they are just used in FDMEE. Logic Accounts are generated during the import step, before mappings happen.
For example, let's say that your have in your file
and you want to import:
So you are going to group Account1 and Account2. The record for "LogicAccount" is not coming from the source file, it has been created because you have configured a logic account to group Account1 and Account2.
Typically, for this example, you will have to export record for LogicAccount1 and not for Account1 and Account2. For this, in your mappings you have to send Account1 and Account2 to "Ignore" and map LogicAccount1 to your target Account (i.e. Travel Expense)
There are two types of logic groups: simple (your logic account is derived from source account) or complex (you can derive your logic account from any dimension combination)
Regarding Validation, you can then customize FDMEE (scripting) to run some validations on Logic Accounts. For example, custom solution to check a total before file is imported.
Hope that clarifies.