350 likes | 642 Views
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.
E N D
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 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
Visual Insight Modern Look and Feel To the Interface Presentation Mode Share Undo-Redo New Icons
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
Visual Insight Quickly Share Visual Insight Dashboards with Peers and Colleagues New Button Set ACLs Email Link Show Link Embed iFrame in HTML
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
MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration
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
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.
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
MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration
Data ImportIntuitive, User Friendly HTML5 Interface Easy Management of Stored Data New Icons Note: ‘File’ and ‘Salesforce’ imports are still Flash-based
Data ImportVisually Construct Queries With Import from Database New Import from Database HTML5 Interface Import Data from Database Demo
Data ImportExpanded Freeform Scripting Write Freeform Queries inHTML5 Interface Against HADOOP, Web-Services and Relational Data Sources
MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration
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
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
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
MicroStrategy WebExpanded Library of Graphs to Reveal Business Insights Lipstick Graph Overlapping Bar Graph Waterfall Graphs
MicroStrategy WebMultiple Datasets on One Map (only DHTML Mode in Report Services Documents) Dataset #1(Bubble Markers) Dataset #2(Push Pins)
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
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
MicroStrategy WebInformation Window for Selectors, Text Fields, Images, and Buttons Info Window onSelectors Info Window onButtons
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
MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration
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
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
MicroStrategy 9.3.1 Visual Insight Big Data Data Import MicroStrategy Web Administration 29