Posts

Microstrategy Workstation scripts to get the quick search results - mstrio Python scripts

 It is Microstrategy Workstation scripts (Python) to get the results from the search object. In the past, this is the usual thing we do in Command Manager.  Lets see a use case to understand this better: List all reports and dashboards in a particular folder and get its details (Report name, Owner, Location, Create date, Mod date, etc).  Usually, we create a search object in Microstrategy and save the search object in a folder. Then we run a command manager script to get the results from the search object.  Here, we will see how to achieve that in Microstrategy Workstation Scripts (Python) Script Logic:  1) Import all packages 2) Establish a connection to Microstrategy project 3) Get the search results in a List object 4) #3 is a complex nested list and nested dictionaries 5) Loop through the nested list and dictionary and construct the path and get owner details 6) Move the results to a data frame 7) Remove unwanted columns from the data frame 8) Add the path and owner details that we

Publish Microstrategy MTDI Super Cube from S3 Parquet file - mstrio Python API

  We need a Python IDE to run this. Currently, some of the Python packages (ex: boto3) are not supported in Microstrategy workstation scripts. So, we can't run this in Microstrategy workstation scripts. Logic:  Install necessary python packages  Import packages (boto3, mstrio, pandas) Establish connection to S3 bucket and read the parquet file Establish connection to Microstrategy Rest server (Library) Create cube We can achieve the same using MSTR Data Import UI. But, in order to connect it to S3 Bucket in MSTR UI, you need "list all buckets" access. In API, we can specify the particular bucket name and parquet file to create this cube. Sample Script: # Install boto3 and mstrio packages. boto3 package is to read files from S3 bucket. mstrio package to connect and create objects in Microstrategy #pip install boto3 #pip install mstrio #Import necessary packages from mstrio.connection import Connection from mstrio.project_objects.datasets.super_cube import SuperCube, list_s

Microstrategy 10.x/10.1/10.2 Visual Insight Dashboard (HTML 5) Performance

As explained in my another post, Visual insights dashboards in HTML 5 (MSTR 10) is the major change from Visual insights dashboard in Flash (MSTR 9.x) Please refer the below link for more details: https://www.blogger.com/blogger.g?blogID=8659869250212697370#editor/target=post;postID=119211721674939237;onPublishedMenu=allposts;onClosedMenu=allposts;postNum=1;src=postname In this post, I am giving few specific items on performance in HTML based Visual insights dashboards. Before get into the details, this may only applicable for projects with large schema . yes it is related with project schema size. After moving to Microstrategy 10, we may see few differences in performances. In few cases, you will see better performance in MSTR 10 and in few cases, you may see bad performances in MSTR 10. In this post, we are going to discuss about MSTR 10.x Visual insights dashboard performances and few tuning options In Visual Insights, few activities where we may see slowdown  in VI da

Visual Insight Dashboard - Microstrategy 9.x/9.4.1 (Flash) Vs Microstrategy 10.x/10.1/10.2/10.3 (HTML 5)

In this post, I am writing few important differences between MSTR 941 flash based visual insight dashboard and MSTR 10.2 HTML 5 based visual insight dashboard.  I am writing this only based on my experience and my understanding. I may be wrong in few cases or few of them may be changed in hot fixes or new versions.  Starting from version 10, Microstrategy deprecated Flash and introduced HTML 5 based dashboards. this is applicable for both documents and VI based dashboards.  This is one of the very major and important change in Microstrategy 10. In this post, we are going to see few key characteristic difference because of this change. 1) Rendering : This is one of the major difference between Flash and HTML 5 based visual insights dashboard.  In a Flash based VI dashboard, it loads all data and charts in a single shot. When you run a dashboard, it will load everything in your browser in the first run. After that, everything else (moving to different layout, app

Idea Exchange - My Ideas Posted in MSTR Community - Better Support for Exporting from Document Cache

2) Better Support for Exporting from Document cache: MSTR Community Link: https://community.microstrategy.com/t5/Idea-Exchange/Better-Support-for-Exporting-from-Document-Cache/idi-p/292068 Note: Microstrategy considers our ideas based on the votes. Please cast your vote which will help to get this as a new feature in the future MSTR release The main purpose and important reason why we create\recommend document cache is to get better performance which gives better user experience. Microstrategy do supports document cache with different output mode but still I feel few improvements needed in the way it handles the data export from the cached document.  Improvements needed:   Options to export a single grid or graph (Not a whole document or a panel or a layout) in a document from the cache – Without re-executing the document in the background If possible connect different cache output modes. Ex: Use excel cache when user tries to export a graph f

Idea Exchange - My Ideas posted in Microstrategy community - Edit Mode in Visual Insight Dashboard

1) Edit Mode in Visual Insight Dashboard: MSTR Community Link: https://community.microstrategy.com/t5/Idea-Exchange/Edit-Mode-in-Visual-Insight-Dashboard/idi-p/291307#.VwwGPp5BbDA.blogger Note: Microstrategy considers our ideas based on the votes. Please cast your vote which will help to get this as a new feature in the future MSTR release I feel it will be really useful and convenient to have Edit mode\Offline mode in Visual insights dashboards as like regular document. Edit mode\Offline mode what I mean is to open VI dashboards without executing\processing data.  Below are few very useful scenarios where we need edit mode, We can open a heavy weight VI dashboards in edit mode easily during the development This will be very useful to debug and fix few errors (corrupted metrics & any corrupted components) Consider the below example,  We have few very complex visual insights dashboards where we have few derived metrics\summary metrics defined in the VI da

Intelligent cubes in Microstrategy

Intelligent Cubes: Topics: Intelligent cubes Intelligent cubes Vs Cache Manage and Monitoring cubes Cube Size and Memory usage Accessing Intelligent cubes Dynamic sourcing Intelligent cube & Security filters Intelligent cubes & Multi-tenant Architecture Intelligent cubes & Level Metrics Intelligent cube is an OLAP feature introduced in Microstrategy 9 version.  Intelligent cube is a pre aggregated set of data stored in intelligent server memory and it will give very quick access to the data without hitting the data warehouse. It is very simple to create an intelligent cube, it is same like a report creation. When we create and publish intelligent cube, it stores all the data in intelligent server memory as well as a copy in file system (secondary storage area -Hard disk). Whenever it reboots, it loads the data to memory from the file ·           Stores data in intelligent server memory and in disk We have two ways to access th