1 / 29

MicroStrategy 9.3.1

MicroStrategy 9.3.1. Visual Insight Big Data Data Import MicroStrategy Web Administration. 1. MicroStrategy 9.3.1. Visual Insight Big Data Data Import MicroStrategy Web Administration. Visual Insight New Naming Convention – VI ‘Analysis’ Objects Are Called ‘Dashboards’. 9.3.

quilla
Download Presentation

MicroStrategy 9.3.1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration 1

  2. MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration

  3. Visual Insight New Naming Convention – VI ‘Analysis’ Objects Are Called ‘Dashboards’ 9.3 9.3.1 New Icon Renamed Menu New Analysis Web CreateDashboard Web Create Analysis Renamed Privileges Web Save Dashboard Web Save Analysis Web Edit Dashboard Web Visual Insight Web Run Dashboard* Execute Analysis or Document (Runs VI Dashboards only) Web Run Document* (Runs RS documents only) Note:VI dashboards and Report Services dashboards are different types of metadata objects

  4. Visual Insight Modern Look and Feel To the Interface Presentation Mode Share Undo-Redo New Icons

  5. Visual Insight ‘Presentation Mode’ Enhances the Look and Feel of Visual Insight Dashboards Open VI Dashboards in Full Screen Mode with One Click! New Button

  6. Visual Insight Quickly Share Visual Insight Dashboards with Peers and Colleagues New Button Set ACLs Email Link Show Link Embed iFrame in HTML

  7. Visual Insight Graph Matrix Widget Axis Scale Formatting Options New Theme • Set a custom minimum and maximum value for each metric or for all metrics • New options to show/hide borders, change legend position, resize legend, show/hide data labels • Option of dark theme in widget

  8. MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration

  9. Big DataSupport for Amazon Redshift MapReduce Databases 9.3.1 Columnar Databases Exadata Higher Scale DataWarehouse Appliances HANA Relational Databases Lower Scale Multidimensional Databases User / Departmental Data Analysis Services

  10. Big DataOther Enhancements Set Preferred Order of DB Instance For SQL engine to evaluate in a multi-source scenario, at project level SAP HANA Input Parameter Support “Parameters” tab links SAP input parameters to their corresponding prompts.

  11. Big DataDeploy R Analytics as MicroStrategy Metrics • Open Source • One-time Install • Execute R Scripts One Time Import: RScript Functions MicroStrategy Intelligence Server Install • No Visual Studio • No Compiling • No Schema Updates M E T A D A T A Query Engine • MicroStrategy Data • Results from R • Delivered to any Touchpoint Inputs Outputs Data Sources

  12. MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration

  13. Data ImportIntuitive, User Friendly HTML5 Interface Easy Management of Stored Data New Icons Note: ‘File’ and ‘Salesforce’ imports are still Flash-based

  14. Data ImportVisually Construct Queries With Import from Database New Import from Database HTML5 Interface Import Data from Database Demo

  15. Data ImportExpanded Freeform Scripting Write Freeform Queries inHTML5 Interface Against HADOOP, Web-Services and Relational Data Sources

  16. MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration

  17. MicroStrategy WebModern, Fresh, Easy to Use Web Interface New Icons, Better Layout and Improved Usability Prominent Button to Design VI Dashboards Immediately One-Click Access To Folders and Actions

  18. MicroStrategy WebMetric Creation from MicroStrategy Web Interface Visually Create a Metric with Function Editor Or… 1. Expression 2. Level of Aggregation 3. Conditionality 4. Transformation

  19. MicroStrategy WebMetric Creation from MicroStrategy Web Interface .... Use Formula Editor For Manually Entry Function Picker Metadata Object Selector Formula Text Box Validate VLDB, Subtotals etc. Formatting

  20. MicroStrategy WebExpanded Library of Graphs to Reveal Business Insights Lipstick Graph Overlapping Bar Graph Waterfall Graphs

  21. MicroStrategy WebMultiple Datasets on One Map (only DHTML Mode in Report Services Documents) Dataset #1(Bubble Markers) Dataset #2(Push Pins)

  22. MicroStrategy WebDerived Elements New Derived Elements Editor in Web Users can now edit stand alone derived elements in Web from within reports and documents To access Derived Elements editor run a report with underlying attribute > RMC > select “Derived Elements” > open a Derived Element “Save As…” functionality and ability to overwrite definition of existing derived element

  23. MicroStrategy WebReport Condition Selectors How to Create a Report Condition Selector Report Condition Selector • Filtering performed on dataset • Re-execute dataset against warehouse or cube to get new data

  24. MicroStrategy WebInformation Window for Selectors, Text Fields, Images, and Buttons Info Window onSelectors Info Window onButtons

  25. MicroStrategy WebAdditional Enhancements Save Button* Copy/Paste Data Share Document URL* Hide/Show Nulls/Zeros • Clicking “Save” to save the Report Services document without closing out of it • Users now have the ability to copy data from a grid report or grid on document with the native command (CTRL+C) • Users can now email or copy a link to a report or Report Services document. Users can also copy HTML. • Ability to show or hide nulls and zeros in grid. Toggle available in Data toolbar or dropdown menu *Also available in MicroStrategy Visual Insight

  26. MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration

  27. AdministrationSystem Manager Ensures Consistency, Improves Reliability & Codifies Tacit Knowledge Incorporate MicroStrategy Administrative Processes Include non-MicroStrategy Processes Build Workflows With Programmatic Elements New New Zip Files Upload with FTP Launch/Terminate Amazon Cloud Instances Manage VMWare VMs and VApps Copy/Delete/Move Files Find/Replace File Content Unzip files Download With FTP Execute Application Execute SQL Send Email Create HIVE DSNs Create Package Command Manager Object Manager Integrity Manager Configuration Wizard Project Merge Project Duplicate Project Mover Server Status Installation Connectivity Wizard Wildcard support Runtime Update of Parameters from File or Registry Decisions to control true/false process status Define global System Manager Parameters Update Parameters Loops to Process Multiple iterations Name Nodes and Add Comments Split/Merge Execution Pause New New New New $(x) Node System Manager Ensures Consistency, Improves Reliability, & Codifies Tacit Knowledge

  28. AdministrationOther Enhancements MicroStrategy System Manager • ‘Email’ process. • CC and BCC support • Port Number and login/password for emails sent via SMTP server • ‘Download with FTP’ process • Secure FTP and Port Number support MicroStrategy Command Manager • Support for Incremental Refresh Reports • Purge or Enable Change Journals • Import Update Packages that are not local to Intelligence Server • Cube and Cache manipulations

  29. MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration 29

More Related