Forum Stats

  • 3,854,781 Users
  • 2,264,422 Discussions
  • 7,905,786 Comments

Discussions

Add new dimension in PBCS

User_4RWFC
User_4RWFC Member Posts: 60 Blue Ribbon
edited Aug 9, 2019 9:29AM in Planning and Budgeting

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

Best Answer

  • Dayalan Punniyamoorthy
    Dayalan Punniyamoorthy Member Posts: 1,516 Gold Trophy
    edited Aug 6, 2019 4:28AM 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.

Answers

  • Dayalan Punniyamoorthy
    Dayalan Punniyamoorthy Member Posts: 1,516 Gold Trophy
    edited Aug 6, 2019 4:28AM 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.

  • user608296
    user608296 Member Posts: 139 Blue Ribbon
    edited Aug 8, 2019 3:19PM

    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