ReportNet and PowerPlay

lavishgradeSoftware and s/w Development

Nov 25, 2013 (3 years and 9 months ago)

99 views

ReportNet and PowerPlay

Extranets and Intranets

City of Albuquerque

Public Sector

Agenda


Overview of Cognos Environment


Why ReportNet?


Extranet


Intranet


Lessons Learned


Q & A

City of Albuquerque


City of 450,000


Cognos Administration


Cognos Security


Cognos Training


User Environment

Why Reportnet?


Cognos Connection


HTML Presentation Capabilities


Report Development Capabilities


Improved Query Studio


Embedded Noticecast


Framework Manager


Easier Administration and Control

Extranet


www.cabq.gov


Quick History


Usage of Cognos reporting


Public Comments


Systems Environment


Two IBM Netfinity Servers


Windows 2003 Server


ReportNet, PowerPlay, Noticecast


Oracle database


Development Server


Inside Firewall


Applications
-

Current


Campaign Reporting


Investor Information


Crime Statistics


Air Quality


Payables


Case Tracking


Web Payments


Noticecast


Utility Billing and ACH

Applications
-

Future


Restaurant Inspections


Building Permits


Citizen Relationship Management (CRM)


Other?

Conversion Issues


Importing of Architect Models into
Framework Manager


Rewrite of all Extranet Reports and
Transformer models


Addressing new issues with ReportNet


Approximately 5 month process

Cognos Connection


Deployment


Security


Suppressing functionality


Publishing Reports to Extranet


Overcoming Obstacles

Reports


Report Studio only, no Query Studio


User and IT developed reports


Demonstration (Extranet connection)


Crime Statistics


Campaign Reporting


Noticecast

The Good,


Framework Manager


Fantastic!


Simplified Extranet Report Development


Powerful Development Tools


Report Prompts and Layout


More control over PDF output


HTML Presentation Improved

The Good,


Customization of User Interface


SDK tools


One Windows Service for Reportnet


Installation much easier


No more Upfront


No more Client Tools


The Bad, and the Ugly


Cognos Connection
-

Holes


Hiding Reports


Output Formats in Excel and CSV


Storing of Prompt Values

The Bad, and the Ugly


Report Delivery


Browser versions


Still in infancy stage for Extranet
environment


Intranet


Quick history


Users since 1997


Started with PowerPlay, then……


Impromptu, IWR Cognos Query and
Noticecast

Systems Environment


Two IBM Netfinity Servers


Windows 2003 Server


ReportNet, PowerPlay, Noticecast


Professional, Business, Consumers


Oracle, Sybase, SQL Server


Development Server

Application Environment


Financials


General Ledger,
Receivables, Procurement, Fixed Assets


Human Resources and Payroll


Fiscal Agent Transactions


Utilities


Public Safety

Applications
-

Future


Peoplesoft CIS


Air Quality


Peoplesoft CRM for Government


Building Permits


Other

Other Conversion Issues


Impromptu Reports, Cognos Queries


Query Studio vs. Report Studio


Rewrite of PowerPlay Cubes


Revisiting Security


Training, training and training


Currently ongoing, estimated 8 month process


Phased deployment

Security


Cognos Series 7


Cognos


Domino LDAP


Groups vs Roles


Framework Manager


Model for each Internal Databases


Controlled by Information Services


IQDs for PowerPlay Cubes


Demonstration (Intranet connection)


Structure of tables and packages


Calculations


Publishing Packages


Security

Cognos Connection


Organization


Security & Public Folders


Cognos Portal Services and Websphere

Reports


Decentralized Report Development


Demonstration (Intranet connection)


Cognos Connection and Portal Services


Query Studio


Report Studio


PowerPlay

The Good,


Query Studio


much improved


Embedded Noticecast


Easy deployment


Report consolidation

The Bad, and the Ugly


Impromptu Report Conversion


PowerPlay Integration


Still a new product in infancy stage

Lessons Learned


Standards


Security


Training



Questions


And Answers!