MicroStrategy ONE

Example: Customers Who Live in the Same City as Call Centers

Your new utility company has call centers located throughout the country, and your recent surveys indicate that customers who live in the same city as a call center are particularly satisfied with service due to extremely rapid repairs during power outages. To begin your new advertising campaign, you want to generate a list of Call Centers that coincide with Customer Cities.

The following steps create an attribute-to-attribute qualification filter that generates the list of desired cities.

To Create an Attribute-To-Cttribute Qualification that Compares the Call Center and Customer City Attributes

  1. In MicroStrategy Web, log in to a project.
  2. Open any folder page (for example, click Shared Folders on the home page).
  3. Click the Create Filter icon .
  4. From the Object browser on the left, select the Customer City attribute from the Customers hierarchy and drag it to the filter pane on the right.
  5. Change Qualify to ID.
  6. Change the operator to Equals.
  7. Click the Select Attribute icon .
  8. Select the Call Center attribute from the Geography hierarchy.
  9. Click OK.
  10. Click the Apply icon .
  11. Save and close the filter, naming it Customer City = Call Center.

    Now that you have created the attribute-to-attribute qualification filter, create a report and add the filter.

To Create the Report

  1. In MicroStrategy Web, log in to a project.
  2. Click the MicroStrategy icon at the upper left of any page and select Create Report.
  3. Add the Customer City attribute to the report.
  4. Add the Customer City = Call Center filter to the report.
  5. Save the report, and then execute it.

    When the report is executed, only a small subset of the total number of Call Center attribute elements are displayed. Each of the elements (cities) present on the report is also a Customer City.