![](media/image1.wmf)

  -------------------------------------------------------------------------
  **Revision**   **Date**   **Revision/Change             **Pages
                            Description**                 Affected**
  -------------- ---------- ----------------------------- -----------------
  1.0            8/2006     Baseline                      All

  3.0            03/2007    Applied formatting and        All
                            content changes, reduced size 
                            of document.                  
  -------------------------------------------------------------------------

# Table of Contents {#table-of-contents .unnumbered}

[Introduction 2](#introduction)

[What is MSIS? 2](#what-is-msis)

[Understanding Data Cubes 2](#understanding-data-cubes)

[Special Note 2](#special-note)

[Drug Summary Mart Measures 3](#drug-summary-mart-measures)

[Opening View 3](#opening-view)

[Changing Measures 4](#changing-measures)

[Calculating Measures 6](#calculating-measures)

[Drug Summary Mart Dimensions 8](#drug-summary-mart-dimensions)

[Understanding Dimension Values 8](#understanding-dimension-values)

[Changing Dimensions 8](#changing-dimensions)

[Troubleshooting Display Problems 11](#troubleshooting-display-problems)

[Not Applicable (NA) in Cells 11](#not-applicable-na-in-cells)

[Helpful Hints 12](#helpful-hints)

[Faster Response Time 12](#faster-response-time)

[Undo Selection 14](#undo-selection)

[Additional Help 15](#additional-help)

Appendix A: MSIS State Summary Web Cubes

## Introduction  {#introduction .unnumbered}

### What is MSIS?  {#what-is-msis .unnumbered}

The Medicaid program began in 1965 with the passage of Title XIX of the
Social Security Act. More than thirty years later, Medicaid still
provides low-income and disabled Americans of all ages with access to
medical and health-related services. Additionally, under the State Child
Health Insurance Program -- SCHIP (Title XXI) of the Social Security
Act, as included in the Balanced Budget Act of 1997, coverage to
children otherwise not eligible for Medicaid is administered in some
States as an expansion to Medicaid.

Medicaid is a federal-state partnership. The federal government
partially funds the program and establishes mandatory and optional
program characteristics. The States provide the remaining program
funding, choose which program options that they wish to implement, and
directly administer the program in their State.

Under the Balanced Budget Act of 1997, as of 1/1/99, it is mandatory
that States report Medicaid data through the Medicaid Statistical
Information System (MSIS). This system requires the States to submit raw
eligibility and claims data to the Centers for Medicare and Medicaid
Services (CMS). MSIS data is used by CMS to produce Medicaid program
characteristics and utilization information. MSIS data is made available
to States and other federal agencies in order to gain greater insight
into the Medicaid program.

The MSIS Drug Summary data mart consists of drug payment and claim
information for each Medicaid fiscal year. The information is stored in
a data cube and is viewed using Cognos PowerPlay Web.

### Understanding Data Cubes {#understanding-data-cubes .unnumbered}

A ***data cube*** is a method of displaying dimensions and measures. One
cube is provided from the MSIS Drug Summary data mart for each Medicaid
fiscal year. The cube provides quarterly and annual measures and
dimensions for drug claim information.

A ***measure*** is a count or summarization of Medicaid information. The
measures in this MSIS data cube are Claim Count and Payments (Total
Medicaid Paid Amount).

A ***dimension*** is a description or characteristic of the measure.
Dimensions include State, Time, Drug Info (Based on MEDISPAN groupings),
and Adjustment Indicators.

### Special Note {#special-note .unnumbered}

This documentation describes the PowerPlay interface using Microsoft
Internet Explorer (IE) version 5.5 or higher. See the on-line Help
** ? ** for assistance with the features and functions of the interface
when using an older version of IE or another browser application.

## Drug Summary Mart Measures {#drug-summary-mart-measures .unnumbered}

The measures in the Drug Summary cube are:

-   Claim Count

-   Payments

A description of each measure is listed in *Appendix A: MSIS Drug
Summary Mart Web Cube*.

###  {#section .unnumbered}

### Opening View {#opening-view .unnumbered}

When you open PowerPlay Web, the application displays the default view
of the report. The State dimension is on the left in row format. The
Annual Year dimension is listed at the top in columnar format. The
default measures are Claim Count and Payments. You can now customize the
display by adding dimensions, changing measures shown, filtering on
dimensions, and changing the format.

![](media/image2.png){width="6.497222222222222in"
height="3.248611111111111in"}

The icons on the bottom of the above view allow you to manipulate
highlighted rows and columns. The functions available include
**Hide/Show** and **Calculations** (which can be used to create ratios
or totals). Some of these functions will be demonstrated throughout this
document.

### Changing Measures  {#changing-measures .unnumbered}

The application displays the Claim Count and Payments measures by
default. You can choose to view one or both measures for Annual, for any
Quarter or for all time periods. You must display at least one measure.

#### Removing Measures {#removing-measures .unnumbered}

1\. There are two ways to remove a measure from displaying on the page.
Right click the heading of any measure. A menu displays. Select
**Hide/Show...** **OR** left click on a measure to highlight it and
click on the **Hide/Show** icon. The Hide/Show window displays.

![](media/image3.png){width="6.497222222222222in"
height="2.314583333333333in"}

2\. The Hide/Show dialog box will display at the bottom of the page.
Click the measure you want and use the left-pointing arrow to move it to
the **Hidden Categories** window or use the right pointing arrow to move
it to the **Visible Categories**. Select **OK** to make the selection or
**Cancel** to exit out of the Hide/Show dialog box with out making any
changes.

![](media/image4.png){width="6.497222222222222in" height="3.23125in"}

3\. The display will update based on your selection. **Payments** has
been removed as shown below.

![](media/image5.png){width="6.497222222222222in"
height="1.8729166666666666in"}

#### Adding Measures {#adding-measures .unnumbered}

1\. Open the **MEASURES** folder by clicking on the plus sign ( **+** )
next to it. Drag a measure (**Payments**) to the column drop area by
clicking on **Payments**, dragging it over and dropping it in the column
area.

![](media/image6.png){width="6.497222222222222in"
height="1.8729166666666666in"}

2\. The display will be updated with your selection.

![](media/image7.png){width="6.497222222222222in"
height="1.9027777777777777in"}

### Calculating Measures {#calculating-measures .unnumbered}

You can create new measures that are derived from the displayed values
or you can produce column totals (such as a National Total). For
example, follow these steps to show the Average Paid Amount per Claim.

1\. There are two ways to calculate the values for a new measure. Right
click the heading of any measure. A menu displays. Select **Insert
Calculation...OR** left click on a heading to highlight it and select
the **Calculation** icon. The Calculation window displays.

> ![](media/image8.png){width="6.495833333333334in"
> height="2.566666666666667in"}

3\. From the Operation drop-down list, select **Divide**.

4\. Type "**Average Paid Amount**" for the Calculation Name. This name
will be used as the column heading.

5\. From the first Category drop-down list, select **Payments**.

6\. From the second Category drop-down list (after Divided by), select
**Claim Count**.

7\. When the calculation is set up the way you wish, click **OK.**

![](media/image9.png){width="6.495833333333334in"
height="2.566666666666667in"}

10\. The display updates based on your selection. Note that calculated
measures are in *italics*.

![](media/image10.png){width="6.495833333333334in"
height="2.5618055555555554in"}

Note that the calculate function can also be used by clicking on a row,
then using the calculate icon to produce column totals (such as a
national total). Note also that when totaling, nesting of rows and
columns is maintained in the totals.

## Drug Summary Mart Dimensions {#drug-summary-mart-dimensions .unnumbered}

### Understanding Dimension Values {#understanding-dimension-values .unnumbered}

The Drug Summary Mart cube structures information so that you can easily
explore the interactions between different characteristics of the
Medicaid drug program. The dimensions add levels of detail to this data.

The dimensions in the Drug Summary data cube contain established code
values and reference information. The dimensions in the cubes are:

-   State

-   Time (Medicaid fiscal year and quarter)

-   Drug Info (Category, Group, GPI)

-   Adjustment Indicators

A description of and the valid values for each dimension are listed in
*Appendix A: MSIS Drug Summary Web Cube*.

### Changing Dimensions {#changing-dimensions .unnumbered}

When viewing the Drug Summary cube, **[the Time dimension must always be
included]{.underline}** and is the default view. The displayed values
are doubled if the **Time** dimension is removed.

#### Adding Dimensions {#adding-dimensions .unnumbered}

1\. To include all dimension values, drag and drop the folder icon onto
the row or column drop area of the display. A bold narrow line appears
in spots where you can place the dimension.

![](media/image11.png){width="6.492361111111111in"
height="3.0881944444444445in"}

2\. The display updates based on your selection.

![](media/image12.png){width="6.492361111111111in"
height="3.0881944444444445in"}

*Note*: The summary rows and columns can be removed if needed using the
Hide/Show options as described above under Drug Summary Mart Measures.

To add only one value from a dimension to your display, follow these
steps.

1\. Click the plus sign ( **+** ) next to the folder for the dimension
you want to add to the report. All values within the dimension are
displayed.

2\. Click on the icon next to the value and drag it to the drop area
where you want it displayed.

![](media/image13.png){width="6.492361111111111in"
height="3.0881944444444445in"}

3\. The display updates based on your selection.

![](media/image14.png){width="6.492361111111111in"
height="3.0881944444444445in"}

*Note*: If the \"All Time\" folder is dragged into the top row of the
report heading, PowerPlay may include a summary column for All Time in
the display. Because the values in the Drug Summary Mart cube have been
aggregated already in an Annual column, these summaries are **not**
valid. To remove the All Time summary column from the display, make sure
that the Show Summaries box in the Hide/Show dialog box is unchecked.

## Troubleshooting Display Problems {#troubleshooting-display-problems .unnumbered}

### Not Applicable (NA) in Cells {#not-applicable-na-in-cells .unnumbered}

\"NA" in some or all of the cells means that measures have been placed
in **both** the row and column areas. To correct this problem, delete
all the measures from either the row or column area.

1\. To delete a column or row, highlight the row or column drop area.

![](media/image15.png){width="6.497222222222222in"
height="1.8909722222222223in"}

2\. Right click on the highlighted column drop area and select delete.

![](media/image16.png){width="6.497222222222222in"
height="2.279861111111111in"}

3\. The display updates based on your selection.

![](media/image17.png){width="6.497222222222222in"
height="1.8909722222222223in"}

## Helpful Hints {#helpful-hints .unnumbered}

### Faster Response Time {#faster-response-time .unnumbered}

You can format the display without showing the data for each change.
This makes the response time faster.

1\. Click the Display Options button
![](media/image18.png){width="0.375in" height="0.2708333333333333in"} on
the PowerPlay toolbar. A menu displays.

2\. Select **Get Data Later**.

![](media/image19.png){width="6.497222222222222in"
height="3.248611111111111in"}

3\. The middle of the display is replaced with the words **[Get
Data]{.underline}**.

![](media/image20.png){width="6.497222222222222in"
height="1.8909722222222223in"}

4\. Format the display to show the dimensions and measures you want.
Added below are the Payments measure in the columns area and the All
Drug Info in the rows area.

![](media/image21.png){width="6.497222222222222in"
height="3.248611111111111in"}

5\. Click **Get Data** to retrieve the actual values. The display
updates based on your selection.

![](media/image22.png){width="6.497222222222222in"
height="3.248611111111111in"}

### Undo Selection {#undo-selection .unnumbered}

1\. To return to the previous view of the cube, click the browser's Back
button.

![](media/image23.png){width="6.497222222222222in"
height="1.7805555555555554in"}

The previous view of the cube will display.

2\. Alternatively, click the Reset button on the Cognos interface.

![](media/image24.png){width="6.497222222222222in"
height="1.7805555555555554in"}

The initial view of the cube will display.

## Additional Help {#additional-help .unnumbered}

You can obtain further assistance by using the on-line Help function.

1\. Click the Help button
![](media/image25.png){width="0.24861111111111112in"
height="0.24861111111111112in"} on the PowerPlay toolbar.

![](media/image26.png){width="6.497222222222222in"
height="1.3923611111111112in"}

2\. The PowerPlay Web Help window displays.

![](media/image27.png){width="6.427083333333333in"
height="4.260416666666667in"}

You can also send an e-mail to **MSIS_Data_Marts@cms.hhs.gov**. Please
include your name and phone number in the message.

*Notes:*

# MSIS Drug Summary Mart Web Cube

This appendix describes the dimensions and measures in the Drug Summary
Mart web cube.

Medicaid Drug Summary Mart Web Cube

+---------------+------------------------------------------------------+
| **Dimension** | **Description**                                      |
+===============+======================================================+
| State         | The standard two-character abbreviation used by the  |
|               | US Postal Service for the state or territory. This   |
|               | dimension must always be selected. The default is    |
|               | All States.                                          |
+---------------+------------------------------------------------------+
| Time (Period) | The fiscal year and fiscal quarter values. This      |
|               | dimension must always be selected. The default is    |
|               | all periods.                                         |
|               |                                                      |
|               | > **Note**: *The Medicaid fiscal year is from        |
|               | > October 1 through September 30.*                   |
+---------------+------------------------------------------------------+
| Drug Info     | Text descriptions of Drug Info presented as follows: |
|               |                                                      |
|               | > D R U G C A T E G O R Y - Text of the drug         |
|               | > category. Drug categories are presented as all     |
|               | > uppercase with a space between each character.     |
|               | >                                                    |
|               | > drug group -- Text of the drug group. Drug groups  |
|               | > are presented as all lowercase characters.         |
|               | >                                                    |
|               | > GPI SUBSET -- GPI subsets are presented as all     |
|               | > uppercase with no spaces between the characters.   |
+---------------+------------------------------------------------------+
| Adjustment    | Indicates whether or not the claim is an adjustment. |
| Indicator     | Values are:                                          |
|               |                                                      |
|               | > Credit Adjustments                                 |
|               | >                                                    |
|               | > Debit Adjustments                                  |
|               | >                                                    |
|               | > Original Claim                                     |
|               | >                                                    |
|               | > Re-Submittal                                       |
|               | >                                                    |
|               | > Void of a prior submission                         |
|               | >                                                    |
|               | > Re-submittal                                       |
+---------------+------------------------------------------------------+

  -----------------------------------------------------------------------
  **Measure**             **Description**
  ----------------------- -----------------------------------------------
  Claim Count             Total number of non-encounter claims
                          adjudicated during the period.

  Payments                Total dollar amount Medicaid paid on claims
                          that were adjudicated.
  -----------------------------------------------------------------------