1 / 22

“Apps Are In … Data’s In … Now How Do I Get The Info Out!”

“Apps Are In … Data’s In … Now How Do I Get The Info Out!”. Russ Proudman ARIS Software, Inc. 425.372.2747 www.noetix.com. Agenda. 1. Reporting Challenges 2. Difficulties Caused by Database Complexity 3. Top 10 List of Key Elements for Successful Reporting 4. Demonstration

spiro
Download Presentation

“Apps Are In … Data’s In … Now How Do I Get The Info Out!”

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. “Apps Are In … Data’s In … Now How Do I Get The Info Out!” Russ Proudman ARIS Software, Inc. 425.372.2747 www.noetix.com

  2. Agenda 1. Reporting Challenges 2. Difficulties Caused by Database Complexity 3. Top 10 List of Key Elements for Successful Reporting 4. Demonstration 5. Q & A

  3. Section 1 Reporting Challenges

  4. What Experts Have Observed “The typical Fortune 1000 company has a big problem: it collects a lot of important business data that nevergetsused.” “Users who could take data and turn it into a competitive advantage can’t get the level of access they need.”

  5. What Do the Experts Predict “Instead of a small number of analysts spending 100 percent of their time analyzing data… All managers and professionals will spend 10 percent of their time analyzing the data themselves using Analytical Processing Systems.”

  6. Running Your Business “I want to see the top 10 vendors in dollar volume over the last year.” “Which invoices were charged to my department this month?” “What is the backlog for item 1265?” “What is the salary history for employees in my department?” Huh? Wha?

  7. How Do You Get The Data Out? Have the Information Services Group Do It Standard Oracle Reports Do It Yourself Not Available! Too Late! Too Hard! “You don’t have the information you need to make informed business decisions.”

  8. Querying Oracle Apps using SQL

  9. End User Query Tools - Example

  10. End User Query Tools “All I need is an End User Query Tool…” • Oracle Discoverer 3.1 • Cognos Impromptu • Business Objects • Brio Query • Crystal Reports • InfoMaker • etc.

  11. Section 2 Database Complexity

  12. Oracle Apps Structure is Complex Problem? Advantage Feature? Comprehensive Suite of Apps Integrated Business Functions 200-300 tables of information per average App Relational Database Great for OLTP Flexibility Need to create complex joins to get to meaningful data Key Flexfields Identify key elements in your business Hard to identify what segments stand for Desc. Flexfields/ Quick Picks Customize Apps for your business Hard to get at and identify customized data elements Performance Oracle is a good performing database Statements must be tuned to perform

  13. Section 3 Top 10 Elements for Successful Reporting

  14. #10. Open Systems- don’t limit your optionsproprietary systems means you’re on a query tool’s upgrade path, method, etc. #9. Automatic Setup- not trading one task for anothercontinual administering / managing query tool is not productive #8. Handle Environment Changes- seamless regenerationif your Oracle environment changes (ie: new SoBs, Op. Unit, Inv/Mfg. Org., etc.) then must be able to regenerate whatever’s required for query tool to keep working #7. Performance Optimization - stop unnecessary waitingtuned queries can be vastly faster than unoptimized ones #6. Organize Information by Functional Areausers productivity is much higher when info broken down by their job responsibility

  15. #5. Index Column Identification- creates fast queriesFull table (multi-table) scans are agonizingly slow while indexes are faster (book) #4. KFF / DFF / LOV Decoding - much easier for userOracle Apps save data as segments(kff), attributes(dff), numbers(lov)Decoding data for user recognition is much easer for reporting / querying #3. On-Line Directory to InformationHaving full help with all objects, definitions, hints, examples, searches means end users will produce reports / queries much faster. #2. Complexity Completely Hidden - user not confusedIf it’s difficult for the end user, they won’t use it! #1. Buffer Needed for Oracle Upgrades / PatchesAs Oracle releases patches / upgrades “they’ll get ‘ya”It’s not a matter of if … it’s a matter of when!

  16. Solution to Database Complexity You can create a business layer in the database using Views • It’s an Open Solution (use any query/reporting tool/SQL, etc.) • Views have the “look & feel” of tables (rows & columns) • Allow for a more complex representation of data than a table • View complexity can be hidden from users (multi-table joins) • Views can be tuned & optimized • Fields in views can identify Oracle Applications index columns • Fields in views can decode KFF / DFF / LOVs

  17. Overview of Views OLAP Clients, Servers Oracle Express Arbor Essbase Cognos Powerplay Oracle ROLAP etc. Query Tools Crystal Reports MS Access, Excel SQL*Plus O Reports ODBC, Java, XML Query & Analysis Oracle Discoverer Business Objects Cognos Impromptu Brio Query Andyne/GQL Metadata Layer Metadata Layer Views Oracle Applications Data Base

  18. PO_Lines Complex Joins Can Be Done in Views Oracle Tables Views PO_LINE_TYPES PO_HEADERS PO_LINES MTL_ITEMS MTL_ITEM_CATEGORIES PO_UN_NUMBERS AP_TERMS

  19. Customize Views to reflect your configuration Oracle Tables Views Flexfields Attribute4 Segment12 Manufacturer_Name Department Quick Picks APPROVAL_CODE MAKE_BUY_CODE APPROVAL_CODE MAKE_BUY_CODE 1 1 2 1 3 2 Rejected Make Approved Make Posted Buy

  20. Section 4 Demonstration

  21. We have a solution … NoetixViews 1. Noetix Help File2. Oracle Discoverer w/ NoetixViews

  22. Section 5 Questions& Answers

More Related