Let's suppose I have one dimension [Dim] with 4 Attributes Attr1,Attr2,Attr3,Attr4. And of course 4 attribute Hierarchies [Dim].[Attr1],...
Apparently it has to do with the number of measures. I left just one dimension and one cube and a few measures and the processing is fast. I added...
I've copied the cube locally and I'm removing things so as to discover at which point it speed up processing. Until now I've removed everything but...
This time : Start time: 12:59:30 PM End time: 1:00:33 PM Duration: 0:01:03 a LOT of time. I don't know what I have wrong. The virtual cube is...
The strage thing is, when I process only one partition ( with the MMC Analysis Manager ) the processing is fast and there is no "virtual cube...
I've tried but the processing times are the same. Anything else you can think of ?
I have a cube with two partitions ( over time ). One with recent data and one with older. Processing the two partitions takes 1 second for one and 4...
ok. I'll do that later.
There's no process using tempdb. that #temp____[hex number] was left there stale by some connection ans wasn't dropped. Or the connection is still...
There's no one accesing tempdb. Somehow that table was left there stale. The creation date accoring to sysobjects is two months ago. I don't know...
I didn't try really everything, just the little I can think of. I'll try restart the server as a last resort ( and I gotta do that in not busy hours...
I've a huge #temp_________[number] table in the temp database. I don't know if it is due to a explicit temp table creation or a subquery or another...
Is there a way to "capture" inside a calculated member the "current slice" ( whether it is a member or an agreggate of several members) ?<br /><br...
SQL 2005 x64 setup files ? I've got Windows Server2003 R2 Enterprise x64 edition installed. It's a Xeon Server. I've installed SQL 2005, but it...
It has to do the way the query optimizer works. Take a look at this excelent paper. It always baffled me why with hardocoded values the query...
It seems that OLAP treats nulls as 0 for the purpose of min/max aggregate. KB Q 244650 If I define a Measure which uses min, the null values become...
I'm trying to create a trigger (without synamic sql) inside a DDL trigger. Something along the lines of this (so you get the idea, of course it...
All the problems were due to that damned server was migrated (ages ago.....) from 7.0 to 8.0<br />I did't remeber that though.<br /><br />I guess...
Tell my bosses that's not wasted time [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br />
No problem buddy.<br /><br />What "side-effects" ? Once something works I never look back [<img src='/community/emoticons/emotion-1.gif' alt=':)'...
Separate names with a comma.
