I think what you're looking for is Analysis Services, included in SQL Server. You still need to design / build your database, but that's a relatively simple step. (Data warehouses...

Lot's of possibilities depending on the level of sophistication, budget, look and feel, etc.

I'd suggest starting with Reporting Services which'll alllow you to build a report integrated back into the portal....

Some items you should consider:

Depending on the hardware you're running on, you really need to start considering partitions once you pass 2 M rows. It has a dramatic affect on...

Check the Services list to make sure you've got the names correct.

When connecting to the server, use the following for the server name:

        machine name\instance name

Good luck.

It sounds to me that your time dimension isn't being created properly, because you're using the server time build.

When you build a dimension out of the "facts", you may end...

First, is it improtant that you filter out negative values (are they present??)  If you're simply looking for products with Volume, try:

NonEmptry ( Descendants( [Product].[Brand].currentmember, [Product].[Brand].[Product_name] ), [Measures].[Volume] ).Count

Assuming this...

Ah, that's "Report Builder", which can publish into ReportServer. Companion tool. Didn't know you were refering to that.

MSRS really isn't an ad-hoc tool, so shouldn't be approached as such. MSRS is really for creating quality, production ready reports. To take advantage of it's more advanced features and...

You haven't said what you're trying to do, or what errors you're seeing, so it's difficult to make suggestions.

In general, carefully consider why you're using write backs. Often, it's much...

Yes and no.

First, in considering the problem, ignore the fact that you want it to work against the hierarchies. Remember that hierarchies are a navigation through attributes.

Now consider the attributes...

You'll need to check the results, but try:

HIERARCHIZE

( GENERATE( {[Time].[Fiscal - Month].[2006].[July]:[Time].[Fiscal - Month].[2007].[December]}, ASCENDANTS( [Time].[Fiscal - Month].CurrentMember...

Sorry for the late response. On vacation.

To reference a report parameter, you need to "convert" it to a member. Typically you're using a string, so trhe syntax is:            StrToMember(@myParameter)

For...

First, forget about using the query designer in MSRS. In my humble opinion (ok, not so humble) it's not worth the bother. Hopefully the RS develoment team will spend a...

A couple of questions question to start with:

What storage model did you use? Start with MOLAP, until you've isolated your drill through problem.

What security credentials are you using? (i.e. an...

There's a number of approaches, which depends on the specifics of what you're doing. (Need more information). However, here's a couple of suggestions:

1. Assuming that you simply want to put custom...