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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Add new dimension in PBCS

User_4RWFCAug 6 2019 — edited Aug 9 2019

Hi team,

In our PBCS application at the moment we have 9 dimension(2 dense & 7 Sparse dimension) and we are in process of adding one more dimension in application.

we have data for for various scenarios for FY14, 15,16,17,18,19,20,22

What will be the best way to handle this end to end, can you please suggest, Thanks much for help on this.

Regards

BV

This post has been answered by DayalanP on Aug 6 2019
Jump to Answer

Comments

DayalanP
Answer

At a high level, you need to extract all the data and add the dimensions and add the 2 dimensions to the extracted data and get them reloaded. If you are getting the History Actual & Budget from Fusion/ERP it will be less trouble to get the data back. All the input data( Budget) in PBCS will be challenge but can be managed.

Regards,

Dayalan P.

Marked as Answer by User_4RWFC · Sep 27 2020
Dornakal

Adding to Dayalan.

Here are the steps if I have to do it

Step 1: Backup the snapshot

Step 2 : Extract  the data (Planning format) in chunks so that you can manage them in excel. We separate data in Months.

Step 3: clear the data

Step 4: add the dimensions.

Step 5 : Load the extracted data

1 - 2

Post Details

Added on Aug 6 2019
#business-intelligence-applications, #essbase, #hyperion, #pbcs, #performance-management-applications, #planning-and-budgeting
2 comments
353 views