Solved

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

Posted on 2015-01-22
4
52 Views
Last Modified: 2016-02-18
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
Comment
Question by:rhservan
  • 3
4 Comments
 
LVL 31

Expert Comment

by:awking00
ID: 40566358
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
 

Author Comment

by:rhservan
ID: 40566735
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
 

Accepted Solution

by:
rhservan earned 0 total points
ID: 40591586
I have resolved this issue on my own:

What I did:
1.  [Community].[lev7].[evdescription]
0
 

Author Closing Comment

by:rhservan
ID: 40600309
Because no other solutions have been provided.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now