inventory snapshot - GMROI calculation

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

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

Accumulating Snap Shot Challenge

Hi, I'm working for a large Internet Service Provider (ISP) and have a DW modelling challenge which I hope people can help me out with. Their nature of business includes as a fact recording as an accumulating daily snapshot real time partition basic

Updating Periodic Snapshot Fact Tables

What are the best practices for maintaining periodic snapshot fact tables if the atomic data that created them is modified? We have a couple periodic snapshot tables that capture new inventory and new revenue at the end of every month. Sometimes the

Fiscal Dim and Snapshot Dates for Budgets

Hi everyone, I have a couple of questions regarding fiscal dates and snapshot dates/data: 1. How would someone model a "fiscal" dim when a date maps to two fiscal months? e.g. Fiscal Year 2010 Fiscal Month 12 Fiscal Month Date

Montly Snapshot views with transactional Fact table w/SCD2

I am a new at working with Dimensional Database design. I am struggling with something that probley is real easy to do, but just can't find documentation that will explain it. I want to create a monthly snapshot view of my transactional Fact table with

SET2/Q.1 a. Is there any difference between inventory level planning and assortment planning?

Q.1 a. Is there any difference between inventory level planning and assortment planning? Explain. (5 marks) b. Examine some recent trends in retail.

MH Forum Help - How to take a "snapshot" or "screen shot"

How to take a "snapshot" or "screen shot" by revvinon To take a snapshot of your computer screen you need to bring up the image you want to capture on your computer monitor/screen. Say I want a picture of this post I am doing

AiShuo Snapshot

Shiny Black: White: Alloy: Matte Black: (Latest model according to a Chinese friend)

Transactional detail fact table w/complimentary snapshot table. How do the two play together?

Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction

Transaction Fact design

hi I am faced with a problem designing a transaction fact in an investment firm. each transaction represents a trade the traders put in (buy,sale etc). The problem I am facing is: the metrics of a transaction change from one day to another day so a

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

Fact table type

Basic questions about fact table type in kimball methodologies. Would appreciate if someone could explain 1)Transactional fact table type This is the transaction event captured from source OLTP system. Fact table in this case has all the keys instead