WIXLIB

Tips and Techniques on how to betterMonitor, Manage and Optimize yourMicroStrategy SystemInfoCeptsHigh ROI DW and BI Solutions'LJLWDOO\ VLJQHG E\ ,QIR&HSWV'1 FQ ,QIR&HSWV JQ ,QIR&HSWV F 8QLWHG 6WDWHV O 86 R ,QIR&HSWV RX ,QIR&HSWV H LQIR#LQIRFHSWV FRP5HDVRQ , DP WKH DXWKRU RI WKLV GRFXPHQW/RFDWLRQ 'DWH By: InfoCeptsJan 2013

Brief Overview of InfoCeptsHigh ROI DW and BI Solutions

Helping Our Customers Derive Value from Their Data since 2004 High quality global delivery model withsavings of up to 40% Founded and led by ex-MicroStrategists 350 people devoted to delivering BI, DWand Integration Solutions 355250We have one of the largest Global pools ofMicroStrategy Consultants167 8 years of growth driven largely by referralsand increasing levels of responsibility11171Focus on culture and excellence2008High ROI DW and BI Solutions2009201020112012

Our ServicesData ManagementBI Strategic ServicesBI Application Development& Management Enterprise Information Business AnalyticsStrategy and Planning Text AnalyticsBI Metrics Predictive AnalyticsManagement BI ApplicationData Governance &Stewardship Data Quality Data Integration Unstructured DataIntegration BI Centers ofExcellence ProgramCustomization Administration and Metadata ManagementTechnology – Managed Master DataServicesManagement Data Analysis Data DesignHigh ROI DW and BI Solutions Program/ProjectManagement

Our Capabilities Span across Industries and TechnologiesTechnologiesBIMicroStrategy, IBM Cognos, Microsoft BI, Pentaho, TIBCO Spotfire,Tableau, OBIEEData IntegrationInformatica, SQL Scripts, Microsoft SSIS, Oracle Data Integrator, TalendDatabasesOracle, Microsoft SQL Server, IBM Netezza, Teradata, DB2,Greenplum, AsterData, Vertica, Par Accel, My SQL, PostgreSQL,EssbaseCustomMicroStrategy SDK, Cognos SDK, Java, .NET, Flex, Objective C, YahooYUI, Ext JSBig DataHadoop, Hive, Map-Reduce, Cloudera, Riak, Apache Flume, CassandraSpecializedTIBCO ActiveMatrix BusinessWorks, SPSS, Clarabridge Text MiningPlatform, Rapid Miner, Rapid Analytics, CEP Platform DroolIndustriesRetail, Banking and Financial Services, Online Media, Telecom, Pharmaceuticals,Hospitality, Healthcare, EducationHigh ROI DW and BI Solutions

Our Solution Programs BI Application Support & Optimization Mobile Application Design and Development Dashboard and Data Visualization Custom BI Development Big Data Data Quality BI Testing BI Application Migration to CloudHigh ROI DW and BI Solutions

Mobile App SnapshotHigh ROI DW and BI Solutions

Mobile App SnapshotHigh ROI DW and BI Solutions

Mobile App SnapshotHigh ROI DW and BI Solutions

Our MicroStrategy Mobile App Development ProgramHigh ROI DW and BI Solutions Mobile App Requirements Questionnaire App Storyboarding Guidelines Mobile App Design Templates Mobile App Design Guide App Development Checklist Test Case Document Mobile Configuration and DeploymentGuide

Our Application Management and Optimization (AMnO) ProgramHigh ROI DW and BI Solutions

Tips and Techniques on how to betterMonitor, Manage and Optimize yourMicroStrategy SystemHigh ROI DW and BI Solutions

What are the important issues faced in managing MicroStrategyenvironment?Why do myreports getdelayed?Why has my reportperformance gonedown?How are mylicenses beingused?High ROI DW and BI SolutionsAre myMicroStrategyreports secure?Object Migrationtakes away a lot ofmy time!Has TestingAutomation helpedme enough?

“My Critical Reports are Often Late!!”High ROI DW and BI Solutions

# 1 Intelligence Sever or Narrowcast Server runningout of memory at the time of report executionAvg. memoryrequired toexecute criticalreportsPerformance CounterHigh ROI DW and BI SolutionsRequired Memory Current Memory?Reports GettingDelayedPro-active alert toAdministrator forfreeing up memoryNotification e-mail

# 1 Intelligence Sever or Narrowcast Server runningout of memory at the time of report executionHigh ROI DW and BI SolutionsReports GettingDelayed

# 2 Delay in ETL Batch LoadAvg. ETL Batchexecution timeusing ETL toolstatistics DBFree form SQL reportHigh ROI DW and BI SolutionsCurrent Execution Time Avg. Execution Time?Reports GettingDelayedPro-active alert toAdministrator on thepossible delayNotification e-mail

# 2 Delay in ETL Batch LoadHigh ROI DW and BI SolutionsReports GettingDelayed

“Report Performance DegradationOver Time”High ROI DW and BI Solutions

#1 Unwanted Cross Joins in a reportEnable “Report Job SQL”Statistics DBAre there reportswith cross joins?Send the list todevelopers to review thenecessity of cross joinsRemove unwanted crossjoinsHigh ROI DW and BI Solutionse-mailnotificationReport PerformanceDegradation

