What is Oracle Apps (ERP)?

admin
Categories: ERP

(Also known as e-business suite)

Lets take an example. Suppose you are running a small grocery shop named “Janata Grocery�, so the typical operation as a shop owner is you basically buy groceries from some big seller and stock it in your shop. Now people come to your shop for day-to-day needs and buy stuff from your shop at a slightly higher price than what you originally bought and stocked it in your shop.
Ocassionally you may not be carrying items or run out of stock that people ask for so you make a note of it and promise the person to come back tomorrow and they will get their item. So far so good, now lets name some entities before we proceed and things get complicated. The big seller from whom you buy stock is called as Vendor, the people who come to your shop to buy things are known as customers, the stock in your shop is known as inventory.

So far we have identified few entities that play an active role in your day-to-day operations. As time goes by, your business expands and now you take orders over the phone and provide service to deliver the items to your customers, so you hire people to help you out in maintaining the inventory, do the delivery part and all the necessary stuff to keep the business running smoothly. The people you hire are known as employees.
So in this small shop, you typically manage the bookkeeping activities by hand using a notepad or something similar. Now imagine the same setup on a larger scale where you have more than 10,000 customers, have more than 1000 vendors, have more than 1000 employees and have a huge warehouse to maintain your inventory. Do you think you can manage all that information using pen and paper? Absolutely no way! Your business will come to a sudden stop sign.

To facilitate big businesses, companies like Oracle Corporation have created huge software known in the category of ERP (Enterprise Resource Planning) as Oracle Applications. Now coming to think of it, Oracle Apps is not one huge software, instead it is a collection of software known as modules that are integrated and talk to each other.

Now what is meant by integrated? First let us identify the modules by entities. For e.g Purchasing and Account Payables deal with the vendors since you typically purchase from vendors and eventually have to pay the dues. Oracle Purchasing handles all the requisitions and purchase orders to the vendors whereas Oracle Accounts Payables handles all the payments to the vendors.

Similarly Oracle Inventory deals with the items you maintain in stock, warehouse etc. Dealing with customers is handled collectively with the help of Oracle Receivables and Oracle Order Management. Order Management helps you collect all the information that your customer is ordering over the phone or webstore etc whereas Receivables help you collect the money for the orders that are delivered to the customers.

Now who maintains the paychecks, benefits of the 1000 employees? right! it is managed by Oracle Human Resources. So you get the idea by now that for each logical function there is a separate module that helps to execute and maintain that function.

So all the individual functions are being taken care but how do I know if I am making profit or loss? That’s where integration comes into play. There is another module known as Oracle General Ledger. This module receives information from all the different transaction modules and summarizes them in order to help you create profit and loss statements, reports for paying Taxes etc.

Just to simplify the explaination, when you pay your employees that payment is reported back to General Ledgers as cost i.e money going out, when you purchase inventory items the information is transferred to GL as money going out, and so is the case when you pay your vendors. Similarly when you receive items in your inventory it is transferred to GL as money coming in, when your customer sends payment it is transfered to GL as money coming in. So all the different transaction modules report to GL (General Ledger) as either “money going in� or “money going out�, the net result will tell you if you are making a profit or loss.

All the equipment, shops, warehouses, computers can be termed as Assets and they are managed by Oracle Fixed Assets. Initially Oracle Applications started as bunch of modules and as time passed by they added new modules for different and new functions growing out of the need for today’s internet world.

So if you come across a module that you are trying to learn and work on, first try to understand what business need is it trying to fulfill and then try to understand what the immediate modules that it interacts with. For e.g lets say you come across Oracle Cost Management module, you will learn that it helps to maintain the costs of items in your inventory and the immediate modules that it interacts with are Oracle Inventory (ofcourse), Oracle Bills of Material, Order Management and so on..

There is more to ERP than this layman explanation of a complex beast that does not justify a single bit but I wished I had this knowledge when I was thrown into Oracle Applications right after I graduated from college. Back then the only piece of software I had known to write was implementing binary trees, infix, prefix, postfix notations in pascal and TSRs (Terminate and Stay resident) using assembly.

