MicroStrategy 9 - Technological Breakthroughs

Hi All,

Today i'm posting some Technical Breakthroughs in Microstrategy 9.

MicroStrategy 9 is breakthrough technology that, for the first time, allows companies to support all levels of BI with one technology. MicroStrategy 9 builds on MicroStrategy’s unique strength at the high-end of BI to extend the boundaries of performance, scalability, and efficiency of enterprise BI. At the same time, MicroStrategy 9 brings that same enterprise-caliber BI technology easily within reach of smaller departmental BI initiatives. Just as importantly, MicroStrategy 9 provides a uniquely smooth migration path for islands of departmental BI to merge into a cohesive and consistent enterprise-wide framework. With MicroStrategy 9, even as departmental BI applications are consolidated into the enterprise-wide framework, the departments can continue to retain significant autonomy and nimbleness that they enjoyed previously as an island of BI.

MicroStrategy 9:  Technological Breakthroughs

MicroStrategy 9 features over 8,000 new enhancements that build upon the already world-class architecture and usability of the platform. The MicroStrategy 9 platform consists of the following products:

MicroStrategy Intelligence Server

 An industrial-strength analytical server optimized for enterprise querying, reporting, and OLAP analysis.

MicroStrategy Report Services

An extension to MicroStrategy Intelligence Server, MicroStrategy’s enterprise reporting engine delivers the full range of report formats, including scorecards and dashboards, financial reports, customer invoices and statements, and highly detailed operational reports.

MicroStrategy OLAP Services 

An extension to MicroStrategy Intelligence Server, OLAP Services enables MicroStrategy Web, Office, and Desktop users to perform intuitive OLAP analysis with Intelligent Cubes.

MicroStrategy Distribution Services

An extension to MicroStrategy Intelligence Server, Distribution Services enables high volume, managed report distribution through e-mail, printers, and file systems on a scheduled basis.

MicroStrategy MultiSource Option

An extension to MicroStrategy Intelligence Server, MultiSource Option enables users to

seamlessly report, analyze, and monitor data across multiple data sources through a single

business model.

MicroStrategy Web

 An interactive environment for reporting and analysis through an all-HTML and zero-footprint Web client

MicroStrategy Office

Delivers the full power and sophistication of the MicroStrategy industrial-strength business

Intelligence platform to the Microsoft Office Productivity suite

MicroStrategy Mobile

 An interactive user interface for monitoring, reporting, and analysis for BlackBerry devices

MicroStrategy Desktop

 Provides an integrated development, administration, and run-time business intelligence

environment on the personal computing desktop

MicroStrategy Architect

 A rapid development tool that maps the physical structure of the data warehouse into a logical business model

MicroStrategy Object Manager

Manages business intelligence applications between development, testing, and production

Systems

MicroStrategy Command Manager

Enables the creation and execution of test-based commands from a command line and a

graphical interface

MicroStrategy Enterprise Manager

A monitoring tool that provides usage and resource information about the business

intelligence environment

MicroStrategy Integrity Manager

A report comparison tool that provides automated information integrity assurance and

regression analysis

MicroStrategy SDK

Exposes the functionality of the MicroStrategy architecture via an open API for customization of the Web interface and integration with third-party applications

MicroStrategy Clustering Option

An extension to MicroStrategy Intelligence Server, Clustering Option adds load-balancing and fault-tolerance to mission-critical MicroStrategy BI implementations.

The following list contains 50+ technological breakthroughs, which is a small cross-section of the over 8,000 enhancements available in MicroStrategy 9. These features are each specifically designed to support all levels of BI.

Major architectural changes and new products in MicroStrategy 9:

1. MicroStrategy MultiSource Option – With MultiSource Option, business users can surf-and-save across multiple databases and seamlessly access data from any source. Completely transparent to both end users and report designers, MultiSource Option enables a unified model of an organization’s data that spans the many individual data warehouses, marts, and departmental databases within the BI environment. Any user can create and analyze reports and dashboards that contain data from any and all sources in the enterprise.

