Is there a way - through a DMV or other query - that I can retrieve the collation for a hierarchy using code?

I know that I can find out the server, cube, and hierarchy collation using SSMS.  But I'm looking to do this in code, in order to compare collations between two cubes' dimensions, and compare member v

If the question is that during an MDX you want to know whether comparing two member names will be case sensitive or not, you can just run this MDX query to test it. I believe the whole cube is case sensitive or not if youre talking about an MDX query, regardless of the specific collation of individual dimensions:

with member [Measures].[IsCaseInsensitive] as "X"="x" select [Measures].[IsCaseInsensitive] on 0 from YourCube

Here is the T-sql to find the database collation and server collation.

select DATABASEPROPERTYEX ('master','collation')
select SERVERPROPERTY('collation')

note when your results are sorted in tempdb it uses by default server collation.

Hi Todd,

Thank you for your question.  

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated.  

Thank you for your understanding and support. 

I am not sure whether I understand you. If you are talking about SSAS, the collation/language settings is only available at the following 4 level:

Instance

Database

Database dimension

Cube

How do you get the hierarchy collation in SSMS? If you can get that information from SSMS, you may capture a profiler trace at the backend to see what discover command was issued to get that information.