when we have something to say
we like to share our Oracle EPM and ERP news and ideas when we have something worth reading to say – it maybe new products or updates, industry news, helpful product or process tips and tricks or just general news on what’s happening in both our, and our customers’ worlds – we’re on Twitter and LinkedIn, follow-us for updates!
Oracle Cloud EPM Pipelines – Batch Timeout in Minutes
Lydia Maksoud, Senior EPM Consultant, highlights a potential issue with Oracle Cloud EPM Pipelines timeout setting and how to solve this.
The Brovanture Team Perform in Nashville (KScope)!
Malcolm Brock Managing Director – three members of the Brovanture team presented at four well attended Kscope24 expert sessions
Brovanture Team at Kscope24
Malcom Brock, Managing Director – Meet members of the Brovanture team at Kscope24 Broanture where they will be presenting four expert sessions
The Future is Oracle Cloud EPM Redwood!
Lydia Maksoud, Senior EPM Consultant – makes sure users are aware that the Oracle Cloud EPM July 24.07 patch will only support the Oracle Cloud EPM Redwood theme.
Brovanture retains the Gold UKOUG EPM Partner of the Year Award in 2024
Malcolm Brock, Managing Director – The UKOUG Community Awards 2024 results are in and Brovanture is again #1 Oracle EPM Partner in the UK and IRE having been awarded the GOLD UKOUG EPM Partner of the Year Award
Brovanture Consultant Lydia Maksoud Shortlisted for the 2024 UKOUG Women in Tech Award
Malcolm Brock, Managing Director, announces that our Brovanture colleague Lydia Maksoud has been shortlisted for the 2024 UKOUG Women in Tech Award
Oracle ACEs – Brovanture now holds a pair!
Malcolm Brock, Managing Director – I am delighted to announce Sarah Dow has been appointed an Oracle Ace so now Brovanture now holds a pair!
Brovanture Nominated for UKOUG EPM Partner Award 2024
Malcolm Brock Managing Director – Brovanture has been nominated for the UKOUG EPM Partner of the Year Award for 2024
Tips for using REST API and Groovy to run jobs in Oracle Cloud EPM Planning
Sarah Ansell, Brovanture Senior EPM Consultant, shares tips for using REST API and Groovy to run jobs in Oracle Cloud EPM Planning
Brovanture Practice Leader Sarah Dow joins UKOUG Shine Mentoring Programme
Malcolm Brock, Managing Director, I am delighted to announce Sarah Dow has been accepted into the UKOUG Shine mentoring programme.
Oracle Cloud EPM Business Rules Custom Error Messages
Brovanture Consultant Richard Jeffries details how you can provide useful additional information when generating Oracle Cloud EPM Business Rules Custom Error Messages
Kscope24 Brovanture Team Sessions have been Selected
Malcolm Brock, Brovanture Managing Director, announces four Kscope24 Brovanture team expert sessions have been selected for the conference
Oracle Cloud EPM transaction matching tip for period mapping
Sarah Dow, Brovanture Practice Leader – Financial Close, shares a solution for pulling data from Oracle Cloud Fusion ERP for Oracle Cloud EPM transaction matching.
Utilising Oracle Cloud EPM Platform Jobs in Pipelines
Brovanture Consultant Lydia Maksoud explains utilising Oracle Cloud EPM platform jobs in Pipelines to schedule jobs in the required order, including pre-processing rules, data load rules and post-processing rules.
Oracle Cloud EPM pipelines – using substitution variables
Brovanture Consultant Lydia Maksoud, explains how substitution variables can be used in Oracle Cloud EPM pipeline scheduled jobs.
Brovanture continues support of students with work placement
Brandon Forword, Senior Project Manager at Brovanture, provides an update on our latest scheme to support students considering a career in IT consultancy.
Oracle Cloud EPM Feb 2024 Update – Important Actions & Considerations
Sarah Dow, Brovanture Practice Leader – Financial Close highlights that Oracle Cloud EPM Feb 2024 Update has Important Actions & Considerations which shouldn’t be overlooked as they may impact your applications!
Brovanture Extends its Graduate Training Scheme to South Africa
Kim Kannemeyer, South Africa Country Manager, announces that Brovanture has extended its Graduate Training Scheme in 2024 by appointing two outstanding graduates in South Africa.
Oracle Cloud EPM – setting user variable default values using Groovy
Lydia Maksoud, Brovanture Senior Consultant – explains how to set user variable values in Oracle Cloud EPM using Groovy.
Oracle Cloud EPM reports formulas – reference rows and columns
Sarah Ansell, Brovanture Consultant, explains how you can reference sub-rows and sub-columns within a formula in Oracle Cloud EPM reports
Why is Brovanture an Oracle EPM Partner?
Malcolm Brock, Brovanture Managing Director reveals the Ventana Research that confirms why Brovanture is an Oracle Partner and only sells Oracle EPM solutions
Why Oracle Cloud EPM Pipelines have all the answers!
Lydis Maksoud, Brovanture Senior Consultant explains the new Oracle Cloud EPM Pipelines and why it’s worth making the switch to Pipelines as soon as possible.
Brovanture Senior Consultant Lydia Maksoud Oracle ACEs it!
Malcolm Brock, Managing Director – congratulations to Brovanture Senior Consultant Lydia Maksoud who has been officially awarded Oracle ACE status
UKOUG Conference ‘23 – Brovanture team sessions announced
Malcolm Brock, Brovanture Managing Director reveals that two of the Brovanture team along with one of our clients, discoverIE, have been selected to present two sessions at the UKOUG Conference ’23
Anam – My first month at Brovanture
Anam Liaqat, new Brovanture Graduate Consultant, shares the experience of her first month on the Brovanture Graduate Development Scheme.
Setting up seven day rolling artifact snapshot backups for Oracle Cloud EPM Planning
Brovanture Consultant, Sarah Ansell, explains how to set up 7 Day Rolling Artifact Snapshot Backups for Oracle Cloud EPM Planning using Groovy Script.
Celebrating South Africa Women’s Day
South African Brovanture Consultant Kim Kannemeyer, encourages you to seek out a worthy cause for South Africa Women’s Day
Oracle Cloud EPM Latest Features – out with the old and in with the new!
Lydia Maksoud, Brovanture Consultant explains the Oracle Cloud EPM functionality that will no longer be available in the future and the new features that will be supported and enhanced.
Oracle’s MFA policy for Oracle Cloud Infrastructure (OCI) – Navigating Multi-Factor Authentication
Tej Bople, Brovanture Consultant delves into the details of Oracle’s MFA policy for Oracle Cloud Infrastructure (OCI) and explores the available options for customers to navigate this change effectively
Unlock the power of OCI: Building a Windows VM Server from scratch in an hour
Brovanture Consultant Tej Bhople provides the detailed steps to unlock the power of OCI: Building a Windows VM Server from scratch in an hour
Have you got a scenario plan for your water supplier’s insolvency?
Malcolm Brock, Managing Director, discusses the need for flexible scenario plans for crisis and long-range planning, cash forecasting, and more.
Kscope23 – Brovanture team presentations hit the spot
Lydia Maksoud, Brovanture Consultant – four members of the Brovanture team have been at KScope23 in Aurora, CO, USA this week giving presentations on Oracle Cloud EPM.
Oracle EPM Cloud Consolidation and Close – restricting viewing questions and comments in tasks
Emma Pawlyn, Brovanture Consultant, shows how attributes can be restricted from view when added to a task with the option “Do Not Display – Anywhere” set for a role type.
Top Five Oracle Cloud EPM Report Text Functions
Lydia Maksoud, Brovanture Consultant, reveals and explains her Top Five Oracle Cloud EPM Report Text Functions
Brovanture’s Thames Moonlight 10 Mile Walk for the Young Women’s Trust
Emma Pawlyn, Brovanture Consultant announces that Brovanture will be taking part in the Thames Moonlight 10 Walk on the evening of Friday 8th September raising money for Young Women’s Trust
Oracle Cloud EPM Redwood UX Design will be the only Theme Supported from 2024
Kim Kannemeyer, Brovanture Consultant, highlights the impending change to Oracle Cloud EPM Redwood UX Design in late 2023 when this theme will only be the only theme supported.
Brovanture is UKOUG EPM Partner of the Year 2023
Malcolm Brock, Brovanture Managing Director announces that Brovanture has been awarded UKOUG EPM Partner of the Year 2023
Automating Oracle Cloud EPM Data Integrations via Business Rules using REST API Commands
Sarah Ansell, Brovanture Consultant – explains automating Oracle Cloud EPM Data Integrations entirely within the cloud using Automate EPM Data Load Rules and without the need to install automation software on a server.
Oracle Cloud EPM Consolidation and Close – Changing the prompts for On-Demand rules
Emma Pawlyn, Brovanture Consultant – explains changing the prompts for on-demand rules in Oracle Cloud EPM Consolidation and Close
Brovanture listed at #2 in FeedSpot 25 Best Oracle EPM Blogs and Websites
Malcolm Brock, Managing Director – Brovanture has been listed at #2 in FeedSpot 25 Best Oracle EPM Blogs and Websites
Brovanture Nominated for UKOUG Partner Award 2023
Malcolm Brock, Managing Director – announces that this week Brovanture has been nominated for the UKOUG EPM Partner of the Year Award for 2023.
Loading Oracle Cloud ERP GL Balances to Oracle Cloud EPM Account Reconciliation
Brovanture Consultant, Lydia Maksoud explains the detailed steps for loading Oracle Cloud ERP GL balances to Oracle Cloud EPM account reconciliation
Oracle Cloud Infrastructure (OCI) Gen2 Migration for Oracle Cloud EPM
Tej Bhople, Brovanture Consultant, explains Oracle’s plans to migrate all Oracle Cloud EPM instances in Classic commercial data centres to OCI. This will affect all Oracle Cloud EPM instances.
Brovanture Shortlisted for Three Women in Tech Employer Awards 2023
Brovanture Managing Director, Malcolm Brock, announces that Brovanture has been shortlisted for three Women in Tech Employer Awards 2023
Kscope23 – Brovanture Team Have Been Selected to Present
Malcolm Brock, Managing Director, reveals the Kscope23 – Brovanture presentations on Oracle Cloud EPM which have been accepted
Utilising the Out-of-the-Box Oracle Cloud ERP Chart of Accounts integration
Lydia Maksoud, Brovanture Consultant, shows how to utilise the out-of-the-box Oracle Cloud ERP Chart of Accounts integration in Oracle Cloud EPM
Oracle Cloud EPM Account Reconciliations – Changing the Preparer on multiple profiles/reconciliations
Emma Pawlyn, Brovanture Consultant, explains how to change the preparer to a new or current employee in Oracle Cloud EPM Account Reconciliations
Streamlining adjustment period data load in Oracle Cloud – ERP to EPM
Lydia Maksoud, Brovanture Consultant – gives the inside track on how to streamline adjustment period data load from Oracle Cloud ERP to Oracle Cloud EPM
Oracle Hyperion to Oracle Cloud EPM – right change, right time?
Malcolm Brock, Brovanture Managing Director discusses when is the right time to transition from Oracle Hyperion on-premises EPM to the newer Oracle Cloud EPM solutions
Oracle Cloud EPM Audit Log Purge Enhancement
Sarah Dow, Brovanture Consultant – explains the Audit Log Purge road map enhancement item for Oracle Cloud EPM which is expected in the 2023 March release (23.03)
We are recruiting for the 2023 Brovanture Graduate Training Programme
Richard Jeffries, Graduate and Student Placement Manager, explains the Brovanture Graduate Training Programme and opens applications for the 2023 programme.
My First Week at Brovanture
Tej Bhople, Brovanture Consultant, shares the experience of her first week in her new role and new company at Brovanture. #wearebrovanture
Oracle Cloud EPM Consolidation and Close – Data Validations
Sarah Dow, Brovanture Consultant – answers ‘How do we add validations into the close process?’ when moving from Hyperion Financial Management (HFM) to Oracle Cloud EPM Consolidation.
Life at Brovanture
Sarah Ansell, Brovanture Consultant – shares what ‘Life at Brovanture’ has been like since her student placement in 2014 and subsequent employment as a business consultant.
Oracle EPM Cloud Planning: Hidden Member Property UDAs
Richard Jeffries, Brovanture Consultant, reveals hidden member property UDAs in Oracle EPM Cloud Planning and how they can be used to test for specific member properties.
Oracle Cloud EPM Data Management Multi Currency Load
Sarah Ansell, Brovature Consultant – reveals the simple steps within Oracle Data Management or Oracle Data Exchange to upload a data file that contains multiple currencies
Top 5 Oracle Cloud EPM Report Member Functions
Brovanture Consultant, Lydia Maksoud shares her top 5 Oracle Cloud EPM Report Member Functions that make reports more dynamic and reduce report maintenance going forward.
A Week is a Long Time in Planning, Budgeting and Forecasting!
Malcolm Brock, Brovanture Managing Director takes a look at how your organisation could get on the front foot with its planning, budgeting and forecasting
Brovanture Approved by Crown Commercial Services for G-Cloud 13
Malcolm Brock, Brovanture Managing Director – announces that Brovanture continues our UK Government approval with G-Cloud 13.
Oracle Cloud EPM Planning – UDA vs Attribute Dimensions vs Alternate Hierarchies
Lydia Maksoud, Brovanture Consultant – provides a comprehensive cheat sheet to help deciding between using a UDA, attribute dimension or an alternate hierarchy in Oracle Cloud EPM Planning.
Exploding the Myth Around Oracle Cloud EPM Integration
Malcolm Brock, Brovanture Managing Director explodes the myth circulating about Oracle Cloud EPM Integration
UPDATED – Loading valid intersections in bulk to Oracle EPM Cloud Planning
Mike Falconer, Brovanture Consultant – updates his explanation of loading valid intersections in bulk to Oracle EPM Cloud Planning
Customise Oracle Cloud EPM tooltips using Groovy
Lydia Maksoud, Brovanture Consultant –shows how to use groovy scripting to generate user Oracle Cloud EPM tooltips, depending on the cell being referenced.
Inflation, Stagflation, Recession – there has never been a greater need for driver-based financial planning and analysis
Brovanture MD, Malcolm Brock – discusses the need for driver-based financial planning and analysis
How to Create an Oracle Wallet SSL Certificate Request Containing Subject Alternative Name?
Guillaume Slee, Brovanture Services Director – shares his solution to creating an Oracle wallet SSL Certificate request containing subject alternative name
Oracle Hyperion FDMEE Integration to Oracle Cloud Financials with a Web Proxy
Ben Derrick, Brovanture Consultant – Shows how to integrate Oracle Hyperion FDMEE to Oracle Cloud Financials if your web traffic is routed through a proxy.
Oracle Hyperion EPM 11.2.8 FDMEE ODI Upgrade Issue
Guillaume Slee, Brovanture Services Director – provides the solution to an issue when upgrading an Oracle Hyperion 11.2.2 EPM environment to version 11.2.8
Finance Automation – Account Reconciliation Offers a Quick and Significant Win
Brovanture MD, Malcolm Brock – highlights the potential for a financial automation quick win with account reconciliation.
Marmite and the Case for Connected Enterprise Planning
Malcolm Brock, Managing Director – discusses why connected enterprise planning will be the key to an organisation’s ability to respond to the rate of change expected in 2022 and beyond
Solving the Computer Application Documentation Dilemma
Malcolm Brock, Brovanture MD – discusses the Brovanture solution to the software application ‘documentation dilemma’
Oracle renews Brovanture expertise Certifications for Oracle Cloud EPM solutions for 2022
Malcolm Brock, Managing Director – announces the renewal of Brovanture’s NEW Oracle PartnerNetwork expertise certifications for Oracle Cloud EPM for 2022 for Western Europe
Integrating Oracle Cloud EPM Planning with Power BI Pro
Mike Falconer, Brovanture Consultant – explains how to integrate Oracle Cloud EPM with Power BI
Oracle Analytics Cloud – Using CLI to Automate Starting-Stopping of Instances
Guillaume Slee, Services Director – explains the use of Oracle Command Line Interface to control instances in the new Gen2 Oracle Analytics Cloud (OAC) architecture
Intelligent Performance Management (IPM) in the November 2021 release of Oracle Cloud EPM
Lydia Maksoud, Brovanture Consultant – reveals the exciting new Intelligent Performance Management (IPM) functionality released as part of the November 2021 Oracle Cloud EPM update
Sustainability disclosure announcements at COP26 – will your reporting processes deliver?
Malcolm Brock, Managing Director – discusses the #IFRS Foundation announcement of the Climate Disclosure Standards Board (#CDSB) at #COP26 and asks will your reporting processes deliver?
Climate Scenario Planning – At COP26 Government Reveals Legislation for UK Organisations?
Malcolm Brock, Managing Director – discusses the COP26 announcement of UK Legislation for large UK Organisations to have Net-Zero climate scenario plans by 2023
Import a Hybrid Snapshot into Non-Hybrid Pod in Oracle EPM Cloud
Guillaume Slee, Brovanture Services Director – explains how to Import a Hybrid Snapshot into Non-Hybrid Pod in Oracle EPM Cloud without hitting an unsupported migration issue
FP&A teams – are you Climate Scenario Planning?
Malcolm Brock, Managing Director – discusses the requirement for integrating climate scenario planning into standard FP&A processes
Oracle Cloud ERP Segment updates your Oracle Cloud EPM Dimension with this simple integration
Mike Falconer, Brovanture Consultant – takes you through the process of creating a connection between your Oracle Cloud ERP and your Oracle Cloud EPM
Using Target Expressions in Oracle Cloud EPM Data Exchange
Lydia Maksoud, Brovanture Consultant – explains how to use Target Expressions in Oracle Cloud EPM Data Exchange as they are more efficient than data load mappings, especially for loading large data sets
Brovanture 2021 Graduate and Intern Cohort – Two Weeks In…
Brovanture 2021 Graduate and Intern Cohort – provide an update on their first two weeks
Brovanture Welcomes its New Graduate and Intern Cohort of 2021
Richard Jeffries, Brovanture Consultant – announces a record intake of new Brovanture graduate and intern participants in 2021 to its Oracle Cloud EPM training programme
Oracle EPM Cloud – Make the User Experience Simple & Intuitive with Direct Links
Guillaume Slee, Brovanture EPM Services Director – explains the new feature Oracle Cloud EPM, the ability to download direct links to any Oracle Cloud EPM navigation flow card or cluster.
Standard vs Native Oracle Smart View for Office Ad Hoc Behaviour
Lydia Maksoud, Brovanture Consultant – explains how to enable the additional enhanced ad hoc features in Oracle Smart View for Microsoft Office Standard Mode in the latest July (21.07) Oracle Cloud EPM patch
Spreadsheets and Tyranny!
Malcolm Brock, Brovanture Managing Director – discusses the ‘tyranny’ of spreadsheets and when organisations should be looking for Cloud application alternatives
Clear Target Data in Oracle Cloud EPM – ERP Integration Using a Data Exchange Clear Region
Sarah Ansell, Brovanture Consultant – shows how to use a Clear Region to wipe data from Oracle Cloud EPM Planning and Oracle Cloud ERP General Ledger for data integration via Data Exchange or Data Management.
Plan for the NEW Normal – 4 Essentials for Finance Departments
Malcolm Brock, Managing Director – discusses 4 essentials to consider as Finance departments start to think about 2021 H2 Planning
Oracle Cloud EPM – Integrating Consolidation and Close with Planning
Jazmin Ribeiro, Brovanture Consultant – takes you through setting up an Oracle Cloud EPM integration with Consolidation and Close as the source and Planning as the target
FAQs answered for the new Clone Snapshot Oracle Cloud EPM Planning feature
Sarah Ansell, Brovanture Consultant – provides a ‘what you need to know’ blog about the latest new Oracle Cloud EPM Planning feature: Clone Snapshot
Drill-through from Oracle Cloud EPM Planning to Oracle EBS
Lydia Maksoud, Brovanture Consultant – shows how to setup the drill-through component for a specific data intersection in Oracle Cloud EPM Planning opening the relevant balances in Oracle EBS.
Connecting Oracle Cloud EPM Planning to Apex with Rest API: Running Jobs from Apex Part 2 of 2
Richard Jeffries, Brovanture Consultant – completes his explanation of how to run jobs in Oracle Cloud EPM Planning from Apex
Brovanture’s investment in our workforce continues to deliver for clients and staff
Malcolm Brock, Managing Director – celebrates the achievement of Brovanture consultant Jazmin Ribeiro ACMA, CGMA
Connecting Oracle Cloud EPM Planning to Apex with Rest API: Running Jobs from Apex Part 1 of 2
Richard Jeffries, Brovanture Consultant – explains how to run jobs in Oracle Cloud EPM Planning from Apex
Oracle Cloud EPM Planning – Cell-Level Security Definitions & Testing
Lydia Maksoud, Brovanture Consultant – explains the new cell-level security feature introduced as part of the March 2021 Oracle Cloud EPM update
Customising the Oracle EBS GL Balances to Oracle Cloud EPM Connection
Lydia Maksoud, Brovanture Consultant – solves the difficulty of updating multiple historic periods and multiple ledgers balances in Oracle EBS with an Oracle Cloud #EPM connection
Brovanture achieves Oracle Expertise Certifications for Oracle Cloud EPM Solutions
Malcolm Brock, Managing Director – announces that Brovanture has been awarded the NEW Oracle PartnerNetwork Certifications for Oracle Cloud EPM Solutions
Oracle Hyperion EPM 11.2 – How to Start OHS Remotely
Guillaume Slee, Brovanture EPM Services Director – explains how, in a clustered EPM 11.2.x environment, to start a second instance of OHS from a primary Foundation server?
Brovanture Ltd Announces UK Partnership with AMANA Consulting GmbH
Malcolm Brock, Managing Director – announces the signing of a partnership with AMANA Consulting GmbH to sell, implement and support their IFRS16 and XBRL software solutions in the UK.
Connecting Oracle Cloud EPM Planning to Apex with Rest API: Separating Substitution Variable access by User
Richard Jeffries, Brovanture Consultant – explains out how to apply granular security to your Oracle Cloud EPM Planning application’s substitution variables within Apex.
‘Reports’ – Next Generation Reporting in Oracle Cloud EPM
Cristina Arzuza, Brovanture Consultant – shares with you the capabilities and potential of the new generation reporting tool, ‘Reports’, in Oracle Cloud EPM.
Oracle Smart View for Office drill-through to Microsoft Excel in Oracle EPM Cloud
Mike Falconer, Brovanture Consultant, highlights a new feature in Oracle EPM Cloud to use Microsoft Excel in Oracle Smart View for Office to directly drill-through to source data.
Connecting Oracle EPM Cloud Planning to Apex with Rest API: POST Substitution Variables ‘Extras’
Richard Jeffries, Brovanture Consultant – completes his series of blogs on how to build the connector between the web source modules and an Oracle Cloud EPM Planning application
Oracle Hyperion EPM 11.2.x – Where did my Oracle Wallet Manager Go?
Guillaume Slee, EPM Services Director – warns of the problem of the missing Oracle Wallet Manager when installing Oracle Hyperion EPM 11.2.x
Loading Oracle EBS GL Balances to Oracle Cloud EPM using the EPM Integration Agent Adapter
Lydia Maksoud – Brovanture consultant, gives a step by step guide to using EPM Integration Agent Adapter
Oracle EPM Data Management update – Another Solution!
Malcolm Brock, Managing Director – UPDATED POST to a change in Oracle EPM Data Management that could create issues for Oracle EPM Cloud users.
Connecting Oracle Cloud EPM Planning to Apex with Rest API – Part 2: Running Jobs in Oracle Cloud EPM Planning from Apex
Richard Jeffries, Brovanture Consultant – outlines how to build the connector between the web source modules and an Oracle Cloud EPM Planning application
Don’t let an Oracle EPM Data Management update spoil your New Year!!
Malcolm Brock, Managing Director – reveals a change in Oracle EPM Data Management that could create issues for Oracle EPM Cloud users.
Brovanture Support – Why you Should ‘Lean on Us’
Malcolm Brock, Managing Director – why should you ‘lean on Brovanture’ for your support for Oracle EPM Cloud and Oracle Hyperion on-premises software applications.
Connecting Oracle Cloud EPM Planning to Oracle Apex with Rest API – Part 1: GET Substitution Variables
Richard Jeffries, Brovanture Consultant – outlines how to create a table in Oracle Apex that dynamically pulls through the substitution variables from an Oracle Cloud EPM Planning
Finance ‘Just in Time’!
Malcolm Brock, Managing Director – Finance and Manufacturing have many similarities so what could Finance learn from modern manufacturing techniques?
Oracle Analytics Cloud (OAC) Remote Data Gateway Part 2: The RPD
Guillaume Slee, EPM Services Director – shows how to get the Oracle Analytics Cloud (OAC) RPD semantic layer to connect to on-premises applications using the Data Gateway facility
Clear a GL Accounting Scenario in the Oracle Cloud ERP Essbase database
Lydia Maksoud – Brovanture consultant, provides insight into handling Accounting Scenario in Oracle Cloud ERP
Lydia’s Story – Brovanture Six Years On
Lydia Maksoud – Brovanture consultant, looks back on six years at Brovanture
Loading multi-period row data in Oracle EPM Cloud Data Management
Lydia Maksoud – Brovanture consultant, explains the process for loading multi-period row data in Oracle EPM Cloud Data Management
EPM Automate Migrating large Snapshots using: copysnapshotfrominstance
Sarah Ansell, Brovanture Consultant – Shows how to create a simple script to manage your migration process between environments that works no matter how large your Snapshots grow
Getting Started with REST API’s using Python
Duncan Brock, Brovanture EPM consultant – REST APIs open the door to a whole world of additional programming languages, but the Oracle documentation only scratches the surface of what is possible…
UK government reaffirms commitment to using Oracle with Cloud Memorandum of Understanding
Malcolm Brock, Managing Director – Oracle and UK Government agreement is good news for all parties delivering Oracle Cloud Services to UK Government organisations
Oracle Analytics Cloud (OAC) – Starting and stopping instances using the REST API (Autonomous/Oracle Managed)
Guillaume Slee, EPM Services Director – shows how REST API calls can be used with Oracle Managed OAC instances to allow you to stop and start your instances
Connecting to multiple Oracle Cloud Environments
Sarah Ansell, Brovanture Consultant shows you how to save valuable time by creating a Smart View environments short-cut to connect to multiple EPBCS environments
Setting up a Direct Link to a ‘Planning in the Oracle EPM Cloud’ Form or Dashboard
Lydia Maksoud – Brovanture consultant, explains how to construct the URL to ensure it works
Robotic Process Automation (RPA) – Why does it matter to Finance?
Malcolm Brock, Managing Director – discusses how RPI can improve the efficiency and effectiveness of your finance organisation
OAC Remote Data Gateway: Connecting to MS SQL Server
Guillaume Slee, EPM Services Director – how to use OAC Remote Data Gateway to connect an OAC instance to an on-premises MS SQL Server database
Brovanture Rises to G-Cloud 11!
Malcolm Brock, Managing Director – Brovanture announces approval of eight of its services, covering hosting, software and support, through the UK Government G-Cloud 11 framework
Write Back Budgets from PBCS to Oracle Fusion ERP Cloud
Lydia Maksoud – Brovanture consultant, extends how to integrate Oracle Cloud ERP and EPM with the inside track on writing back plans, budgets and forecasts to ERP
Integrating PBCS with Oracle Fusion ERP Cloud
Lydia Maksoud – Brovanture consultant, gives the low down on how to integrate Oracle Cloud ERP and EPM plus tips on what can go wrong and how to fix it
Setting up a Custom Role for a NetSuite to PBCS Integration
Mike Falconer – EPM Consultant, gives the inside track on setting up a custom role for an Oracle NetSuite to PBCS integration
Significant changes to the Oracle EPM Cloud offering
Jazmin Ribeiro, Brovanture Consultant – explains the significant changes to the way Oracle are packaging and pricing their EPM Cloud solutions
ODTUG KScope19 – Deep-Dive into Data Integration
Mike Falconer – EPM Consultant, takes a detailed look into the future of data integration
ODTUG KScope19 – Deep-Dive into the future of Oracle Cloud Planning, Budgeting and Forecasting
Mike Falconer – EPM Consultant, takes a detailed look into the future of Oracle Cloud planning
ODTUG KScope19 – Thoughts on the EPM Strategy Symposium
Mike Falconer – EPM Consultant, my review of the EPM Strategy Symposium at ODTUG kscope19
Brovanture Wins Best Speaker Award at Premiere Oracle Conference
Guillaume Slee – EPM Services Director, last week members of the Brovanture team attended the @ODTUG #Kscope19 conference in Seattle
Brovanture sees Cyber Essentials Certification as ‘Essential’
At Brovanture we are committed to the wellbeing of our customers’ IT systems and data whether we supplied them all, or not. This means we have to be sure of the integrity of our own systems and to be able to demonstrate we have and are continuing to do the right thing on security. One […]
Jazmin breaks 4 hour marathon
Malcolm Brock, Managing Director – Jazmin Ribeiro one of our consultants raises over £1000 pounds for charity and runs the London Marathon in under 4 hours
Brovanture Session at ODTUG Kscope19 Highlighted
Malcolm Brock, Managing Director – the Brovanture session ‘Integrating EPBCS with the Oracle Cloud’ at ODTUG Kscope19 is highlighted by Oracle Ace, Jon Harvey, conference EPM Data Integration Track lead
OAC – Essbase Streaming Dataload from SQL Server Database
Guillaume Slee EPM Services Director, Brovanture – In my latest blog post I take a look at streaming to the OAC Essbase cloud from a MS SQL Server source.
OAC – Scripted Backups on Autonomous
Guillaume Slee EPM Services Director, Brovanture – In this blog post I explain how to schedule a backup of your BI and Essbase applications using the esscs/esscli command line REST API wrapper to perform an LCM backup, as well as using the MaxL client to perform data exports.
OAC – Bulk Importing Users & Groups via IDCS REST API
Guillaume Slee EPM Services Director, Brovanture – In my previous post we saw how it’s possible to bulk import users using a CSV file. Here we look at how we can automate creating/importing users using the IDCS REST API.
OAC – Bulk Importing Users & Groups via the IDCS UI
Guillaume Slee, EPM Services Director at Brovanture – A key part of Cloud SaaS is integrating it with your existing systems. This blog will show you how to bulk import users manually via the IDCS UI.
Connecting two Clouds – NetSuite to Oracle PBCS Cloud-to-Cloud Integration
Mike Falconer, Brovanture Consultant – Connecting a source system to a forecasting system is rarely straightforward. Therefore, when an opportunity arises to ditch the shackles of extract-based integrations and migrate entirely through the cloud, one must grasp that opportunity with both hands – And I will show you how.
Cloud Automation Helps Finance Teams Save Time and Refocus On Strategy
Gary Boniface, Brovanture Consultant – forward-thinking business leaders are automating financial processes end to end
OAC – How to Create Oracle Autonomous Essbase and OBI Analytics Cloud Instances
Guillaume Slee, EPM Services Director at Brovanture – Here I will show how easy it is to spin up new OAC instances, create an Essbase instance and a Business Intelligence Enterprise instance.
Guide to building a Financial Dashboard in FCCS.
Sarah Dow, Brovanture Consultant – creating your own dashboards in FCCS is easy when you know how, with each graph facilitating drill down to explore the data in more detail
FDMEE System Maintenance Tasks: Maintain Setup Data
Lydia Maksoud, Brovanture Consultant – As well as staging table data, Data Management/FDMEE stores various setup components in SQL tables behind the scenes. There are a number of ‘System Maintenance Tasks’ within data management which can be used to update and maintain these hidden tables.
Moira Jacques Nominated for an Oracle Change Agents of Finance Award
Malcolm Brock, Managing Director Brovanture – Moira Jacques, Commercial Finance Controller at Edrington-Beam Suntory UK Distribution Limited is nominated for the Crystal Ball Award in the 2019 Oracle Change Agents of Finance Awards.
Creating an Infolet in Oracle FCCS
Sarah Dow, Brovanture Consultant – Oracle FCCS Infolets are a great way to display key high-level static information this blog explains how to set them up
Brexit – Do you have a plan B, C, D, E, F, G, H…?
Malcolm Brock, Managing Director – Dealing with a complex set of scenarios like this and maintaining control, plus really understanding the variables and their implications, is a big task and vitally important right now.
PBCS Cheap Tricks – Quick and Easy Backup Process
Mike Falconer, Brovanture Consultant – the November 2018 PBCS update for EPM Automate has come with a neat new command that can really streamline your rolling backup process
PBCS Cheap Tricks – Dealing with Dates and Depreciation
Mike Falconer, Brovanture Consultant – dates have been the bane of many a Hyperion Administrator’s life for about 20 years now and this is mostly due to the inconsistency in the business rule formulae surrounding them
UKOUG EPM Partner of the Year – Brovanture win gold!
Mike Fitzgibbon, Marketing Manager – Brovanture WON GOLD at the 2018/19 UKOUG Partner of the Year awards in London on 4 October 2018
Integrating Oracle PBCS with Power BI Pro
Mike Falconer, Brovanture Consultant – Have you ever wanted to visualise your forecast using state of the art tools? – here’s how…
how automation is changing the finance function
Gary Boniface, Brovanture Consultant – While the implementation of automation in accounting in most businesses is still in the early stages, the future is coming faster than you might think…
Customise and Simplify Drill-Through Regions in PBCS
Mike Falconer, Brovanture Consultant – Setting up a demanding FDMEE schedule for a global business who required half-hourly updates from their source system
My Placement Year at Brovanture
Richard Jefferies, Brovanture placement student – The role turned out to be a perfect mixture between technology and finance, building and fixing financial systems without the repetitive tasks involved in actually using them
Brovanture Ascends from G-Cloud 9 to G-Cloud 10!
Malcolm Brock, Managing Director Brovanture –
We were on Cloud 9 but now we are Cloud 10!, literally, with the approval of eight of the services Brovanture provides, covering hosting, software and support, through the UK Government G-Cloud 10 framework
Brovanture is Nominated for UKOUG EPM Partner of the Year Award
Malcolm Brock, Managing Director Brovanture – Whatever the result, we will carry on delivering great service and most importantly putting our customers first in everything we do
PBCS: Financial Report Bursting to the File System
Guillaume Slee, Brovanture Director – many users in the EPM on-prem world use the Financial Reporting bursting feature to burst out 100s of reports but what about EPM Cloud?
EPM Market Consolidation Time Again? Should you be Considering Your Options?
Malcolm Brock, Managing Director Brovanture – Out of the blue this week, Workday announced its acquisition of the Cloud planning vendor Adaptive Insights, just before a planned IPO
Transfer of Smart List Values to Members in Calculation Manager
Sarah Ansell, Brovanture Consultant – Retrieving and transforming a Smart List entry (stored against a dimension member) into a member name to be used within a calculation script
Could Your Next IT Project Drive You to Your Knees?
Malcolm Brock, Managing Director Brovanture – For over a week now, the UK ‘High Street’ bank TSB has been reeling under bad press and customer pressure because its switch over to new IT systems
Loading Metadata using PBCS Data Management
Lydia Maksoud, brovanture consultant – After much anticipation, the ability to load metadata from a flat file into (e)PBCS is now supported using the inbuilt data loading ETL tool Data Management
How Close Are You to a Spreadsheet Disaster?
Malcolm Brock, Managing Director Brovanture – Monday morning (9 April 2018), reading The Times newspaper Business Section I was struck by the headline ‘Spreadsheets plus human error can add up to disaster’
Are You Prepared for A Cyber Attack?
Malcolm Brock, Managing Director Brovanture – Reading the news this week I was struck by an expert discussing the implications of the current Sergei Skripal poisoning incident in Salisbury in the UK
The ‘Beast from the East’ and Month End
Malcolm Brock, Managing Director Brovanture – Without the right systems and technology, the result will be that month end processes cannot be completed so dates will be missed and vital information needed to plan and make decisions will be late
The ‘Ultimate Question’ for FP&A
Malcolm Brock, Managing Director Brovanture – For FP&A, Planning, Budgeting and Forecasting and the ‘ultimate question’, in my experience it has to be…
Taking Oracle Planning and Budgeting Cloud Service Beyond Finance
Malcolm Brock, Managing Director Brovanture – Much is talked about broadening the horizons of planning, budgeting and forecasting and how organisations should adopt a truly ‘enterprise’ approach…
Our Focus is on Customer Success
Malcolm Brock, Managing Director Brovanture – On the 15 January 2018 Brovanture became the 1st Oracle Fully Certified Cloud Excellence Implementer (CEI) for EPM…
New 2018 UK Growth Optimism – Are You Prepared?
Malcolm Brock, Managing Director Brovanture – Last week I wrote about gloomy predictions for the UK hotel sector in 2018. What a difference a week can make!
2018 UK Hotel Market – Bull to Bear?
Malcolm Brock, Managing Director Brovanture – We don’t expect the growth in 2018 to match 2017, even though the outlook is broadly positive for the UK hotels sector…
Maximising the Return on Public Sector IT Investment
Malcolm Brock, Managing Director Brovanture – For Public Sector organisations there is significant relevance in this. Austerity has put great pressure on their budgets and is driving a ‘doing more for less’ revolution
Smart Lists as Run Time Prompts
Sarah Ansell, Brovanture Consultant – Smart Lists are very powerful tools within Planning Budgeting Cloud Service (PBCS) software
When it comes to financial software, Darwin has a point!
Malcolm Brock, Managing Director Brovanture – Good financial software solutions are designed based on current best practice and end to end processes. What organisation would not want to adopt these best practices?
FDMEE Tips: Using Factors in Import Formats
Lydia Maksoud, Brovanture Consultant – Import expressions can be added to an FDMEE import format to alter the data being imported from a file in several valuable ways
An introduction to Predictive Planning
Sarah Ansell, Brovanture Consultant – Predictive Planning is an extension to Oracle Hyperion Smart View for Office that can be used to display predictions based on historical data
FDMEE Automation – Automatically Identifying the process ID
Mike Falconer, EPM Consultant – here is another neat way of identifying what can often be a useful variable in your data load, the process ID
FDMEE Automation – automatically identifying the load period
Mike Falconer, EPM Consultant – a couple of tips and tricks for this blog related to how to identify key inputs into the data load process!
PBCS workflow approvals via iPhone and Android
Lydia Maksoud, Brovanture Consultant – Workflow processes can be set up in PBCS applications to manage the progress and approval of a specific work task
FDMEE Automation – send email notification reports automagically!
Mike Falconer, EPM Consultant – This is the first of a multi-part series exploring techniques that can be used in an automated data load into PBCS using FDMEE
SharePoint quietly shifts to OneDrive for a week
Mike Falconer, EPM Consultant – For those unacquainted with OneDrive, it essentially functions as Microsoft’s answer to Dropbox, or similar cloud storage solutions
PBCS Stealth Update – reports won’t prompt for input
Mike Falconer, EPM Consultant – As we all know, PBCS is being updated all the time. This adaptability is one of PBCS’s greatest strengths but can also be a weakness.
What’s going on with my business rule security?
Mike Falconer, EPM Consultant – All my standard checks came up empty. In desperation I turned to another cheap support trick, creating a user with similar access.
Branding your Cloud and FCCS
Mike Falconer, EPM Consultant – How do I brand my own interface? The Branding options are found under Tools > Appearance.
Using SQL to map null values to ignore
Lydia Maksoud, Brovanture Consultant – there is a way around this using a custom SQL mapping script to define your own mappings and this blog is here to show you how
Loading valid intersections in bulk to Oracle PBCS
Mike Falconer, EPM Consultant – A very useful feature of PBCS over traditional Oracle Hyperion Planning is the ability to define Valid Intersections of your dimension members. This means you can restrict your users to only enter data into specific intersections of several dimensions which you define.
Data copy in an ASO Application
Lydia Maksoud, Brovanture Consultant – One of the main problems with ASO databases in the past was finding a way to perform calculations such as a standard data copy from one member to another
Using EPM Automate to back up your PBCS application
Lydia Maksoud, Brovanture Consultant – EPM Automate is a utility which enables service administrators to remotely perform a selection of routine tasks on their PBCS system
Sneaky new PBCS features
Jazmin Ribeiro, Brovanture Consultant – new admin features in PBCS that we can’t recall being mentioned in the monthly update documents
It’s new & it works!
Jazmin Riberio, Brovanture Consultant – the October 2016 PBCS update saw the release of the “Enhanced Data Integration with Fusion Financials Cloud”