MicroStrategy ONE

Showing and hiding column data types

In the Freeform SQL Editor, you can show and hide column data types along with other pertinent information.

Prerequisites

  • The procedure below assumes you have already created a Freeform SQL report.

  • You must have the Define Freeform SQL report and Create schema objects privileges to access and use the Freeform SQL Editor.

To show and hide column data types

  1. Access the Freeform SQL Editor. (How?)

  2. From the View menu, select Show Column Data Type. This option displays the full data type information for the column, including Data Type, Precision/Length, and Scale, in addition to Column, Object, Form, and Type, which are displayed by default.

  3. You can use the drop-down list to change the selection for Data Type, such as integer, char, date, real, time, float, and so on. However, you need to ensure that the data type matches the type of data in the data warehouse. Otherwise, the report may fail.