Did you like this article? If yes, would you please do me a favor by trying my company’s Dashboard Tool ? It has pre-built sample dashboards which you can demonstrate to your manager or use it to increase your BI and Apps skills. InfoCaptor is the most easy to use dashboard application which I personally put lot of thought in the design. I no longer work for anybody (yes I quit Oracle Corp!) and now just concentrating on growing this baby. I do independent consulting on the side to keep the engine running :-)

You folks have poured in so much love and wishes into this site and this article and I wish the same for my new product. Thank you for listening.

Everyone Has a BI Search Engine!

Rita Sallam
Categories: BI News, Other

Cognos Announces Cognos Go! For my SAP and SAP BW

Cognos is furthering its integration with SAP BW, its value proposition as a front-end to SAP BW strategy and has done for SAP BW what SAP Netweaver does not do; it has announced the immediate availability of Cognos Go! Search Service support for SAP. This provides one-click access to BI and SAP data through single search solution. SAP’s current search technology within Netweaver, TREX, is a limited and cumbersome search engine that does not search BW elements such as BEX reports, infocubes, etc.. It searches standard document files, word, ppt, Excel, pdf, .rft.  You can use it to search reports that have been publish to SAP Enterprise Portal (as long as the TREX server is configured to do so), as well as other documents and web pages.

 

Key Features
Cognos has a proprietary indexing scheme that can fully index BI content and search key data fields, not just titles or report descriptions.
SAP customers can access Cognos Go! through SAP Certified iViews in the SAP NetWeaver Portal, and third-party enterprise search solutions including Autonomy, FAST, Google, and IBM Consistent security – Cognos Go! leverages the Cognos 8 Business Intelligence security model, which means SAP users will only see reports, metrics, and analyses that they have been given permission to view.
Cognos Go! can access SAP data across multiple versions and instances of SAP R/3 and SAP NetWeaver, independent of a company’s SAP upgrade plans.
These search capabilities are not natively available in SAP applications.
 

Comments
Post Cognos 8 introduction, Cognos has turned its attention to three areas: Enterprise/ BI search, Increased focus on support for SAP, increased emphasis on Performance Management, with particular focus on industry solutions, and Cognos is also placing increased emphasis on its packaged analytic applications with a focus on easy integration with Enterprise Applications, including Oracle. These packaged analytics are primarily Finance focused and are not yet well development across the other domain areas.
In contrast, Post XI2 release, Business Objects has turned its attention to Enterprise Information Management, Mid Market Solutions, and industry specific solutions, pitting it squarely against Oracle and IBM.
 

Cognos Partners with FAST for Enterprise Search

 

Last month Cognos and FAST announced their intention to partner for Enterprise Search for BI with little press reaction. While this announcement again reiterates the two companies intention to combine their respective products, the announcement does not make any mention of Cognos Go!, Cognos’s proprietary search capability that can currently leverage Google OneBox and IBM OmniSearch.

 

Comment
The slew of announcements by Cognos in Search, CPM and vertical solutions (all areas except Cognos 8), seems to be a desperate attempt by Cognos to deflect the market away from the realities slow adoption of the Cognos 8 platform.

 

IBM’s BI Search Capability

 The WebSphere Content Discovery for Business Intelligence, now a competitor to Oracle partner, Google Onebox, combines business intelligence applications with search for structured and unstructured information within an enterprise.

 The software can also display within BI applications contracts, spreadsheets, project plans, scanned images, audio, video, email and other correspondence, to provide context for business decisions. Cognos has integrated the IBM product (in addition to the Google Onebox product) with Cognos 8 Business Intelligence via a proprietary indexing scheme. The new product delivers in search results information from BI systems, including reports, scorecards and dashboards.

 

By combining unstructured information with BI, the new product, for example, could extract data from call center and warranty notes and make it available for use with BI-generated quantity, sales and return rates for products, IBM said. Together the information could help uncover reasons why return rates are high.

 

Hyperion Claims to Have BI Search by Adding Business Word Search Features to System 9

OK, Hyperion seems to be claiming a really desperate “me too� with this release!!! Of course word search on reports is NOTHING NEW and in no way resembles the Google OneBox capability adopted by Oracle and for that matter other BI vendors. Google OneBox gives corporations secure access to information in any application within the enterprise from the Google search box.

 

