The 2nd link in my initial post is to an article that shows an easy way - with minimal VBA  - to facilitate the use of user-set parameters with stored...

Well, the point of my suggestion that you evaluate the Data Pig approach is that eliminates VBA and the connectivity used is built into Excel.  There are no "add-ins" and,...

I have no issue with using ADO or not.  Is there some particular benefit from using ADO and datasets in your solution?
The approach from DataPig is very simple and...

I suggest that people check out the excellent approach in DataPig that allows direct conectivity to SQL Server and enables Excel to run stored procedures ( or SQL scripts if...

"Managing yourself includes communication with your boss and appraising them of status"

From the 1st poster :

I did all that very conscientiously, but my experience was that IT mgt. still did...

I have worked at several investment management firms with supposedly high-level technology teams.

However, I found that IT managers, as opposed to the business people, are actually very uncomfortable with a...

Why did you not consider using the Office Web Components?

OWC Pivot tables would enable you to do the OLAP reports without building another OLAP database.

Using OWC, Fig 6 would...

( Previously posted to an empty forum )

 Regarding BI in major corporates.

The following anecdote is not me bragging, as you will see when I get to the "punchline".

I implemented a...

Regarding BI in major corporates.

The following anecdote is not me bragging, as you will see when I get to the "punchline".

I implemented a global OLAP intranet-based reporting tool to handle Assets...

Is it not cool to start raising the impact this amount of electricity use for running and cooling al these computers has on the environment?

At what point will it become more...

If you are not using stored procedures, then it is very hard to confirm that the optimiser is using the indices the way that you intend.  Stored procedures will improve...