[Mondrian] time dimension oddities

Nicholas Goodman ngoodman at bayontechnologies.com
Wed Dec 28 14:58:18 EST 2011

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/0e723e86/attachment.html 

More information about the Mondrian mailing list