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!

Sign Change in FDM

aceMay 12 2011 — edited May 12 2011
As per my outline, expense is being subtracted from income.

But the data loaded through FDM already has a negative sign with all expenses, which causes the expenses to be added in income during data load.

As I am a new user of FDM, please tell me the way through which I can reverse the signs of the specified accounts in FDM to resolve this issue?
This post has been answered by SH_INT on May 12 2011
Jump to Answer

Comments

Gaz in Oz

Leave the SQL Developer history files format alone.

If you want to get the "timestamp" into readable format, then you can convert the epoch timestamp into readable form using:

alter session set nls_timestamp_format = 'YYYY-MM-DD HH24:MI:SS.FF3';
SELECT to_timestamp('1970-01-01', 'yyyy-mm-dd') +
       numtodsinterval(1513762282594 / 1000, 'SECOND') readable
FROM   dual;
READABLE
--------------------------------
2017-12-20 09:31:22.594

...for example.

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 9 2011
Added on May 12 2011
#business-intelligence-applications, #fdm, #financial-data-management, #performance-management-applications
1 comment
185 views