First thing first, awesome script, save me a lot of time!

I tried running the script on a table that's set up as page compression, but the script didn't work, complaining...

just wanna loop back to the original post.. and say that thanks for the suggestion to BISM normalizer.. it definitely works.. and it's actually a much simpler deployment process now...

no one knows for sure?

i think it's a more a ssas limitation.. on how the mdx is structured...

so a user can belong to multiple business group?? if he/she select only one.. then there's no...

i like this one... sllghtly more advance..but anything too basic you can easily find in BOL anyways

http://www.amazon.com/Expert-Development-Microsoft-Analysis-Services/dp/1847197221/ref=sr_1_1?s=books&ie=UTF8&qid=1352831996&sr=1-1&keywords=expert+ssas+cube

yup.. definitely works with excel...everything is through AD.. just make sure you create a new role and assign appropriate permission to your group or individual users...

the users would not need...

semi addictive is only available in enterprise edition...

no luck in standard

you can see if you can replicate what you trying to do in calculation using MDX (if you are...

yeah.. indexing is basically all automated.. you don't create index per se.... because cube is really for aggregated results.. not to find a single entry (like relational index)

to speed...

pivot table definitely should work with multiple reporting filter..

are you referring to drill through?? basically when you are double clicking the data to get the detailed data behind it, while...

definitely create new dimension table.....

if anything.. it could just be a simple sql that u run every time before cube processing

such as merge dimItem using (select distinct item...

anyone??

also.... just to clarify... it's (for example) for transaction type ID 4 (business key)

but underlying data in the fact / dimension table could be multiple PKs

so it could be...

I routinely move that much data using SSIS, with fast load option without worrying too much... depends on your size per row, it may be faster than you think too

but...

toby.cihla (7/27/2011)

---

We are just currently experiencing the same issues. 3 SSAS 2008 servers. 1 Production, 1 QA, 1 Dev. SSAS Database on Production now taking 2x as...

Hi all.. thanks for all the suggestions so far.. but it's still a mystery..

i have done a network test, by copying large files between DW1-CUBE1 and DW2-CUBE2, and both perform...

hmm... CPU is identical on both servers.. Memory is the same as well

Available memory during run time seems similar

We have 72 GB on BOTH DW servers, and 32GB...