Displaying derived elements and their attribute elements simultaneously

You can analyze attribute elements with derived elements, while also including the attribute element on the report. You can accomplish this by selecting which attribute elements are included in the All Other derived element.

By default, the All Other derived element only collects attribute elements that are not included in derived elements, and includes them on the report as individual attribute elements. For an introduction to the All Other derived element, see All Other.

The simple report below is used as an example of how you can display derived elements and their attribute elements simultaneously.

You have the following options in the Derived Elements Editor to display derived elements and their attribute elements simultaneously:

• Do not include individual items in the All Other element (default behavior): The attribute elements that are used to define the derived element are excluded from the All Other derived element. This means that the attribute elements are not displayed, only their combined data for the derived element is displayed.
  
  For example, in a report with Category and Profit, you create a Group derived element that combines the Books and Electronics attribute elements. By selecting to keep the default option, the derived element is displayed on the report but the attribute elements that makes up these derived elements are not, as shown below.
  
  
   

• Include individual items in the All Other element: The attribute elements that are used to define the derived element are also included in the All Other derived element. This means that the attribute elements are displayed along with the derived elements they are a part of.
  
  For example, in a report with Category and Profit, you create a Group derived element that combines the Books and Electronics attribute elements. You select to include the Books attribute element and the Electronics attribute element in the All Other derived element. This displays the derived element, as well as the individual Books and Electronics attribute elements, as shown below.
  
  
  
  For an attribute element to be included in the All Other derived element, all derived elements that the attribute element is included in must be defined to include their attribute elements in the All Other derived element. This can cause unexpected behavior when an attribute element is included in multiple derived elements.
  
  For example, in a report with Category and Profit, you create a Group derived element that combines the Books and Electronics attribute elements. You create a second Group derived element that combines Electronics and Movies. The report is shown below.
  
  
  
  You select to include the attribute elements of the Books and Electronics derived element in the All Other derived element. Notice that Books is displayed but Electronics is not displayed, as shown below.
  
  
  
  This is because the Electronics attribute element is also a part of the Electronics and Movies derived element, which is defined to exclude its attribute elements in the All Other calculation. To display the Electronics attribute element along with both derived elements, you must define both derived elements to include their attribute elements in the All Other derived element.

The steps below show how to define whether derived elements are displayed with their attribute elements simultaneously.

Prerequisites

• A report connected to an active Intelligent Cube, a Grid/Graph in a Report Services document, or a stand-alone derived element.

• This procedure also assumes you have created derived elements for the report, Grid/Graph, or stand-alone derived element.

• You have the Derived Elements Editor open. For information on accessing the Derived Elements Editor, see Accessing the Derived Elements Editor.

• You need the Define Derived Elements (MicroStrategy Developer) and/or the Web Define Derived Elements (MicroStrategy Web) privileges. These privileges are part of OLAP Services.

To include or exclude attribute elements in All Other derived elements

1. In the Derived Element Editor, select a derived element.

2. Select the Property tab.

3. Select one of the following Apply element to all other calculation options:

   • Do not include individual items in the All Other element

   • Include individual items in the All Other element

   • These options are described in the beginning of this section (Displaying derived elements and their attribute elements simultaneously).

4. Click OK to save your changes and close the Derived Elements Editor.

Related Topics

• About Derived Elements

• Using the Derived Element Editor