sergio.eduardo.linares (3/17/2015)

---

Sorry, more information:

how to make this SQL Query:

select a.Id_Store, count(distinct a.Id_Elem)

from Fact a inner join (

select Id_Elem, max(Id_Fact) as Id_Fact from Fact

group by Id_Elem) x on

a.Id_Elem = x.Id_Elem and

a.Id_Fact...

Please don't post duplicate questions/threads. Rather update the original with more information.

Original thread is here: http://www.sqlservercentral.com/Forums/Topic1669062-17-1.aspx#bm1669295

Your last sentence seems to contradict the rest.

Could you please clarify...do you need to get a distinct count of elements (i.e. 2 for the first range you mentioned), or...

How about something like this:

...

where{

{{[Month].[Year Month Hierarchy].[Calendar Year].&[2015].&[2015Q1].&[201503]}

* {[Status].[Status].&[Active]}

}

+

{

{{[Month].[Year Month Hierarchy].[Calendar Year].&[2015].&[2015Q1].&[201502]}

* {[Status].[Status].&[Inactive]}

}

MDX Reference: https://msdn.microsoft.com/en-us/library/ms145493.aspx

seaport (3/17/2015)

---

Martin,

Thanks for the quick reply

In the Advanced Tab, I still have to go through each attribute, right?

Also, I am trying to figure out how this "Advanced" Tab works. So...

seaport (3/17/2015)

---

How do I deny read access to a dimension data, through either SSMS or XMLA?

It looks like I cannot deny access at the dimension level. I have to deny...

ttdeveloper (3/17/2015)

---

Martin

Spot on - redesigned the composite keys and the relationship (attached). Hierarchies are now fixed. This is awesome.

Thanks for your help as always.

So - I guess just for my...

From what you are describing here, it doesn't seem like you are really solving the problem by creating a dimension for all your different types of calculations. You will still...

I would start by checking for locks in the destination. If you have multiple packages executing in parallel and writing to the same tables, you may be creating a deadlock...