<HTML>
<HEAD>
<TITLE>Labels above members</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>I don’t want this:<BR>
<BR>
Something Sales | Something Sales – Previous Year | Something Sales – Percent | Whatever Sales | Whatever Sales – Previous | Whatever Sales – Percent<BR>
<BR>
I want this:<BR>
<BR>
</SPAN></FONT><FONT SIZE="1"><FONT FACE="Courier New"><SPAN STYLE='font-size:9pt'>| Something | Whatever |<BR>
| Sales | Previous Year | Percent | Sales |Previous Year | Percent |<BR>
</SPAN></FONT></FONT><FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'><BR>
This is what seems to work as a way to group up members and label them up. Is there better way?<BR>
<BR>
with<BR>
member [Something] as ‘1’<BR>
member [Whatever] as ‘2’<BR>
<BR>
Select <BR>
Hierarchize(<BR>
Union(<BR>
Crossjoin(<BR>
{[Something]}, <BR>
{[Measures].[Something Sales], [Measures].[Something Sales – Previous], [Measures].[Something Sales - Percent]}<BR>
), <BR>
Crossjoin(<BR>
{[Whatever]}, <BR>
{[Measures].[Whatever Sales], [Measures].[Whatever Sales - Previous], [Measures].[Whatever Sales - Percent]}<BR>
)<BR>
)<BR>
)<BR>
<BR>
<truncated><BR>
<BR>
If there is no better way, then my next step is to figure out how to put in alias for the rest of the measures so instead of “Something Sales – Previous”, it displays “Previous Year”. Any pointer appreciated. Thanks!<BR>
<BR>
Cheers,<BR>
j</SPAN></FONT>
</BODY>
</HTML>