No problem at all 🙂

You can use the ASSP project GetCubeLastProcessedDate function to get the last time a cube was processed:

http://asstoredprocedures.codeplex.com/wikipage?title=CubeInfo&referringTitle=Home

You could query this from your database using OpenQuery from your DB.

Alternatively if you...

Isn't it just something like:

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" Transaction="true">

<Delete xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID> OLAPDatabase </DatabaseID>

...

Yep, you can get that using the techniques in those two links. Just forget about the SUM part.

A couple of ways this can be done......

with LAG:

https://social.msdn.microsoft.com/forums/sqlserver/en-US/f0e50fc6-8197-4251-8280-bc2989fe4060/ssas-2008-mdx-dynamic-data-set-for-last-12-months

or with VBA Now() and DateAdd:

http://mikedavissql.com/2013/07/22/creating-a-rolling-date-range-named-set-in-mdx/

*Sucks teeth like a mechanic*

Oooookay. As ever with this type of thing the answer is definitely "it depends".

I would never completely ignore them though (particularly 2, 4 and 6...

This will get you started:

https://dwbi1.wordpress.com/2011/06/06/ssis-updating-a-variable-based-on-database/

Have a read of this article from this very site: http://www.sqlservercentral.com/articles/Cursor+vs+Recursive+CTE/99795/

It has the answers that you seek.

Do you have Evaluate as Expression set to True?

No more context than just the above? No? The expression editor appears in numerous places....

You're running out of memory. Is there any value in the BLOBTempStoragePath property of the data flow task? If not then try to add one with adequate storage - this...

Generally it's polite to provide a little bit of context when posting questions on here.

The error is probably the comma at the start of the expression ("0,01" instead of...

Unless you created the Tabular Model using Excel (Powerpivot) then you have to manage custom calculations at server level. You have a number of options which are detailed here: https://msdn.microsoft.com/en-us/library/hh212939.aspx

VRT (5/5/2015)

---

May be on Server, there might be a limitation on records that you need to increase the Dimension records count.

OLAP\Query\DefaultDrillThroughMaxRows

and also the RAM memory size also you may need...

Without knowing how your attributes and hierarchies are defined (or what they're called) or having any code that you may have tried it's a bit hard to help. However I...