How time dimension works

[muttou]

hi i m using the Jasper server for my Analysis and found it well but i need to know that how Time dimension works and i have a TimeStamp data type in my table tell how i can map or make the time series on this columns for e.g

'01-JAN-07 10:23:00 am' make it levels like year = 2007 , and next level month = January etc... i used to format my field like to_char(Myfield, 'YYYY') for Year Level and to_char(Myfield, 'MM') for my Month level.. but give me the error message.....i need the urgent solution with the example shows the date data type columns and then makes the Time Dimension on that field or another way ,,,,, Thanks thanks a lot.

[dpeykov]

Hi,

 

I have the same problem and No solution yet :(

Did U find how to solve that. I was trying with setting "levelType" = TimeYears, TimeQuarters... while designing the schema, but It doesn't work properly.

 

Hope somebody tell us, recently, how to make it working.

 

Best Regards,

Dinko Peykov

[swood]

A Level can contain KeyExpression, NameExpression and OrdinalExpression which are SQL statements, like:

 

Code:

      <Level name="Name" type="Numeric" uniqueMembers="true" levelType="TimeYears">
        <KeyExpression>
          <SQL dialect="oracle">
year(timestamp)
          </SQL>

...other SQL dialects if needed...

          <SQL dialect="generic">
year(timestamp)
          </SQL>
        </KeyExpression>

 

This will have a performance impact over having distinct year, month, day columns.

 

 

Sherman

JasperSoft