Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exporting Data to Excel for All Locations

Erich RanzSep 15 2009 — edited Sep 15 2009
Is there a way to export data for all (or selected) locations at once in FDM? For example, I'd like to export the Import data for 15 locations to Excel file(s). Another example, I'd like to export account mappings for 15 locations to Excel file(s). Until now, our group has been doing this manually every so often.

It would be ultra-super-fantastic if this could be automated.

Thanks!

EDIT: It looks like this can be done via a script in the FDM Workbench. I found ExportEntityMap as an example. Any tips/suggestions/best practices?

EDIT2: Sample scripts appear to be location specific (API.POVMgr.PPOVLocation). Any way to specify locations and/or loop through them with an array etc?

EDIT3: Script export does not provide sexy Excel format, nor mappings other than Explicit (from what I can gather). The output is for Tron only. We can all agree Tron is cool, but Excel rules in our acct/fin departments.

Thanks again!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2009
Added on Sep 15 2009
#business-intelligence-applications, #financial-data-management, #performance-management-applications
1 comment
1,370 views