Posts Tagged ‘Hyperion’

Amazon Web Services’ (AWS) low-cost S3 cloud storage provides a cost-efficient solution to archive snapshot files extracted from Oracle Planning and Budgeting Cloud Service (PBCS). In the following paragraphs, I will use the AWS Command Line interface (CLI) to upload to the Amazon S3 bucket to archive backup files pulled down from a PBCS instance. […]

The ability to create different versions of hierarchies within Oracle Data Relationship Management (DRM) is one of the tool’s biggest benefits. The definition of a version is simply the grouping of hierarchies. This simple, yet effective, function allows organizations to create versions for several different types of scenarios: Grouping of hierarchies based on time periods […]

I breathed a sigh of relief last Friday when I learned that Microsoft had patched a vulnerability in March that was recently exploited by the WannaCrypt0r ransomware.  I opt to have Windows OS updates installed automatically on my workstation so I was protected before the ransomware poked through the crust from the bowels of its […]

Kscope17, ODTUG’s user conference known for providing a rich opportunity for networking and education on Oracle technologies, is quickly approaching and we’re excited to connect with you at the event. Perficient is proud to be a silver sponsor of Kscope17, which is being held June 25-29 in San Antonio. Visit us at booth #211 to […]

At Perficient, our SupportNet team uses a variety of tools for analyzing logs across the Oracle applications. There are a number of different file formats, which often makes parsing logs troublesome. We have adopted use of regular expressions to help parse the variety of formats that we have to routinely analyze. “A regular expression (regex […]

Every organization has a process for managing its data. It’s a must in today’s digital world. We all know this, but we also know that many organizations struggle with their data management processes. Especially those organizations that rely on common, multipurpose tools to do so. Email, phone calls, Excel spreadsheets, and ticketing systems can help facilitate the […]

Oracle Backup Policy “Oracle Planning and Budgeting Cloud creates the snapshot by backing up artifacts of all service components and Essbase data present in your service instance during the maintenance window. Because Oracle stores only the snapshots created in the most recent maintenance window, the artifacts and data available for restoration depend on their state […]

With the recent launch of Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS), Oracle adds yet another cloud-based application purposed to centralize and simplify your Planning application development and needs. EPBCS is uniquely positioned as being an out-of-the-box solution for your Financials, Workforce, Capital Expenditures, and Projects budgeting and forecasting requirements. Upon creating an Enterprise […]

I am often asked by clients to create reports that display alternating shaded rows. We’ve all been there, squinting away trying to view those tiny numbers crammed onto a single report. Too often we find ourselves relying upon a ruler to help follow the values across the row as the columns continue to grow across […]

There are several analytical capabilities that Oracle Enterprise Performance Management (EPM) products, whether Hyperion on-premises or Cloud EPM, have to offer. Financial reports and ad-hoc analysis in Excel are all great. However, in general EPM reporting capabilities remain restricted to whatever data you have in EPM. Are you looking to do one or more of […]

Fragmentation of Essbase block storage databases occurs as a result of routine data changes, data loads, and calculations. Essbase has two database statistics that measure database fragmentation: the average clustering ratio and the average fragmentation quotient. Check out this article from the Oracle Customer Engineering & Advocacy Lab for a more thorough description of BSO […]

After teaching several HFM 11.1.2.4 Create & Manage Applications courses, I have found several functionality advantages of HFM 11.1.2.4. User Functionality Greatest user improvement comes in Smart View and the Journals Extension. Users now have to ability to create and manage journal entries in Excel. We know that any time functionality can be completed in […]