I have the following cube set up:

Fact table of dates when our sales people called on each customer.
Time dimension (which has the structure
FinancialYear->Quarter->FinancialMonth->Week->Date)
Grade dimension
Banner dimension

Each customer has a particular banner and grade.

I am trying to return the number of calls for each grade of customer (on
the columns), with the banner the customer belongs to on the rows.

The problem I am having is that I want to be able to return the data for
a given date range - ie user selects a start and end date, and it
returns the summarised data for those dates only.

I am having immense difficulty getting the date range going, so any help
on this would be much appreciated.

Thanks in advance...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Don't worry - I've worked it out...

For anyone who is interested, I managed to get it going by creating a
calculated member:
WITH MEMBER [Time].[Relevant] AS
'sum([Time].[StartDate]:[Time].[EndDate])'

and then using this as the slicer dimension...

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!