INTERVAL TIME SUM COLUMN

Star Schema vs All in one table

Hi, I have a scenario where we have dimensional information and the facts in one table rather than a traditional break up into facts and dimensions. What could be the problem i could run into with having all information in one table. Thanks.

Dates in many dimensions

Hello, I am new to DW. Currently, I am working on a Human Resource database. There are many tables in the source systems which stores dates e.g. dates about contract start, finish, Vacations of an employee, temporary service suspension and many more.

[Bass]Interval, Triad, Chord Construction (1-3-5-7)

kawan2 smua, nih ane nemu inpoh bagus ttg bass tapi ane ga ngerti gan....tolong kalo ada yg ngerti ttg Interval, Triad, ato Chord Construction bisa bantu jelasin....tolong bgt ya gan klo ada yg paham C - C = namanya Unison = ga ada jaraknya / 0 half

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

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

Sequences Interval and Method Solfegio

Bagi temen-temen yang tertarik dengan jazz, nih saya mau sedikit share.. tadi tiba-tiba browsing nemu Circle of Fifth yang seperti ini.. INI JAZZ ALIRAN SESAT!!! hati-hati kalo baca artikel, banyak yang sembarang posting di internet, google,

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

Separate column for moderator names

Now moderator names are displaying below forum forum names in this format: Forum name Moderator: Username I'm suggesting to add separate column on index page for moderator names, (like topic and post numbers or Last Post). This will abridge the

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

online status time

An option where you can set the "who is online" time ... if your are inactive for 10 secunds you are already not online ... I think a setup option for this time would be great ... so users can read in a topic and be shown online on the botton of

Riflemen to the front of the column

This time they were not been sent off to act as forward scouts in territory they were sure of holding; this time their job of sweeping the area in front of the column was being done for real. Even the army would march without the formal parade first -

Funny comedy joke time!

We all could use a laugh now and again, so here's where to find one when you need one. If you have something funny from your fave comic that you want to share, post it here. I'll get the ball rolling with one of my favorites, the late great Bill