when we have something to say
we like to share our 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 Smart View for Office drill-through to Microsoft Excel in Oracle EPM Cloud
/in EPBCS, FCCS, PBCS /by Nigel YouellMike 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’
/in EPBCS, PBCS, Uncategorized /by Nigel YouellRichard 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?
/in Uncategorized /by Nigel YouellGuillaume 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
/in EPBCS, FCCS, PBCS /by Nigel YouellLydia Maksoud – Brovanture consultant, gives a step by step guide to using EPM Integration Agent Adapter
Oracle EPM Data Management update – Another Solution!
/in EPBCS, FCCS, PBCS /by Nigel YouellMalcolm 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
/in EPBCS, PBCS /by Nigel YouellRichard 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!!
/in EPBCS, FCCS, PBCS, Uncategorized /by Nigel YouellMalcolm 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’
/in Uncategorized /by Nigel YouellMalcolm 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
/in Uncategorized /by Nigel YouellRichard 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’!
/in Uncategorized /by Nigel YouellMalcolm 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
/in OAC /by Nigel YouellGuillaume 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
/in Uncategorized /by Nigel YouellLydia Maksoud – Brovanture consultant, provides insight into handling Accounting Scenario in Oracle Cloud ERP
Lydia’s Story – Brovanture Six Years On
/in EPBCS, Essbase, PBCS /by Nigel YouellLydia Maksoud – Brovanture consultant, looks back on six years at Brovanture
Loading multi-period row data in Oracle EPM Cloud Data Management
/in EPBCS, FCCS, PBCS /by Nigel YouellLydia 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
/in EPBCS, FCCS, PBCS /by Nigel YouellSarah 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
/in EPBCS, PBCS /by Nigel YouellDuncan 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
/in EPBCS, FCCS, PBCS /by Nigel YouellMalcolm 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)
/in Essbase, OAC /by Nigel YouellGuillaume 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
/in EPBCS, PBCS /by Nigel YouellSarah 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
/in Uncategorized /by Nigel YouellLydia Maksoud – Brovanture consultant, explains how to construct the URL to ensure it works
Robotic Process Automation (RPA) – Why does it matter to Finance?
/in NetSuite /by Nigel YouellMalcolm 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
/in OAC /by Nigel YouellGuillaume 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!
/in Uncategorized /by Nigel YouellMalcolm Brock, Managing Director – Brovanture announces approval of eight of its services, covering hosting, software and support, through the UK Government G-Cloud 11 framework
Integrating PBCS with Oracle Fusion ERP Cloud
/in Uncategorized /by Nigel YouellLydia 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
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellJazmin 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
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellMike Falconer – EPM Consultant, takes a detailed look into the future of Oracle Cloud planning
ODTUG KScope19 – Thoughts on the EPM Strategy Symposium
/in Uncategorized /by Nigel YouellMike Falconer – EPM Consultant, my review of the EPM Strategy Symposium at ODTUG kscope19
Brovanture Wins Best Speaker Award at Premiere Oracle Conference
/in Uncategorized /by Nigel YouellGuillaume 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’
/in Uncategorized /by Nigel YouellAt 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
/in Uncategorized /by Nigel YouellMalcolm 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
/in EPBCS, Essbase, NetSuite, PBCS /by Nigel YouellMalcolm 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
/in Essbase, OAC, Uncategorized /by Nigel YouellGuillaume 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
/in Essbase, OAC, OBIEE, Uncategorized /by Nigel YouellGuillaume 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/in Essbase, OAC, OBIEE, Uncategorized /by Nigel YouellGuillaume 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/in Essbase, OAC, OBIEE, Uncategorized /by Nigel YouellGuillaume 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
/in NetSuite, PBCS /by Nigel YouellMike 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
/in NetSuite, Uncategorized /by Nigel YouellGary 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
/in Uncategorized /by Nigel YouellGuillaume 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.
/in FCCS /by Nigel YouellSarah 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
/in PBCS /by Nigel YouellLydia 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
/in PBCS /by Nigel YouellMalcolm 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
/in FCCS /by Nigel YouellSarah 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…?
/in EPBCS, PBCS /by Nigel YouellMalcolm 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
/in PBCS /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellMike 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!
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellGary 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
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellRichard 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!
/in home page /by evbondMalcolm 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
/in Uncategorized /by evbondMalcolm 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
/in Uncategorized /by Nigel YouellGuillaume 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?
/in Uncategorized /by evbondMalcolm 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
/in Uncategorized /by Nigel YouellSarah 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?
/in Uncategorized /by evbondMalcolm 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
/in Uncategorized /by Nigel YouellLydia 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?
/in Uncategorized /by evbondMalcolm 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?
/in home page /by brovantureMalcolm 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
/in home page /by brovantureMalcolm 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
/in Uncategorized /by evbondMalcolm 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
/in home page /by brovantureMalcolm 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
/in Uncategorized /by evbondMalcolm 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?
/in Uncategorized /by evbondMalcolm 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?
/in Uncategorized /by evbondMalcolm 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
/in home page /by brovantureMalcolm 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
/in Uncategorized /by Nigel YouellSarah 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!
/in home page /by brovantureMalcolm 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
/in Uncategorized /by Nigel YouellLydia 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
/in Uncategorized /by Nigel YouellSarah 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
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellLydia 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!
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellMike 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?
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellLydia 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
/in PBCS /by Nigel YouellMike 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
/in Uncategorized /by Nigel YouellLydia 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
/in Uncategorized /by Nigel YouellLydia 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
/in Uncategorized /by Nigel YouellJazmin 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!
/in PBCS, Uncategorized /by Nigel YouellJazmin Riberio, Brovanture Consultant – the October 2016 PBCS update saw the release of the “Enhanced Data Integration with Fusion Financials Cloud”