What does “Persisted file cannot be found” mean when you’re executing a DMX query? I didn’t know and couldn’t find anything on the internets.
On a fairly regular basis, customers I work with wonder out loud (read: gripe) why SSAS 2005 and 2008 don’t allow them to easily drill-down to the relational tables that back a cube using an action. SSAS 2000 did this nicely, but SQL Analysis S
Carl Rabeler of the Microsoft SQLCat team has just released a really nice set of tools targeted at helping you analyze SSAS performance. You can read about it here: http://sqlcat.com/toolbox/archive/2009/02/05/a-solution-for-collecting-analysis
If you have taken the time to implement translations in your SSAS cube, it is comforting to know that the Analytic Grid can and will display your localized text. From what I can gather, we aren’t quite smart enough to simply read regional settings
A couple of days ago I needed to create a new DSV against a Teradata source. I found that the “lag” in the normally light-on-its feet DSV wizard was pretty bad - it took in the neighborhood of 1.5 minutes for the Add Related Tables function to ret
