latest…

FAQs answered for the new Clone Snapshot Oracle Cloud EPM Planning feature

April 22, 2021

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

April 14, 2021

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

April 8, 2021

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

March 25, 2021/in Uncategorized /by Nigel Youell

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

March 17, 2021/in EPBCS, PBCS /by Nigel Youell

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

March 12, 2021/in EPBCS, PBCS, Uncategorized /by Nigel Youell

Lydia Maksoud, Brovanture Consultant – explains the new cell-level security feature introduced as part of the March 2021 Oracle Cloud EPM update

Oracle EBS GL Balances to Oracle Cloud EPM Connection IMage

Customising the Oracle EBS GL Balances to Oracle Cloud EPM Connection

March 10, 2021/in ARCS, EPBCS, FCCS, PBCS, Uncategorized /by Nigel Youell

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

March 4, 2021/in ARCS, EPBCS, FCCS, PBCS, Uncategorized /by Nigel Youell

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

March 2, 2021/in Uncategorized /by Nigel Youell

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

February 26, 2021/in Uncategorized /by Nigel Youell

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

February 23, 2021/in EPBCS, PBCS /by Nigel Youell

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

February 18, 2021/in EPBCS, FCCS, PBCS, Uncategorized /by Nigel Youell

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

February 9, 2021/in EPBCS, FCCS, PBCS /by Nigel Youell

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’

February 2, 2021/in EPBCS, PBCS, Uncategorized /by Nigel Youell

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?

January 19, 2021/in Uncategorized /by Nigel Youell

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

January 13, 2021/in EPBCS, FCCS, PBCS /by Nigel Youell

Lydia Maksoud – Brovanture consultant, gives a step by step guide to using EPM Integration Agent Adapter

Oracle EPM Data Management update – Another Solution!

January 11, 2021/in EPBCS, FCCS, PBCS /by Nigel Youell

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

January 7, 2021/in EPBCS, PBCS /by Nigel Youell

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!!

January 4, 2021/in EPBCS, FCCS, PBCS, Uncategorized /by Nigel Youell

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’

December 22, 2020/in Uncategorized /by Nigel Youell

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

December 16, 2020/in Uncategorized /by Nigel Youell

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’!

February 27, 2020/in Uncategorized /by Nigel Youell

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

February 14, 2020/in OAC /by Nigel Youell

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

February 4, 2020/in Uncategorized /by Nigel Youell

Lydia Maksoud – Brovanture consultant, provides insight into handling Accounting Scenario in Oracle Cloud ERP

Lydia’s Story – Brovanture Six Years On

November 28, 2019/in EPBCS, Essbase, PBCS /by Nigel Youell

Lydia Maksoud – Brovanture consultant, looks back on six years at Brovanture

Loading multi-period row data in Oracle EPM Cloud Data Management

October 21, 2019/in EPBCS, FCCS, PBCS /by Nigel Youell

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

October 14, 2019/in EPBCS, FCCS, PBCS /by Nigel Youell

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

October 8, 2019/in EPBCS, PBCS /by Nigel Youell

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

October 4, 2019/in EPBCS, FCCS, PBCS /by Nigel Youell

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)

September 25, 2019/in Essbase, OAC /by Nigel Youell

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

September 18, 2019/in EPBCS, PBCS /by Nigel Youell

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

September 13, 2019/in Uncategorized /by Nigel Youell

Lydia Maksoud – Brovanture consultant, explains how to construct the URL to ensure it works

Robotic Process Automation (RPA) – Why does it matter to Finance?

August 29, 2019/in NetSuite /by Nigel Youell

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

August 1, 2019/in OAC /by Nigel Youell

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!

July 26, 2019/in Uncategorized /by Nigel Youell

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

July 24, 2019/in EPBCS /by Nigel Youell

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

July 23, 2019/in Uncategorized /by Nigel Youell

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

July 19, 2019/in Uncategorized /by Nigel Youell

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

July 15, 2019/in Uncategorized /by Nigel Youell

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

July 11, 2019/in Uncategorized /by Nigel Youell

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

July 10, 2019/in Uncategorized /by Nigel Youell

