BizTech_Blog_Header

BizTech Blog

Stephen Goldsmith

Stephen brings over 20 years of experience in helping organizations achieve a competitive advantage through improvements in business processes and information systems. With a history of building custom data warehouse solutions as far back as the early 90’s, Stephen has helped countless organizations uncover business knowledge from the vast amounts of data hidden in their operational manufacturing, financial, sales, marketing and project management systems. Stephen joined BizTech in 2010, as the Director of Business Intelligence and Analytics. His role builds upon the growing Business Intelligence market and positive results BizTech has experienced with Oracle’s packaged Business Intelligence applications.
Find me on:

Recent Posts

New Features of EPM 11.1.2.2

Author: Stephen Goldsmith Date: Oct 16, 2012 11:43:00 AM

Categories: Hyperion EPM

Latest Version of Hyperion is 11.1.2.2, With the recent release of the newest version of EPM, 11.1.2.2, Hyperion has introduced new functionality in Essbase and Planning, including...

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

OBIA Architecture and Functionality Overview

Author: Stephen Goldsmith Date: Sep 4, 2012 9:49:00 AM

Categories: Oracle Business Intelligence

The architecture for Oracle Business Intelligence Applications (OBIA) includes several components. Understanding these components is prerequisite to a successful OBIA implementation. A brief description of each component is included below the diagram.

Read More

A Business Person's Guide to Business Intelligence Terms

Author: Stephen Goldsmith Date: Jul 18, 2012 3:16:33 PM

Categories: Oracle Business Intelligence

I recently read an article from Software Advice called the BI Buzzword Breakdown. The article highlighted the confusion around business intelligence (BI) terms and asked experts to provide their own definitions. While a quick visit to wikipedia will define most business intelligence terms, we as practitioners have learned that successful BI implementations require significant support and interaction with business users. The IT-led 'build it and they will come' strategy, just plain does not work. Thus, we need to be able to translate from techy terms to business terms. As a compliment to the software advice article, I would like to attempt to explain some of the key terms as if I was speaking to a fictitious business executive, who I will call Amy.

Read More

Operational vs. Analytical Business Intelligence

Author: Stephen Goldsmith Date: May 2, 2012 11:28:06 AM

Categories: Oracle Business Intelligence

As business intelligence software technologies have matured, organizations have begun to expand the use of business intelligence software, like Oracle Business Intelligence, beyond reporting from data warehouses. Using tools like Oracle business intelligence to report off of operational systems such as Oracle EBS has become commonplace. So the question becomes, what is the difference between analytical and operational reporting and how should an organization architect a solution for each reporting type.

Read More

Oracle's Business Analytics Strategy

Author: Stephen Goldsmith Date: Apr 11, 2012 5:33:55 PM

Categories: Oracle Business Intelligence

Recently Mark Hurd, Oracle President and Balaji Yelamanchili, Oracle Senior Vice President, Analytics and Performance Management, unveiled the latest advances in Oracle’s strategy for analytics. The webcast focused on the latest developments in business intelligence technology and applications, advanced analytics, performance management applications, and engineered systems. Key points included how to:

  • Deliver real-time intelligence to your mobile workforce globally
  • Forecast and plan at the speed of business
  • Accelerate your financial close and reporting process

Click this link to watch the webcast.

Read More

Workaround for OBIEE 11g and Firefox 10

Author: Stephen Goldsmith Date: Feb 26, 2012 3:27:17 PM

Categories: Oracle Business Intelligence

If you are reading this blog, you are probably like me in that you downloaded a 10.x update to Firefox and found that OBIEE no longer works. Here is a quick and dirty workaround until Oracle is ready with a patch:

Read More