time calculations | nicolad76

Simple Calculations

Where should I place simple calculations such as A/B where A and B are fields in the database. Should the calculation exist in the database as a separate column or should it be a calculation in the report. What are the pros and cons of both approaches?

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

Store Business Hours in Time Of Day dimension?

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

time dimension

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,

Wondershare Time Freeze [Free offer is time limited]

I found this rollback software from another website,and i checked its official site. Easy switch between virtual environment and actual system: With Wondershare Time Freeze, you don't need to reboot computer to go back to the actual system. Just exit

Real time datawarehouse replacing operational reporting

Hi, As I was reading through articles I came across one of the advantages in real time datawarehouse that it can replace the operational reporting so there is no need for reports to go across 2 reporting DB there can be one centralised Real time DW and

Demyx Time

Have you ever heard of Demyx Time??? I SO hope you have. It is the greatest TV show EVER. (Although, it isn't on TV, so I guess it's not really a TV show...) If you don't know what it is, here's a quick descrciption. Demyx Time is a youtube show that

Time Frame & Estimate

I am new BI learner and currently studying kimball datawarehouse toolkit. I have question, How can i estimate a time frame and estimate in terms of working hours for Data Warehouse project. I know we have to go through whole Business dimensional lifecycle

Point in time reporting using ad hoc functions

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

~*~ Again That Time of Year is Here ~*~

Again that time of year is here When wreaths elves lights appear The hue of Santa’s suit and sleigh Adding color the wintry skies of gray Until pansies roses tulips grow Melting all of the Season’s snow But I like holly gifts Advent more Than all

Banning members from the chatbox for a time period

Hi everyone, I have this idea,when your a moderator of a chatbox on a forum,the mod can use a code to ban a member for a certain time period,instead of banning them,and having to unban them. Example: Code:/ban/{time limit for the ban}

[WALLPAPERS CONTEST] Time to vote for the best one!

Dear users! First of all thanks to all participants! We had 150 wallpapers submitted, which is by far our must successful contest! It's now time to vote for the best wallpapers. Only 5 will win! Ready? All you have to do is to pick your favorite

Time for our next remodel...everybody participate!

Hello guys n' gals! So, the admin is officially done with this evil semester and is ready to remodel Lumine Hall once more. I've gotten some input, and it is now time for all of us to come together and decide what we want to do. That being said, here are