Comments
Hyperion claims that reports will contain links to related topics, categories or reports. WOW, what a concept!! Oracle Enterprise BI (AKA SBA), offers extensive guided analytics capability, where not only are links to related or relevant reports suggested to the end user, but also filter context is also passed between reports that are linked together. Hyperion Interactive Reporting, part of Hyperion 9, doesn’t even offer linked reports, with context or otherwise. All related content must be included in a single file.

 SAS and Google OneSearch

Following in the footsteps of BI rivals like Information Builders and Cognos, SAS has also partnered with  Google Inc to allow joint customers to perform context-based searching across SAS-generated reports, analyses and dashboard information. SAS will give users contextually relevant search capabilities with Google to explore metadata, but also to look at the business views (SAS Information Maps) that have been defined by SAS clients.

 

A Discussion of Google’s Impact on BI

It seems as if the business intelligence pure-play vendors are taking fire on all fronts.

From Oracle, IBM, MSFT and SAP, all of which are placing a greater strategic emphasis on BI and Enterprise Search capabilities of their own, and now from Google, which for now is a complement to add more user friendliness to BI platforms and expand their potential user base.

 Google claims that Google Search Appliance is a distinct improvement over the portal interface, which many BI vendors have pushed as a means to drive broader user adoption.  This remains to be seen. Search and Portal seem complementary to me; I’m not sure the two are mutually exclusive.

 While Google claims the search engine will hide the complexity of the underlying data, e.g. if a user searches its repository for adapters and returns IBI’s iWay adapters, users themselves aren’t necessarily aware that they’re accessing WebFocus or other IBI data, Best of breed vendors don’t seem to worry about potential brand dilution. Cognos for instance claims that they will brand their BI content in the file name, e.g. Cognos Scorecard, or Cognos Report.

 

There’s another upshot of the search phenomenon, howeverâ€?it could mean the end of per-seat BI licensing agreements.

 

 

SPSS Review Current Analysis

admin
Categories: BI News

SPSS Review Current Analysis
Overview

SPSS 14.0 is an enterprise-class offering that reflects the company’s evolution from the desktop to the department and, finally, to the enterprise. SPSS has always been recognized as one of the premier desktop statistical software vendors, but it has sometimes been mis-positioned as being little more than a desktop or departmental tools vendor. With SPSS 14.0, however, SPSS has integrated its products into a single platform with a common set of services (e.g., security administration; a repository supported by most relational databases with model management capabilities, including advanced search, versioning, and test-versus-production status; scheduling and notification; etc.), while exposing its APIs to facilitate its openness and to serve the evolving needs of the enterprise. By integrating its products and sharing a common set of services with other SPSS products (e.g., Clementine), SPSS 14.0 should improve business processes at the operational level and thus the overall analytical effectiveness of the enterprise.
Strengths

    * SPSS is actively carving out and helping to define a market niche with its emphasis on predictive analytics and the need to use analysis to drive actions. The May 2005 release of PredictiveClaims for fighting insurance fraud reinforces its predictive analytics message. Also, the LexiQuest acquisition expanded SPSS’ predictive analytics capabilities to include unstructured text data mining capabilities.
    * SPSS launched several products or enhancements that strengthen its core value proposition in data mining. In January 2006, the vendor released v. 10.0 of its Clementine data mining workbench, providing such productivity enhancements as anomaly detection, feature selection, and export to Excel; such performance enhancements as in-database caching, database write-back with indexing, and improved support for parallel processing; and tightened integration models with SPSS Dimensions and SPSS Predictive Enterprise Services. Also, in June 2005, SPSS announced ShowCase Suite 7.0, which included major enhancements to its Essbase, Analyzer, and Enterprise Reporting components.
    * SPSS has partnerships with a number of major data warehouse vendors, including Hewlett-Packard, Hyperion, IBM, Microsoft, Sun, Sybase, and Teradata (a division of NCR), and with such BI vendors as MicroStrategy (announced in March 2006). In February 2005, SPSS formed a strategic alliance with RTI International, an independent research company with over 2,500 employees to offer data collection and predictive analytics to the public sector.
    * SPSS continued to tighten its integration with Microsoft SQL Server 2005. In June of 2005 SPSS announced SPSS Statistical Services for Microsoft SQL 2005, which would integrate SPSS’ predictive analytics software with Microsoft SQL Server 2005.
    * Current Analysis failed to mention SPSS’s integration with ODM, which provided a highly scalable, embedded data mining engine for Clementine, the SPSS front end.
