Instead of modifying the xmla: You should also be able to pull this off using AMO (Analysis Management Objects) from C#, VB.Net, or a SSIS scripting task, check out http://msdn.microsoft.com/en-us/library/ms124924.aspx...

Stephane,

Can you elaborate on deploying every 4 hours?

I don't quite understand why and from where you (automatically) deploy every 4 hours, especially when you don't want to use BIDS to...

Stephane,

The code you give shows that you are trying to use a calculation. If I understand you question correctly, you should instead alter the DisplayFolder for the measures you want...

Hugo Kornelis (7/17/2008)

The use of sparse column does reduce the number of bytes available for in-row storage. However, since SQL Server 2005 all varying length data can and will automatically...

I stumbled over your post, and wonder if you have found a solution yet?

My hunch would be to use a SSIS package, containing of a script that gets the names...

There is no transformation required: you can get straight from source to destination.

Can you give more details on how the data is being loaded to the database?

If it comes in through SSIS, you might add a last step to start the batch...

I've seen several examples to return a daterange, and since SQL2005 a recursive CTE is the most promising.

On i.e. this link you'll find an example you can use.

If the "calendar"...

I would go with Ben's suggestion, though splitting the "rowstring" to fields by using derived columns can be quite timeconsuming (and boring :doze: ). However, you're pretty sure you get...

Maybe this gets you the desired result?

In a DataFlow:

1) add a rownumber to both datasets (you might need to add an extra column on the datasources if the order should...

I'm sorry, but I don't quite get your requirement.

If you need to do some select for each in date in an onther select, shouldn't it be easier to use a...

Beside reading several articles and forum posts on this site; may I suggest using a search engine like Google or live search?

It will get you tons of info to get...

With a similar problem, rather than change the datatype to unicode in my database (not really an option), I added a convert function to the OLE data source: CONVERT(nchar, Problem_column)...

Had to refer to BOL to check out those sp's, since I don't use cursors (a Best practice as Hugo pointed out).

However, as the other commenters above already pointed out,...

Though I deem Peter Brinkhaus' solution as not very maintainable (If I would stumble across this code :pinch: it would take me some time to figure out what's going on),...