Database
Partner TechTip: A Best-of-Breed Business Intelligence Solution Can Solve a Lot of Business Issues
Written by Tom Huntington   
Thursday, 13 March 2008

Is your BI solution hard to install and difficult to use?

By Tom Huntington

Is your BI solution meeting your needs? It might not be if you have any of the following symptoms: Your data is out of date; your report backlog is still a backlog; your BI technical department is larger than two people; your team spends time redefining your data to make the solution work; your technical team spends hours upon hours installing program fixes; your solution works only with one database; it's too complicated for end-users to write their own inquiries; and anytime you want to do more, you have to pay.

Last Updated ( Tuesday, 06 May 2008 )
Read more...
  Discuss...

User Rating: / 0
TechTip: Know the Drill!
Written by Gene Cobb   
Thursday, 13 December 2007

Enhance your DB2 Web Query reports by using drill-down capabilities.

By Gene Cobb

 

Hopefully, by now you've had a chance to install and use the new DB2 Web Query for System i tool. Hailed as the successor to the popular Query/400 product as the strategic System i query and reporting tool, DB2 Web Query can do things that Query/400 could only dream of. One of these advanced features is drill-down: the ability to select a column in a high-level (summary) report and click through (drill down) to show the next level of detail in another report.

 

Two types of drill-down capabilities can be implemented with DB2 Web Query:

 

·        Programmatic drill down—This requires developing at least two reports: a high-level summary report (also called the parent) and a detail report to link to (the child). The parent report contains the information necessary to link to the child report. The child report could in turn drill down to another linked report to reveal the next level of detail. Each new level of drill-down requires the creation or existence of another linked report.
Last Updated ( Tuesday, 06 May 2008 )
Read more...
  Discuss...

User Rating: / 8
Partner TechTip: Coordinating System i Data with Windows or UNIX Data Is Not Easy
Written by Tom Huntington   
Thursday, 06 December 2007

How do your System i queries access Oracle, MySQL, SQL Server, and other databases?

Do you need to combine System i, UNIX, and Windows data all on one executive dashboard panel? Do you need to consolidate data from multiple databases in your network? Are you tired of being forced to transfer System i data from your DB2/400 database to a data warehouse so that it can be queried?

The basic i5/OS Query product allows you to access only your local DB2 data through the queries you write. IBM's new Web Query tool also allows you to access your DB2 data, but it costs extra to use and connect to other databases. In addition, you have to go somewhere else for support for these connections. Other tools allow you to access DB2 data on your System i, but they do it from Windows or UNIX. Wouldn't it be nice to have a System i-centric solution?

Last Updated ( Tuesday, 06 May 2008 )
Read more...
  Discuss...

User Rating: / 0
TechTip: Debugging Multi-Result Set DB2 Stored Procedures
Written by Michael Sansoterra   
Thursday, 29 November 2007

Use Microsoft Access as a great testing utility.

Stored procedures are great tools for easily delivering the results of one or more queries (aka result sets) to a client/server or Web application. (For a brief outline of this technique from the client side, see "Retrieve Multiple Result Sets from a Stored Procedure.") However, testing DB2 stored procedures that return multiple result sets can be challenging. For instance, I wrote a stored procedure that returns an immense amount of related data in six result sets and is subsequently processed in a SQL Server database. Every once in a while, however, there is a problem that requires examination of all the result sets for troubleshooting. How does one go about easily capturing these result sets?

Read more...
  Discuss...

User Rating: / 0
TechTip: Pseudo Journal—Estimate the Overhead of System i Journaling
Written by KENT MILLIGAN   
Thursday, 08 November 2007

Are you afraid to journal because of the potential overhead it can add to your system? Fear no more!

Read more...
  Discuss...

User Rating: / 0
Partner TechTip: Transform Spool Files into Meaningful Information
Written by Duncan Kenzie   
Thursday, 20 September 2007

Easily generate summary data, charts, graphs, KPIs, or graphic reports such as invoices.

BCD's Catapult is a business intelligence solution with a difference. Because it has tight integration with BCD's application modernization suite, it delivers meaningful information to users through more distribution channels than comparable products.

Read more...
  Discuss...

User Rating: / 0
<< Start < Prev 1 2 3 4 5 6 7 Next > End >>

Results 1 - 6 of 40

The following trial software can be found at the MC Press Software Center.   



   MC-STORE.COM