Weaknesses

    * SPSS has many alliance partners that incorporate its products within their own software applications. As the company expands its footprint into analytic applications, as it did, for example, with the DataDistilleries acquisition and its set of “Predictiveâ€� offerings, it must carefully navigate this new co-operation environment.
    * As SPSS continues to target the enterprise market, it will face increased competition from industry giants, such as SAS and Oracle, which consider this to be their market. SAS, in particular, is showing a new level of aggressiveness. However, SPSS has been cognizant of the importance of building its indirect sales channels to help it better leverage its software, and it is aggressively pursuing this channel.
    * The initial releases of SPSS Server 14.0 are on Windows 2000 Server and Windows Server 2003 platforms, although Sun Solaris, IBM AIX, and Red Hat Enterprise Linux support is expected to follow shortly thereafter.

Most important BI player

admin
Categories: BI News

Positive Coverage from Bloor: Oracle set to become probably the most important player in the BI market

Oracle has for a long time been the predominant database used in general business for data warehousing and other BI uses. Its tool set, whilst complete, has never quite matched the appeal of the database. Oracle tools were adequate but never really exciting or groundbreaking. With the acquisition of Siebel Oracle find themselves as the owners of one of the most exciting BI solutions available at present.

 This all indicates that Oracle is taking BI very seriously, and this new found enthusiasm is being backed by significant investment and the creation of a very complete vision to enable them to compete very aggressively in all segments of the market. Critically, Oracle are setting to be very open, not just in terms of word and conformance to standard, but explicitly and enthusiastically they are setting out to embrace other tools be they SAP, DB2, or Microsoft and offer an open, hot pluggable solution, which is a best of breed tools and applications set that will be very compelling.

Latest Enhancements to PowerCenter 8

admin
Categories: BI News

Latest Enhancements to PowerCenter 8

Since the initial rollout of PowerCenter 8 on a limited basis in December 2005, Informatica has made further enhancements to the generally available release, resulting in the following new capabilities:

 

    * Advanced data quality products — With Informatica’s acquisition of  Similarity Systems, PowerCenter 8 now includes new products that deliver advanced data quality capabilities:  Informatica Data Quality and Informatica Data Explorer.
    * Enhanced 64-bit platform support — Windows 32-bit, Windows on Itanium, Solaris 32-bit, Solaris 64-bit, Solaris on x64/Opteron, AIX 32-bit, AIX 64-bit, HP/UX 32-bit, HP/UX 64-bit/Itanium, SuSe Linux on 64-bit, Redhat Linux 32-bit, Redhat Linux 64-bit.
    * Expanded enterprise data access — New PowerExchange options include data sources such as JD Edwards OneWorld, DB2/UDB Real-time, IDMS
    * Real-time, as well as changed data capture support for leading database environments.
    * New Visual Mapping Design Tool:  Informatica Data Stencil. Concurrent with the PowerCenter 8 release, Informatica is also now offering a data-flow design tool based on Microsoft Visio: Informatica Data Stencil. Free of charge to customers, Data Stencil provides a Visio template that allows rapid construction of data flows, which directly feed PowerCenter 8’s Mapping Generation product to automatically generate PowerCenter mappings. The tool works bi-directionally, so that existing PowerCenter mappings can create a visual map of the data flow. Customers can download Data Stencil and sample mapping templates by visiting http://devnet.informatica.com/datastencil.

NextAction Migrates from SQL Server to Oracle!!

Rita Sallam
Categories: BI News, Other

NextAction Migrates from SQL Server to Oracle!! Proof that SQL Server not There Yet for Enterprise DW  – Thanks to Bill Nee for sending. 

 

   

The Bottom Line Results from the Migration 

  • 8X faster application development 
  • 12X faster data loads 
  • Exponentially faster updates (1.5 days then crash, down to 10 minutes) 
  • Significantly lower hardware costs ($2MMM to $40,000) 
  • 8 instances to 1 
  • 30 TB down to 5 TB (lower disk costs) 
  • Data mining results down from 8 days to one 

  

