As mentioned in answering your last post (re: cube 'connectivity') one way to do this is via Proactive Caching. a quick google search will bring up a lot of...

Like most things - it depends 🙂 If you're using MOLAP storage (and a lsot of people do) then no, they're not connected. Changes made in the source...

Mosha has some hints on how to achieve this, here.

You should be able to specify the solve order. I think it was the higher the number the later in the calc pass it would resolve (ie set the...

Ok, gotcah. A named calc should definitely be able to handle it, not sure why it's not happy with what you've entered. Have you tried testing (ie viewing...

I fully understood that - hence my question. I guess I didn't see much point in adding a second Quarter (or other 'calendar') time component *if it's the same as...

Just a heads up, this isn't an answer, more of a question :hehe:

Is your 'calendar' quarter the same as your fiscal quarter? And if not, I'd prob lean towards introducing...

hmm, interesting....

looking at the msdn entries for both (ADOMD and OLEDB), the ADOMD explicitly mentions that it utilises XMLA under the covers and also allows for http connectivity. The...

Are the SSAS and IIS machines one and the same? ie does the IIS box need to impersonate across to another server?

how would you do this? you'd put a for each file looping task in there and stop the data flow (read) operation when you hit the right number.

Why would...

In case you're working in a tight SOE place, getting admin rights (as in local admin on the machine) is somewhat overkill. Technically, you just need to get someone...

you've raised a couple of different things here, not all as related as you might think...

"We use SQL server authentication, SO while defining data source, I used SQL server Authentication...

Definitely able to automate the creation of the partitions, not necessarily easy though 😉

Prob not something that helps your cause here but am hoping that someone has mentioned to whomever...

Personally I'm usually opposed to trying to coerce the budget figures (or any other measure thats not at the same grain) in to the fact grain. If you're using...

Jez - As Dave mentioned, you really should try for smaller partition sizes circa 20M rows or less. Have you checked any of the perf/admin guides for As2K5 or...