power-up your reporting for oracle apps! enterprise reporting and dashboard solution rob griebel,...
TRANSCRIPT
Power-Up Your Reporting
for Oracle Apps! Enterprise Reporting and Dashboard Solution
Rob Griebel, Noetix
Agenda
• About Noetix
• Reporting Challenges
• The Noetix Solution
• Product Demonstration
• Q&A
About Noetix
• Information access experts since 1994
• Offices in North America and Europe
• Oracle Certified Partner
• 1200+ customers worldwide
Industry
A W A R D S
Reporting Challenges
Oracle Reporting Challenges
• No Business User Reporting Capability
• ERP – Large and Diverse User Base
• Most Companies Have Significant Reporting Backlog
• Bundled Solution – Costly to Develop and Maintain– Requires Programming Expertise– Technical Challenges
• Limited Available Alternatives– Complex Data Model = Data Mapping
• Complex Data Nomenclature
• Poor End User Adoption Rates of Reporting Tools
The Noetix Solution
User Reporting Challenges Solved
Challenge
Ability to run ad hoc queries
Complexity of Oracle data model
Access to data no matter where it resides
Need IT assistance
IT backlog Report development cycle takes significant effort
IT constraints and other priorities
Learning curve
Want data represented in familiar terms
Want to use tools I know
Re Use of content for reports, dashboards
Quick installation of common technology that all tools can use (Noetix WebQuery, Excel, Dashboards)
Valuable reports out-of-the-box you can customize and deploy yourself
Automatically generates business views in terminology users understand
Noetix Solution
• NoetixViews®
Provided 650+ views of the underlying data structures
• Noetix AnswerPoint™
Delivers hundreds of click-on, customizable answers to business questions.
• Noetix QueryServer®
Integrates disparate data sources into a secure query routing and management platform.
• Noetix WebQuery® Empowers decision makers to create and modify reports without IT involvement..
• Noetix Dashboards™
Interactive graphical presentation of enterprise information
Noetix Solution Components
Noetix Platform
Query Mgmt Services
Metadata Repository
Custom Views
HRHR CRMCRM LegacyLegacyAppApp CustomCustom DM/DWDM/DWOracleOracle
Generated ViewsOracle Applications
Data
Noetix Architecture
Noetix Dashboards
Generated Reports (Templates)Oracle Application
Noetix WebQuery
with Excel Integration
Query & Reporting
ToolsApplications
Custom Reports
Noetix Metadata Repository
What is Metadata?
Your configuration…
Setups
Users/Roles
Business Rules
Organizations
Oracle Applications 11i
Noetix MetaBuilder
Oracle Applications 11i
Security
NoetixViews
How Noetix Uses Metadata
Noetix Metadata Repository
Query & reporting
KPIs and metrics
Transaction data
What is a View?
Example:Purchase Order tables in the database
PO_HEADERSC PO_LINE_TYPES
PO_LINES
MTL_ITEM_CATEGORIES MTL_ITEMS
AP_TERMS PO_UN_NUMBERS
Your Report
Open POs
PO No.Item
DescriptionList PriceQuantity
Unit PriceVendor
Simplified Noetix “View”
PO_Lines
BuyerCurrency
ItemDescriptionList PriceOpen FlagLine No.PO No.QuantityTerms
Unit PriceVendor
MTL_ITEM_CATEGORIES PO_LINE_TYPES
PO_LINES_TL
PO_HEADER_TL MTL_ITEMS_TL
PO_NUMBERS AP_TERMS_II
Same View No changes!New database structure…
Key Flexfields as Configured
Key FlexfieldBase Table Column Names
SEGMENT12
SEGMENT6
SEGMENT3
Account$Company
Account$Division
Account$Cost_Center
Key FlexfieldView Column Names
Noetix QueryServer
Integrates disparate datasources into easy-to-usevirtual tables
Provides simplified integrationwith Oracle Application data
Centralizes control & dataaccess management
Oracle Siebel Legacy
Centralized Query & User Management
Dynamically integratesreports with Microsoft Excel
Noetix WebQuery
Cost-effective, zero client information delivery (XML)
Easily-to-Use ReportingInterface for Casual User
Navigation Tool of theNoetix System
Web Based Interface
How much?
How many??
Noetix AnswerPoint
• Provides end-users with immediate answers to business questions
• Automatically generates over 550 reports custom to your Oracle implementation
Immediate Answers
• Provide Templates for Custom Report Requirements
Why We are Successful
Pre-generated Content– Views and reports that pick up configuration
End User Independence– Ease of use
Faster Time to Market– Predictable, proven implementation
Open Architecture– Easily integrate with other data sources
Performance– Don’t have to sacrifice real-time data
Change Management– Upgrade protection
Why Noetix is Different?
the only software provider that
automatically generates content
(metadata) from Oracle
Applications, enabling immediate
access to enterprise-wide
information.
Product Demonstration
Demo Overview
• Pre-Built Reports You Can Customize
• What You See is What You Get
• Power-Up Your Query Tool of Choice
– Microsoft Excel
– Dashboards
Questions?
Q&A