Situation: 

  • In 2004, the company’s 13TB data warehouse was spread across five Microsoft SQL Server 2000 databases. 
  • But within a year, the fast-growing firm’s database had grown to 30TB spread across eight instances of SQL Server 2000. “My guys were working 70 to 80 hours a week,â€Â? he said. “We were dying on the vine.â€Â?  
  • NextAction’s data warehouse was growing too fast to easily manage on SQL Server, said Helle, and it would crash so often that the process of mining data for retailers grew from three and a half days to eight days — a major problem, since the data mining took place weekly. “That’s what really impacted revenue, the fact that it failed quite often,â€Â? Helle said. 
  • Partly because the rest of NextAction was mostly a Microsoft .Net environment, Helle tested the then-beta version of SQL Server 2005 against Oracle 10g, both of which had 64-bit versions. 

  

The Results in More Detail 

  

  • Microsoft treated Helle well, putting NextAction into a special program for extremely large databases that included plenty of support. But within two weeks, the results were clear to Helle. “SQL Server has made great strides in the past couple of years. But like I told the Microsoft guys, it’s hard to match [Oracle’s] 15 years of evolution,â€Â? he said. 
  • Not only was Oracle Enterprise Manager 10g much more stable, it was also much faster, Helle said. “We ran about 20 benchmarks. Creating applications was, on average, eight times faster on Oracle. Loading data was about 12 times faster. An updating statement that died after 1.5 days on SQL Server without completing took one hour and 10 minutes to finish on Oracle.â€Â? 
  • The weekly customer data mining now takes only one day. That is in part because NextAction uses Oracle Partitioning to run more than 1,100 partitions, one for each customer. 
  • That 30TB database was shrunk to just 5TB after being rewritten — and it was moved to one Oracle instance from eight. For backup purposes, NextAction is using Oracle’s Data Guard, which sets up a mirror with a second, identical Oracle database. 
  • Although the majority of databases Helle had run involved Oracle on Unix, for speed and cost reasons he chose a Hewlett-Packard Co. DL 585 server using four AMD Opteron processors with Novell Inc.’s SUSE Linux operating system. That configuration cost about $40,000, versus $2 million for the prior SQL Server-based system. 
  • “SQL Server has made great strides in the past couple of years. But like I told the Microsoft guys, it’s hard to match [Oracle’s] 15 years of evolution,â€Â? he said. 
  • Not only was Oracle Enterprise Manager 10g much more stable, it was also much faster, Helle said. “We ran about 20 benchmarks. Creating applications was, on average, eight times faster on Oracle. Loading data was about 12 times faster. An updating statement that died after 1.5 days on SQL Server without completing took one hour and 10 minutes to finish on Oracle.â€Â? 
  • The weekly customer data mining now takes only one day. That is in part because NextAction uses Oracle Partitioning to run more than 1,100 partitions, one for each customer. 
  • That 30TB database was shrunk to just 5TB after being rewritten — and it was moved to one Oracle instance from eight. For backup purposes, NextAction is using Oracle’s Data Guard, which sets up a mirror with a second, identical Oracle database. 
  • Although the majority of databases Helle had run involved Oracle on Unix, for speed and cost reasons he chose a Hewlett-Packard Co. DL 585 server using four AMD Opteron processors with Novell Inc.’s SUSE Linux operating system. That configuration cost about $40,000, versus $2 million for the prior SQL Server-based system. 
  • That price doesn’t include the storage, which Helle acknowledged was expensive. But it is also large: The HP StorageWorks XP1200 disk array can store 330TB, which Helle thinks should easily last him five years. Just in case, though, the HP can manage a total of 3 petabytes via auxiliary systems. 
  • Helle is also testing Oracle RAC (Real Application Clusters) to help ease future growth. 

Microsoft

Rita Sallam
Categories: BI News

Microsoft  

  Microsoft Plans to Close Business Intelligence Product Gap and Shift Competitive Position With ProClarity – Gartner Group, Bill Hostmann  

   

G 

artner makes the following observations regarding Microsoft’s acquisition of Proclarity: 

