MicroStrategy Web

It stores all of the information that you want to analyze from your various business systems.

It contains the definition of reports as well as all of the objects that are included in reports.

It records data about your business

Fact

Attribute

Hierarchy

Metric

Attribute

Prompt

Fact

Hierarchies

Fact

Template

My Subscriptions

History List

Shared Reports

My Reports

Documents cannot be prompted

A prompt may have a default answer already selected when you first view it.

All prompts are displayed the same way.

Static

Predefined

Prompted

Pull Down

Text Box

Option Button

Check Box

Grid

Graph

Grid and Graph

All of the above

Drilling

Advanced Sorting

Data Pivoting

Outline Mode

Outline Mode

Banding

Drilling

Page-by

Grouping in documents is similar to the page-by axis in reports

You can change the order of the data elements in the Grouping field.

You can add additional data elements to the Grouping field.

Quick sort enables you to sort by one row or column at a time

You can perform an advanced sort using the sort buttons

Advanced sort enables you to sort sequentially by up to three rows or columns at a time.

Clicking on a hyperlinked attribute element name

Right-clicking and using the Drill menu

Dragging an attribute to the Drill panel

Using the Drill panel

Dynamic

Interactive

Static

Simplified

Autostyle

Banding

Thresholds

Number formatting

You use Quick Switch to switch from one document to another in the View Mode

You use Quick Switch for changing the display of a grid to a graph and vice versa in a document

You use Quick Switch for converting a graph into a Flash widget

All of the above

Flip through panels in a panel stack

Select attribute elements to display in a grid or a graph

Select metrics to display in a grid or a graph

All of the above

Clicking the Undo button

Clicking the Re-prompt button

Clicking the Rerun button

Subscriptions are useful for reports or documents that you routinely execute at specific times or for ones that take longer to process

When you subscribe to a report or document, you are requesting that the administrator execute the report or document based on a schedule that you select

You can create your own schedules and then use them to subscribe to reports and documents

My Subscriptions

History List

My Reports

Shared Reports

PDF

Microsoft Word

Microsoft Access

All of the above

Banding

Autostyle

Sorting

It requires MicroStrategy OLAP Services

It enables an indented, hierarchical display of report results

To use Outline mode, a report must be sorted first

Thresholds are visual indicators that certain conditions exist in data

In MicroStrategy Web, you first define the conditions and then format metric values to display in specific ways when those conditions are met

You do not have the option to toggle thresholds on and off

Data Pivoting

Drilling

Banding

Outline Mode

By using a selector, you can determine what data is displayed in grid or graph reports in the document or which panel of a panel stack is displayed

By using the Quick Switch button, you can quickly switch from one document to another

You cannot view the document in Full Screen Mode

View filters limit the actual data that is brought back from the data warehouse

View filters can be saved and reused on other reports

You can only create view filters based on attributes and metrics in the Report Objects window

A report consists of a template, which defines the format and layout, and a filter, which determines the data that is included in the result

A report cannot have an empty filter

You cannot create multiple views of the report

You add a metric from the Report Objects window to the template

You remove an attribute from the Report Objects window

You create a view filter on an attribute in the Report Objects window

You create a metric using two metrics that are in the Report Objects window

They are built using existing metrics already in the Report Objects window

You can save them and re-use them on other reports

Derived metric funtionality is available only if you have MicroStrategy OLAP Services

Nested metric

Shortcut metric

Complex metric

Simple metric

Metrics can be moved only to the rows or columns, not the page-by field

Pivoting enables you to quickly and easily rearrange data so that you can view it from multiple perspectives

Data pivoting requires MicroStrategy OLAP Services

Sorting

Data pivoting

Swap rows and columns

Exporting

Advanced drills enable you to drill to any attribute in any hierarchy

Advanced drills can only be performed using the Drill menu

Advanced drills can only be performed using the Drill panel

Data pivoting

Filter on Selections

Swap rows and columns

Advanced drilling

A view filter is used to display only a subset of the full result set

You can create view filters based on any project object, not just report objects

View filters can contain only one condition

You can define subtotals, which calculate totals at various attribute levels in a report

You can create your own custom subtotals and use them on a report

You can either show the grand total or subtotals but not both on a report

You can save the report as static or prompted

You can choose to keep either the filter or the template as prompted, or both

You cannot keep your current answers as the default answers

You can subscribe to reports and documents and then use the History List to retrieve the results

You cannot add them from the wait page as they are executing

You can add them when you are viewing the result

Resize row and column headers

Enable banding

Lock row and column headers

It enables you to create metrics inside a report that you can use in other reports

It enables you to include attributes and metrics in the Report Objects window without displaying them on the template

It enables you to drill to any object in your project without generating new SQL

They enable you to create your own reports using prompts

They cannot have a report filter

The Report Wizard provides a quick and easy way of creating your own report by selecting from predefined templates and filters

The Report Builder provides a more detailed means for creating your own report. It enables you to select the individual attributes and metrics for the template and to choose the objects and operators that you want to use for the filter qualification

Flash mode

Express mode

Interactive mode

Source Systems

Metadata Database

Data Warehouse

ETL Process

Metric

Attribute

Fact

Hierarchy

This user can create reports from a Predesigned Report and a Prompted Predesigned Report

This user can create reports from a Predesigned Report, Prompted Predesigned Report and from scratch

Can create a Document

Preferences

My Reports

My Subscriptions

True

False

Excel (with or without formatting)

CSV (file format recognized by Excel)

HTML

Plain text

All of the above