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!

Cannot load Periodic and YTD data in FCCS using Data Management

2837733Feb 22 2017 — edited Aug 24 2017

I asked this question in the FCCS community but I hope I'll get responses here.

I'm trying to load a file into FCCS using data management that contains both Periodic data as well as YTD data. The income statement accounts are periodic values and balance sheet accounts are YTD values

To do that I:

  • Added the view dimension under my target application to UD6.
  • Indicated in the import format to use the account field in the view i.e. the View dimension is equal to the account field in the imported file. That way I can map the accounts to the correct view dimension
  • in the view dimension mappings, put in explicit mappings for all BS accounts to go to FCCS_YTD_Input and * to FCCS_Periodic

The problem is that when I look at the export file, it maps all data to FCCS_YTD_Input.

So, I removed all mappings in the view dimensions to put everything in periodic but it still loads everything to YTD_Input.

Has anyone else experience this?
This post has been answered by 2837733 on Jun 12 2017
Jump to Answer

Comments

PavanIndurthi-Oracle

Hi Ajay,

It is not suggested to have 2 different production applications(FCCS,PBCS) in test and prod.

Your approch will violate the guidelines.

Regards,

CBarbieri

If your subscription includes both FCCS and PBCS I think you should be able to have both applications in both pods.

Ajay Pal Singh

Hi Pavan,

I know that but I want to use the PBCS test instance for preparing FCCS Demo for a few days only.

After that, I will migrate the snapshot from prod instance.

Just want to know the consequences if any.

Thanks

Ajay Pal Singh

Hello CBarbieri,

I have the subscription for PBCS application only.

Regards

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

Post Details

Locked on Sep 21 2017
Added on Feb 22 2017
#business-intelligence-applications, #financial-data-management, #performance-management-applications
7 comments
1,916 views