BI Validator v2.8.3 or later support testing automation of MicroStrategy reports, dashboards and documents. The very first step for creating a test for MicroStrategy is to create a new BI Connection for your environment. 


Prereqs for Creating a new BI Connection:

BI Validator uses Task Administrator (TaskAdmin) for creating a session and retrieving the report catalog from Microstrategy using the Web API. So it is important to have access to the TaskAdmin for using the tool. Use the below URLs for testing the access to the TaskAdmin depending on whether your MicroStrategy server is hosted on IIS or Tomcat: 


http://<server name>/MicroStrategy/asp/TaskAdmin.aspx

or 

https://<servername>/MicroStrategy/servlet/taskAdmin


Task Administrator can be used to verify the access for creating a session. As per the MicroStrategy documentation below, the user need 'Web Server Administrator' privilege. ttps://lw.microstrategy.com/msdz/MSDL/GARelease_Current/_GARelease_Archives/940/docs/mergedProjects/websdk/topics/taskinfr/TI_Using_Tasks.htm


How does BI Validator use TaskAdmin?

Listed below are the Task API used by BI Validator internally for automating the testing of MicroStrategy Reports and Dashboards:


TaskAdmin API Name Purpose
getSessionState
Login to MicroStrategy and gets the session data
folderBrowse
Load Catalog information such as folders, reports & documents
reportExecute Loads Report XML. Used to verify that the report exists.
RWExecute
Loads Report XML User to retrieve the list of prompts and their values


Creating a BI Validator Connection:

Below is a screenshot of a sample connection to a MicroStrategy environment that is using Tomcat. 



Enterprise URL: This is the URL for the MicroStrategy Secure Enterprise. The URL can vary slightly depending on whether your MicroStrategy server is running on Tomcat or Microsoft IIS. 


Sample URL for Tomcat : http://192.168.5.132:8080/MicroStrategy/servlet/mstrWeb


Sample URL for IIS :  http://datagaps16:8080/MicroStrategy/asp/main.aspx


Server: Server name can be located easily from the login URL for the MicroStrategy Secure Enterprise. A typical login URL for MicroStrategy Secure Enterprise looks like below:
 

http://<server name>/MicroStrategy/servlet/mstrWeb?evt=3010&Project=MicroStrategy+Tutorial&Server=DATAGAPS16


The URL has 'Server=DATAGAPS16' string as one of the parameter. The server name in this cases is DATAGAPS16. 


If you have Single Signon and don't have the login page, you can look at the URL of the project you are trying to open from MicroStrategy Secure Enterprise.


Port: Port is the MicroStrategy Intelligence Server. Leave it as 0 for default. 


Project: Name of the project. Please make sure to enter the spaces and any character as they appear. 


Authentication Type: Pick the authentication type used by the MicroStrategy Server


Single Signon: If your environment uses a Single Signon such as Active Directory, please select 'SSO Details' tab and provide the details. 


Reference 

You can use MicroStrategy Task Administrator for testing the creation of a session. Below are the list of  Authentication Types and their Codes.

    MWSStandard = 1

    MWSNTCredential = 2

    MWSPassThru = 4

    MWSAnonymous = 8

    MWSLDAP = 16

    MWSWarehousePassthru = 32

    MWSSimpleSecurityPlugIn_MWSAuthTrusted = 64

    MWSIntegrated = 128

    MWSNone=9