tag:blogger.com,1999:blog-4968667725127637904.post7434356062099527337..comments2024-03-21T05:38:29.299-07:00Comments on fishing with FDMEE: FDMEE Custom Solution to Load Multiple Periods Through Single POV - Part 2Francisco Amores (@akafdmee)http://www.blogger.com/profile/06055076603713050868noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-4968667725127637904.post-84483154549300579492016-08-19T06:05:36.811-07:002016-08-19T06:05:36.811-07:00Thanks Francisco, Great Idea. Implemented it succe...Thanks Francisco, Great Idea. Implemented it successfully.ishtiquehttps://www.blogger.com/profile/15271144560267192562noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-55891643054092188452016-08-18T08:01:19.869-07:002016-08-18T08:01:19.869-07:00This comment has been removed by the author.ishtiquehttps://www.blogger.com/profile/15271144560267192562noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-71362964025411782552016-06-20T14:08:01.622-07:002016-06-20T14:08:01.622-07:00Hi Robb,
thanks for sharing.
You could also have ...Hi Robb,<br />thanks for sharing.<br /><br />You could also have 12 versions of the import format and change it dynamically in the befimport based of pov period.<br /><br />this is also a good solution if your import format is static and easy to maintain.<br /><br />RegardsFrancisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-17678248642668237112016-06-11T16:57:52.551-07:002016-06-11T16:57:52.551-07:00Hi Francisco,
For single period loads from a file...Hi Francisco,<br /><br />For single period loads from a file with multiple period columns, I use and import script that chooses the column that corresponds to the period chosen in the POV that I will share with you here:<br />def ChoosePeriodColBasedOnPOV (strField, strRecord):<br /> retval = 0<br /> indexOffset = 9<br /><br /> try:<br /> monthsIndexedByColNum = ['Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec']<br /> retval = float(strRecord.split("|")[monthsIndexedByColNum.index(fdmContext["PERIODNAME"][:3])+indexOffset])<br /> except Exception, e:<br /> fdmAPI.logError(str(e) + " - " + strRecord)<br /> finally:<br /> return retvalRobb Salzmannhttps://www.blogger.com/profile/08971173000793211795noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-3177950322608606172014-10-29T23:54:01.952-07:002014-10-29T23:54:01.952-07:00Custom software development specialists explore ex...<a href="http://www.acetechindia.com/custom-software-development.html" rel="nofollow">Custom software development</a> specialists explore exactly of the company are on they need from their IT system in order to operate to their optimum. <br />Allanhttps://www.blogger.com/profile/04414023777592108747noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-45863005255452597652014-08-04T04:40:16.750-07:002014-08-04T04:40:16.750-07:00Hi, it depends on your logic. You can use CASE sta...Hi, it depends on your logic. You can use CASE statement for PERIOD column which is the one being exported.<br />ThanksFrancisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-2794081282356647302014-07-29T05:35:55.102-07:002014-07-29T05:35:55.102-07:00Hello,
Great hack! However, could-you tell me whe...Hello,<br /><br />Great hack! However, could-you tell me where I have to insert the code in the original AIF_HS_BALANCES query ?<br /><br />Here the original one:<br />SELECT bal.LOADID ,COALESCE(pa.YEARTARGET, p.YEARTARGET) YEAR ,CASE c.CATFREQ WHEN 'M' THEN COALESCE(pa.PERIODTARGETM, p.PERIODTARGETM) WHEN 'Q' THEN COALESCE(pa.PERIODTARGETQ, p.PERIODTARGETQ) WHEN 'Y' THEN COALESCE(pa.PERIODTARGETY, p.PERIODTARGETY) WHEN 'D' THEN COALESCE(pa.PERIODTARGETD, p.PERIODTARGETD) ELSE COALESCE(pa.PERIODTARGETM, p.PERIODTARGETM) END PERIOD ,COALESCE(ca.CATTARGET, c.CATTARGET) SCENARIO ,CASE WHEN (bal.STAT_BALANCE_FLAG = 'Y') THEN part.PARTCURRENCYKEY ELSE bal.CURRENCY END CURRENCY ,bal.DATAVIEW ,part.PARTDATAVALUE DATAVALUE ,bal.ACCOUNT ,bal.ENTITY ,bal.ICP ,bal.UD1 ,bal.UD2 ,bal.UD3 ,bal.UD4 ,bal.UD5 ,bal.UD6 ,bal.UD7 ,bal.UD8 ,bal.UD9 ,bal.UD10 ,bal.UD11 ,bal.UD12 ,bal.UD13 ,bal.UD14 ,bal.UD15 ,bal.UD16 ,bal.UD17 ,bal.UD18 ,bal.UD19 ,bal.UD20 ,bal.AMOUNT ,bal.JOURNALID FROM ( ( SELECT LOADID ,PARTITIONKEY ,CATKEY ,PERIODKEY ,DATAVIEW ,CURKEY CURRENCY ,ACCOUNTX ACCOUNT ,ENTITYX ENTITY ,ICPX ICP ,UD1X UD1 ,UD2X UD2 ,UD3X UD3 ,UD4X UD4 ,UD5X UD5 ,UD6X UD6 ,UD7X UD7 ,UD8X UD8 ,UD9X UD9 ,UD10X UD10 ,UD11X UD11 ,UD12X UD12 ,UD13X UD13 ,UD14X UD14 ,UD15X UD15 ,UD16X UD16 ,UD17X UD17 ,UD18X UD18 ,UD19X UD19 ,UD20X UD20 ,SUM(AMOUNTX) AMOUNT ,COALESCE(STAT_BALANCE_FLAG, CASE WHEN (CURKEY = 'STAT' OR CURKEY = ' ') THEN 'Y' ELSE 'N' END) STAT_BALANCE_FLAG ,JOURNALID FROM TDATASEG WHERE VALID_FLAG = 'Y' AND CALCACCTTYPE > 0 GROUP BY LOADID ,PARTITIONKEY ,CATKEY ,PERIODKEY ,DATAVIEW ,CURKEY ,ACCOUNTX ,ENTITYX ,ICPX ,UD1X ,UD2X ,UD3X ,UD4X ,UD5X ,UD6X ,UD7X ,UD8X ,UD9X ,UD10X ,UD11X ,UD12X ,UD13X ,UD14X ,UD15X ,UD16X ,UD17X ,UD18X ,UD19X ,UD20X ,STAT_BALANCE_FLAG ,JOURNALID ) bal INNER JOIN TPOVPARTITION part ON part.PARTITIONKEY = bal.PARTITIONKEY INNER JOIN AIF_TARGET_APPLICATIONS app ON app.APPLICATION_ID = part.PARTTARGETAPPLICATIONID INNER JOIN TPOVCATEGORY c ON c.CATKEY = bal.CATKEY LEFT OUTER JOIN TPOVCATEGORYADAPTOR ca ON ca.CATKEY = c.CATKEY AND ca.INTSYSTEMKEY = app.TARGET_APPLICATION_NAME ) INNER JOIN TPOVPERIOD p ON p.PERIODKEY = bal.PERIODKEY LEFT OUTER JOIN TPOVPERIODADAPTOR pa ON pa.PERIODKEY = p.PERIODKEY AND pa.INTSYSTEMKEY = app.TARGET_APPLICATION_NAME<br /><br /><br /><br />thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-76697002922561009812014-03-18T02:36:58.331-07:002014-03-18T02:36:58.331-07:00Hi,
It should be working in Planning as well.
did ...Hi,<br />It should be working in Planning as well.<br />did you check you have correctly assigned your file field in the Import Format?Francisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-820300378112466352014-02-25T02:59:59.444-08:002014-02-25T02:59:59.444-08:00Hey Francisco,
short Question. Is there a trick t...Hey Francisco,<br /><br />short Question. Is there a trick to show the account description in Planning ?! I just defined Descriptiion 1 in the import format as i would do it in HFM but no description is shown. In HFM it works perfectly ?!<br /><br />Regards<br /><br />TimAnonymoushttps://www.blogger.com/profile/14782035441238030212noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-3868917439680192602014-02-19T07:31:11.250-08:002014-02-19T07:31:11.250-08:00Thank You ! Awesome :)Thank You ! Awesome :)Anonymoushttps://www.blogger.com/profile/14782035441238030212noreply@blogger.com