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. https://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