Start with a Cube View

There is a new folder in the Data Warehouse in Public Folders > ESE Cubes > Cube Views which contains a variety of views of the 2010 Cube that can serve as excellent starting points for additional inquiry. Not all users have learned to develop cube views (which is trickier than accessing the pre-defined reports) but interacting with these pre-made cube views is much simpler.

Current cube views include:

• MCAS CPI Trends by Grade Level
• MCAS Demographic Trends
• MCAS Performance by Grade Level
• MCAS Performance by Year
• MCAS School/District CPI vs State CPI by Grade
• MCAS Special Education Performance Gap Trends

Click the cube view that you'd like to investigate (for instance, MCAS Performance by Grade Level) and use the Dimension Line at the top of the screen to "filter" the data by choosing the desired district or school, subject area, subgroup, etc.)

To save the cube view you created, you can click the Save As icon in the lower right corner and save it to your My Folders area. (Don't worry, you won't overwrite the public cube views.)

To convert the cube view to PDF for printing, click the File button in the toolbar at the bottom of the screen (looks like a page) and choose Export PDF.

For more information on cubes, please see Chapter 3 of the EDW User's Guide.