The problem (in short):
I need to be able to hook up my charts to dataproviders where
<month_name> equals "January". And only pull that. I dont need it to
read every month in the hierarchy. Or month_name is January and day_name
is '14'. In order to do this I need to do IF logic with the dataprovider
it seems to me. My other post occurred because in leiu of being able
to do "IF month_name='January'. I have just gone in and changed the
xml so that instead of <month> </month> [...] it now says <january>
</january><february></february> etc. That sort of defeats the data
description aspect of XML (it seems to me).
The background (if you are interested):
This problem has to do with me NOT wanting to write 100+ reports to
generate 100+ separate xml files to access.
I need to track the metrics of several internal groups over the year via
charting. I want to drill down into individual months (by day) and --
maybe, days by hour. I also want to track into the sub groups per
month and per day-in-month for each of these groups as well.
The data is network event traffic and doing the queries live will just
not work. Users wont use the slicing and dicing visualization affords if
they have to wait every time the click an item.
So, I know I can save myself a lot of reports by putting all the data
into about 10 - 20 reports or so by using the XML as its supposed to be
used (i.e. describing the data). I need to be able to hook the data
provider to only a sub-node in the xml hierarchy and not have it read
everything at that level. I need it to read only has long as
month_name=January or month_name=January AND day_name='15'.
