Hi all, I'm currently using AS2005 to implement a download warehouse.
Basically I have a fact table with the usual dimensions hanging off it
date, product, vendor etc. I then have some measures 2 of which are
[Number of Downloads] and [Download Price]. When a product gets
downloaded a row is inserted into the fact table :

Number of Downloads: 1, Download Price: 0.99, DateKey: 145 , ProductKey
:10 VendorKey 57 etc..

This works well for getting high level figures e.g for March 2006 we
had 1000 downloads and total sales of £10000. what I want to achieve
is download price banding, as we have different Download prices for
different product downloads and want to implement a solution that gives
me the following results:

Download Priced between £0 -0.99 250 Downloads
Download Priced between £1 -100 200 Downloads etc

I've tried to create a calculated measure to work the bands out but the
results always operate on aggregated values and not at leaf level so
they are always summed up . I cannot add the download price to my
product dimension table because the price changes on date and vendor ,
in other words we don't know the download price till it enters the FACT
table and it varies..

I don't really want a Bands dimension and create a key in the fact
table that shows what band it is because this would mean altering the
ETL I really need a solution inside the cube or as an MDX statement.

anyone got any ideas?? cos I'm tearing my hair out

please help

Jim