|
Many companies today continue to have trouble making business decisions on the data which is stored in the operational systems (ERP, CRM, Legacy, etc.) or in PC data sources (MS Excel or Access). Reporting is generally performed through custom programming, spreadsheet manipulation or simple querying tools. Even with the basic reporting you get with those tools, these reports can generate other questions which require further detail. Another issue often occurs when users develop their own solutions, which can generate inconsistent information as different departments report different results based on their own interpretation of calculations such as net sales. This is where having an Enterprise Data Warehouse and On-line Analytical Processing (OLAP) Data Marts combined with Financial Consolidation and Planning applications can help solve some of these problems.
More companies today are looking towards the Hyperion Business Intelligence and Enterprise Performance Management Platform, Hyperion System 9 BI+, Hyperion System 9 Applications and Hyperion System 9 Foundation Services to provide the software solutions necessary to automate the extraction of data from source systems, and host the data warehouse, OLAP data marts and financial management applications. The core components of Hyperion's platform are Hyperion Essbase Analytics, Enterprise Analytics, Web Analysis, Financial Reporting, Interactive Reporting, Production Reporting, Hyperion Planning and Hyperion Financial Management which provide the processing power, scalability, performance, manageability, and security needed for delivering information to a broad class of users accountable for corporate performance, including executives, operational managers, Finance, and front-line workers anywhere in the extended enterprise.
Analytic Vision provides a number of service offerings to support Hyperion's Business Intelligence Platform and Financial Management Applications. These include advanced automation using Hyperion Analytic Integration Services, Hyperion Essbase Analytics and Enterprise Analytics, Web Analysis, Financial Reporting, Spreadsheet Automation Services, Smart View for Office, System 9 Foundation Services, Hyperion Planning, Hyperion Financial Management, Hyperion Performance Scorecard and numerous front-end presentation tools for Hyperion Essbase.
Hyperion System 9 Migration Services
Making a decision on the timing to upgrade to Hyperion System 9 can be challenging. Many factors need to be considered such as costs, benefits, technical implications and resource constraints. Let our team of technical and business experts help you through this process by evaluating the impact to your business and potential efficiencies to upgrading. Over the last 12 months we have helped several clients through this process and developed detailed project plans to migrate your existing Hyperion products to Hyperion System 9. With experts on both the data and SQL repository migration along with reports and user content we bring an accelerated approach to moving to System 9 along with ensuring you maximize the benefits of the new System 9 Foundation Services, Business Intelligence tools and Financial Management and Planning applications.
Hyperion System 9 Foundation Services
System 9 Foundation Services provides a single, shared infrastructure to manage users, security, and metadata. Foundation Services consist of System 9 BPM Architect (BPM Architect), Hyperion System 9 Workspace (Workspace), Hyperion System 9 Smart View for Office (Smart View), Hyperion System 9 Shared Services (Shared Services), and Hyperion License Server. Analytic Vision provides comprehensive services to help you design develop and implement System 9 Foundation Services following best practice guidelines and customer experiences. Over the last 12 months we have implemented System 9 foundation services at over 15 clients so you can draw upon the experiences to get the most out of your System 9 upgrade or new implementation.
Hyperion System 9 BPM Architect
With the newest release of System 9 Foundation Services Hyperion clients can now take advantage of a single dimension library and data synchronization process across Hyperion Essbase Analytics, Hyperion Planning and Hyperion Financial Management. BPM Architect was built off years of experience with the Hyperion Master Data Management (MDM) product. BPM Architect, also known as MDM light, provides a valuable tool suite to manage all dimensions, hierarchies, attributes, versions and data synchronization across all your System 9 applications. Analytic Vision strongly supports this new product and we have started implementation work at several clients for you to draw upon best practices and customer experiences.
Hyperion System 9 Analytic Integration Services
Many Hyperion Essbase Analytic Services (Essbase) clients today develop custom application programs necessary to perform formatting of operational data and other automation activities required for the refresh of an Essbase multidimensional database. Hyperion offers Analytic Integration Services to provide an easy to use graphical environment to integrate data or metadata from ERP and CRM applications, relational databases, data warehouses, and legacy transactional systems as well as flat files, spreadsheets, XML documents and Web logs. If you implement a properly design enterprise data warehouse, a key benefit of Analytic Integration Services is the enabling of a true Essbase drill through into the supporting transaction detail; this means that users of a financial data mart could not only see month end balances, but can drill down to the supporting journal entries.
Analytic Vision works to fully automate the refresh of the Essbase Analytics database application (and the supporting data warehouse) using a combination of custom programming, ETL (Extract, Transform, and Load) tools, and Analytic Integration Services. Our automation techniques allow us to develop a parameter driven process that can be executed on a scheduled basis or run on demand utilizing the software you have today. We also understand the issues of performance tuning a design when high volumes of data are involved, and can help you avoid project pitfalls in this area.
Extend the value of SAP, Oracle, and Microsoft investments with Essbase Analytic Services (Essbase), Hyperion Planning and Hyperion Financial Management.
To help gain the most value from your SAP, Oracle and Microsoft Platforms, Analytic Vision offers services to help you access data natively from these environments for ad hoc query and analysis, Financial Reporting, Dashboards, Advanced Analytics, Financial Planning, and Financial Consolidations. Our team of SAP, Oracle and Microsoft experts can you design the most efficient BI and reporting architecture by leveraging and extending existing investments.
Hyperion System 9 BI+ Essbase Analytics and Enterprise Analytics.
One of the key areas of our services and expertise revolves around the design, development and automation of Hyperion Essbase Analytics (Essbase) analytical applications. Essbase is a multidimensional (MOLAP) development environment that provides rich functionality, including more than 250 calculation functions, attributes, write-back, procedural logic, and custom-defined functions and macros.
It is our experience that many companies who already have Essbase have implemented a solution that requires manual steps such as loading data from Excel and manually keying in new accounts as they are set up in the general ledger. This is a tedious process that we help companies eliminate by fully automating the extraction and loading of operational data into Essbase data marts. Analytic Vision consultants have the skills required to build more advanced Essbase analytical applications than the traditional consulting firms. Areas of expertise include;
•
Advanced formulas and calculations
• Conditional and
cross-dimensional formulas
• Dynamic formula
changes
• Allocations
• Complex outline design and development
• Multiple calendar
types (retail, annual, fiscal, etc.)
• Rules-based automation
for primary and alternate hierarchies
• Alias, Alias Combinations
and Alias Table automation
• View/Report hierarchies
to reduce report maintenance (Current Month, Current
Week, Current YTD)
• Attributes Dimensions
• Complete automation of the refresh processes
• Parameter-driven
update process
• Support for full
and incremental data loads
• Substitution Variable
Automation
• Techniques for
maximum database uptime
• Parallel ETL strategies
to reduce refresh time
• Advanced Partitioning
• Composite data
marts support multiple subject areas
• Use for security
and improved performance
•
Performance Tuning
• Reductions in data
load and calculation times
• Reduce database
size
• Improve end user
retrieval performance
Our
Rapid Implementation Methodology
allows us to keep our projects focused on your deliverables so that they are on task within budget and on time. Our implementation plans include design and development reviews throughout all phases of the project to insure that we meet your objectives. We also work to assist you in building your internal capabilities with knowledge transfer between our consultants and your IT staff.
Hyperion System 9 BI+ Web Analysis
At Analytic Vision, we understand that the complete automation of the back-end database refresh processes is only part of the overall development equation. It is important to match the capabilities of the user with how they interact with the data. One method for presenting analytical reports and providing a means for discovery is with Hyperion Analyzer. Hyperion Analyzer allows for the design, development and presentation of analytical reports with Essbase data using traditional Internet browser technologies. Developing an Analyzer front-end application is like developing an intranet website for your users. It is important to understand the overall design of the application, look and feel of the analytical pages, corporate standards, and workflow. Analytic Vision consultants understand how to work with all facets of Analyzer from installation, design, development, deployment, and end-user training of the new application. We also understand how to performance tune Analyzer reports for optimum performance.
Hyperion System 9 BI+ Financial Reporting
At Analytic Vision, we understand that the collection of data from disparate systems and locations can be very challenging. In addition, the reporting of that information to internal and external users in a timely fashion is very critical. System 9 BI+ Financial Reporting provides fully automated, highly formatted and board quality financial reports to internal management and to external users such as the SEC. Our team of experts have designed and implemented BI+ Financial Reporting solutions at over 15 clients in the last 12 months to help you draw upon best practices and accelerated implementations. We also specialize in System 9 upgrades and migrations from previous versions of Hyperion Reports.
Spreadsheet and Smart View for Office Automation Services
If there is one application that we all have readily installed on our PCs, it is the spreadsheet. For most of us it is Microsoft Office suite including excel, word and PowerPoint. Companies that have Hyperion Essbase Analytics, Hyperion Planning and Hyperion Financial Management installed still use Excel for the most complex analytical requirements. Essbase, Planning and Financial Management now come with an Excel, word and PowerPoint (Smart View) add-in product that enables OLAP functionality within the Office Suite. One of the areas where most add-in users fear to venture is in the automation and programming of Office applications. This includes Visual Basic coding required to access the Application Programming Interfaces (APIs) provided by Essbase, Planning and Financial Management to access and automate the features provided by Smart View. At Analytic Vision, we understand how to program all of the background processes required to fully automate your Office Applications and provide a user-friendly front-end to your Excel, word and PowerPoint applications. Our team members are experts in the use of Smart View functionality with Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Visual Basic and Hyperion Essbase Analytics, Hyperion Planning and Hyperion Financial Management.
Third-Party Presentation Tools for System 9 BI+ Essbase Analytics, Hyperion Planning and Hyperion Financial Management.
Analytical Front-end Presentation tools today for Essbase, Planning and Financial Management in most companies are limited to Hyperion Web Analysis, Financial Reporting or Microsoft Excel (Smart Views). For most companies these tools will completely meet their internal reporting requirements. This changes when your business requirements dictate that analytical data must be provided within web pages along side of non-analytical content. This could include intranet, extranet, or portal web applications that provide access to analytical data for your employees, customers, vendors, or as part of a worldwide organization. Analytic Vision, as a full service provider, understands that sometimes software vendors cannot provide the total solution, but has other partners who can provide that functionality. As such we partner with companies such as Microsoft, Alphablox to provide premium custom-developed front-end web applications. For more information on our Microsoft, DB2 Alphablox or other front-end services visit the Front-End
Presentation Services page.
Hyperion System 9 Planning
Once companies have implemented a financial data mart with Hyperion System 9 Essbase Analytics, a typical next step is to utilize Essbase to assist in the budget and planning process. While Analytic Vision can help your team develop a custom built solution to fit all of your needs, Hyperion offers a user friendly pre-built web-based budgeting and planning solution called Hyperion System 9 Planning that facilitates collaborative, integrated, event-based planning processes throughout your company for a wide range of financial and operational needs. This product eliminates the need for complex spreadsheet budget models that so many companies develop. Analytic Vision staff is fully trained and experienced in the installation and configuration of Hyperion System 9 Planning. Our experience with System 9 Planning will facilitate your implementation and help focus you toward delivering the required budgeting and planning deliverables to your company.
System 9 Planning's Web functionality includes reporting and analysis, process management and data entry, allowing top-down targets to be formed and communicated easily throughout the organization.
Hyperion System 9 Workforce Planning
Analytic Vision's team of Financial Planning experts specialize in the implementation of Workforce Planning solutions that makes headcount, salary and compensation planning fast and efficient across the organization. Integrating Human resource planning into overall Financial Planning process is critical given compensation and related expenses are often the largest line items in budget. Let our experts look at your current compensation Plannng process to access the potential benefits of this System 9 Planning module.
Hyperion System 9 Financial Management
Another critical need for organizations with complex, global reporting requirements is the utilization of Financial Management software to collect, report and analyze data across multiple ERP and General Ledger Systems. Hyperion Financial Management (HFM) combined with Hyperion Data Quality Management (FDM) provides "best in class" Financial Consolidations and Reporting. HFM & FDM include many pre-built features to improve the financial close process along with a complete audit trail of all the necessary internal controls. Analytic Vision is engaged with several clients supporting global financial consolidation needs and can assist in the process of developing and implementing HFM to fully automate the financial consolidation and reporting process.
Hyperion Performance Scorecard
Today, executives and managers must have an easy way to track the key performance indicators (KPIs) of their businesses. They have limited time and cannot navigate through the increasing volume and complexity of information within their organizations. They need to be able to focus on critical business issues and quickly take corrective action. Dashboards can provide this type of critical information in a graphical format so executives and managers can quickly spot trends and access detailed information when required. Balanced Scorecards or Scorecards are also another type of performance measurement application that is sometimes confused with dashboards. Scorecards help companies set and communicate goals, assign responsibility, establish key performance metrics, and continuously measure performance against company objectives.
Hyperion Performance Scorecard helps focus your company on business objectives, plans and actions. You can empower your employees with clearly defined performance measures for success and enable continuous performance improvement for the entire company.
At Analytic Vision, we understand how important it is for key managers and executives within your company to quickly and easily view the health of the organization. Our team members are experts in quickly implementing Hyperion's products to create dashboard and scorecard solutions depending on your requirements. Give us a call today and we will be glad to help you get started.
|
