Solved

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

Posted on 2015-01-22
4
55 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 32

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

815 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

7 Experts available now in Live!

Get 1:1 Help Now