Mike Falconer – EPM Consultant, takes a detailed look into the future of Oracle Cloud planning

ODTUG KScope19 – Thoughts on the EPM Strategy Symposium

July 9, 2019/in Uncategorized /by Nigel Youell

Mike Falconer – EPM Consultant, my review of the EPM Strategy Symposium at ODTUG kscope19

Brovanture Wins Best Speaker Award at Premiere Oracle Conference

July 4, 2019/in Uncategorized /by Nigel Youell

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’

June 20, 2019/in Uncategorized /by Nigel Youell

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

May 3, 2019/in Uncategorized /by Nigel Youell

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

April 26, 2019/in EPBCS, Essbase, NetSuite, PBCS /by Nigel Youell

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

April 8, 2019/in Essbase, OAC, Uncategorized /by Nigel Youell

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

April 3, 2019/in Essbase, OAC, OBIEE, Uncategorized /by Nigel Youell

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

March 28, 2019/1 Comment/in Essbase, OAC, OBIEE, Uncategorized /by Nigel Youell

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

March 26, 2019/1 Comment/in Essbase, OAC, OBIEE, Uncategorized /by Nigel Youell

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

March 20, 2019/in NetSuite, PBCS /by Nigel Youell

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

March 13, 2019/in NetSuite, Uncategorized /by Nigel Youell

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

March 6, 2019/in Uncategorized /by Nigel Youell

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.

February 28, 2019/in FCCS /by Nigel Youell

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

February 12, 2019/in PBCS /by Nigel Youell

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

February 7, 2019/in PBCS /by Nigel Youell

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

February 4, 2019/in FCCS /by Nigel Youell

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…?

January 24, 2019/in EPBCS, PBCS /by Nigel Youell

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

January 2, 2019/in PBCS /by Nigel Youell

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

November 21, 2018/in Uncategorized /by Nigel Youell

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!

November 12, 2018/in Uncategorized /by Nigel Youell

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

November 6, 2018/in Uncategorized /by Nigel Youell

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

November 5, 2018/in Uncategorized /by Nigel Youell

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

August 27, 2018/in Uncategorized /by Nigel Youell

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

August 6, 2018/in Uncategorized /by Nigel Youell

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!

July 12, 2018/in home page /by evbond

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

June 29, 2018/in Uncategorized /by evbond

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

June 22, 2018/in Uncategorized /by Nigel Youell

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?

June 14, 2018/in Uncategorized /by evbond

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

May 31, 2018/in Uncategorized /by Nigel Youell

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?

May 2, 2018/in Uncategorized /by evbond

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

April 22, 2018/in Uncategorized /by Nigel Youell

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?

April 17, 2018/in Uncategorized /by evbond

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?

March 16, 2018/in home page /by brovanture

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

March 1, 2018/in home page /by brovanture

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

February 22, 2018/in Uncategorized /by evbond

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

February 7, 2018/in home page /by brovanture

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

February 1, 2018/in Uncategorized /by evbond

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?

January 23, 2018/in Uncategorized /by evbond

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?

January 15, 2018/in Uncategorized /by evbond

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

January 11, 2018/in home page /by brovanture

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

December 1, 2017/in Uncategorized /by Nigel Youell

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!

October 12, 2017/in home page /by brovanture

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

July 7, 2017/in Uncategorized /by Nigel Youell

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

June 20, 2017/in Uncategorized /by Nigel Youell

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

June 14, 2017/in Uncategorized /by Nigel Youell

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

June 5, 2017/in Uncategorized /by Nigel Youell

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

June 2, 2017/in Uncategorized /by Nigel Youell

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!

May 17, 2017/in Uncategorized /by Nigel Youell

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

May 10, 2017/in Uncategorized /by Nigel Youell

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

May 9, 2017/in Uncategorized /by Nigel Youell

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?

May 3, 2017/in Uncategorized /by Nigel Youell

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

April 26, 2017/in Uncategorized /by Nigel Youell

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

April 25, 2017/in Uncategorized /by Nigel Youell

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

April 19, 2017/in PBCS /by Nigel Youell

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

