IBM Data Management Community Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems. Join / Log in
Drill Down Paths
In the same way that this grid can be drilled into,
QMF supplies drillable charts called Drill-down Paths, as follows.With any query result, click the button for “Transfer to” and choose Drill-down Path:
Choose a chart for the first image;As with Charts choose the category and value and aggregation type.Adjust the FormattingClick Finish to see the first chart of the series. Note this black square says you are still making the drill down. You click it to stop the creation and save the drill down path. Proceed to choose the next chartAnd format the chartNow the second chart in the series is shown. Click on ANY BAR to make the next chart.Add the Category and Values and AggregationFinally adjust the chart format and click OKWhen you have all the charts you need click the Black button to end the series and save.You will get this informational messageIf you click Yes then you will still need to save the Drill-down path:Now you can navigate the drill-down path by clicking chart elements or reverse your direction by clicking on the directional control arrows.
These can be created in QMF for Workstation or QMF for WebSphere and can use actual dynamic queries or Dynamarts as the source. Of course, Dynamarts will give better performance.