Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

mondrian

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?

like image 760
champion Avatar asked Nov 19 '13 14:11

champion


People also ask

What is the difference between the numeric and integer data types?

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

What is the difference between numeric and number?

Number is a noun - 数目字. Numeric is an adjective meaning relating or expressed as numbers Examples: Numbers are numeric characters.

What is a numeric data type?

Numeric types consist of two-, four-, and eight-byte integers, four- and eight-byte floating-point numbers, and selectable-precision decimals.

Is integer a numeric value?

In contrast, integer and decimal data types are exact numeric values.


1 Answers

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

like image 156
ivstas Avatar answered Oct 19 '22 06:10

ivstas