That's exactly where we're at; existing in 2008r2 and new going into 2012. Thanks a ton!

sneumersky (1/17/2014)

---

When you say "at the end of your ETL", do you mean:

1. Load DBMS dimensions and facts, THEN Fully Process Dimensions and Facts?

2. Process 1 SSAS object...

If I manually process it, it becomes visible.

Best: Standing up a soup-to-nuts ETL process (package templates, logging, auditing, master-child execution arrangement, etc) for a proof-of-concept SSAS cube.

Most memorable: The Production server failing, and finding out the...

@Nils- yes, makes perfect sense, thanks for the detailed explanaiton

@SQLDBA360 - I agree 100%; we are trying to get away from local groups and move to AD authentication but that...

Nils, are you saying I need to update the SID on the 'restored' server with the SID of the 'restoring' server?

The names are different, but the groups serve the same purpose.

Sure; I mean updating the schema and data of our "warehouse" databases, for lack of a better term. These are databases that hold current and historical data that the...

Thanks everyone, great suggestions. I never thought about reading BOL unless I was researching a problem! I'm going to SQL Saturday in Madison in April; I'll look into...

I have a BA in History, believe it or not. Career-wise, I actually started out on the business side, where i did a lot of ad hoc reporting for...

Yeah, that's what I was thinking I was going to have to do. Thanks...

Thanks, I was emclosing in quotes due to the "_" in the database name. One of our DBAs was able to create the file for me. Thaks for...

Along the same line, can anyone recommend a good book on SSAS that focuses more on the theory behind data warehousing? I'm looking for something that would be geared...

Recently a new group moved across the aisle from us, and they're on calls all day (one with an unbelievably annoying voice), so I started bringing my MP3 player to...

Business Intelligence WIN!