Documentation Index

Fetch the complete documentation index at: https://help.board.com/llms.txt

Use this file to discover all available pages before exploring further.

Cube data types

Prev Next

Board Cubes support numeric and alphanumeric data, stored in the following types of Cubes:

Numeric Cubes

Numeric Cubes have the following data types to choose from:

  • Single. Floating-point numeric type (4 Bytes). Each cell occupies 4 bytes. Numbers that need more than 4 bytes to be saved will be rounded. The value of a single cell must be between -3.4028235E+38 and +3.4028235E+38.

    The rounding occurs only when writing data to a single cell of the Cube, so if your data source provides data in single precision or in an 8 character field, we recommend that you use this data type. When used in Procedures and reports, single-precision Cubes are aggregated using double precision variables; therefore, virtually no aggregation occurs.

    This data type is preferred for numeric Cubes because it offers a good trade-off between accuracy and space requirements.

  • Double. Floating-point numeric type with double precision (8 bytes). Each cell occupies 8 bytes. The value of a single cell must be between -1.79769313486232E+308 and +1.79769313486232E+308.

  • Integer. Integer numeric type. Each cell occupies 8 bytes. The value of a single cell must be between -9,223,372,036,854,775,808 and 9,223,372,036,854,775,807.

  • Currency. Fixed 5 decimal format with the same accuracy as the “Double” type. Each cell occupies 8 bytes.

Text Cubes

Text Cubes have the following data types to choose from:

  • Text. Text Cubes are used to store text information in unformatted text format. For example, a Cube with only the Customer Entity in its structure can store customer addresses, or a Cube having the Product and Country Entities in its structure can store product names, which may vary according to the language of the country. As another example, a Cube structured by the Profit & Loss and Month Entities can store textual comments for each month's closure next to the profit and loss line.

    The Text data type is dynamic and unlimited, although it is recommended to limit the text in a single cell to a reasonable size: 1 to a maximum of 2,000 characters, in order to properly and fully display the text in a single cell of a Data View or in other Objects.

    Since they store text, Text Cubes do not support aggregation.

    Given the dynamic nature of text Cubes, if you use ASCII Data Readers to populate one, we recommend you change the Data Reader format from "fixed width" to "CSV". If you have a Procedure that extracts a text Cube to a file, we recommend you set the extracted file to "tab-delimited" in CSV format.

    When a text Cube is extracted, the carriage-return (new line) and tabulator characters are omitted, so any comments on multiple lines are converted to text on a single line.

  • RTF. RTF Cubes are a specific kind of BLOB Cubes that store text information in Rich Text Format (RTF) format, thus allowing the user to add a certain degree of formatting, including bolding, italicization, custom fonts, and custom colors. RTF documents can also contain images, such as .jpg and .png files, embedded within their text.
    RTF Cubes can be used in conjunction with certain Board Screen Objects, such as the Dynawrite Object, to allow Planners to edit their content in Play Mode via Data Entry actions.

Date Cubes

Date type Cubes are used for service level analysis. Board supports calculation between dates: the difference between 2 date Cubes returns the number of days between 2 dates. Adding an integer (a production lead time, for example) to a date (an order date for example) returns the delivery date.

It is not possible to aggregate date Cubes, however if you create an aggregated view on a date Cube using the Data View Object, the highest and lowest dates are returned. For example, suppose we have a date Cube called DueDate structured by an Entity named Project and another Entity called Department, the latter being the parent of Project.
A report on DueDate by Department returns the smallest and highest dates found for projects related to the department.

A date is physically stored in numerical format (an integer value where 1 represents 01/01/1900). When viewed by a user, the date is displayed in short date format following the user's operating system regional settings.

BLOB Cubes

BLOB Cubes are Cubes that can store files in their cells. A BLOB Cube can hold a collection of MS-Word or Excel documents, image files, PDF documents, or other types of files.

BLOB Cubes can handle a set of documents—such as commentaries, images or other types of attachments—in a multidimensional manner. For example, in a Financial Planning application, you can use a BLOB Cube to allow users to attach a lengthy commentary or an Excel worksheet to a particular account (e.g. Revenues) for a particular month (e.g. February).
The content of a BLOB Cube can display in a Data View, in its cells, or in a tooltip using the Tooltip-by option.
Once loaded through a Data Reader or via Data Entry, the embedded files are compressed and encrypted into the BLOB Cube and can only be accessed from the Capsule environment. Just like other Cubes, BLOB Cubes are subject to the Data Model Security settings, so you can configure user rights in order to assign "read-write" privileges to some users or "read-only" to others.

  • Board BLOB Cubes support the following data types:

    • Picture. Board supports .jpg, .jpeg, .png, and .gif file types.

    • Microsoft Excel. Board supports only Microsoft Excel Workbooks created with Excel 2007 and newer (files with the .xlsx extension).

    • Microsoft Word. Board supports only Word documents created with Word 2007 and newer (files with the .docx extension).

    • Microsoft Power Point. Board supports only Power Point presentations created with Power Point 2007 and newer (files with the .pptx extension).

    • PDF. Board supports PDF.

    • Custom. This data type can be used so that a BLOB Cube stores files with a custom extension other than those supported natively.

      Leaving the Blob extension for Custom blank does not allow upload of any file with Data Entry enabled. In this case, files must be uploaded via a Data Reader.

Read how to map a BLOB Cube in a Data Reader.