Posts

Featured Post

MicroStrategy 10.2 is now available GA

MicroStrategy has released 10.2 version & it is available now on Download site

Short Summary


As every tool has its own pros and cons with every release of product - the same behavior was seen by end customers upon upgrade to MSTR 10.1 especially which removed FLASH/Interactive Mode & kept as deprecated modes caused concerns with users & other memory issues on server side with enterprise edition, development error pop ups that was arising in web (primary), hyperlinking from 9.4.1 to 10.1 , special characters issue, app crash on mobile with calendar selector or multiple clicks within dashboard the app crashes.. etc..So, to resolve these defects - MSTR has released 10.2 

Release Highlights
General workflow and stability enhancementsEnterprise Manager is now independent from Operations Manager and HealthAgentDynamic dates in Desktop/VIQuickly import custom visualizations created using the MicroStrategy Developer Library (MSDL) in DesktopMobile iOS and Android usability improvemen…

How to uninstall MicroStrategy Analytics Enterprise using the Uninstallation Cleanup Utility

Content SUMMARY This document describes how to uninstall MicroStrategy 9.x and 10.x  on Microsoft Windows using the Uninstallation Cleanup Utility.  The Uninstallation Cleanup Utility can be downloaded from the attachment at the bottom of this tech note.
CONSIDERATIONS/GUIDELINES: This Uninstallation Cleanup Utility is designed to remove the obsolete or leftover services, files and registries after uninstalling MicroStrategy products. The goal of this cleanup utility is to remove the leftover files and registries after uninstallation to make the machine "cleaner" for a second time installation (it can solve some known downgrade installation issues). The basic assumption for removing files is that the user installed MicroStrategy in a path that contains the string "MicroStrategy". If not, the files and certain registry keys will not be removed.Using the cleanup utility incorrectly can cause system-wide problems that may require re-installation of the Operating System. …

BI Scorecard 2014 Analysis

Image
I agree with below analysis that was shared by BIScorecard




More info can be found in the below link PDF
Happy Reading!


Vels View On MicroStrategy World 2017 - Washington D.C.

I would like to share my learnings from the MSTR World 2017 – which happened last week at Washington D.C. Attached PDF is an complete story of 2017 MSTR World – which I attended it first time and enjoyed it. Detailed one – but you’ll like it J Few Highlights: Ø Dossier & Workstation is going to be BI Revolutionary (BOOK like concept J - if you like reading books – technically, I would say counterpart to STORY telling in Tableau is referenced with BOOKS in MSTR J - Cool idea of implementation though) Ø BI Tool comparison across various parameters such as Enterprise, Mobility, Embedded Analytics, IoT etc., with Qlikview, Tableau, BOBJ & Cognos (few analysis points are valid from my experience of working with other tools) Ø New community site was launched with moderators and curators tagged for each section Ø Power of Real Time & Telemetry Analytics using MicroStrategy Usher Ø Profit/Loss comparison of MSTR vs 

TN318146: Memory limitations for In-Memory Data Import in MicroStrategy Analytics Desktop 10.x

QUESTION: Are there any memory limitations for MicroStrategy Analytics Desktop 10.x when doing In-Memory Data Import?
ANSWER: The amount of data that MicroStrategy Analytics Desktop 10.x can handle will depend directly on the machines resources where Desktop is running.  More specifically, the amount of RAM the machine has available when the intelligent cube gets created during In-Memory Data Import.

NOTE: There is an inherent limit specific to importing Excel files due to using an internal Java component to extract the data from Excel files.  It is recommended that the Excel file size should not exceed 1GB as the java heap size of the JVM is configured to be 1GB.

TN318146: Memory limitations for In-Memory Data Import in MicroStrategy Analytics Desktop 10.x

MicroStrategy | TN319499: MicroStrategy Intelligence Server 10.6 fails to start on Windows 10 with Feature Pack 1607 "Anniversary Update"

Image
SYMPTOM When attempting to start MicroStrategy Intelligence Server 10.6 on Windows 10 machines that include Feature Pack 1607, the "Anniversary Update", the following error is displayed as soon as the service is attempted to be started:
Windows cloud not start the MicroStrategy Intelligence Server service on Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion

Upon checking Windows Event Viewer, a more detailed message can be seen, linking the failure to the dynamic library SHSMP64.dll:
Application Error Faulting application name: MSTRSvr2_64.exe, version: 10.6.34.38, time stamp: 0x5850b457 Faulting module name: SHSMP64.dll, version: 9.0.2.1, time stamp: 0x57e9f987 Exception code: 0xc0000005 Fault offset: 0x0000000000003574 Faulting process id: 0x363c Faulting application start time: 0x01d259f60b719146 Faulting application path: C:\Program Files (x86)\MicroStrategy\Intelligence Server\MSTRSvr2_64.exe Faulting module path…

MicroStrategy | How to use the Portable Documents feature in MicroStrategy Desktop 9.x

Image
Starting in MicroStrategy Desktop 9.0.2, the Portable Documents feature can be used to export a Report Services document template and import it into blank documents. This feature is particularly useful for recreating documents that have object corruption without having to manually recreate the formatting on a new document. 
Exporting the Document Template:
More than one Report Service documents can be chosen when creating the template.Export Report Service document template will create a package in the source project.
Importing the Document Template:
All  datasets and their components will show in the Source Document Template section.Objects(Attribute forms, Metrics) can be mapped in the Replace With section.Import document template will import the package to the destination project.

MicroStrategy | How to export Project Configuration Settings in a readable manner.

Image
In some business scenarios, it is required to export the current Project Configuration Settings as a backup file. And the file needs to be clear and readable. This tech note shares two methods to accomplish this.
SOLUTION 1:
Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. Connect to MicroStrategy Analytics Modules in Command Manager;Run the following script:LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial"; Right mouse click on Results Pane -> Results -> To Text; Copy and paste the results into a .txt file.SOLUTION 2: Repeat steps 1 and 2 in the first solution;Save the script as <script file name.scp>;Run the following script from command line:cmdmgr -n "<Project Source Name>" -u <Login> -p "<Password>" -f "<the location of the script file>" -or "<output file name>.txt"

Take Tutorial Project for example, the script ca…