May be the idea of levels is what is confusing me here. Let's assume we are talking about Coutry-State-city ( By the way, I am using SSAS 2008)

I have the...

The number of actual levels is unknow when the dimension is processed. we only know that there are 6 levels at the most. What I am trying to do is...

I am faced with the same problem. I created a hierarchy where sometimes the value of some levels in null ie:

Cust->AcctLvl1->AcctLvl2->AcctLvl3->AcctNum

Cust->AcctLvl1->AcctLvl2->------>AcctNum

I set HideMemberIf to NoName but no luck. Any solution...

Good article Carolyn. Any idea about the maximum size of the files that can be zipped or the zipped file itself?

select o.orderid, o.orderno sum(od.ssamount)

from orders o ,orderdetails od

where o.orderid = od.orderid

group by o.orderid, o.orderno

having sum(od.quantity) = 100