2. MicroStrategy OLAP Services and In-Memory Capabilities – MicroStrategy OLAP Services provides the enhanced Intelligent Cube, a dynamic in-memory cache that leverages the strength of the MicroStrategy Intelligence Server Security and Personalization Engines, and provides analytical flexibility by leveraging the MicroStrategy Intelligence Server Analytical Engine. Users can analyze the full depth and breadth of their data warehouse with OLAP Services, since no limits are set on data scalability, analytical scope, or drill-through capability. In-memory operation delivers faster overall performance, improves performance for the most time-consuming queries (from hours to seconds), and shifts the load onto the database, freeing up database capacity.

3. MicroStrategy Distribution Services – Distribution Services provides high-volume, automated distribution of reports, documents, dashboards, and business performance alerts via e-mail, file servers, and networked printers. Distribution Services enables greater user self-service for all report distribution and business monitoring needs, reducing reliance on IT.

More BI / Less IT Effort: Enhanced Web Interactivity

4. More User-friendly Web Interface – A re-designed Web user interface that leverages many familiar, user-friendly paradigms, including folder-tree navigation, ribbon toolbars, accordion controls, control-click multi-select capabilities, and context-sensitive right-click actions.

5. Prompt and Filter Creation – Create stand-alone, reusable prompt and filter objects directly from Web, using intuitive interfaces.

6. Multi-select Filtering and Drilling – Select individual rows and columns on a grid to quickly and easily format, drill, pivot, and perform other tasks on-the-fly.

7. Threshold Creation – Quickly apply predefined thresholds, such as the top 5% performing products, or define your own detailed thresholds and conditional formatting using new editors.

8. Flash Content in DHTML – Display and interact with Flash content, such as widgets or flash-enabled selectors, in Interactive, View, or Flash modes.

9. Full Function Library – Instantly create complex derived metrics using the Function Wizard, which includes a documented library of functions available for any calculation imaginable.

10. Complete Subtotal Control – Calculate the exact subtotals you need for reports using an improved Subtotal Editor that enables the definition of more advanced subtotals.

11. L ink Editor – Easily define connections between one report or document and another report or document while passing parameters to answer any prompts in the target object.

12. 64-bit Web Server Support – Maintain far more concurrent user sessions and run much larger reports, all within the same server. This is achieved via full support for 64-bit Java Virtual Machines (JVMs) in both J2EE Web servers as well as ASP.net Web Servers. The expanded memory available in 64-bit JVMs allows for optimal Web performance across the enterprise.

13. Extreme AJAX Code Structures – Leverage a re-engineered Web server that adheres to an “Extreme AJAX” model, delivering a much more responsive, interactive Web experience for business users. In Extreme AJAX, processing is shifted from the Web server to the Web browser, freeing up Web servers so they can support additional user sessions.

With Extreme AJAX, MicroStrategy Web supports more users with faster performance using the same Web servers, resulting in a lower cost of departmental and enterprise BI.

More BI / Less IT Effort: Enhanced Dashboard and Enterprise Reporting

14. Out-of-the-Box Statement Printing – New Report Services features allow business users to develop complex enterprise reporting and customer statements, without programming, through flexible, automatic formatting features, such as horizontal repeating sections, dynamically-selected images, vertical text layout, multi-layout reports, automatic table of contents generation, automatic pagination, and watermarks.

15. Multi-layout Documents – Combine frequently-used dashboards into a single convenient “dashboard book” that can be run once and quickly referenced throughout the day. Or, include multiple document layouts in a single document to simply provide an integrated view of business data.

16. H TML Containers – Add depth and perspective to your dashboards by incorporating live Web content such as stock tickers and real-time feeds.

17. Dashboard Templates – Create or use out-of-the-box dashboard templates to decrease document design time. A dashboard template is a predefined structure that can contain data sets, layouts, and controls, such as titles, panels, and panel stacks.

18. Instant Document Creation from Reports – Instantly create a document or dashboard from an existing report, which is displayed as a Grid/Graph on the document.

19. Document Autostyles – Employ a varied collection of new autostyles to quickly apply a set of fonts and colors to an existing dashboard.

20. Dashboard Drilling – Perform OLAP manipulations, such as drilling, directly on grids and graphs contained within dashboards.

21. L inked Formatting – Link a Grid/Graph to the original report by adding it to the document as a shortcut. Any changes made to a report, such as formatting a metric or changing the graph type, are passed to the Grid/Graph in the document.

