Format: Derived Elements Dialog Box

You can format derived elements using the Format: Derived Elements dialog box. Formatting derived elements lets you highlight important or unique data as well as correctly reflect value and character formats for your derived elements. You can:

• Format the derived element name by applying formatting to the header of a derived element. You can use this to highlight or visually distinguish the various derived elements displayed in a report or document. To do so, select Header from the first drop-down list.
• Format all metric values associated with the derived element by applying formatting to the values of a derived element. You can use this to display metric values as percentages, fractions, or unique formats. To do so, select Values from the first drop-down list.

For an introduction to derived elements, with examples and images, see the Derived Elements chapter in the In-memory Analytics Help.

To Access the Format: Derived Element Dialog Box

1. To format a derived element in a report, click the name of the report to run it.
2. To format a derived element in a document, open the document in Editable Mode.
3. Right-click the header of the attribute used to create the derived element, then select Derived Elements.
4. Select the name of the derived element you want to format, then click the Format icon .

The following formatting options are available:

• Font tab: Specify font options, such as font type and font style.

  • Font: Select any font that is installed and available on your machine.
  • Style: Apply italic and bold effects to the text.
  • Size: Select any font size that is installed and available on your machine. Choices in this list vary depending on the selected font type.
  • Effects: Apply an underline or strikeout effects to the text.
  • Color: Specify a color in which to display the text by selecting a color from the color palette. You can access additional colors by clicking More Colors.

• Number tab: Specify formatting options for numeric values.

  • Default: Numbers are shown using the default number formatting for the attribute or metric value being displayed.
  • General: Numbers have no specific formatting.
  • Fixed: Numbers are displayed using a fixed number of decimal places. Specify the number of decimal places to be displayed as well as how to display negative numbers.
  • Currency: Numbers are displayed as currency. Specify the number of decimal places to be displayed, the currency symbol to be used, where to display the currency symbol, and how to display negative numbers.
  • Date: Numbers are displayed as dates. Specify the format to display dates in by selecting one of the examples in the Type field.
  • Time: Numbers are displayed in time format. Specify the format to display time in by selecting one of the examples in the Type field.
  • Percentage: Numbers are displayed as percentages. Specify the number of decimal places to be displayed and how to display negative numbers.
  • Fraction: Display decimals as fractions. Specify the format to display fractions in by selecting one of the examples in the Type field.
  • Scientific: Display numbers in scientific notation. Specify the number of decimals to be displayed.
  • Custom: Specify a custom notation to display numbers in.

• Alignment tab: Specify text alignment options, such as whether to center text or display text vertically.

  • Text alignment: Specify the horizontal and vertical alignment of text in a cell.

    • Horizontal: Specify the horizontal alignment as Use Default, Left, Center, Right, or Justify.
    • Vertical: Specify the vertical alignment as Use Default, Top, Center, or Bottom.

  • Text control: Specify text display and text wrapping options.

    • Wrap text: To display the text on multiple lines within the cell, select this checkbox. To display the text on a single line, clear the checkbox. This checkbox is cleared by default.
    • Text direction: Specify whether the text is displayed Horizontally (across the page), or -90 degrees (vertically from top to bottom), as shown below:

    
    

    Vertical text is displayed when the report is executed in MicroStrategy Web. Vertical text is not displayed in MicroStrategy Developer or in Design Mode in MicroStrategy Web.

  • Padding: Specify the amount of space to display between the text and the border of the cell.

    • Left: Enter the amount of padding to display between the text and the left border of the cell.
    • Right: Enter the amount of padding to display between the text and the right border of the cell.
    • Top: Enter the amount of padding to display between the text and the top of the cell.
    • Bottom: Enter the amount of padding to display between the text and the bottom of the cell.

• Color and Lines tab: Specify cell formatting options such as border color and background color.

  • Fill: Select a color from the color palette to use to display the background of the cells containing derived element values. You can access additional colors by clicking More Colors.

  • Borders: Select the line style and borders for each cell.

    • None: No border applied.
    • All (default): The same line style and color is applied to the left, right, top, and bottom of the cell. Specify the line style and color for the borders.
    • Custom: A different line style and color can be applied to the left, right, top, or bottom of the cell. Specify the line style and color for each border.

  • Line and Shape Settings (Flash-only): These formatting options are available for Flash-enabled documents and display in Flash Mode.

    Flash Mode is available only if your document was created before MicroStrategy 10.1 and was defined to display in Flash Mode. Beginning with 10.1, Presentation Mode replaces Flash Mode.

    • Style: Select the line style for the border from the drop-down list.
    • Color: Select the color for the border from the drop-down list.
    • Weight: Select the thickness for the lines that make up the border.

Related Topics

Derived Elements Editor