Was not so difficult as I thought, however, it took me several hours to understand how could it work:

with

MEMBER [Measures].[Current Rate To Euro] AS (

([ISO Currencies].[ISO Curr Code].CurrentMember,[Time].[Date Id].CurrentMember, [Measures].[Exchange...

Hi,

Today I faced a similar situation and I started using the ParallelPeriod function, but later I found this blog entry:

Retrieve selected year data and same level data from previous year

I...

Hi again,

I recommended the new one, it's quite similar to the previous one but adds some other information regarding SQL Server 2012 (SSAS Multidimensional, not Tabular). It is important to...

Hi All,

I´m reading this post a little bit late but I can recommend you this new book:

Expert Cube Development with SSAS

Language : English

Paperback : 402 pages [ 235mm x 191mm...

Hi,

I agree with Pau Key and I would check the configuration of the solution.

Does your solution contain multiple projects?

You can check this post to see if it helps you:

Preventing projects...

Hi everybody,

if someone is interested, I found a possible solution using Custom Workflows

Create a Custom Workflow

That required of course another skills. I will meet the .Net developers but I think...

Hi Folks,

Thanks for your answers.

@Nevyn: my case is actually more complex, as an example I said 10 columns, 5 relevant and 5 non relevant, but I have a...

Hi Brian,

first I would like to thank you for the article.

I think this week or the last there was also an interesting discussion of the performance of the merge...

Thanks Jeff for the Article,

I found it very interesting and also have some fun at reading it.

I think all depends of the scope of a project and in the business...

Hi Peter, What a nice tip!

Hi,

if I create a credential with my user (with my user name and domain password) it works.

If I used the account, that was created by the admins it failed. The...

Hi Koen,

of course, here is the message from the Job History:

Message

Executed as user: DEFACTO-PRODUKT\SQLSrvNUESSISSQL1. ...r 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started:...

Hi Koen,

Thanks for your response

I´m not using any proxy account, instead I set the account for the Agent Service using the SQL Server Configuration Manager:

If I want to have...

I found this post, which gives some clues about whether to use BizTalk or SSIS for certain integration Problems:

BizTalk and SSIS

I hope that others give also their opinions.

Best Regards,

Hi Elliott,

thanks again for your answer.

The business case is the following.

I have a customer card system with partnership capabilities. A partnership can only have one main card and more partner...