tag:blogger.com,1999:blog-4968667725127637904.post5341697264655711955..comments2024-03-21T05:38:29.299-07:00Comments on fishing with FDMEE: Jythoning with FDMEE - Dynamic Import Format (Part 1)Francisco Amores (@akafdmee)http://www.blogger.com/profile/06055076603713050868noreply@blogger.comBlogger21125tag:blogger.com,1999:blog-4968667725127637904.post-29370073463703521572017-03-30T13:47:18.383-07:002017-03-30T13:47:18.383-07:00Hi Francisco, If one dynamically changes the impor...Hi Francisco, If one dynamically changes the import format, what happens with the load rule ?? Shouldn't we change the import format there as well ??Bernardo A Neira https://www.blogger.com/profile/13478063414396653089noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-45377821639323970962016-10-07T10:40:10.737-07:002016-10-07T10:40:10.737-07:00Hi, I'm having a problem with my check report ...Hi, I'm having a problem with my check report and would like to understand which script is executed after Consolidate.py, the one invoking the check step (and the check report), after some days looking at the logs I can't seem to find the answer<br /><br />Thanks in advanced<br /><br />Thanks a lotBernardo A Neira https://www.blogger.com/profile/13478063414396653089noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-70925119698120906112016-03-31T12:44:45.659-07:002016-03-31T12:44:45.659-07:00In the BefImport Script test if the Location being...In the BefImport Script test if the Location being loaded is the appropriate GAAP (not sure how you specify this variable, Import Format or Location Name or is it by the data). update the tpovpartition table when import is initialized to the appropriate Validation Entity, Validation Rule, Validation group. <br />Beau Reynoldshttps://www.blogger.com/profile/07625529924732708959noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-57823708407292348242016-03-31T12:37:12.943-07:002016-03-31T12:37:12.943-07:00Thanks for your help do you know at what point sho...Thanks for your help do you know at what point should I change the validation rule back ??? Because Im not pretty sure wether the table with the validations is populated before the check or after itBernardo A Neira https://www.blogger.com/profile/13478063414396653089noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-27947400185862066272016-03-31T12:33:46.908-07:002016-03-31T12:33:46.908-07:00This comment has been removed by the author.Beau Reynoldshttps://www.blogger.com/profile/07625529924732708959noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-53337659716617597382016-03-31T09:20:14.863-07:002016-03-31T09:20:14.863-07:00Thanks for the quick reply, do you know which tabl...Thanks for the quick reply, do you know which table has this info ?? also at what point of the process should I change it ?? before import ?? before check ?? and when should I change it back ???Bernardo A Neira https://www.blogger.com/profile/13478063414396653089noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-12602683609756617792016-03-31T09:17:42.259-07:002016-03-31T09:17:42.259-07:00HI, you would have to change it via database.
Ther...HI, you would have to change it via database.<br />There is no API for that yet.Francisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-81060186713652270182016-03-31T09:15:33.072-07:002016-03-31T09:15:33.072-07:00Hi, do you still check questions on your blog ??Hi, do you still check questions on your blog ??Bernardo A Neira https://www.blogger.com/profile/13478063414396653089noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-4838046318455618322016-03-28T12:06:06.356-07:002016-03-28T12:06:06.356-07:00Hi, this fishing with FDMEE blog rocks it's be...Hi, this fishing with FDMEE blog rocks it's been really helpful so far.<br /><br />I have a question, is there a way to also dynamically change the set of validation rules for a single location ? I have an scenario in HFM for 2 different GAAP's and was thinking of creating only one location, however the validations change a lot depending on the GAAP the user is loading. I wouldn't want to create another location for every entity because the client has about 100 of them, instead I wanted to use your idea of assigning the Validation Rule depending on the name of the load file<br /><br />Is this possible?? I was going through the API but didn't find anything regarding validation rules<br /><br />Any help would be highly appreciated Bernardo A Neira https://www.blogger.com/profile/13478063414396653089noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-82266881509249220002015-10-14T06:55:52.591-07:002015-10-14T06:55:52.591-07:00Interesting point especially as essentially jython...Interesting point especially as essentially jython is python and there is loads of documentation and examples out there for that! Also there is the freely available jython reference online.<br /><br />VBScript was never going to be a realistic option once Oracle moved to a platform independent version of the software. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-17691366610477638452015-03-17T08:44:55.606-07:002015-03-17T08:44:55.606-07:00Srx, your comment has really struck a chord with m...Srx, your comment has really struck a chord with me. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-34253558081673429832014-10-15T02:20:11.359-07:002014-10-15T02:20:11.359-07:00I know that it's useless complaining but why o...I know that it's useless complaining but why on earth did Oracle choose Jython for FDMEE scripting. Language in itself so undocumented, then even more undocumented regarding FDMEE appliance. Strange.srxhttps://www.blogger.com/profile/07171491730419232141noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-90395436022306749142014-06-04T05:52:02.279-07:002014-06-04T05:52:02.279-07:00Hi,
you have a sample script in the admin guide wh...Hi,<br />you have a sample script in the admin guide which shows how to connect to SQL database in order to import data into Open Interface Table.<br /><br />RegardsFrancisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-50292668318693005832014-06-02T14:43:08.152-07:002014-06-02T14:43:08.152-07:00Is there any Jython syntax that is equivalent to t...Is there any Jython syntax that is equivalent to the vb API farsSnap function? I want to connect to a custom table with the FDM database.Beau Reynoldshttps://www.blogger.com/profile/07625529924732708959noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-61413853290109902852014-05-13T10:21:20.310-07:002014-05-13T10:21:20.310-07:00Hi, sorry for the delay.
THat is VB code. You wil...Hi, sorry for the delay.<br /><br />THat is VB code. You will need to use Jython syntax.<br /><br />you can use something like strrec.split(",")[10]<br /><br />RegardsFrancisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-33140272179575910152014-02-26T12:16:34.172-08:002014-02-26T12:16:34.172-08:00Hi Francisco,
can you look at the function below a...Hi Francisco,<br />can you look at the function below and tell me whether you notice anything wrong with it? I am attempting to write an import script using Jython in FDMEE. The script is very simple but I'm having a hard time assigning the value from a given field to a variable.<br /><br />dr_str = fdmAPI.fParseString(strrec,30,11,",")<br /><br />Thanks,<br />ClintClinthttps://www.blogger.com/profile/09051095355868752913noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-33544702948609110322014-01-21T10:10:32.621-08:002014-01-21T10:10:32.621-08:00If HFM, you can also adjust the HFM_EXPORT action ...If HFM, you can also adjust the HFM_EXPORT action script.. as it is still availableFrancisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-69685534012334505012014-01-21T10:01:50.772-08:002014-01-21T10:01:50.772-08:00Are loading to HFM or HP/Essbase? unfortunately th...Are loading to HFM or HP/Essbase? unfortunately that procedure cannot be followed in FDMEE. There are different ways of approaching it. You could use a lookup dimension and then export it, concatenate with other dimension and use Essbase rule file to split, etc. You can also work on your own risk and alter database table to have a custom dimension Period_Custom, make it mappable, and exported to the DAT file...If you find table for application dimensions you will notice how it works.Francisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-3810172859399056282014-01-21T09:32:53.841-08:002014-01-21T09:32:53.841-08:00I have a file with multiple periods in the rows th...I have a file with multiple periods in the rows that I want to load. In the old days I just created a custom dimension for Period and turned off the Period as a Global member on the workbench and then loaded them all at once through a single POV. If there is an OOTB way to do this I would love to know, still trying to get a handle on the new FDM logic...Paulhttps://www.blogger.com/profile/04914122627165731929noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-35546606409433609462014-01-21T05:07:40.172-08:002014-01-21T05:07:40.172-08:00Hi Paul,
if you want to insert data into the Open ...Hi Paul,<br />if you want to insert data into the Open Interface Table from a flat file you will have to create a script so you read data from the file and insert into the table. You don't need any API function to create a record. YOu have an example of how to insert data into a table using Jython in Page 263 of Admin Guide.<br />Any way, why would you like to do that? Do you want to import only data from your active POV? You can then create an import format for that with no need to loading before into the OI table.<br /><br />Rgds<br />Francisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-50833727503381719702014-01-20T20:51:05.459-08:002014-01-20T20:51:05.459-08:00how did you expose the objects inside of the FDM A...how did you expose the objects inside of the FDM API? I'm trying to write a BefImport script that writes a file with Periods in the Rows (like most files from a Relational DB) into the Open Interface table and trying to find the equivalent of the old DW.DBTools.fCreateRec object.Paulhttps://www.blogger.com/profile/04914122627165731929noreply@blogger.com