September 22, 2003 at 3:12 pm
Hi,
I have a cube with a date dimension of
Year – Qty – Month – Date
And I am access the cube via an ASP page (Not dot net)
My Question is if a user supplied a date range for example
1 Jan 03 – 30 Jun 03
How can I calculate that is date range fits exactly into Qtr 1 – Qtr 2 ?
This will then save me referencing the months level (6 members) and go directly to the Qtr level (2 Members)
Kevin
September 25, 2003 at 8:00 am
This was removed by the editor as SPAM
October 10, 2003 at 8:02 am
the moment you invent an "idiot proof" application, along will come a clever idiot...
Honestly, the best answer is to change the user interface to allow the user to query on quarter as well as date range. Then, if the user specifies dates that EXACTLY align with a quarter, and the query runs slower, you can chalk it up to "user error." (If it really is slower, the user may learn their own mistake and switch on their own).
There may be tricks that could be applied to this problem, but it sounds like you've hit a point of diminishing returns.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply