Skip to Main Content

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!

FDMEE PSU210: MultiPeriod load from Excel issue

finskiyFeb 14 2017 — edited Feb 23 2017

Hello all!

How to load Multi Period data from Excel(.xlsx) into Planning using 'one-column' format for periods at Excel template ?

for example:

AccountEntityPeriodAmount
acc1ent1Jan100
acc1ent1Feb200
acc1ent1Mar300

I've already tested loading multi periods data from .txt using file type 'Delimited - Numeric Data' - it working fine! I also tested different source mappings - Explicit and Adjustment (for custom period names) - it's also working fine!

I'm also tested loading multi periods data from Excel using differents columns for periods (Jan,Feb..Dec), file type 'Multi column - Numeric Data' and Expression in Import Format period mapping - it's also working fine!

But when i'm trying to use 'one column' format at Excel template without any Expression in Import Format mapping - all rows are loading into first period - Jan!

i've been tested different ways - file type 'Delimitied..' or 'Multi column..' and Explicit/Adjustment source period mappings...still same problem, all rows are loading into one period..

Any ideas how to solve this ?

Thanks!

Best Regards,

Artem.

Comments

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

Post Details

Locked on Mar 23 2017
Added on Feb 14 2017
6 comments
696 views