Hi, Joyce! Thank you for reply!

Did I understand  properly that when I rename  the class in Atelier the new file (Class C) will appear on the server after sync and the old one Class B will be still there too?

Another question here. Again we have Class A and Class B in Atelier project, in the repo and on the server. 

Suppose, Developer B in my team deleted class A, renamed class B to Class C and pushed it to the repo.

Then If I check files out from the repo Atelier project will consist of Class C only. And if I sync Atelier with the server I would have Class A, Class B and Class C there, right?

So I guess I should never trust development server and if I want server be equal to the repo I should purge all the classes from namespace periodially and upload them from Atelier. right?

Thank you in advance!

Hi, Ryan!

Let me show you this via Samples:

This MDX will do the job:

SELECT NON EMPTY {[Measures].[Amount Sold],[MEASURES].[PCT REVENUE SOLD]} ON 0,NON EMPTY HEAD(ORDER([Product].[P1].[Product Category].Members,Measures.[Amount Sold],BDESC),5) ON 1 FROM [HOLEFOODS]

Where PCT REVENUE SOLD has the following expression:

Aggregate(Product.CurrentMember,Measures.[Amount Sold])/Aggregate(Product.CurrentMember.Parent,Measures.[Amount Sold])

This results in Analyzer with the following pivot:

It shows top 5 Product categories by revenue with percent to Total.

Hope this helps