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...

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...

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

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...