[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)?
Nick
-------------- 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