Planning

Get Involved. Join the Conversation.

Topic

    Brian Somers
    Standard and Enterprise PlanningAnswered
    Topic posted June 21, 2019 by Brian SomersRed Ribbon: 250+ Points, tagged PBCS, Planning 
    162 Views, 7 Comments
    Title:
    Standard and Enterprise Planning
    Summary:
    Hybrid BSO and Custom Planning Functionallity
    Content:

    Hi,

    Can someone advise on where Hybrid BSO comes in to play in the new EPM Standard Cloud Service. It seems that custom planning (in my mind the old PBCS) is not available but where does Hybrid BSO come in to play? Are the existing modules all based on Hybrid BSO? If so will the dimensions in these modules be able to be configured as either dynamic or noin dynamic aggregations?

    Then on the EPM Cloud Service , my understanding is that Hybrid BSO is enabled and custom Planning(only on Enterprise) is also therefore new custom Planning apps can be built on either dynamic dimension aggregations or more traditional stored aggregations.

    Would that be correct?

    Thanks

    Best Comment

    Mark Rinaldi

    Hybrid BSO is the default setting for EPM Standard Cloud and EPM Enterprise Cloud for the Planning Business Process.  Yes, all pre-seeded Modules will default to Hybrid BSO and have dimensions adjusted based on our testing.  You can modify them to be dynamic based on your testing with realistic and representative data.

    In EPM Enterprise Cloud, the Planning Business Process supports 3 Business Process Types:  Custom (think PBCS plus extra cubes), Free-Form (Essbase .otl import without dimension-type restrictions), and Modules (EPBCS).  Each of of these Business Process Types supports Hybrid BSO by default. 

    So all Planning Business Process types in both EPM Standard Cloud and EPM Enterprise Cloud default to Hybrid BSO for the "Input" cubes.  ASO cubes are still available for pure reporting use cases with large dimension sets and highly sparse data.

    Does this answer your question?

    Comment

     

    • Mark Rinaldi

      Hybrid BSO is the default setting for EPM Standard Cloud and EPM Enterprise Cloud for the Planning Business Process.  Yes, all pre-seeded Modules will default to Hybrid BSO and have dimensions adjusted based on our testing.  You can modify them to be dynamic based on your testing with realistic and representative data.

      In EPM Enterprise Cloud, the Planning Business Process supports 3 Business Process Types:  Custom (think PBCS plus extra cubes), Free-Form (Essbase .otl import without dimension-type restrictions), and Modules (EPBCS).  Each of of these Business Process Types supports Hybrid BSO by default. 

      So all Planning Business Process types in both EPM Standard Cloud and EPM Enterprise Cloud default to Hybrid BSO for the "Input" cubes.  ASO cubes are still available for pure reporting use cases with large dimension sets and highly sparse data.

      Does this answer your question?

    • Parmit Choudhury

      Hi Mark,

      Can you help with Oracle documentation on Essbase Hybrid BSO in EPM Cloud.Our environment has existing applications on EPBCS for Financials,workforce.What could be the impacts if we decide to enable it for existing application in EPBCS. Will the existing application be deleted if we enable Hybrid BSO.

      • Mark Rinaldi

        Here are the steps to enable Hybrid BSO on a properly licensed EPBCS environment:

        1. On Test instance, perform a Database Refresh and ensure no errors (fix any and re-do until you have a clean Refresh)
        2. On Test, perform a full LCM Backup
        3. As a precaution, download this full LCM Backup locally
        4. Create an SR requesting to have Hybrid BSO enabled on the Test environment.  Include the following test in the SR:

        I <Your Name> authorize Oracle to enable Hybrid mode on my EPBCS environment <Service URL> as soon as possible/specific <date>. I know that the environment will be recreated and the application will be deleted, and I will have to either import the backup LCM snapshot that I have or recreate the application from scratch. I also confirm that I have read and understand this best practices document for using Hybrid BSO and know that I will need to redesign the existing application to leverage Hybrid BSO functionality.

        1. Support will provide you the Best Practices doc, though I will likely be posting it on Customer Connect soon.  The point is, you will have to re-design any custom cubes for Hybrid BSO best practices and requirements.  For the Modules, we update the OOB content to reflect these Hybrid BSO best practices but you may have to update any customized content that you overrode or wrote yourself to ensure all is aligned for Hybrid BSO usage
        2. I will confirm the request is valid and approve the necessary updates are made to your Test instance
        3. You then import the LCM file back in and the upgrade occurs. 
        4. Validate all is well (after any potential re-configuration)
        5. Once Test is validated, request to have Production updated for Hybrid as well and repeat the process

        Let me know if you have any other questions.

        Thanks.

        • Parmit Choudhury

          Hi Mark,

          I just want to confirm that we have to think about redesign only on the custom elements in the application.Also, please can you help with the following -

          1. Advantages of Hybrid BSO over BSO in EPM Cloud.
          2. What are the major considerations/impacts before enabling Hybrid Mode.

          Thanks  

          • Mark Rinaldi

            I just created this Ideal Labs post, How to Enable and Configure Hybrid BSO with EPBCS, that provides Tips & Tricks and procedural steps to enable.  Basically, you enable Hybrid BSO to improve performance.  The advantage of Hybrid BSO is the ability to make sparse parents Dynamic Calc, so you can reduce Aggregation times, database size, Dense Restructure times, etc.

            Note, you have to test different configurations to determine what can be Dynamic Calc vs. Store.  Sometimes the whole app can be Dynamic but that is exceptionally rare.

            I hope this helps.