#2 Fact table is referred more than once in a SQLPassEnable “Report Job SQL”Statistics DBAre there reportswith Fact Table count ina SQL pass 1?Identify and share thereports with DevelopersModify wherever possibleHigh ROI DW and BI Solutionse-mailnotificationReport PerformanceDegradation

#3 Too much processing on Intelligence Server toexecute a reportTotal Report Execution TimeDatabaseTotal Report Execution TimeAnalytical EngineDatabaseCan also be done using Enterprise ManagerFor Expensive Reports Identify reports for which –% Analytical Engine Time Defined Threshold Notify Developers to optimize, wherever possibleHigh ROI DW and BI SolutionsReport PerformanceDegradationAE

“Inefficient Object Migration”High ROI DW and BI Solutions

Manual Object migrations across environments Developers/Leads create ObjectMigration Package using MicroStrategyObject Manager Create a folder where all the migrationpackages will be uploaded Create a File Watcher script whichchecks if new file is uploaded When a new file is detected, object ismigrated to the new environment Send notification of task completion orfailureHigh ROI DW and BI SolutionsInefficient ObjectMigration

!Questions / Comments ?High ROI DW and BI Solutions!

“Security Breach in MicroStrategy ”High ROI DW and BI Solutions

#1 Duplicate Attributes in a projectSecurity Breach Consider an example of Regional Sales ReportsRegionRegional Manager East Region EastRegionRegion1Regional Manager East Region EastLocation East, West, North South Check if duplicate attribute definition exist using a Command ManagerScript Remove, if unauthorized duplicate attributes existHigh ROI DW and BI Solutions

#2 Use of Pre – Post SQL VLDB Settings ofMicroStrategy28 Use command managerscript to get list of reportswhere VLDB setting – PrePost Statement property isused Get SQL of the these reportsusing Integrity Manager Remove unauthorized Pre –Post statementsHigh ROI DW and BI SolutionsSecurity Breach

#3 User is able to view reports that he/she is notentitled toProcessFirst time ProjectMigrationSecurity BreachActionEnsure “Everyone” group is notgranted project accessCommandManagerScriptsObject MigrationHigh ROI DW and BI SolutionsEnsure Folder Access Control Listis not undesirably changed bycomparing with Baseline AccessControl List

#4 Multiple user connection request to MicroStrategyServers in Enterprise environmentSecurity Breach Breach of corporate “Password” security policy Monitor the list of distinct IPs for user by executing commandmanager script in Statistics Database Automatically report suspicious activityHigh ROI DW and BI Solutions

“Manual interventions required whileusing Integrity Manager ”High ROI DW and BI Solutions

#1 Manual Test Creation for multiple reports inIntegrity Manager Create Tests using TestGenerator Excel Basic input parameters tocreate a test: Report ListServer Connection DetailsProcessing OptionsOutputMTC file is generatedautomaticallyHigh ROI DW and BI SolutionsIntegrity Manager

#1 Manual Test Creation for multiple reports inIntegrity ManagerUsing Perl ScriptHigh ROI DW and BI Solutions

#2 Manual Creation of Baselines for Critical Reports Integrity Manager Executable Fileis used to run test MTC files toautomatically create baselines Automate the process for multiplereports using batch scriptsHigh ROI DW and BI SolutionsIntegrity Manager

#3 Manual Monitoring of Test Results todetermine errors Write a Batch script to parseIntegrity Manager summary XMLfile Automated mail alert in case ofErroneous Test resultsHigh ROI DW and BI SolutionsIntegrity Manager

“Ineffective License Management”High ROI DW and BI Solutions

Incomplete view of License usage and allocationMicroStrategy License Manager Report Number of Licenses by ProductUsers by ProductHigh ROI DW and BI SolutionsIneffective LicenseManagement

Licence Management - How you would like it to beIneffective LicenseManagementOnly 1 license beingused out of 10INVESTIGATEAdmin and Sales Deptsare Over utilizing –REALLOCATEAll 11 licensesbeing used- PLANUser has notlogged in for amonth - CHECKOver utilizing licences by1 – IMMEDIATE ACTIONHigh ROI DW and BI Solutions

Let’s SummarizeTopicReports Getting DelayedReport PerformanceDegradationObject MigrationTo-do stepsProactively manage memory availabilityNotify if ETL loads are behind schedule Detecting Cross Joins Detecting Multiple Fact Table references in aSQL pass Analytical Engine time optimizationAutomate Object Migration process Detecting Duplicate Attributes Detecting Unauthorized Pre-Post SQLstatements Manage unauthorized access to reports Preventing “password” sharingSecurity BreachAutomate Test creationIntegrity ManagerAutomate Baseline creationAutomate Error DetectionLicense Management39High ROI DW and BI SolutionsLicense Management Dashboard

iManageHigh ROI DW and BI Solutions40

High ROI DW and BI Solutions

High ROI DW and BI Solutions

High ROI DW and BI Solutions

High ROI DW and BI Solutions

High ROI DW and BI Solutions

High ROI DW and BI Solutions

High ROI DW and BI Solutions

Presentation GiveawayGiveaway: Key Metrics for MicroStrategy AdministratorsWill be available on Feb 01, 2013 l free to reach out to us for details of any of the 8High ROI DW and BI Solutions

Thank YouHigh ROI DW and BI Solutions

# 1 Intelligence Sever or Narrowcast Server running out of memory at the time of report execution Avg. memory required to execute critical reports Pro-active alert to Administrator for freeing up memory Performance Counter Notification e-mail Reports Getting Delayed Required Memory Current Memory?