Once you have your cube, all you need is Excel.

Oracle has added a CUBE subclause to the GROUP BY clause. Does SQL have something similar?

I was going to jump in on the arithmetic error but others got to me.

But there's a more serious error: the old "one version of the truth" mishegahs. There is...

"Our conversation ended by you saying SAS is an over priced calculator, if you work for pharma your opinion is not relevant because about 30 pages of the 500 pages...

No, no tool does absolutely everything. I was talking more about SELECT vs. tools like Informatica, et. al.

I tend to like to put things into a relational db first, then...

Again, it's very hard to understand what you wrote here, your sentences are too long. Are you coming from German?

I will respond to this: "every Pharmaceutical manufacturer in this country...

"A SELECT statement is algebraically flawed so it is a mute point"

So? Who cares? It gets the job done.

"it can do calculus, here is what I know you can do...

LOL! BI is indeed DSS, just dressed in different clothes.

The problems with DW and BI are emotional, not technical. Can't create indexes to solve those problems.

BI is one of those things that are sold well, because they have great sizzle: stop lights, cool blinking thingies, etc. However, it's never enunciated how much work it is...

The problem is with the rules. It is not natural the way schools are set up, for people to work alone.

After all, the most valuable skill you can learn in...

A thought for generating passwords non-randomly: use your birthday in the Jewish (or Muslim or Persian or whatever) calendar. Therefore, if you forget it for whatever reason, you can regenerate...

True OO databases haven't caught on much, AFAIK. Neither have native XML databases. There are some query languages, like XPath extant, but the amount of infrastructure behind them is nowhere...

Management is parenting people you don't love, who are frequently older than you are.

It's not easy.

"I've never met anyone who could effectively do both."

Well, I'm going to be immodest here and say that I do both sides of the coin fairly well, and I expect...

Sorry if I wasn't clear. The data model is the heart of any application, whatever data store is used. That should be designed and understood before any development is done.

And...

I guess I hold differently. When you have more than one person working on a single function, then you have communication issues. When I develop sw and do both the...