Just select it like a normal one. to be clear, the idea is to select an existing file to start with, then go change to the one you really...

For me also my first wading into cubes was in order to create "self-serve reporting" to prevent the one-off report designing. We didn't have the resources to do that...

I've never had SQL sp's applied automatically so I guess it never occurred to me that it was possible. I am glad that it doesn't, actually. I like...

there are many many MANY BI tools out there for users. If cost is an issue, Excel is a decent choice at least to get started.

We have Targit and...

oh yeah, a calc! What a deliciously simple solution!

not sure this is the greatest way to go about it, but we implement [FactTableName]Averages as a separate object "spinoff". It populates in the same fact table ETL pkg...

Pragmatic Works offers free webinars monthly. The topics vary.

it's not the kind of thing I would build in. If someone wants to know something that basic then they probably aren't in the cube (ymmv). I would...

Configuration, I don't know, that would be custom to your environment.

For...

ooop, sorry. we don't do incremental, we wipe daily.

Yeah, forget dorky. If we all knew how to do everything perfectly, it wouldn't be near as fun to get that feeling of SUCCESS!!!

I can't be alone in wanting...

I mean zip as lowest. The smallest granularity. The largest population.

States have many cities, cities can have one or many zip codes but a zip code...

Pragmatic works has free webinars every month. I usually find one or two of interest. FREE FREE FREE!!!

Try to process each dimension independently, then try full cube processing again.

If any of the dims fail, you should hopefully get an error message that points you to the problem.

The cube can reside on a different server, yes.

If you connect to Analysis Services on the server that the data lives on, you can see if that's where the cube...