"Perfect" design vs. Time to Implement

time relatives - YTD, MTD, QTD the best approach

What are the various design options for calculating fact by YTD,MTD, QTD for multiple different calendars?

This tip suggests that we can eliminate the minute dimension and have a full time stamp in the fact row.I need more clarification on how this could be implemented. For instance if I need a fact to be shown with 1/2 hour split down how could I do it withou

Perfect Dates

As the title says, how would you describe a perfect date... with or without the nasty

Best way to implement date ranges in schemas (fact 1 valid "from" date1 "to" date 2)

Greeting, I am roaming around the web and im not very successful in my research so i will ask here, hoping that someone smarter than me will be able to help! Basicly, I need to build a cube (and the underlying start schema) that will allow the user

Time in fact or dimension? Accumulating snapshot

I need to build an accumulating snapshot where not only do I need to track the many dates I need, but also the specific times of when things occur. Role playing and using a date dimension is not enough because it doesn't track the specific time of the day

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

The "perfect" forum presentation

Hello everybody To help you with your forums promotion, here is how we would promote the Forumotion support forum (for example). Important : This type of presentation isn't mandatory, but we recommend you present you forum this way, because

Dimension Modeling Design challenge - Help Needed

Guys, Help me out identifying whats wrong with my model. I am able to get to the right data, but size of the fact table is arguably high and not gladly acceptable. Let me show you the picture (tip of the iceberg) Data table in transaction db is

Iraqi company to implement project of trade zone

Iraqi company to implement project of trade zone Monday, March 22nd 2010 7:56 PM Basra, March 22 (AKnews)- The Secretary of Investment board in Basra, Jalal Noori, said Monday that granting the license to the project of trade zone border with Ira

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

What's the current time in your country?

well this is simple Just tell us what's the current time on your country everytime you log or so on It's 9:15 pm here.

SimBro_Release_v2.1.4_100131_TEST

rapidshare.com SimBro_Release_v2.1.4_100131_TEST.zip rapidshare.com SimBro_Release_v2.1.4_100131_TEST1.zip mediafire.com ymmnziitmow [Fix] Some typo, Style level bug [Codechange] Clean up some mess, [News] Nothing....

[NEW CONTEST] Time to get creative for Christmas!

Hello We're now near XMAS! And to celebrate the event, ForumOtion is offering you loads of credits with this new contest of XMAS themes ! Let's see a flashback of last year winners: 1st, with 65 votes : Christmas magics 2nd, with 62