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

Remington Model 29
Looking for Remington Model #29 shotgun. Not real common, the 4-5 I've seen were rough shape. Would like to find one decent shape and price, no polychokes or recoil pads.

Rule based algorithm to convert an ER model to a dimensional model
I recently came across two white papers by Moody/Kortnik that show how to use a rule based algorithm to transform an ER model to a dimensional model. I have made the papers available on my

Badge & Item Inventory
I was just thinking of having a separate section for badges & items on the forums. If you look at some sites...actually, the only site I know is Allisbrawl. They have a certain category on a user's profile that says "Badges". They are

Point Shops! (Along With Inventory!)
I think that there should be point shops which you guys might have waited until you made a point shop feuture in each forum before releasing the point system. I think you guys might be able to do it like this. When you click on the buy button and you guys

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.

Operational Reporting from a Dimensional Model
Having worked with various models over the years, i'm begining to think that a multi layered data model approach is best for medium and larger corporations. (see my IM model here

Logical Dimensional Model
Is there such a thing as a logical dimensional model? If you agree, how is it different than your physical dimensional model?

Model for these charges
How would I model the following order system? Base Daily 4 x $50 | $200 Extra Hourly 5 x $25 | $125 Extra Weekly 3 x $300 | $900 Discount A | -$20 Discount B Percentage 5% of base @ $200 = -$10 Extra Option Z | $600 Extra Option Q | $100 Tax |

Question - creating a dimensional model for facility management
Hello, folks. I'd like to ask some newbie questions. I'm starting a multidimensional model for facilities management from scratch, and I'll certainly need a SPACE dimension, since it's the grain in which all the spatial information is stored in the

Model Customer Transactions with variable tax counts and amounts
Hello, I am trying to create a dimensional model for the customer sales transaction business process for a regional grocery chain. The business requirements specify we must be able to recreate the accurate transaction level (aggregate) totals as well

Does anyone here suffer from atypical/complicated migraine?
I'm just wondering if there is anyone on this board that suffers like me with the above? All the aura but no headache. Dont get me wrong, I mean it's wonderful not to suffer anymore with the dibilitating headaches (used to get them but they lessened as

how to model an event log
I am trying to model the following event data: Field1 = event date, field2 = event code, field3 = location code, field4 = customer_id, fields5 to 8 are event code specific, ie.

For those of us with daily migraine.....
for those with daily migraine. How do you keep going. Why do you keep going. I have been asking myself these questions for some time now. Especially since I have tried my last option. And it has not worked. (Botox) I can no longer fool myself by