Creating the Subject Areas

Creating the Subject Areas

To create the subject areas, do the following:

1. In the Architect, click New.

2. Click Subject Area.

3. For Subject Area Name, type Patient Set A

4. For Base Cube, click Browse and select Tutorial

5. For Class name for the Subject Area, type Tutorial.SubjectA

6. Click OK.

   The system creates the subject area and saves the class.

   You should see the following:

   

   In the Architect, there is no user interface for defining a filter. Instead it is necessary to type a suitable filter expression or to copy and paste one from the Analyzer.

7. In a separate browser tab or window, access the Analyzer and then do the following:

   1. Expand HomeD.

   2. Drop ZIP Code to the Filters box. This adds a filter box directly above the pivot table.

   3. In that filter box, click the search button and then select 32006, 32007, and 36711.

      Click the check mark.

      This action filters the pivot table.

      Important:

      Do not drag and drop 32006, 32007, and 36711 separately to the Filters box. Instead drag the level as described and then select the members.

   4. Click the Query Text button .

      The system then displays a dialog box that shows the MDX query that the Analyzer is using:

      SELECT  FROM [Patients] 
      %FILTER %OR({[HOMED].[H1].[ZIP Code].&[32006],[HOMED].[H1].[ZIP Code].&[32007],[HOMED].[H1].[ZIP Code].&[36711]})
      

      

   5. Copy the text after %FILTER to the system clipboard.

   6. Click OK.

8. In the Architect, click the line labeled Patient Set A.

9. In the Detail Pane, paste the copied text into Filter.

   %OR({[HOMED].[H1].[ZIP Code].&[32006],[HOMED].[H1].[ZIP Code].&[32007],[HOMED].[H1].[ZIP Code].&[36711]})
   

   

10. Click Save and then click OK.

11. Compile the subject area.

12. For the second subject area, repeat the preceding steps, with the following changes:

    • For Subject Area Name, type Patient Set B

    • For Class name for the Subject Area, type Tutorial.SubjectB

    • Repeat the preceding steps with the other two ZIP codes. So, for Filter, use the following:

      %OR({[HOMED].[H1].[ZIP Code].&[34577],[HOMED].[H1].[ZIP Code].&[38928]})