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!

Changing HFM adapter after upgrading FDM 11.1.1.3 to 11.1.2.1

983307Jan 24 2013 — edited Jan 24 2013
Hi,

I have upgraded FDM from version 11.1.1.3 to 11.1.2.1. The last step I guess is to re-register the adapters to 11.1.2.1 version - FM11x-G5-E
Does any know how to achieve that with out re-building the mappings?

Or any pointers is appreciated!

Thanks,
PM
This post has been answered by JeffJon on Jan 24 2013
Jump to Answer

Comments

it wants a sql query, but you gave it sqlplus commands instead

back up a level and share the type of report you have, and what kind of output you want, grid, chart, report, html, etc...

EdStevens 
thatJeffSmith-Oracle wrote:
it wants a sql query, but you gave it sqlplus commands instead 
back up a level and share the type of report you have, and what kind of output you want, grid, chart, report, html, etc...

Just a simple report, with the formatting as suggested by the sqlplus commands that were shown.

Answer

if you want to use the sql formatting stuff, set your report type to script

pastedImage_0.png

Then you can have at it...but instead of using COL formats, why not try SET SQLFORMAT ansiconsole?

pastedImage_1.png

Marked as Answer by EdStevens · Sep 27 2020
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 21 2013
Added on Jan 24 2013
#business-intelligence-applications, #financial-data-management, #performance-management-applications
2 comments
519 views