Counting coverages over time

Gehaus at 21h59
05
May
2010
Counting coverages over time

Hi All,

I work for a non-profit mental health org. Many of our clients get benefits from the county. These benefits last a year and then a new one is requested. They have different categories of benefit (2X1, 3A1, 3B1).

I need to count the number of active benefits broken out over time. Counting events that happen on a single date is very straight forward but counting things that have a start and an end date are proving to be
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Hi There Is there a BI tool that can handle the following two reporting scenarios? Please note scenarios to be preferably supported through ad hoc reports that user can build on the fly? Also, if you know how to achieve this functionality in a particular
Hello, I am building my first DataWarehouse and I got stuck on how to handle the time of day and my business hours. I am trying to evaluate response times for support cases and I have multiple time zones with different business hours. I only need to
Just a quickie (as the actress said to the Bishop ). I am counting my meds right now, I want to see what I am taking and how many. Havent done this for a while and would be nice to see if things are better (not worse... ) Its easy to log Triptans
How would you like if there was a hit counting in our forums? What is a hit? Every time someone enters the site (no matter if he's a member or a guest) the system counts a hit... Many sites have hit counters... I think that it would be nice if we had
Hi I have to create a time dimension to cater to the reporting needs. With the current database structure which is not a dimensional model we need to create reports that are period based. How do we create a time dimension table (we need year, quarter,
Forums from same category
See also
more_less
Informations

8 Replies For the topic :
"Counting coverages over time"

This topic has been viewed 1133 times.

Last message :
05/05/2010 at 21h59 by "Gehaus"