Viewing 4 posts - 1 through 4 (of 4 total)
Kevin
Sounds like a cool job, The AS should run fine on your new server.
This is however dependant on the record numbers.
Cubes are normally built at night so unless you are...
December 27, 2005 at 1:10 pm
#611599
#611598
Try this URL
http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-6193886071729868&dt=1135109735437&lmt=1135109734&prev_fmts=200x90_0ads_al&format=fp_al_lp&output=html&channel=4102412200&url=http%3A%2F%2Ffreedatawarehouse.com%2Ftutorials%2Fdmtutorial%2FTime%2520Dimension.aspx&ref=http%3A%2F%2Ffreedatawarehouse.com%2Ftutorials%2Fdmtutorial%2FDimensional%2520Modeling%2520Tutorial.aspx&cc=89&u_h=768&u_w=1024&u_ah=768&u_aw=1024&u_cd=32&u_tz=780&u_his=2&u_java=true&u_nplug=13&u_nmime=46&kw_type=broad&rt=ChBDqGZjAAlBngpKLBJqCHAmEgRPTEFQGgg1UrW2uZmYQCgB&hl=en&kw0=Object+Oriented+Modeling&kw1=Data+Warehouse&kw2=Star+Schema&kw3=OLAP&okw=OLAP
December 20, 2005 at 1:37 pm
#610722
Yup
This is achieved by using a group by and a case statement.
You could also augment this query with subqueries so you get
columns with the amount of invoices, adjustments and payments...
December 20, 2005 at 1:29 pm
#610717