Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 77
  • Last Modified:

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!
0
rhservan
Asked:
rhservan
  • 3
1 Solution
 
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:
I have resolved this issue on my own:

What I did:
1.  [Community].[lev7].[evdescription]
0
 
rhservanAuthor Commented:
Because no other solutions have been provided.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now