Solved

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

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Alter table 4 22
triggered use of sp_send_dbmail failure 2 22
Sql Count with Select Distinct 4 24
Error running stored procedure 11 10
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

930 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

17 Experts available now in Live!

Get 1:1 Help Now