Data Types » Format types

Format types

Attribute forms are also associated with a MicroStrategy format type, which specifies how attribute form values should be displayed on MicroStrategy interfaces. You specify the format type of an attribute form in the Form Format: Type drop-down menu in the Attribute Editor.

The attribute form format types are described in the following table.

Format Type

Description

Big Decimal

Information is stored and displayed in the Big Decimal form, which represents high-precision fixed point numbers. For more information about Big Decimal, see Big Decimal.

Binary

Information from binary data types is stored and displayed as a string of characters. For more information on support of binary data types, see MicroStrategy support for binary data types.

Date

Information is stored and displayed as dates in a sequential form to perform calculations on the dates. It represents dates in the MM/DD/YYYY format.

Datetime

Information is stored and displayed both as date and time in the format specific to the data. The date follows the MM/DD/YYYY format and time follows the HH:MM:SS format.

Email

Information is stored and displayed in the form of an e-mail address.

HTML Tag

Information is stored and displayed as an HTML tag.

Number

Information is stored and displayed in a number format.

Picture

stored and displayed the form of an image file, such as bitmap, JPG, or GIF.

Text

Information is stored and displayed in a text format.

Time

Information is stored and displayed as time in the HH:MM:SS format. This displays only the time and not the date.

URL

Information is stored and displayed as either an absolute or a relative Universal Resource Locator.