The Managed Query and Reporting Environment Foxfire Query

Скачать презентацию The Managed Query and Reporting Environment Foxfire Query

f320ddb4084e59dab9960e1156a85aaf.ppt

Количество слайдов: 51

Who is Micromega Systems? n Software developer, publisher, and IT training company n 21 years in business n Do not resell other people’s products n > 100, 000 seats for Foxfire! n > 300 vertical industry partners Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Importance of Database Design The Real World (where users operate) Activities & Events Understand, Control, Improve Data Entry & Retrieval Procedures (The System’s Personality) Application Software Collect Measurements & Descriptions (Data) System Software (W 2 K, Fox. Pro etc. ) Collect Arrange Store Hardware Look For Patterns & Relationships (Information) Retrieve Count Compare Arrange Display Databas e Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

The Challenge End User Reporting Skills Foxfire! moves the barrier to end user reporting Totally Helpless Other BI Tools Ordinary user - not a data jockey, but needs practical business intelligence to do their job Copyright © 2002 Micromega Systems, Inc. Fox. Pro Report Writer (ugh!) Power User Damn near a Programmer Foxfire! is a registered trademark of Micromega Systems, Inc.

What is Foxfire!? n Query builder and Report generator n Fox. Pro App n n n Manages the query and reporting experience behind the scenes Provides total data access to ordinary end users Integrates seamlessly Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Easiest to Use n Managed Query/Reporting Environment n All business logic stored in tables n Data items – stores table and field spec’s n Joins – stores relationships n Requests – stores report definitions n Preferences – stores user & group privileges Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Easiest to Use n n Bird’s eye view of reporting task Point-and-click report design No techno-babble Complex tasks are automatic n n n SQL generation Layouts painted Group totals and other arithmetic functions for numeric fields Predefined validation rules, expressions, subqueries and other processes Ask-at-Runtime criteria Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

