I agree with Pedro on this, even with using the same dimension on rows/columns. If I want information broken out by month & day of week, as it stands I'd have to settle for one of:<br><br>* Break it out on one axis and live with it -- while I can't easily see relationships between events that occur on mondays every month, there's not much I can do about it otherwise.<br>
* Create either a mirrored date dimension or a day of week dimension<br>** The mirrored date dimension could easily create confusion with users. There's that saying "keep it simple, stupid". More dimensions = more complexity.<br>
** The day of week dimension would suffice, but has some problems:<br>*** requires yet another dimension key on my fact table. If my fact table has many dimensions, more than one of which I'd like to use at different levels of aggregation on different axes, this bloats the fact table<br>
*** I would probably have to remove day of week from the date dimension, which might be annoying under other circumstances where I want the date dimension to have both month & day of week. The date dimension can have multiple drill-down paths, but that also creates more options for users -- and users don't like too many options<br>
* Just break it out on one axis, then write custom code to iterate over the query results in a different sequence than presented<br><br> For whatever reason, it's easier for people to wrap their heads around few columns with many rows, than many rows and fewer columns. Additionally, it'd be easier to see trends or patterns by applying the day of week on a different axis from the month.<br>
<br> While it's true a report or visualization would be _capable_ of presenting the information in whatever way it sees fit, it'd be nice for the [report/visualization] developer, and for those tech savvy users with just enough knowledge to design simple queries.<br>
<br> I see this as code re-use. Why create 5 dimensions to represent the same concept in different ways when one dimension would suffice if you have more flexibility in its use.<br><br>-Brian<br><br><div class="gmail_quote">
On Thu, Jul 16, 2009 at 4:06 AM, Pedro Alves <span dir="ltr"><<a href="mailto:pedro@neraka.no-ip.org">pedro@neraka.no-ip.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
<br>
Hey there.<br>
<br>
<br>
Is there a way to remove the restriction of not having the same dimension<br>
in more than one axis?<br>
<br>
<br>
I'm working on a dashboard generator that dynamically integrates with<br>
mondrian, but this is a very bad restriction if I want users to apply<br>
whatever filters they want. The following query is an example of the type<br>
of stuff I'd love to be able to do:<br>
<br>
<br>
select<br>
Descendants([Products], [Products].[Version]) on rows,<br>
Measures.[Downloads] on columns<br>
>From ...<br>
where<br>
([Dates].[Date].[2009-07-16],<br>
[Products].[Firefox].[3.5],<br>
[Download Types].[Complete])<br>
<br>
<br>
Instead, I need to do<br>
<br>
<br>
select<br>
Descendants([Products].[Firefox].[3.5], [Products].[Version]) on rows,<br>
Measures.[Downloads] on columns<br>
>From ...<br>
where<br>
([Dates].[Date].[2009-07-16],<br>
[Download Types].[Complete])<br>
<br>
<br>
In terms of plain queries this is not complicated; But in a scenario where<br>
the users is free to choose whatever dimensions he wants to chart against<br>
whatever conditions he wants to filter, my algorithm to generate the query<br>
gets much more complicated than I'd like<br>
<br>
<br>
And I don't think there's a reason for this restriction; There were<br>
projects where I've defined in the mondrian schema the same dimension<br>
duplicated just to be able to do what I need. Another example is here:<br>
<a href="http://tinyurl.com/kk9b2b" target="_blank">http://tinyurl.com/kk9b2b</a> . Having to define a [Time2] dimension that's<br>
absolutely identical to [Time] to obtain a very standard crosstab<br>
information.<br>
<br>
<br>
<br>
Any tips appreciated<br>
<br>
<br>
-pedro<br>
<br>
_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
</blockquote></div><br>