Questions remain regarding product integration and “fit” into Microsoft’s overall BI and business performance management product road map. 

  

Proclarity has been a departmental solution, there are significant questions regarding the products ability to support enterprise implementations. “..the average deployment size for ProClarity tends to be departmental, smaller and less expensive compared with companies such as Business Objects, Cognos, or Information Builders and Panorama.â€� 

  

ProClarity, Microsoft will have the potential to improve the development tools for Reporting Services. “(Several developers using Microsoft Reporting Services said that it was difficult to get multidimensional results sets into the form they wanted for their reports, and were struggling with the current Reporting Services development tools.)â€� 

  

Reporting and Analysis in SQL Server 2005 are not yet fully integrated, “The ProClarity platform also will enable Microsoft to link (drill down) reporting and analysis, as well as scorecards (its own and the new Microsoft Business Scorecard Manager) and analysis — a hole in the Microsoft BI portfolio, which probably was not going to be closed until late 2007, with the release of Excel 12 server-based edition.â€� 

“Some Microsoft and ProClarity products overlap in key areas, such as development and administration tools and dashboards. These offerings and overlaps will need to be explained in a product road map after the acquisition closes.â€� 

  

Pricing and packaging will need to be mapped out for customers. “Proclarity has more typical, although less expensive than best of breed vendors Cognos and Business Objects.â€� 

  

“It is also unclear what strategy changes, if any, Microsoft’s BI partners — such as Cognos, Business Objects and Panorama — will take in response to this proposed acquisition. We expect that these partners will feel increased pressure from Microsoft as a competitor and will pursue new opportunities and strategies, such as packaged analytical applications and process embedded capabilities/applications, to rise above the emerging BI battlefield being shaped by increasing investments in BI from Oracle, SAP and now Microsoft.â€Â? 

Is Hyperion Desperate for Some Positive Coverage?

Rita Sallam
Categories: BI News

Hyperion and MSFT Announce Great Collaboration; In the Face of Horrible Q1 Results, Is Hyperion Desperate for Some Positive Coverage? 

  

A 

ccording to Hyperion, integration of Microsoft SQL Server technologies with Hyperion System 9 BI+ to will enable interoperability for mutual customers.  

  

Collaboration plans include four initiatives that integrate Microsoft SQL Server 2005 technologies — including SQL Server 2005 Reporting Services, SQL Server 2005 Analysis Services and SQL Server 2005 Integration Services — with Hyperion System 9 BI+. 

  

This announcement is a bit puzzling and seems like a desperate attempt to gain attention on the part of Hyperion. Hyperion 9 includes Ad hoc analysis, Reporting, OLAP (Essbase), as well as Planning and Budgeting, all of which (except for Planning) overlaps in functionality with SQL Server 2005 BI.

Hyperion

Rita Sallam
Categories: BI News

Sluggish Sales for Hyperion System 9 Continue Due to High Price Tag and Migration Cost; No Relief In Sight from Upstream Acquisition or Upcoming BPM Architect Product 

   

H 

yperion is projecting a 10%, or $28 million, in fiscal 2007, which is seen by many in the financial community as a major disappointment, given the September 2005 launch of S9, upcoming releases such as BPM Architect, and recent acquisitions including Razza Solutions (which brought the Master Data Management product, Hyperion’s fastest-growing product). First Analysis Securities Corporation estimates that UpStream and MDM combined can contribute 5%, or $14 million, in incremental license revenue in fiscal 2007.  That leaves only $14 million from incremental sales of System 9, not a very rosy picture, indeed. 

  

According to First Analysis Securities, high license fees and lengthy migrations are a significant hurdle for customers considering an upgrade to System 9. They comment, “Our key takeaway is that System 9, like many of the integrated BI platforms, is a step function improvement in performance and usability. However, that benefit carries a high price tag of a long and complex implementation process and sales cycle, making the timing of customer upgrades somewhat uncertain. Despite earnest customer interest in the new product capabilities, we don’t see this cycle ramping results in the near term.â€� 

  

