Modifying Topic Item Properties

Topic items are discrete informational attributes of topics, such as Customer ID, Street Address, or Sales Revenue, and are the basic building blocks of a query. Topic items are organized within topics and represent the columns of data in database tables.

You can modify the names of topic items to make them easier for users to understand and set drill-down path information.

  To modify a topic item:

  1. Select the topic item and select View, the Properties or click the Properties icon.

    The Topic Item Properties dialog box is displayed, showing information about the source of the topic column in the database.

  2. Change the topic item properties to the desired setting and click OK.

    Available options include:

    • Item Name—Displays the name of the item.

    • Set As Fact—Eliminates items with integer or real values from a drill-down path. This feature is used in conjunction with the Set As Dimension field in the Topic Properties dialog box.

    • Information—Additional column information from the database. Information about keys is displayed only when server-defined joins are enabled.

    • Length—Enables you to change the string length of columns.