So after some more research and monitoring of both sides of the equation, I notice there are times where Excel takes literally 2GB of memory while doing this calculation. There...

This may sound like a silly question, but is there a way to limit what filters are in the list? For example, if I just filtered the dataset to this...

I was able to figure it out right before you posted :-D. I did this in SSMS and the problem did not replicate. I did a ping from my computer...

This is happening to all users. I believe the users have a fairly decent connection to the data cubes. The overall speed of the cubes seems to be on par...

Yes this seems to only happen on fields with more than 1000 members.

Often these have the same granularity as the key. The attribute relationships are the default relationships.

Ignacio,

Thank you very much for this information...after spending several days working on this I have successfully added all the intricate securities to my cubes!

Thank you again this has been...

Nevermind I am an idiot :w00t:

For some strange reason I had it in my head that the distinct count would have to be unique across multiple dimensions...after writing several sql...

Also, I am using SQL Server 2008 if that helps 🙂

The question was fine, as I see 'installation of SQL Server 2005 Enterprise edition" as being installed with no service packs. The answer however is inaccurate (though I answered it...

If you read in sql server books online

"SQL Server collations apply non-Unicode sorting rules to non-Unicode data, and Unicode sorting rules to Unicode data, by using a corresponding Windows collation...

Also, also! :hehe:

I have learned a great deal through this study that has helped my day to day job skills tremendously so I am very thankful for that, and it...

Also, all venting aside 😀

Any additional tips from people who have taken the test (yes I know under the microsoft agreement that you can not divulge exact details about the...

Eh no worries! Being a DBA rarely people actually see my face so I get it all the time with the companies I work with :-D. Ironically enough I just...

Jeff Moden (7/21/2011)

---

shannonjk (7/21/2011)

---

Jeff, Thanks for the tip! I have actually been focusing on that exact thing with indexes lately :). On a side note, I am actually a 'him'...

Jeff, Thanks for the tip! I have actually been focusing on that exact thing with indexes lately :). On a side note, I am actually a 'him' not a 'her'...