Date..From/To selection using Set Analysis

[alexis]

Hi

A small subset of my schema looks as follows:

My rich Calendar table is linked to my Fact table via the AcceptDate field and all the date related selections work as expected. Selecting Year, Quarter, Month etc works as expected returning all the correct data in the table and "Filters" Multi-select box (see below).

The user however has requested a "Start Date" "End Date" facility which I have built for them utilising variable vStartDate and vEndDate for calculating the amount totals in the table using Set Analysis as shown below - this also works fine.

Sum({< AcceptDate = {'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'} >} CUSTOMSAMOUNT)

Problem:

The available options in the "Filters" multi-box do not truly reflect reality as they ignore the date range selected and you may be presented with a selection which when chosen does not generate results. Can anyone suggest an approach that will cater for this anomaly?

[Gysbert_Wassenaar]

Perhaps this tutorial is what you need: Selecting Arbitrary Date Ranges