Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Suggestions with two different Calendar dimensions

  1. #1
    Join Date
    Sep 2007
    Posts
    3

    Default Suggestions with two different Calendar dimensions

    Hi Everybody.

    I am currently trying to setup a data cube which contains 2 time based dimensions besides others.

    Code:
      <Dimension foreignKey="PERIOD_ID" name="Periode" type="TimeDimension">
       <Hierarchy hasAll="true" allMemberName="Alle Perioden" primaryKey="PERIOD_ID">
        <Table name="D_PERIOD2" />
     
        <Level name="Kalendar Jahr" column="YEAR" type="Numeric" 
         uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" />
        <Level name="Monat" column="MONTH" type="Numeric" 
         uniqueMembers="false" levelType="TimeMonths" hideMemberIf="Never" />
     
        <Level name="Tag" column="DAY" type="Numeric" 
         uniqueMembers="false" levelType="TimeDays" hideMemberIf="Never" />
       </Hierarchy>
      </Dimension>
      <Dimension foreignKey="YEAR_ID" name="Jahr" type="TimeDimension">
       <Hierarchy hasAll="true" allMemberName="Alle Jahre" primaryKey="YEAR_ID">
        <Table name="D_YEAR2" />
        <Level name="Jahr" column="YEAR" type="Numeric" 
         uniqueMembers="true" levelType="TimeYears" hideMemberIf="Never" />
        <Level name="Kalenderwoche" column="CALENDER_WEEK" type="Numeric" 
         uniqueMembers="false" levelType="TimeWeeks" hideMemberIf="Never" />
       </Hierarchy>
      </Dimension>
    The first dimension was setup to support drill down by "calendar"-Data.

    The second dimension is to support browsing by ISO Weeks.

    With those two dimensions assigned on rows one can not drill down in those two dimensions. An exception occus while executing the query. I think it is caused by the various crossjoins in the generated MDX

    NON EMPTY Hierarchize(...., Union(Union(Crossjoin([Jahr].[Alle Jahre].[2007].Children, {[Periode].[Alle Perioden]}), Crossjoin([Jahr].[Alle Jahre].[2007].Children, [Periode].[Alle Perioden].Children)), Crossjoin([Jahr].[Alle Jahre].[2007].Children, [Periode].[Alle Perioden].[2007].Children)) ON ROWS
    Therefore I'm asking for suggestions either how to solve the error or suggestions for better setup a kind of Calendar-Dimension with ISO-Calendarweek support.

    Kind Regards,
    Ken

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default

    What's the exception? Jpivot generally generates valid MDX, and mondrian can generally execute valid MDX, and if so, the worst thing that should happen is that you get empty rows. Or you could be hitting a bug.

    Julian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.