inventory snapshot - GMROI calculation
Hoping someone can advise on this. I've got the DW Toolkit book and it's been invaluable in setting up a simple retail sales fact table with conformed dimensions. We've now moved on to chapter 3: inventory and our users have requested a stock snapshot,

Inventory Snapshot - GMROI Calculation
We are developing a solution for our company. We currently have a sales cube and we are in the process of building an inventory cube. We are having a design problem in that we are not sure if we should include some of the measures which currently exist in

Pressure mounts for dinar revaluation Kuwait
Pressure mounts for dinar revaluation http://www.arabianbusiness.com/11145 Kuwait's state news agency blamed the dinar's peg to the dollar for rising inflation on Monday, building a case for a currency revaluation after weeks of market pressure on

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,

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

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

SET2/Q.3 Given below are the patterns of three individuals, explaining how they interact socially.
Q.3 Given below are the patterns of three individuals, explaining how they interact socially. Miss Sunidhi- She is protective and controlling Mr Rajat-He is rational ,calculating and unemotional. Mr. Sahil- He is spontaneous and dependent. Classify

Real time datawarehousing
Hey, There is a lot of buzz going on regarding real time datawarehousing. But how do you actually do this ? How can you implement conformed dimensions and conformed facts in real time ? How can you consolidate data real time ? Vendors promise

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

Time Dimension vs Measures in Minutes
Hi All, I would like to design the time in a multidimensional model. The classic calendar date dimension (day, week, month, year) should be applied here. Besides that, I have a fine grain: the minute. More specifically, let's suppose I have 10.000

PPD Calculation
I use the FAH GPU Tracker V2 Version 3.24 on Windows7 x64. It seems, that the tracker have a little problem with the timeformat from the system. The text-window of the tracker is filled up with error messages. The content of the logfile

Handling different Time Zones
I have SSAS 2008 with sql server 2005 database as a source. Currently, we store all dates in UTC time and use system generated Time dimension in the cube. Up until recently the granularity of a day was just fine for our needs. Now ( I've been doing

Modeling goals which may slowly change over time
I did a quick search on goal modeling and didn't seem to find an existing scenario that matched the one I am posting about. I have a DW modeled against data from a time-charging application within an IT department (ie everyone must record time spent on