Describe the Desktop tool in terms of the Designer and Analyst components
Designer: Enables complex report and document development | Analyst: Simplified version providing interactivity; slice & dice capabilities
Describe the Desktop tool in terms of the Architect component
Facilitates data mapping from the DW. It's an abstraction layer that translates operational data into familiar business terms
Describe the Desktop tool in terms of the Administration component
Enables user management, security, Iserver configurations
What does the metadata database do in terms of the MSTR architecture?
Contains info that facilitates data retrieval from the DW; stores MSTR object definitions and info about the DW; maps MSTR objects to the DW structures and content; Used to translate user requests to SQL; Stores definitions of all MSTR objects; enables sharing of objects
What does the ETL process do in terms of the MSTR framework?
Stores info about the the source system structure and content; Stores info about the DW structure and content; Stores info about the source system structure and content to the DW; Provides info to extraction tools that execute the transfer of data from the source to the DW
What are the qualities of an OLAP system with regards to Organization of Data; Data Retention; Data Integration; Data Storage; Usage?
Org: by dimension and business subject; Retention: long term (2-5 yrs); Integration: High, per the ETL process; Storage: TBs; Usage: Batch load, Reporting Read-only. spiked usage during DW loads
What are the qualities of an OLTP system with regards to Organization of Data; Data Retention; Data Integration; Data Storage; Usage?
Org: By workflow per application; Retention: short term (2-6 months); Integration: minimal/none; Storage: GBs; Usage: Realtime, write/update, evenly distributed usage, transactional data
The MSTR BI Architecture is comprised of which components?
Source system; Data Warehouse; ETL process; Metadata database; MSTR applications
What does the History Project Icon represent?
Use to retrieve scheduled reports. Only available if using Iserver.
What does the My Personal Object Project Icon represent?
Use to store objects that I create, and that are only visible to me. Can create add'l subfolders here.
What does the Public Objects Project Icon represent?
Contains objects that can be viewed by all users depending on permissions/privileges. Contains many subfolders that are organized by type.
What does the Schema Objects Project Icon represent?
Contains objects that represent the business data model such as facts, attributes, and hierarchies.
What does the Data Explorer Project Icon represent?
A browsing tool that contains hierarchies enabling you to navigate the warehouse data and relationships for the project.
What is the Shortcut Bar?
It contains shortcuts to various folders and MSTR functionality.
What are the 3 types of MSTR objects you can create in Desktop?