BizTech_Blog_Header

BizTech Blog

Integrate, Consolidate, Translate, and Validate using Oracle Hyperion Financial Management

Author: Stephen Goldsmith Date: Nov 1, 2012 9:52:00 AM

Categories: Oracle Business Intelligence, Fusion Applications, Hyperion EPM

Oracle Hyperion Financial Management (HFM) is a comprehensive, Web-based application that delivers global financial consolidation, reporting and analysis in a single, highly scalable software solution.

HFM utilizes today's most advanced technology, yet is built to be owned and maintained by the enterprise's finance team.

Read More

Less Paralysis, More Analysis

Author: Stephen Goldsmith Date: Oct 26, 2012 1:50:00 PM

Categories: Oracle Business Intelligence, Fusion Applications, Hyperion EPM

Enterprise Performance Management (EPM) is defined as a management field of Business Performance Management which considers the visibility of operations in a closed-loop model across all facets of the enterprise. There are several emerging domains in the EPM field which are being driven by corporate initiatives, academic research, and commercial approaches including: Strategy Formulation, Business Planning and Forecasting, Financial Management, and Supply Chain Effectiveness.

Read More

Operating Room Business Intelligence, Lessons Learned from Manufacturing Companies

Author: Stephen Goldsmith Date: Oct 22, 2012 2:16:36 PM

Categories: Oracle Business Intelligence

With continued mounting pressures to reduce healthcare costs, healthcare providers can leverage the lessons learned in the 90’s by the world’s leading manufacturing companies. This blog is the first in a series of blogs that will discuss how healthcare organizations can employ manufacturing best practices to reduce costs, increase efficiency and improve patient satisfaction. Given that this is a business intelligence blog, the focus will be on how existing data can be transformed into information to achieve the aforementioned healthcare objectives.

The first area of focus, the operating room, has several manufacturing parallels. Think of an operating room as a machine that is very expensive to operate and has a fixed amount of capacity that must be optimally used to maximize utilization. Downtime due to poor scheduling or delays in preceding processes impacts utilization, output and customer satisfaction.

Read More

Four CSV files for OBIA Financial Analytics

Author: Stephen Goldsmith Date: Oct 22, 2012 11:42:00 AM

Categories: Oracle Business Intelligence

Group Accounts ranges varies from client to client and that is the reason why the user is given the ability to enter their input defining the group accounts for accounting purpose in OBIA.

But there is a standard anyone has to follow for defining the group accounts. There are three csv’s that help you define the group accounts and those group accounts fall into either Balance Sheet or P&L:

Read More

OBIEE 11.1.1.6.2 issues

Author: Stephen Goldsmith Date: Oct 22, 2012 9:54:00 AM

Categories: Oracle Business Intelligence

The latest bundle patch set has been available for OBIEE for a few months now. We have noticed an issue where the SQL generated by the RPD is different after the Patch set is applied.

Read More

Oracle Hyperion: A Better Plan for Planning

Author: Stephen Goldsmith Date: Oct 17, 2012 3:34:00 PM

Categories: Oracle Business Intelligence, Fusion Applications, Hyperion EPM

Does this Typical Planning (Budget) Process sound familiar?

Read More

Setting up iBots in OBIEE 11 g

Author: Stephen Goldsmith Date: Oct 3, 2012 3:28:00 PM

Categories: Oracle Business Intelligence

This post explains how to setup ibots in OBIEE 11g. In this case, the ibot setup was done by the weblogic OBIEE administrator. ibots are received by the end user and the end user login is integrated to OBIEE 11g from EBS. The limitation on this setup is that the end user can’t create iBots and send it to another user. Only weblogic administrator can login to OBIEE directly and create the ibots.

Read More

Using Presentation Variables to Dynamically Configure Aging Buckets at Runtime

Author: Stephen Goldsmith Date: Sep 24, 2012 10:55:00 AM

Categories: Oracle Business Intelligence

I came across a requirement where a client wanted to see specific records that had end dates before 30, 60, or 90 days from now. In other words the client wanted to dynamically change the date range to include records with a date less than Today’s Date + (30,60,90 days).

Read More

Why OBIA Financial Statements Cannot be extended through ETL Enhancements

Author: Stephen Goldsmith Date: Sep 17, 2012 10:01:00 AM

Categories: Oracle Business Intelligence

Why it’s not possible to modify a P&L statement just through the OBIA csv files?

We recently ran into an issue that most clients who use OBIA Financials encounter. We want to show two revenue line items on the BI apps prebuilt P&L dashboard (for example: Line of business #1 Revenue and Line of business #2 Revenue). The account group names from file_group_acct_names partially determine what shows up on the balance sheet and income statement.

Read More

How to Extend OBIA Financial Statements

Author: Stephen Goldsmith Date: Sep 10, 2012 10:39:00 AM

Categories: Oracle Business Intelligence

For customers installing Oracle Business Intelligence (Financial) Applications a very useful customization can be done in a few steps that will add a nice bit of familiarity for reviewers of the financial statements.

Read More