[vc_section full_width=”stretch_row” css=”.vc_custom_1532085157436{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 0px !important;background-color: #ffffff !important;}”][vc_row full_width=”stretch_row” css=”.vc_custom_1764749871676{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 40px !important;}”][vc_column css=”.vc_custom_1764749883421{margin-top: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1764749501124{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
DiLytics Cloud-Based PBCS Solution Optimizes Planning and Budgeting
[/vc_column_text][vc_column_text css=”.vc_custom_1764746128064{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client is the largest city and the county seat of Alameda County, California. It is a major West Coast port, the largest city in the East Bay region of the San Francisco Bay Area, the third-largest city overall in the Bay Area, and the eighth-most populated city in California. It serves as a trade center. [/vc_column_text][vc_column_text css=”.vc_custom_1764746231285{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
Background
[/vc_column_text][vc_column_text css=”.vc_custom_1764746283054{margin-top: 0px !important;margin-bottom: 35px !important;}”]The client had implemented a planning and budgeting solution from Oracle Corporation, called Oracle Planning and Budgeting Cloud Service (PBCS).
Budgeting is an iterative process that requires planners to come up with multiple scenarios and versions of the Plan for review. Based on review feedback and resulting calculations, planned numbers need to be revised several times for improvement before the plan can be finalized and approved. This iterative process becomes very cumbersome without comprehensive insight into the Plan numbers at different stages in the process. Though Oracle PBCS provided some out-of-the-box reports, the client users did not find them to provide adequate visibility. Due to this, client’s business users found it challenging to perform the Planning and Budgeting functions efficiently.
Hence, the client identified the need for an Analytics solution to address the limited reporting in PBCS. In addition, it was identified that the Analytics solution should be hosted on the cloud so that IT maintenance effort is kept to a minimum. [/vc_column_text][vc_column_text css=”.vc_custom_1764749543541{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]
DiLytics’ Solution
[/vc_column_text][vc_column_text css=”.vc_custom_1764746450238{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics has a prebuilt solution, PBCS Insight, for Planning and Budgeting which is approved by Oracle Corporation and is published in Oracle Marketplace. DiLytics implemented PBCS Insight to provide comprehensive reporting on Oracle PBCS data. The key elements of the DiLytics solution were to:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764749643351{margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Identify the data objects to be integrated from Oracle PBCS to Oracle Analytics Cloud
- Determine the REST APIs in Oracle PBCS to extract data
- Leverage DiLytics Java package to schedule PBCS data extracts
- Use Oracle Data Sync to integrate PBCS data into Oracle Analytics Cloud
- Model PBCS data in Oracle Analytics Cloud as a business dictionary
- Develop reports and dashboards on PBCS data in Oracle Analytics Cloud
[/rt_list_style][vc_column_text css=”.vc_custom_1764746505749{margin-bottom: 10px !important;}” el_class=”text-block”]As part of the implementation, DiLytics carried out: [/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764749628158{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Requirements review and analysis
- Custom package development
- Design and build of ETL data integration, data warehouse, and Oracle Analytics Cloud report
- Conference Room Pilot
- System testing and user acceptance testing (UAT)
- Code migration and Go-live deployment
- Training
- Knowledge transfer and post production support
[/rt_list_style][vc_column_text css=”” el_class=”text-block”]
Business Benefits
[/vc_column_text][vc_column_text css=”.vc_custom_1764749695245{margin-bottom: 10px !important;}” el_class=”text-block”]Here’s how the organization benefited from the improved planning process:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764749658180{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]
- Optimized planning process with availability of analytics on a 24×7 basis
- Efficient running of the budgeting process by an empowered planning team
- Improved business predictability via the facilitation of enterprise-wide and department-level planning and budgeting
[/rt_list_style][vc_column_text css=”” el_class=”text-block”]
Technical Stack
[/vc_column_text][vc_column_text css=”” el_class=”text-block”]Data Source(s): Oracle PBCS
Data Integration Tool: Oracle Data Sync
Data Warehouse: Oracle Database Cloud Services (DBCS)
Reporting Tool: Oracle Analytics Cloud[/vc_column_text][vc_column_text css=”” el_class=”text-block”]
What Does the Client Say?
[/vc_column_text][vc_column_text css=”.vc_custom_1764749851383{margin-bottom: 0px !important;}” el_class=”text-block”]DiLytics implemented an Analytics Solution for our Planning and Budgeting process. We implemented Oracle Planning and Budgeting Cloud Services (PBCS). Our team required additional visibility and reporting on planning and budgeting data compared to what was available in PBCS. We engaged the DiLytics team to address this need. DiLytics understood our team’s requirements and designed a data warehouse. They integrated data from PBCS into the Data warehouse. They leveraged the Oracle Analytics Cloud platform on DWH to deliver our Analytics and Reporting requirements. – Director of Finance[/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1764749749067{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 35px !important;padding-bottom: 75px !important;background-color: #ffffff !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column width=”1/3″ css=”.vc_custom_1531997568277{margin-top: 0px !important;margin-bottom: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][/vc_column][vc_column width=”1/3″][vc_column_text css=”” el_class=”text-block”]
DiLytics Delivers
[/vc_column_text][/vc_column][vc_column width=”1/3″][vc_custom_heading text=”View all Success Stories →” font_container=”tag:h6|font_size:16px|text_align:right|color:%23dd3333|line_height:26px” use_theme_fonts=”yes” css=”.vc_custom_1660717315754{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”font-weight-medium” link=”url:https%3A%2F%2Fdilytics.com%2Fsuccess-stories%2F|title:Success%20Stories”][/vc_column][vc_column][rt_case_study_style case_study_style_variation=”seven” case_study_display_filter=”no” case_study_enable_title=”yes” case_study_enable_excerpt=”yes” case_study_spacing=”30″ case_study_looping_sort=”ASC” no_of_case_studies=”3″][/vc_column][/vc_row][vc_row][vc_column][vc_empty_space][/vc_column][/vc_row]