Depends on what your users are happy with.

Most people seem happy with Excel. If you are using Excel 2003 and SSAS(2005) then you may need to add Microsoft OLE DB...

I have a script that I use. Basically it loops through all the tables in a database and uses

exec sp_spaceused

This then returns

...

Sachi,

would it be possible for you to attach the spreadsheet? Or just a sample? And a create statement for the table it is going into. It would make it...

Dancewav,

I would use a condition on the precedence constraint (or as I call it an expression on the green line) between the execute SQL task and the email task.

1.So...

Sorry I can remember, its years since last using ProClarity in anger. There used to be an issue with using subtotals when a filter has been applied. Are you uusing...

Prodid

RegionId

StepId

StepName

PreviousStepName

TimeInfo (this will have time taken from prev step to current step)

CurrentTime

The design should reflect what you want to see as a result. The table above does not quickly...

It was really helpful post, thanks actually we have decided to go with having additional columns that would have values on time taken for each step. By having time taken...

They all come in by using Excel. They add a pivot table, external data source and then use an http address for the server where SSAS resides.

Thanks for the...

Yep all the primary keys from the dimension should be in the collections fact table. I would expect the collections fact table to consist of a collection id (primary key...

I am probably telling you stuff you alreasy know.

3. Migrate the OLAP/Analysis Services to the new server. The AS will need to be reporinted from the old database to the...

First things first.

What sort of Analysis are you going to do. From your post I am assuming these are some sort of machines that you are looking at. I have...

There are several tools available that wuill do this in both Excel and Word (Olap scribe). Dont know if that will help

Mark.

Firstly you do not need to make a massive change. You need to think more about how the data is to be used. If you are going to use Analysis...

As far as I know we are not using perfmon. Unless someone else has decided to. Thanks I am a bit surprised but will have a look at this.

Thanks.

Ells

Thanks for your help. Got all the info I need. Just one really lame question. I am assuming that the minimum and maximum settings are for physical memory only?

Thanks a...