You could try this using Excel to chart a pivot table as an inline image (in "real time"). Three bits to assemble: get the pivot table set up in Excel, chart it, then put the chart on the web. Here's a MS KB article that
demonstrates returning a chart image. (Apologies for the link to MS... google on "google://excel chart asp vbscript web" if stale.) Similar searches should find the necessary info.
This is quite a bit of overhead and probably not a practical solution for a high-traffic page, but OLAP is low-traffic by definition, right? Using the pivot table and chart in Excel should greatly simplify slicing up the cube and graphing code (show me sales >$1000 from regions 1 & 2 in Q2 for the last 3 years by week as a percentage of total sales for the week.)
--
May the Source be with you.
You said you wanted to be around when I made a mistake; well, this could be it, sweetheart.
| [reply] |