My concern is the amount of time one should wait to decide it's not going to fix itself and take corrective action.

Thanks,

Larry

Formerly user CynicalDBA - I forgot my username had...

Add several of my team to the list of those whose BIDS will just occasionally hang for no reason. SSAS is fine and responds to to other requests. ...

It is certainly possible and it is what I have done...

Kudos for recognizing many of the things that go into a successful BI project. My$0.01: these are the same issues on almost any other software project. Want to...

With each fact row representing a credit card tender, there is nothing wrong with storing both a tender type FK and a tender (card number) id FK on the fact...

As others have said, the data has to exist somewhere relationally. As for dimension/fact design, it all depends upon what type of analytics you want to do. Would...

It sounds like you have a good start on documenting the ETL portion of your DW. 

One of the interesting parts is clear definitions of measures derived in your warehouse. ...

I will assume that you have nothing inherently wrong with your cube and dimension design. Not always a safe assumption, I know. 

If you are using MOLAP storage, then indexing the relational tables...

You have several ways to improve performance of AS processing in AS2000.  First, the obvious - don't do a full process if only a "small" number of rows are new. ...

I like having Reporting Services do as much work for me as it can.  While creating my stored procedure, I get a final query or a table definition and use...

I dislike "me too" posts, but here is another one.  If I'm not interested in an off-topic issue, I move on.  Heck - I have no need for certain features...

I was lucky enough to catch Brian's talk on Wednesday afternoon.  The Hawaiian shirt and shorts were great.  And the presentation was pretty good, too. 

Look at the properties for clsCube in BOL.  It has last processed date and other cool stuff in it, as well the related classes/subclasses.  Others will have to respond on the...

Not that I know of.  Just three tables created from the RS toolbox.  Did not use the List object in the toolbox.

Larry

Good article.  I'm glad it works for you.  My current employer is about to start experimenting with it as our headquarters gets compressed into a single building.  My issues when I used...