More BI / Less Effort: Enhanced Business User Self-Service

22. Streamlined Report Design for Business Users – Assemble reports more quickly and easily via intuitive, self-service features, such as the simplified browsing of available dimensions, attributes, and metrics; drop zones that provide visual cues to users as to where to drag-and-drop these building blocks; and a formatting control for report formatting that is intuitive to Microsoft Office users.

23. New Graph Report Designer – Interactively build graph reports with dozens of visualization options using a new and intuitive graph design tool that makes it easier for designers to visualize the final output of their graphs. Drag-and drop elements into metrics, categories, and series zones; use right-click options to quickly format graph elements; and quickly apply a variety of colors and styles to graphs.

24. Derived Elements – A new feature of MicroStrategy OLAP Services that can be used to enhance the analysis on Intelligent Cube reports and Report Service documents. Elements of an attribute can be combined on-the-fly to create and save reusable filters, groups, lists, and calculations.

25. Collaboration and Notes – Add notes and comments to reports and documents to provide instructions to other users, share information, and more. Every report and document can maintain and display a set of notes, with details on who left the note and when.

26. Personalized Prompt Answers – Store personalized answers for a prompt and reuse them wherever the prompt is present, saving time and ensuring efficient prompt handling while running documents and reports.

27. New, Faster Prompt Interface – More user friendly and responsive prompt interface, delivering vastly improved performance for both the display and use of prompts.

28. Complete OLAP Analysis – Freely investigate data and “surf” through the data warehouse without having to design a new report for each new combination of data you want to see. Perform OLAP manipulations, such as pivoting and drilling, directly on graph reports.

29. Create and Edit MicroStrategy Reports and Documents in Microsoft Excel, PowerPoint, and Word with MicroStrategy Office – Edit and create reports and documents directly from MicroStrategy Office, through a seamless integration with MicroStrategy Web.

More BI / Less Effort: Improved Analytical Capabilities

30. New, Improved Widgets – Analyze and control advanced visualizations such as the Heat Map widget in new, innovative ways.

31. Greater Range of Analytics – Leverage a wide range of new data mining algorithms; statistical, predictive, and OLAP functions; as well as improved metric grouping capabilities. Integrate with these analytics to develop complex statistical calculations, more effective forecasting metrics, and many different forecast models for the same metrics.

32. Report directly against Salesforce.com – Available as part of MicroStrategy MultiSource Option, a Salesforce.com ODBC driver allows users to seamlessly create and run BI reports and dashboards using Salesforce.com data.

Global Applications and Distributed Operations

33. Multi-lingual Metadata and Data – Deploy a single project in multiple languages, ensuring that employees and customers all over the world can always access essential business information in their own language. Business users can view MicroStrategy interfaces, as well as their own reports, metrics, attributes, and data in their own language, enabling more convenient and collaborative analysis across the enterprise.

34. Repository Translation Wizard – A component of MicroStrategy Object Manager, the Repository Translation Wizard facilitates the translation of metadata objects by copying the object strings into a translation repository to assist with the translation process.

35. Update Packages – Available in MicroStrategy Object Manager, Update Packages enable multiple and independent development teams to coordinate the inclusion of their new developments into the global operational BI system. Each development team can independently submit updates, additions, and changes to an existing operational system. The new Update Packages are then used to incrementally install each team’s updates and reconcile all overlaps or conflicts that might arise.

36. Distributed Administration – A new administrative capability that allows the sub-setting of administrative duties and the distribution of administrative responsibilities to business units and departments. This enables central IT groups to relinquish routine administrative duties, such as user administration, project administration, and user security administration, to other administrators in the system.

37. Web-based Administration – Administrators can create, modify, and manage users, groups, and security roles from MicroStrategy Web, allowing them to manage the BI system from anywhere, at any time.

Time-to-Value: Rapid Project Design

38. Graphical Architect – A new version of MicroStrategy Architect that allows users to map their business model into a MicroStrategy metadata from a single interface that can be used to build metadata objects through simple drag-and drop and right-click operations. MicroStrategy Graphical Architect streamlines the project modeling experience, making it interactive and visual, thereby drastically reducing the time required to build and deploy complex project models.