April 18, 2017/in Uncategorized /by Nigel Youell

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

April 12, 2017/in Uncategorized /by Nigel Youell

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

April 6, 2017/in Uncategorized /by Nigel Youell

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!

January 31, 2017/in PBCS, Uncategorized /by Nigel Youell

Jazmin Riberio, Brovanture Consultant – the October 2016 PBCS update saw the release of the “Enhanced Data Integration with Fusion Financials Cloud”

FAQs answered for the new Clone Snapshot Oracle Cloud EPM Planning feature

April 22, 2021

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

April 14, 2021

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

April 8, 2021

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

March 25, 2021

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

March 17, 2021

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

March 12, 2021

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

March 10, 2021

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

March 4, 2021

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

March 2, 2021

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

February 26, 2021

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

February 23, 2021

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

February 18, 2021

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

February 9, 2021

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’

February 2, 2021

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?

January 19, 2021

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

January 13, 2021

Lydia Maksoud – Brovanture consultant, gives a step by step guide to using EPM Integration Agent Adapter

Oracle EPM Data Management update – Another Solution!

January 11, 2021

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

January 7, 2021

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!!

January 4, 2021

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’

December 22, 2020

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

December 16, 2020

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’!

February 27, 2020

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

February 14, 2020

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

February 4, 2020

Lydia Maksoud – Brovanture consultant, provides insight into handling Accounting Scenario in Oracle Cloud ERP

Lydia’s Story – Brovanture Six Years On

November 28, 2019

Lydia Maksoud – Brovanture consultant, looks back on six years at Brovanture

Loading multi-period row data in Oracle EPM Cloud Data Management

October 21, 2019

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

October 14, 2019

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

October 8, 2019

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

October 4, 2019

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)

September 25, 2019

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

September 18, 2019

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

September 13, 2019

Lydia Maksoud – Brovanture consultant, explains how to construct the URL to ensure it works

Robotic Process Automation (RPA) – Why does it matter to Finance?

August 29, 2019

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

August 1, 2019

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!

July 26, 2019

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

July 24, 2019

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

July 23, 2019

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

July 19, 2019

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

July 15, 2019

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

July 11, 2019

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

July 10, 2019

Mike Falconer - EPM Consultant, takes a detailed look into the future of Oracle Cloud planning

ODTUG KScope19 – Thoughts on the EPM Strategy Symposium

July 9, 2019

Mike Falconer - EPM Consultant, my review of the EPM Strategy Symposium at ODTUG kscope19

Brovanture Wins Best Speaker Award at Premiere Oracle Conference

July 4, 2019

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’

June 20, 2019

At Brovanture we are committed to the wellbeing of our customers’…

Jazmin breaks 4 hour marathon

May 3, 2019

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

April 26, 2019

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

April 8, 2019

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

April 3, 2019

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

1 Comment

March 28, 2019

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

1 Comment

March 26, 2019

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

March 20, 2019

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

March 13, 2019

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

March 6, 2019

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.

February 28, 2019

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

February 12, 2019

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

February 7, 2019

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

February 4, 2019

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…?

January 24, 2019

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

January 2, 2019

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

November 21, 2018

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!

November 12, 2018

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

November 6, 2018

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

November 5, 2018

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

August 27, 2018

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

August 6, 2018

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!

July 12, 2018

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

June 29, 2018

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

June 22, 2018

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?

June 14, 2018

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

May 31, 2018

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?

May 2, 2018

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

April 22, 2018

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?

April 17, 2018

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?

March 16, 2018

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

March 1, 2018

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

February 22, 2018

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

February 7, 2018

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

February 1, 2018

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?

January 23, 2018

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?

January 15, 2018

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

January 11, 2018

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

December 1, 2017

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!

October 12, 2017

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

July 7, 2017

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

June 20, 2017

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

June 14, 2017

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

June 5, 2017

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

June 2, 2017

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!

May 17, 2017

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

May 10, 2017

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

May 9, 2017

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?

May 3, 2017

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

April 26, 2017

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

April 25, 2017

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

April 19, 2017

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.

when we have something to say

latest…

more…