FUNCTIONAL COMPONENTS OF FOXFIRE! User Interface (collects specifications for the query / report Request. User access to features and data views are controlled by the active Preference Set Request Definition Table Data Item Table (Field Definitions) SQL Statement Generator (creates native SQL from specs and the data dictionary) SQL Statement Join Table (Relations) Query Engine Std. Rushmore or ODBC w/ SQL Pass-through (in the Enterprise Edition) Results Set (a Fox. Pro Cursor) (temp file) Layout Engine Generates FRX’s or XSLT templates Report Layout Definition (FRX or XSLT) Administrator’s Tools & Utilities (loads meta-data tables w/ specs for Data Items, Joins (relations), Preference Sets (user profiles), etc. Preference Set Table User, group, & reporting task profiles FRX or XSLT Template Tables Report Engine Standard Fox. Pro module or XSLT engine) Output Manager: To a printer, data store, OLE, Web Publisher etc. Rectangles indicate programs or processes. Ovals indicate tables or data stores. Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc. Output Can be printed report, XML data stream, XLS Pivot Tables, PDF (to email or web, HTML marked up ASCII, DBF etc.

Usability Highlights n n Bird’s-eye view of the task Point-and-click report design No techno-babble Complex tasks are automatic n n SQL generation with complex join criteria Layouts painted with group totals or other arithmetic functions for numeric fields Predefined validation rules, expressions, subqueries and other processes Ask-at-Runtime filter criteria Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Easiest To Integrate and Customize n Meta-Data n n n User and group Preferences manage data and privilege access Data dictionary – defines fields, data groups, joins Logic Hooks – allow insertion of custom features at most key points Object model – exposes Foxfire!’s functionality to other apps, supports custom user interface in any OO language. Templates -- for report layouts, XSLT, etc. Source Code – modify it your way! Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Preference Table n n n One record per user, group or reporting task Manages each user’s or group’s access to data and features Maintained with System Administrator’s Utilities Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Data Dictionary n English names e. g. data items (fields) n Filter management parameters n Calculations n Advanced processing options n Derived attributes (calculated fields) n Alternate joins Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Source Code & Project components Everything but the SQL generator and license control logic But be warned … Modifications complicate your life Create more maintenance objects Upgrades are burdensome There’s a better way! Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Configuration Module FOXFIRE. APP Preference file setup logic begins Global Setup logic begins Nextphase logic begins FFCONFIG. PRG tcphase = “Preference file setup”. your own code for a feature. return tcphase = “Global setup”. your own code for a feature. . return tcphase = “Nextphase”. your own code for a feature. return Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Have It Your Way w/ FFCONFIG. PRG Insert custom code at Logic hooks n 18 global – w/ every Request n 7 ODBC data-source - for custom data acquisition logic n 4 local - unique to each Request n Frequent extensions - e. g. v 6. 02/3 After Request Export; Before Request Import Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

FFCONFIG – Global Hooks GLOBAL HOOKS STARTUP PREFERENCE FILE SETUP GLOBAL SETUP REQUEST SETUP BEFORE SQL GENERATION BEFORE FRX GENERATION” AFTER FRX GENERATION” BEFORE SELECT” AFTER SELECT” BEFORE REPORT” AFTER OUTPUT” BEFORE EMAIL” AFTER EMAIL” BEFORE XML IMPORT” AFTER XML IMPORT SUCCESS” BATCH BUILDER ADD” BATCH BUILDER RUN” CLEANUP” Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

ODBC & Local Hooks ODBC DATA SOURCE CONNECTION HOOKS QUEUE JOB NEW SERVER RECORD BEFORE CONNECTION AFTER CONNECTION BEFORE DISCONNECT AFTER USER LOGIN “LOCAL” REQUEST HOOKS BEFORE SQL GENERATION (do procedure) BEFORE QUERY (do procedure) AFTER OUTPUT (do procedure) Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Special Features Batch Processor / Scheduler Import/Export - exchange Requests with other Users Web Publisher (for reporting over the internet Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

New or TBA Features XML output w/automatic XSLT Link to Excel for graphs & pivot tables PDF support Email PDF, XLS, XML, etc. Dispatch results from Preview Object Model component supports programmatic operation and custom UIs Web-based reports next month Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

New Web Based Reporting Ability to Design and Run reports on the internet All existing Foxfire! requests will work immediately with the web interface Works with Windows 2000 / XP and IIS, VFP 7. x Available In October of 2002 Demo Now !!! Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

New Com / VFP Object Model Ability to Design and Run reports as well as access / update other Foxfire! metadata programmatically without the Foxfire! UI Implemented via a COM and native VFP component Beta version 1. 0 is available now at www. micromegasystems. com for download to current developer maintenance subscribers. V 1. 5 will be available later this fall Runs under VFP 7. x (unsupported by MMS on VFP 6. x) The following – A technical overview of the Object Model Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

FFAPPLICATION Main Component CREATEOBJECT(“FOXFIRE. FFAPPLICATION”) NEWOBJECT(“FFAPPLICATION”, ”VFOXFIRE. VCX”) Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

FFAPPLICATION Methods n SETLOCATION () n n Specifies where Foxfire is installed LOADPREFERENCE( ) n Loads Foxfire preference sets and requests Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Object Model – Level 1 FFAPPLICATION PREFERENCES REQUESTS JOINS DATAITEMS Request Object Collections Properties Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc. STYLES

Loading Preferences SET CLASSLIB TO VFOXFIRE lo. FF = CREATEOBJECT(“FFAPPLICATION”) IF loff. Set. Location(“C: FF 60”)=0 IF lo. FF. Load. Preference(“Demo Use Of Views”)=0 ? lo. FF. Requests. Count ENDIF Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

FFApplication Methods n n n All methods return numeric codes 0 means success Negative values are errors lc. Msg = lo. FF. Error. Info(ln. Error) Returns the error message Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Collection Methods n n n Find ( c. Key. Value) Set. Index (n. Numeric) Items ( nindex/key) lo. FF. Requests. Items(“WORDWRAP”) lo. FF. Requests. Items(1) Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Request within Collection Request Data. Items Sorts Filters Sort. Item Data Item Filter Item (based on Data. Item Object) Data. Item Hidden Sort. Order Not Grouped Relationship Group. Options Value Runtime Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Request Object Properties • Request. Name • Description • Type (Detail/Summary) • Output. Type (Report/XLS, etc) Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Collection Methods n n n Find ( c. Key. Value) Set. Index (n. Numeric) Items ( nindex/key) lo. FF. Requests. Items(“WORDWRAP”) lo. FF. Requests. Items(1 Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Sample New Report X = createobject(“ffapplication”) x. Set. Location(“C: FF 60”) x. Load. Preference() lo. Rep = x. Requests. Add( “Detail” ) lo. Rep. Data. Items. Add(“Cars Make”) lo. Rep. Data. Items. Add(“Cars Model”) lo. Rep. Sorts. Add(“Cars Make”) lo. Rep. Sorts. Add(“Cars Model”) lo. Rep. Groups. Add(“Cars Make”) lo. Rep. Output. Type = “Spreadsheet” lo. Rep. Update( ) Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Object Model Support V 1. 5 n What’s Supported n n n Running Queries Output to Files Updating of Data Items Quick Report Creating / Running Reports Ask-At-Runtime via parameters Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Cost Effective n Standard Edition (Fox. Pro & VFP) n Developer’s Edition @ $395 n Web Developer Edition @ $695 n n Custom apps – embed object code royalty-free Commercial products n n VAR and OEM agreements w/ monthly reports and royalties Less expensive than any product in its class Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Cost Effective n Enterprise Edition (FP, VFP & ODBC) n Developer’s Edition $495 @ named seat n n Includes source code, project components, 1 designer license Web Developer Edition @ $995 named seat Royalty-Free Runtime (canned reports) End User Designer Licenses $495 @ 5 concurrent seats n n $99 @ concurrent seat Compare to Crystal or any other Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Distributing w/a Product n n Every distribution with a product requires a report and royalty payment VAR’s embed in every copy n n Indistinguishable from the rest of the app No extra cost whatsoever to customer Pre-pay in blocks, report sales monthly OEM’s private label (optional add-on) n May charge extra for it Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

The Deal You Can’t Refuse Show Special Offer Buy from our web site by COB Monday, and take $100 off the Enterprise Developer’s Edition Or $50 off the Standard Developer’s Edition No Hassle Guarantee Complete satisfaction or your money back Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Advantages & Benefits n n n Enables users to roll their own Organizes query and reporting tasks Focus on results, not mechanics of retrieval Hides unnecessary information Remembers technical details (eliminates repetition Lowers time and cost of experimentation Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

The Rave Reviews “I absolutely love this product…” - Dick Pierson, Micro Resource, Inc. “Easy to use… Show users and sell product” - Jerry Mandel, Ventana C&P Sol’s “A must-have in every sale” - Jay Rubin, DFC Enterprises “Essential …contains all the business rules…” - Stewart Jackson, Megabyte - DDP Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

The Reader’s Choice Foxfire! received awards from readers of Databased Advisor Magazine 4 years in a row n Best Fox. Pro Add-on - Winner n Best Windows Add-on - Winner n Best Query Tool - Hon. Mention n Best Windows Report Writer - Hon. Mention n Best DOS Report Writer - Hon. Mention Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.

Thank You (the end) www. micromegasystems. com sales@ or support@ or licensing@ Foxfire Forums on the web Pre-Sales Tech-Support (800) 453 -6655 or (415) 945 -3333 Chick Bornheim (415) 945 -3352 cbornheim@micromegasystems. com Copyright © 2002 Micromega Systems, Inc. Foxfire! is a registered trademark of Micromega Systems, Inc.