What is difference between Numeric and Integer types, and how I can use timestamp level type in Mondrian?

champion picture champion · Nov 19, 2013 · Viewed 62.1k times · Source

While reading manual of Mondrian I found that it has not so much types including Integer and Numeric - what's difference between this types?

And how can I use timestamp level type?

Answer

ivstas picture ivstas · Nov 22, 2013

Well, Integer type can contain only whole numbers, like 5 or 123. Numeric type can contain decimal numbers like 15.39.

About the second question: I think you're asking about Time dimensions, not the Timestamp (which is type). In this case it's better to refer the Mondrian documentation:

http://mondrian.pentaho.com/documentation/schema.php#Time_dimensions