[Mondrian] Names vs. Unique Names
Matt Campbell
mkambol at gmail.com
Fri Jan 25 15:14:36 EST 2008
Despite 6 years of MDX experience, I only recently discovered that you could
refer to a dimension member without specifying the dimension it is a part
of. For example, [M] can be used as a shortcut for [Gender].[All
Gender].[M]. This works in both Analysis Services and Mondrian.
I don't like this feature for a couple reasons:
1) [M] could also mean [Marital Status].[All Marital Status].[M]. There's
no obvious way of knowing which member you'll get.
2) More importantly for us, to figure out which dimension has a member with
that name Mondrian needs to query each and every dimension table in that
cube looking for a match. Since we have 700+ dimensions that essentially
means that the server is brought to a standstill searching for a member that
may or may not exist.
I'd like to add a property (false by default) that will require dimension
name to be included in an identifier. The code change looks trivial. What
do people think?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20080125/039f4160/attachment.html
More information about the Mondrian
mailing list