Poor Hyperion Q3 results seem to confirm that System 9 sales are suffering from technical issues and/or the new license (i.e. migration) fee. According to First Analysis, “We talked with one of Hyperion’s larger international customers at the event that “continues to struggleâ€� with the S9 license fees. First Analysis also spoke with Hyperion customer, Norway Post, which incurred licensing costs in excess of $1 million to migrate to S9 and purchase additional products. In spite of this, they are articulating a strong valuation proposition for the product. 

  

In a confirmation of Hyperion’s challenges with System 9 sales, according to a First Analysis Hyperion User Conference Report, three important partners (each located in the three major regions, east, central, and west) focused on the business intelligence platform business have not yet completed more than a handful of migrations in total.  They said, ‘While we did hear from partners about improvements with S9 in the area of configuration and trouble-shooting, negative comments focused on a lack of S9 documentation, as well as a shortage of pre-sales talent and in-depth knowledge across the entire offering (i.e. relational and OLAP).â€� 

  

BPM Architect  

The fall release of BPM Architect (part of version 9.3) will likely be a major release and innovation for application customers. BPM Architect will allow Hyperion customers to build and maintain applications (e.g. Planning and HFM) in a single environment with shared dimensions and properties, as well as data synchronization. Hyperion claims that like Essbase 7X, System 9 will have slow and steady growth until sales pick up in 12 –24 months. Hyperion also claims that BPM Architect will help to accelerate this growth. Question is, how much and how complex will the migration path be from the current set of completely disparate development environments, AND how much training will be required?? No doubt, this will add to the challenge of moving to System 9.   

  

Other Announced Enhancements  

As per the recent user conference, Hyperion will focus on the following areas in the upcoming release: 

  • Business language search for simplicity and ease-of-use (see below) – OK, like everyone else.. 
  • Prescriptive metrics for guided analytics – not sure where and how they will do this… 
  • Adaptive visualization for personalization – Again, not sure what this means, but everyone is improving visualization. 

  

 

Skinny on Upstream  

Hyperion’s acquisition of UpStream provides financial data quality. UpStream provides a data readiness and guided workflow application for tracking the movement of financial information from source to report. UpStream software supports data collection and transformation, internal control, repeatable financial processes and audit trails back to the source systems. UpStream’s data quality workflow platform — WebLink DM – allows organizations to control and track data utilization back to source systems. WebLink DM automates business workflow processes that incorporate strict integrity controls required for verifiable financial data quality processes. WebLink DM moves data from multiple source systems, transforms the data, and then loads it into a customer’s analytical applications — including Hyperion BI applications – through a repeatable, defined workflow. The product provides a comprehensive audit trail to address Sarbanes-Oxley requirements. 

  

The acquisition fills a key capability gap for Hyperion in data quality and auditing capability needed for SOX compliance. While Oracle and Business Objects have their own robust and broad DQM capabilities, which can match the functionality provided by Upstream, this acquisition provides niche Financial Data Quality Management capabilities, specifically, which will be attractive to Hyperion’s traditional Finance target customer base. Hyperion hopes that the purchase will accelerate migrations from Enterprise to HFM. It is unclear whether or not Hyperion/ Upstream will continue to support 3rd party data quality tools. 

   Upstream Acquisition Positive Comments 

  • Focus on the Financial DQM problem and provides enabling capability specifically for SOX and HIPPA 

  • DQM offering for business users 

  • Complementary to other Hyperion products; little overlap 

  • Upstream supports both process-oriented compliance (i.e., automation of financial data-quality workflows) and also feedback-oriented compliance (i.e., provision of a comprehensive audit trail on these workflows) 
  • Adds a differentiator for Hyperion CPM products 

   Upstream Acquisition Negative Comments 

  • With this acquisition, there are potentially multiple workflow technologies/ environments in Hyperion’s portfolio. Hyperion has not yet announced plans to rationalize these. The existence of multiple environments (BI, CPM, MDM) would make achieving a single source of truth difficult. This would constitute a significant rearchitecture and future migration issues for Hyperion customers 
  • No indication of whether or not the Upstream will continue to support 3rd party DQM products 

·         The niche financial data quality offering confirms Hyperion core target customer base, Finance. The acquisition does nothing to rescue Hyperion’s relatively unsuccessful attempts to make inroads into other departments within the organization, which has effectively limited Hyperion’s applicability as an enterprise CPM platform.