Hi, thanks for your answer.

Yes you are right, it's a YOY measure that should be available for the last two years.

If a store opening date is newer as today minus...

I think you are a little bit confused with the topic.

You have to differentiate between dimension attributes and dimensions.

If you want to analyze for instance, how many patients have visited...

To be honest my knowledge about replication is very limited but I think there is nothing configured:

I will ask the system admins to confirm.

I checked and there are no duplicates in the source query.

I need to verify the collation of the databases, but a bigint column shouldn't have problems with different collations.

Hi Mohamed,

thanks for your interest:

The source table name is dbo.SalesOrders and has an identity big int primary key SalesOrdersId

This is the source query:

SELECT

NS.SalesOrdersId ,

NS.Qty AS NatSalesQty,

NS.GrossSales AS NatSalesGrossValueDomestic,

NS.NetSales AS...

Hi Mohamed,

yes, I edited the output of the OLE DB source using the advance editor and set the output as sorted and the sorted column as sorted key = 1,...

Hi,

I didn't get your point but I think you are overcomplicating the things. You can fully control your incremental loads using a log table.

Anyway, you can use DMV queries...

I cannot find duplicates in the source, therefore I am trying to find another cause for the duplicates. But what I also want to find out with this post is...

Another detail,

I am using with (nolock) in all the queries, including the lookup query

Hi Phil,

The PK is a bigint. In the source is a surrogated key, in the target is just the PK.

We have a tool to avoid multiple executions, instead they...

Hi Gail,

thanks for your useful answer.

In my scenario I am not nesting views. I am just trying to improve an ETL Process, where the source queries are embedded...

If someone is interested I found this post:

MDX Scope with an If Then statement[/url]

The combination of both, the measure to switch on or off let´s say the path or to...

Hi everybody,

if someone is interested I got the answer in the MSDN forum. The solution is explained is this post:

http://www.artisconsulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=24

That is the result of the UNICODE,

I would like to take some time to dig deeper on this and summarize all the information.

Thanks all of you for the support!

Thanks so much again you guys for your priceless support:

@Cadevre: I got the point, I ran your query but this is the result:

I don't know if I am too...