- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Period Source Mapping in FDMEE
I am using a custom SQL DB as a source for myFDMEE and stuck in few query , wondering if anyone can suggest ?
1- for period Mapping, do i need to have a calender (Period) pre-defined in SQL ? if yes then how can i do that ?
2-I have data columns (Jan-De) In source Table, so in the BefImport Script how should i insert values (Jan-Dec) into AIF Amount Columns ? i can insert Jan column value into AMOUNT column of AIF open Interface Table when selecting "Period Mapping Type" as None .
Please suggest if anyone have any idea . Much Appreciated !