Dimensions based on day intervals

for table holds orders, have following columns:

• orderdate: date , time customer placed order
• shippingdate: date , time goods shipped
• difference: difference in days of above 2 columns

 

i have overview of day intervals in orders shipped. example, know how many orders shipped in following intervals:

• 0-2 days
• 3-5 days
• 6-10 days
• 10+ days

 

the number of days calculated in fact table, there specific way can handle categorization in dimension?

the result this:

	2008	2009
0-2 days	339	384
3-5 days	145	138
6-10 days	25	22
10+ days	4	2

thanks!

last time impleted someting gaming company there ranges on dimension

--> created dimension based on ranges customer wanted see
--> add 1 more column fact table

--> update new column correct interval range keys

you might able produce in mdx on fly performn better when @ relation level , bring data cube.

---

ashwani roy

my blog

please click mark answer button if post solves problem!

SQL Server  >  SQL Server Analysis Services