I'm very new to MDX querying, so please bear with me.

I am working on tracking hardware/software assets within my company.


I have a fact table schema with the following:


Date, ReportingId, MachineId, SoftwareId
4/19/2007 526 3 1
4/19/2007 526 3 2
4/19/2007 526 3 3
4/20/2007 527 1 1
4/20/2007 527 1 2
4/20/2007 527 1 3
4/27/2007 528 1 1
4/27/2007 528 1 2
4/27/2007 528 1 3
4/27/2007 529 2 1
4/27/2007 529 2 2
4/27/2007 529 2 3
4/27/2007 529 2 4
4/27/2007 530 1 1
4/27/2007 530 1 3


All machines are scanned at some interval, techs can force a scan at
any time (so there may be more than 1 entry for a machine per day;
that's why they are using a reportingid; it represents a scanning
session I guess)


The idea here is to track all the software installed on a particular
machine, at a specific point in time. So if I wanted to report on
machines between 4/20 and 4/27, I would need to see data from
reportingId 529 and 530, but not from scan 526 because it is outside
the date range.


How would I query for this? I know how to query for this in SQL, but
I am at a real loss here. The cube design is not set in stone and is
fairly flexable at this point.


Also eventually, I need to report on top vendors, software growth,
etc
to negotiate pricing. So if there is anything I should keep in mind,
any help would be appeciated.