About the Tile Chart Type

A tile is a chart type that lets you select specific values from the cube to display. In addition to using a form as a data source, you can directly enter a cell intersection that provides the value for a tile. You can have up to 6 tiles across, and 4 rows down in a dashboard, and give them a title. Until you associate a tile with data, it displays sample data.

With a form as the data source for a tile:

• You can have up to six tiles per object.
• The values in the first column (up to the sixth row) are used to create the tiles.

  Note:

  Sometimes in a form, the first column may be collapsed (hidden) when viewed as a grid. But the collapsed column is still considered when the tile gets its values from the form.
• The tile’s title is the row’s title, and it gets its values from the first column, then by row.
• You can set the tile’s title, the tile’s height percentage, legend, and can select which axes from the form to include. For example, if you select a form with three rows, the tile displays three values.

With a cell intersection as the data source for a tile, you can have only one tile per object.

Tip:

To select a tile chart type, expand the list of chart types by clicking the link at the bottom of the list.

Here are options you can set for a tile chart type. Note that you can set whether the displayed value is horizontally aligned in the tile to the left, the center, or the right.

Scaling Large Numbers

Especially useful for large numbers, you can scale how a currency value is displayed. For example, if the tile value is 1,689,000 and you select K as the scaling option, the tile displays the value as 1689K. Your scaling options:

• None: No scaling is applied.
• Auto: The value is displayed based on its range. For example, 1,500 displays as 1.5K, 1,689,000 displays as 1.69M, 42,314,531,211 displays as 42.31B, and 1,234,567,891,234 displays as 1.23T.
• K: The value is displayed as thousands units. For example, 1689000 displays as 1689K.
• M: The value is displayed as millions units. For example, 123,456,789 displays as 123M.
• B: The value is displayed as billions units. For example, 12,345,678,912 displays as 12B.
• T: The value is displayed as trillions units. For example, 1,234,567,891,234,567 displays as 1,234T.