[Mondrian] time dimension oddities

Kristopher Kiger kris at digonex.com
Wed Dec 28 15:32:49 EST 2011

That seems to have fixed it.  Thanks for pointing that out! That makes sense... I can't believe I missed it!

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On Behalf Of Nicholas Goodman
Sent: Wednesday, December 28, 2011 2:58 PM
To: Mondrian developer mailing list
Subject: Re: [Mondrian] time dimension oddities

On Dec 28, 2011, at 11:37 AM, Kristopher Kiger wrote:

    <Level name="day" visible="true" column="day_in_month" nameColumn="day_long_name" ordinalColumn="day_in_month" type="Numeric" uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" description="day">

Your issue is likely the fact that you're uniquely identifying a member via SQL (group by) (column=) as day in month (1,2,3..30) but using a non unique method to name your members via nameColumn (7 day names) across your month.

What happens if you remove the nameColumn (or use a nameColumn that *is* unique across Month)?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20111228/7acc631e/attachment-0001.html 

More information about the Mondrian mailing list