Griffin-Schruers, incorporated

Business Intelligence

             


ASK ABOUT OUR INTERNATIONAL SERVICES!!

            

Cognos

Crystal Reports / Business Objects


               cognosdevelopment.gif (1862 bytes)

  • Installation / Configuration
    First Time install
    Upgrades

    Troubleshooting
    Training
    Mentoring

  • IBM COGNOS 10
    COGNOS 8
    ReportNet

  • Cognos Connection
    Business Insight
    Report Studio
    Query Studio
    Analysis Studio
    Event Studio
    Metrics Studio

    Framework Manager
    Data Manager
    Metrics Manager
    Transformer

    PowerPlay Studio
    Query Analyzer
    SDK

  • advanced Framework design
    Data Manager ETL
    multiple datasources
    aliased tables
    various query subject levels and view
         presentations layers
    complex, manual joins
    unions
    SQL queries
    security via user class setup and corresponding
          filters
    connection to various data sources via Cognos
          Connection and Framework Manager
          modeling


    Mine data from 3rd party products
         Mapics Syteline
         Sungard Pentamation/Banner
         Avaya Call Center
         Avexus Impresa
         VIP
         SSA ERP LX
         Infinium
         SAP BW

  • COGNOS SERIES 6.x and 7.x
    advanced Catalogue design
    connection to various data sources either 
         directly or via hot files (Oracle, SQL Server, 
         text files, etc.)
    table weighting
    Impromptu report techniques
    advanced framing
    complex formulas
    prompts and filters

    sub-reporting
    Access Manager
    IWR (on-demand, bursted, prompted)
    Powerplay Web

  • QA/QC of report results to verify results (usually through SQL queries via other tools)
    limited script generation to run scheduled reports automatically

  • deployment techniques
    Cognos Connection
    LAN (on-demand, prompted)
    creation of IQD files from Impromptu reports for use in cube design /
    creation of MDC and PYI type cube models within transformer

  • drill through
    Report Studio report to Power cube
    Report Studio report to Report Studio report
    Cognos 8 and Cognos 10 Package based drill
    Impromptu report to Impromptu report
    Power cube to Impromptu report
    Power cube to Power cube

  • cube techniques
    alternate drill paths within cube
    conditional formatting
    security within cube design
    measure definition
    customized dimension views
    allocation

  • cube optimization
    server settings
    settings (data type, formating, etc.) within cubes

  • cube design - 'spreadsheet' vs. 'columnar' style

  • power prompts

  • row level security techniques

  • Architect


Crystal Reports

  • advanced formulas
  • conditional formatting and suppression
  • custom grouping
  • user prompts
  • complex record selection criteria and filters
  • multiple table data sourcing from a variety of sources (ODBC, native crystal drivers, stored procedures, Crystal Dictionaries, etc.) with complex joins
  • subreports (both linked and unlinked)
  • charts
  • row level security (Infoviews, Dictionaries)
  • column level security
  • crosstabs.
  • versions 4.2 through current
  • web deployment (ciweb, Info, Enterprise, Server [XI]) and portal administration

Business Objects

  • Complex Report creation
  • Universe Design
  • User Prompts
  • Filters
  • Package creation

crystalreports7user.gif (2719 bytes)

wpe1.jpg (3579 bytes)

___________________________________

MS Access
___________________________________

  • Custom Reports
  • Easy to Use User Interfaces (Point and Click)
  • Prompts and pull-downs
  • Filters
  • User Deployment

wpe1.jpg (3579 bytes)

wpe2.jpg (3579 bytes)



Griffin-Schruers, incorporated offers training in all of the above and more.

TRAINING INFO

 

e-mail:  info@g-si.com

or call:

303-489-9420

CALL US FOR A FREE ASSESSMENT OF YOUR CURRENT REPORTING SETUP TODAY!

Home        More Info

Griffin-Schruers, incorporated
2299 Park Ave.
Waldron, AR  72958
T:  303-489-9420   *     F:  404-393-1208

www.g-si.com         e-mail: info@g-si.com
(c) 2003-2007, Griffin-Schruers, incorporated, all rights reserved