Multiple Choice (2pts each). Please select the best answer for each of the following questions. There is only ONE correct answer.
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
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