39. Cube Advisor – A new tool that allows users to create and support a dynamic sourcing strategy that can best support the reports in their projects. Cube Advisor helps achieve this by analyzing reports to determine if their report definitions can support the use of dynamic sourcing, and recommending and creating Intelligent Cubes that can provide data to reports using dynamic sourcing.

Lowest Total Cost of Ownership: Administration and Performance

40. Support for 64-bit Windows – MicroStrategy Intelligence Server, and its integrated technologies (OLAP Services, Report Services, Distribution Services), are now supported on the Microsoft Windows 64-bit Operating System.

41. SQL Engine Optimization – A new level of SQL optimization designed to improve performance by eliminating unnecessary SQL passes and optimizing multi-pass SQL generation. This delivers the fastest report performance at all times, at any scale, to all business users in the enterprise.

42. Change Journaling – A new change journaling feature in MicroStrategy Object Manager, designed to track and audit changes made to any metadata object in the BI system. This is a major feature of object versioning that will ensure that companies successfully complete audits and remain Sarbanes-Oxley compliant.

43. Security Enhancements – Ensure enterprise-wide data security and login flexibility via improved password strength requirements, encryption, and out-of-the-box single sign-on capabilities, supporting Microsoft Active Directory (LDAP and Kerberos), Tivoli, and SiteMinder. The enhanced security integration significantly speeds up user configuration.

44. Intelligent Clustering – Improved job distribution and Intelligence Server clustering delivers higher throughput, better asset utilization, and enhanced system performance. Scheduled jobs can now be shared across clustered Intelligence Servers and are distributed by job load.

45. Improved Caching – Experience minimal report and document wait times as a result of a new, automatic report caching level and the caching of Report Services documents in their final formatted output, including PDF, Excel, XML, CSV, and HTML.

46. Flexible History List Management – Store History List messages, along with their entire caches, in a database, as opposed to a file system. This flexibility improves the reliability of retrieving the messages and data, and also improves scalability since there can be an “infinite” storage of history lists in the database.

47. Improved Enterprise Manager – Take advantage of new operating system performance counters, and report on In-Memory ROLAP cube usage, Distribution Services, and prompt answer statistics.

48. Improved Command Manager – Command Manager now runs on all supported platforms, and includes new Java programming capabilities, including conditions, loops, and variables. Where no graphical user interface is available, Command Manager’s new text-based interface allows script creation and execution. New procedures allowing for the creation of custom extensions and a large number of usability enhancements result in a rapid script development experience.

49. Improved Integrity Manager – Take advantage of the improved prompt resolution functionality in Integrity Manager by prioritizing prompt resolution strategies or specifying report-level prompt answers to be used in each Integrity Manager test. Integrity Manager also enhances integrity testing by comparing the PDF output of reports and documents.

Lowest Total Cost of Ownership: Easily Extend Your MicroStrategy BI to More People

50. Portlet-to-portlet Communication – Portal Integration is available out-of-the-box and included free with every Web server. Integrate your BI easily with Microsoft SharePoint, SAP NetWeaver Portal, Oracle WebLogic, and IBM Websphere. Portal integration enables greater user scale and easier user adoption for your business intelligence using your existing enterprise portals.

51. P lug-in Architecture – The Customization Upgrade Wizard facilitates the management of customizations by creating portable pieces of software, called plug-ins. These plug-ins can be easily installed and deployed in MicroStrategy Web, so that compilation or modification of the source code is no longer required. Sample applications such as the External Security Sample Application are now available as plug-ins.

52. Improved Composite Applications and Mash-Ups – Improved integration with Adobe Flex 3 and Adobe’s Air Engine eases the development of fully-functional and fully-disconnected flash-based applications that can download and store all necessary data, but run on the desktop without any Web connectivity.

53. Eclipse READY Web Configuration Editor – Organize, streamline, and simplify customizations in MicroStrategy Web. Eliminate the need to manually modify default configuration files such as the Page Configuration file, the Style Catalog Configuration file, or presentation files such as JSP or ASP.NET files.

54. Integration with FlexBuilder IDE – Create a variety of Adobe Flash-based RIA Applications, Adobe AIR applications, and more, via a tight MicroStrategy integration with Adobe Flex.