Need some advice..kinda urgent!

Ok...so I have installed sql 2005 with the whole nine yards along with it. I also have an installation of sql 2000 along with 2000 reporting services on a seperate server. Finally I also have about 100+ million rows I need to report on it and I need it to look as clean as possible. Regional/Category type of breakdown/drilldown Pivot charts, drop down filtering etc...maybe even some cool .net features..

Obvisouly a template for 2005 is the way to go...but whatever is going to get me up and running with a webbased reporting interface as soon as possible that will do what I need it to do is what I am looking for.

I am not to bad with getting solutions running in visual studio but plan to have my develoepr actually do the quieries...just looking for a point in teh right direction.

Thanks in advance!

Michael404

Do the nine yards include Analysis Services 2005, which may be useful in achieving acceptable and predictable query performance with 100+ million rows?

Also, what degree of interactivity is needed in the web-based reports - will the features of Reporting Services suffice, or do your users need full pivot capabilities such as swapping axes?

|||

Thanks for the repy... Yes full reporting capabilities...

What do you mean about reporting servcies with full pivot capabilities...

I need drop downs for filtering and drill through capabilities wouldnt be bad either...however, I dont believe I understand the specifics on swapping axes?

Can you elaborate?

Thank you!!!

Michael

|||

Also...can you explain to me more on OLAP? I understand and have built cubes in the past but never got into querying them....how does that work? I know it runs along side Reporting Services but I am just curious..100 million rows is only a start and need to know the BEST way to report on this amount of data.

Thank you!

Michael

|||

This analysis from OLAP Report describes the defining "FASMI" qualities and applications of OLAP technology - the site also has other info on OLAP:

http://www.olapreport.com/Applications.htm

>>

OLAP applications

OLAP technology can be used in a wide range of business applications

...

>>

|||For example, consider a pivot table, where the user can interactively drag dimensions and drop them on rows or columns, swap the dimensions on rows and columns, or "stack" additional dimensions on rows and columns. These features are usually associated with OLAP client tools.