I couldn't agree more. When I said cheap I was referring to Excel, not SQL Server.

Lori, you should note that you need a SQL Server license for every machine on...

Ooo...not sure about using Excel for reporting. Its up to you of course but weigh up the pros/cons

Pros:

Cheap

Accessible

Cons:

No centralised report repository to enable enterprise wide reporting

Calculation occurs locally (I think)

Lack...

Lori,

I would echo everything that Fernando says however assuming you are going ahead with it here's some useful info.

Panorama & ProClarity are dependant on you building multidimensional cubes in Analysis...

For what its worth...

SQL 2005 has a very nice way of accomplishing this through the use of a data source view (DSV). It is more effective than the source table...

1. The size is displayed in the column properties at the bottom of the table designer. I've looked in Options and there's no way (that I can see) of hiding...

DTS2005 is a huge step in the right direction but its still missing some key functionality, functionality that you will find in products like Informatica.

e.g.

Why can't you set breakpoints in a data...

Brian,

I don't really agree with the following comment:

"Business Intelligence tasks like DTS, Reporting Services and Analysis Services can be managed through the BI Workbench"

That is at best ambiguous and at...

I think I understand your requirement. A dimension level can only be based on 1 field hence you'll need to build a view and use that as the source for...

That doesn't make much sense.

Which of the 2 columns that you have listed is going to be the source for your dimension?

Regards

No need for sarcasm Bill (if thats what it was)

As long as the original poster understands the licensing issues - thats the most important thing...

Hi Steve,

Thats exactly my point regarding AS tool vendors. Microsoft aren't going to blow them out of the water - that would be bitig the hand that feeds them!

This cizer product...

Thanks Larry, thats really interesting. it turns out the answer they weere looking for wsa something along the lines of:

1)       The way it handles multiple...

Errr, I wouldn't exactly agree with Bill there.

The point about Reporting Services being free is a bit of a misnomer. Its included with the SQL Server license which is NOT free. In...

Cetainly sounds like a feature request. Send it to sqlwish@microsoft.com

Regards

Mithrandir,

Build yourself a measure using SUM (for illustrative purposes call it MySum) and another using COUNT (MyCount) in the conventional way.

Then you need to build yourself a calculated member that...