MicroStrategy Training

• Introduction

  MSTR Components 

  • Desktop/Developer,Web Integrity Manager
  • Command Manager
  • Object Manager
  • System Manager
  • Enterprise Manager

  ODBC, DSN creation:

  • Exercise 1: ODBC creation
  • Exercise 2 : DSN creation

  Project creation and adding odbc, dsn

  • Exercise 1: Project creation

  Project level and I-server related settings

  • Exercise 1: Change different project level settings and check their impact on report sql
  • Exercise 2: unload and load project in I-server configuration
  • Exercise 3: Stop , start and restart I-server using service manager

• Getting data into MSTR with warehouse catalogue,
• Updating table Structure,
• adding/changing prefix using WH Catalogue

Exercise 1: Exploring options in WH catalog, writing customised sql to get wanted data

Exercise 2: import/add table prefix   and check it's impact on sql"

• Job Monitor,
• User Manager
• Cache Monitor
• Clustering
• Caching
• Scheduling
• Web Administration and Preferences

Exercise 1: Monitoring jobs and explore all options in job monitor

Exercise 2: Purging and deleting cache for reports, documents and I-cubes

Exercise 3: Create 2 sample users with user manger and assign access to project

• Security filters,
• ACL's

Exercise 1: Create security filer and apply at project/report level

Exercise 2: Create a folder and apply acl's to restrict access to certain users

MicroStrategy User Management-

Subscription Management – Time Triggered & Event Based Subscription

Exercise 1: Create a Security role and apply to users and groups

Migrating objects from one environment to other and their conflicts and dependencies

Exercise 1: Migrate objects using object manager from one environment to other using conflict resolution window

Exercise 2: Migrate objects using object manager from one environment to other using packages

• Outlines,
• user creation,
• cache clear,
• I-server commands and procedures

Exercise 1: Creating multiple users through command manager

Exercise 2: Execute cache clear commands at report, object and element level

Exercise 3: I-server status check, start , stop and restart with commands

Overview and Features discussion

Overview and discussion

Introduction and features discussion