Viewing 15 posts - 1 through 15 (of 37 total)
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...
Larry
October 13, 2011 at 10:57 am
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. ...
Larry
January 13, 2009 at 4:06 pm
Jez (10/23/2007)
[snip]Is this a possibility in your situation to use different views of the date dimension table for different dimensions?Jez
It is certainly possible and it is what I have done...
Larry
October 23, 2007 at 6:13 am
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...
Larry
October 16, 2007 at 9:02 am
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...
Larry
October 11, 2007 at 8:39 am
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...
Larry
October 9, 2007 at 8:59 am
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. ...
Larry
April 4, 2006 at 8:24 am
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...
Larry
March 29, 2006 at 7:50 am
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. ...
Larry
March 29, 2006 at 7:06 am
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...
Larry
February 2, 2006 at 12:09 pm
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...
Larry
November 29, 2005 at 7:41 am
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.
Larry
October 3, 2005 at 2:18 pm
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...
Larry
August 12, 2005 at 2:16 pm
Not that I know of. Just three tables created from the RS toolbox. Did not use the List object in the toolbox.
Larry
Larry
August 3, 2005 at 10:20 am
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...
Larry
June 21, 2005 at 11:25 am
Viewing 15 posts - 1 through 15 (of 37 total)