<HTML>
<HEAD>
<TITLE>Re: [Mondrian] Labels above members</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>Phantal and haaseg in IRC suggested to use degenerate dimension. Phantal explained further.<BR>
<BR>
> what you're describing is a degenerate dimension<BR>
<BR>
> You add field to your fact table for each 'type' of fact, Something, Whatever, Stuff, Blah, etc<BR>
<BR>
> Then you add a dimension to wrap that field, and the actual measures (sales previous, sales, sales percent) are the same fields for every type of fact according to that dimension<BR>
<BR>
> That way you don't have [Something Sales], and [Whatever Sales], you just have [Sales] <BR>
<BR>
Thanks, guys<BR>
<BR>
I learned that this mailing list is actually for the development of Mondrian, not usage of Mondrian. My apologies.<BR>
<BR>
<BR>
On 10/2/08 12:40 PM, "Joshua Shaffner" <<a href="joshua.shaffner@goodwill.org">joshua.shaffner@goodwill.org</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><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<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_______________________________________________<BR>
Mondrian mailing list<BR>
<a href="Mondrian@pentaho.org">Mondrian@pentaho.org</a><BR>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a><BR>
</SPAN></FONT></FONT></BLOCKQUOTE>
</BODY>
</HTML>