How do I get a description into query with a member based id code?

Dimension : Department
Hierarchy: H1.Level7
Member: DP_00, DP_01, DP_03....... DP_96

I would like to utilize the Member Properties with "Description" which holds the information for the actual department name.  How can I write the MDX to utilize this and return the actual Department name.

Such as:

Dimension: Department
Hierarchy: H1.Level7
Member: Apple_Dept, Bannana_Dept, Candy_Dept..............................Zebra_Dept.

Let me know if I can provide additional information!
rhservanAsked:
Who is Participating?
 
rhservanConnect With a Mentor Author Commented:
I have resolved this issue on my own:

What I did:
1.  [Community].[lev7].[evdescription]
0
 
awking00Commented:
Does the member field in Department contain a record for each member (e.g. one row contains DP_00, another row contains DP_01, etc.) or is there just one record for the member field that is a long comma delimited list? Also, I assume "Member Properties" is another table that contains department names which you want to use as a "Description" in place of the member values currently in the Department table. If so, what is the relevant structure of the "Member Properties" table, which I also assume will have another field that can be used to create a join to the Department table? It is almost always best to provide sample data and expected results to assist the experts in understanding the issue at hand and providing them with test data.
0
 
rhservanAuthor Commented:
member field in Department contains a record for each member (e.g. one row contains DP_00, another row contains DP_01, etc.)

No commas are in the members at all.  If I go to the level they are located there is a list of all departments with blue round marker on each one.

When I use the filter fall departments at the top of the grid it places them in the filter field with commas between each department id individual individually,

Also,
"Member Properties" is another table that contains department names which you want to use as a "Description" in place of the member.
Response - This is located in a folder under "member properties" under level7.  My end result would be to use either or in a column for a report.  Either the Description or as an ID code.

Department members
0
 
rhservanAuthor Commented:
Because no other solutions have been provided.
0
All Courses

From novice to tech pro — start learning today.