Need Urgent Help in designing dimension and cube !! help please !
- From: "Siva" <Siva@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 28 Jun 2005 18:10:04 -0700
Hi. I need urgent help in designing appropriate dimension and cubes for the
following scenario
I have the following tables
Table : Orders (OrderId, EmailId, OrderDate, ShipDate, Status,
....blah...blah......)
Table: OrderItems ( OrderId, OrderItemId, OrderItemPrice,...blah blah)
Table: OrderPricing (OrderId, TotalOrderPrice, DiscountCode, DiscountPrice,
...blah)
Table: Users (EmailId, UserName, address, UserType,.....etc)
The above tables have more than millions of transaction records over years.
I have to build the following
1. Number of Order Sales figure by customer (email, and by over period)
2. Average Order Sales for any given range of dates by each user (email)
3. Total Discount Availed by customer wise and by any period wise...etc etc
and many more situations like that.
I would appreciate if some one could point out how to design the appropriate
dimensions and cubes for this scenario
Thanks in advance
Siva
.
- Follow-Ups:
- Prev by Date: Re: A bit confused about "changing" dimensions.
- Next by Date: RE: analysis services excel add-in and pivot tables connection issue
- Previous by thread: Internet Exploer Script Error when clicking on anything in Analysis Manager
- Next by thread: RE: Need Urgent Help in designing dimension and cube !! help please !
- Index(es):
Relevant Pages
|
