Manually editing values in the MicroStrategy Metadata incorrectly may cause serious, project-wide. metadata_connection_string The connection string Intelligence server uses to connect to the metadata database. MSTRInstallPath: By default, on cloud environments it is /opt/mstr/MicroStrategy/. x metadata Number of Views 2. After this change, when creating a metadata via the Configuration Wizard, the test schema will be used. If the description for the ODBC DSN does not match "MySQL ODBC 5. Open Windows Services and start MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. Follow steps below to achieve this: Connect the the metadata DSN from DB Query Tool. If you are working on a report that has already been saved, a confirmation message appears. For information on how to create a Configuration Wizard response file, see. The password of a metadata user with full administrative privileges (Administrator is recommended). " I-Server configuration error: "The metadata you selected has not been upgraded to the current version of Intelligence Server. Refer to your MicroStrategy contract and any accompanying contract documentation for descriptions of the different MicroStrategy license types. Connect to your database using SQL Server Management Studio and in the left pane select your Metadata database. Generate SAML Configuration Files. Metadata is stored in a relational database with a predefined structure. Security Filters. The following is a list of the different properties of a MicroStrategy metadata object that can be listed using Command Manager 8. x. To list all enabled users is the everyone group, here is sample code: import java. TABLES WHERE table_schema = "TEST_md" Database Administration Tool. The data sources include a file in a folder on your computer or stored in Dropbox, a. The MicroStrategy analytics platform is consistently rated as the best in enterprise analytics and is used by many of the world’s most admired brands in the. You link this imported data to define attributes and metrics. Information on the MicroStrategy Tutorial project is provided in the Project Design Help. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. Some of the main components of the MicroStrategy platform include: MicroStrategy metadata —a repository that stores MicroStrategy object definitions and information about the data warehouse. To set up MicroStrategy Intelligence Server. Enumeration; import. Navigate to the Security tab and configure the following parameters. Set Data Retrieval Mode to the setting Allow Native API at the report level: 2. MicroStrategy environments prior to MicroStrategy 2020 use MySQL. Open the MicroStrategy Configuration Wizard. Open the MicroStrategy Configuration Wizard. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. And by this, I mean all objects: Attributes, tables, names, users, states, object information, etc. Select Configure Intelligence Server, and click Next. The API exposes a way to fetch data using HTTP requests such as POST, GET, and DELETE. Get Started. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. Configure and store credentials for the login. In MicroStrategy Desktop > Administration > Configuration Managers > Database Instances, edit the Database Instance associated to the DSN then select the Database connection associated to the DSN and. SQL scripts transform the statistics data into a form that can be useful for administrative reporting. If you. NOTE: For Windows, refer to the MicroStrategy KB article - KB428146: How to determine which DSN is being used by the Intelligence Server on a 64-bit Windows machine. Hover over the Properties column and click Open Intelligence Server Administration Portal . The queries can be modified syntactically for other databases. x using the MicroStrategy Configuration Wizard. Metadata Doctor (MD Doctor) is a utility that detects and fixes certain physical inconsistencies in MicroStrategy 9. 11. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. Click Next. x-10. In general, report creation in MicroStrategy is. x does not return full c… Metadata partition mapping is the mapping of partitions where the mapping of partitions is performed and maintained in the project metadata by the application, in this case, MicroStrategy. KB35809: Using ScanMD to fix known logical metadata inconsistencies in the MicroStrategy Product Suite 9. log and contact MicroStrategy Technical Support in this case. You are returned to the Summary page. To help reduce deployment complexity MicroStrategy now includes an embedded repository that can support the following MicroStrategy products: Metadata Repository; Collaboration Server; Platform Analytics; The infrastructure is installed and ready for use should this be the right fit for your deployment. Create an Amazon Redshift DSN using the MicroStrategy Connectivity Wizard. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. There's a reason we're at the top of the list. KB442629: How to check topic data in Linux for MicroStrategy Platform Analytics 11. Configuration Wizard fails when configuring the MicroStrategy Intelligence Server. The user can also write the SQL Trace to a new log file by selecting the option from the drop down. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . KB205798: How is information about subscriptions stored in the DSSCSPSNLZTN Metadata table in MicroStrategy 9. For information on how to create a Configuration Wizard response file, see. To list out all the users, perform an outer join of the attribute based on the report template. The Search Options dialog box opens. The most fundamental objects stored in the metadata are schema objects. By definition, a metadata is "data about the data. SQL queries in this document have been written for MicroStrategy 9. There are two methods of determining a Project's version: Using the MDUpdateUtil tool Access MDUpdateUtil. Click Configure Intelligence Server. From the Tools menu in MicroStrategy Developer 9. The MicroStrategy REST API is an Application programming interface that lets developers quickly extract subsets of pre-processed data in JSON format. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. In some cases it may be helpful or necessary to examine the raw entries for subscriptions that are stored in the MicroStrategy Metadata in order to determine if an issue is being caused by erroneous entries in the Metadata tables. Serves as a central point for the MicroStrategy metadata; The following capabilities are integrated into and run on the same machine as MicroStrategy Intelligence Server: MicroStrategy Distribution Services monitors data and automatically sends critical business performance information to users via email, file servers, FTP locations, and. Select Export Translations as a translation action and click Next. While there is no location within the MicroStrategy products Graphical Unit Interface (GUI) where a user can determine the DSN being used by MicroStrategy Intelligence Server to connect to the metadata, it is possible to determine this information by looking in the registry. The image below shows which parts of a report are translated using data internationalization and which parts of a report are translated using metadata internationalization: This section assumes you have an. In the Platform Analytics directory, located in C:\Program Files (x86)\MicroStrategy\Platform Analytics\, open the bin folder. Delete the first and the last line of the web. If you're looking for MicroStrategy Interview Questions for Experienced or Freshers, you are in the right place. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Click OK . In the Platform Analytics directory, located in C:Program Files (x86)MicroStrategyPlatform Analytics, open the bin folder. On the Select Components page, select the check boxes for each Intelligence Server you want to upgrade. To import strings from the translation database back into the metadata, select the Import Translations option from the Metadata Repository page in the wizard. KB484282: MicroStrategy Db2 connection times out after Db2 backup and restore. Steps to enable Scheduler: Open Developer. In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager. Run MicroStrategy Backup. The example below shows the analysis for a MySQL Metadata: SQL to find the tables in a given schema SELECT table_name FROM information_schema. Click Next. Number of Views 2. By default, this file is located in C:Program FilesCommon FilesMicroStrategy as indicated in Step 1 e) If users would like to transfer the file to another machine or send it via e-mail, they should make sure to compress the file with WinZip or a similar tool as. This tech note is an explanation of how to check the size (row count) of a table in MicroStrategy 9. And by this, I mean all objects: Attributes, tables, names, users,. If in some extreme scenarios, the deadlock still occurs after the. Identify your tables in the 'Tables'. Enter the User Name and Password for the database. However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. Open the MicroStrategy Configuration Wizard. In the screenshot above, the SQL is being logged to the metadata SQL. The diagram below illustrates three-tier metadata connectivity between the MicroStrategy metadata database (tier one), Intelligence Server (tier two), and Developer (tier three). MicroStrategy Backup Preparations. Input Location; BakFileLocation. 1. However, you can also modify a response file with a text editor to make minor changes such as entering different user login and password information. It will not show users whose number of jobs is 0. Set Encryption Method = “1-SSL”. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from. x, the correct results were shown even if a user activity metric was on the report. x, fact tables may be partitioned using warehouse partition mapping tables or metadata partition mapping tables. Generate SAML Configuration Files. In certain senarios, it is helpful to find out the metadata shell version by running SQL against the metadata in MicroStrategy DB Query Tool (or ODBC Test Tool in version 8. Selected. The MicroStrategy system uses the metadata to know where in the data warehouse it should look for information. However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. Platform Analytics is a telemetry tool that supports telemetry capture from multiple MicroStrategy deployments simultaneously. csv - information about every user in the metadata. On the next screen do not enter any password, just click Next. MicroStrategy Tutorial Reporting. Add the following parameter to the file: For a native Postgre driver: ConnSettings=SET SEARCH_PATH to 'test'. MicroStrategy ranks #1 in the Analytics Developer use case in Gartner's 2023 Critical Capabilities report. Follow the directions below in order for managed objects to show up in a search result: In the Search for Objects dialog box, select Options on the Tools menu. /mstrcfgwiz. xml) and SAML configuration files ( MstrSamlConfig. How to display a list of users that are currently enabled in the MicroStrategy metadata using MicroStrategy Enterprise Manager In MicroStrategy Enterprise Manager 9. 1 Driver", the MicroStrategy metadata connectivity layer will expect the data from the driver to be in UTF-8 format whereas the driver uses a UTF-16. You can retrieve subscriptions by filtering for Object Type = Subscriptions/Schedule. Open the MicroStrategy Configuration Wizard. AWS, Microsoft Azure 또는 Google Cloud 중 귀사의. MicroStrategy remains ranked #1 in Portfolio Capabilities in the 2023 edition of the BARC Score. The Full option exports a snapshot of each page and each individual visualization. The Freeform SQL functionality allows you to use your own SQL statements to generate reports, instead of using the MicroStrategy Engine-generated SQL. Third Party Software Installation: WARNING: The third-party product(s) discussed in this technical note is manufactured by vendors independent of MicroStrategy. When a Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. The utility is found under Program. This chapter addresses the processes necessary to. There's a reason we're at the top of the list. A Server Definition Object. x who want to delete a server definition but do not have access to the Configuration Wizard GUI need to use the console mode. x to PostgreSQL 9. Refer to the following MicroStrategy Knowledge. So, You still have the opportunity to move ahead in your career in MicroStrategy. It also has a more powerful and easy to use. Click the folder icon to browse to and select a response file. Click Next. x and 9. To access the configuration page, you need admin privileges. Select the data source from the Data Source Name drop-down list. Response File: The MicroStrategy Configuration Wizard response file that defines how to upgrade Intelligence Server components or migrate your History List from a file-based system to a database-based system. Enter the following information for the rest of the text fields. According to research, MicroStrategy has a market share of about 4. With a backup of the metadata in place, proposed fixes should only be accepted if the full impact of the fix is understood. When an Administrator reconfigures the Intelligence. The destination project must be updated first. For steps to create a project source, see the. Object Layer. So I want to create an. Cloud. x and additional columns are added to existing metadata tables to facilitate support for Internationalization, Metadata Auditing and Distribution Services. Object layers contain and store the objects created in MicroStrategy. Starting Oracle Data Pump Export. Open the Photos app and find the photo you want to view the metadata for. Click the New User icon on the toolbar. A metadata management solution becomes even more valuable when it is active. 9. . It is used by MicroStrategy Developer and other client interfaces to build, interact, and manage the contents of the MicroStrategy metadata. This attribute is not directly related to the 'Report' attribute so that if 'Report' and 'Schedule' are placed on a report template by themselves, they will not be joined in a meaningful way. This video shows basic steps of MD upgrade process. Proactive. DSN: Select the data source name for your metadata repository. The destination project must be updated first. Informatica activates your metadata with AI and machine learning, augmented with human knowledge, and integrates it with data analytics programs and other applications to uncover new data insights. x and newer: 1. Collect this file along with the DUMMYMDT DSSErrors. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. and run another dependency search and so on. However, a report with only the "User" attribute will list out all the users, regardless of their activity. ; Go to Connection Type > Direct (2-tier), and click Next. This is necessary in order to properly set the Windows registry keys. For steps to connect to and create a database instance for an Excel file, see Connect to Excel Files. MicroStrategy environments 2020 and onward use PostgreSQL. Secondly, you can create queries in MicroStrategy in the same way that we did in the Call REST API in MicroStrategy section:Open Repository Translation Wizard and click Next. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. MicroStrategy의 강력한 클라우드 네이티브 플랫폼, 멀티 클라우드 전략 및 컨테이너화 기능은 가장 리스크가 적은 방식을 채택하여 제품 출시까지 소요되는 시간을 단축합니다. Connect the metadata update utility to a two-tier project source whose Data Source Name (DSN) points to the metadata. Open the MicroStrategy Configuration Wizard. Warehouse Catalog. In some cases, users may want to see the direct object dependencies of objects in the MicroStrategy metadata. Specifically, ODBC connects to and transfers. Click Next. A command prompt opens. For instructions on using. From the Language drop-down list, specify the language in which to display MicroStrategy Web pages. In simple terms, it detects physical inconsistencies by running SQL against different metadata tables and then comparing. If you use Windows NT/2000 or later as. To view this field, the Intelligent Cube must be published at least once. From the Language drop-down list, specify the language in which to display MicroStrategy Web pages. For example, users might want to create a dossier that shows all dossiers and the component datasets on dossiers. Note: MicroStrategy metadata will be created in the metadata2019 database in MySQL Server. Overview of Freeform SQL reports. Enter user information in the Create New User dialog. The following steps generate the application metadata ( SPMetadata. Project default level preferences are set at the MicroStrategy Intelligence Server 8. xml file located in the WEB-INF folder of the MicroStrategy Web installation directory. For example, if you want to create a new user in the Web Reporter group, click the Web Reporter group link. The update utility, like Desktop, can use an Intelligence Server on any supported operating system interchangeably. Change the value ' md5 ($#####) ' with ' $##### ', (aka removing the md5hashing of your input). x - 9. Now available for feature release—MicroStrategy 10. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. On the Metadata Connection page, type the DSN, database login, and database password to access the MicroStrategy metadata. Or a user might want to see all objects that have a certain metric as a component. Select Configure Intelligence Server, and click Next. MicroStrategy metadata. If this is not the correct path, you can find the path by running locate MSIReg. for Superclass and search for 'ProjectsTransform'. If the metadata server instance is shutting down unexpectedly, very likely a core file will exist in the MicroStrategy folder structure. x to PostgreSQL 9. Set up the Enterprise Manager. The 'Database Name' option allows the MicroStrategy Narrowcast administrator to create the Object Repository or the Subscription Book Repository in any of the databases that exist in the database server pointed to by the Data Source Name (DSN). xml file located in the WEB-INF folder of the MicroStrategy Web installation directory and open it in a text editor. x metadata and the MicroStrategy Enterprise Manager 9. The Object Telemetry dossier contains a great deal of subscripton information. 1) Connect to Metadata through DB Query Tool or other SQL tool. For detailed information, query the INFORMATION_SCHEMA. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Type: Attribute Qualification; Attribute: Report Job SQL PassType Y and click Enter to create History List tables with the same ODBC DSN information entered for your metadata tables. Download the software from the MicroStrategy download site. Open Command Manager and connect to the. Select “MicroStrategy SDK”. Type, Subtype and extType parameters of objects can be used to narrow down the search. The value of this key is the name of the DSN that MicroStrategy Intelligence Server uses to connect to the Metadata. The metadata ID for which the user session was connected. It is based on a single data repository strategy, whereas Cognos has two metadata repository and database-based. MicroStrategy is usable in both forms, web and desktop tools, whereas Cognos is a web-based reporting tool mechanism. Cloud This video walks users through the process of installing and running the mstrbak tool and how to use it. /mstrcfgwiz. The INFORMATION_SCHEMA. Before running ScanMD, a database backup of the metadata must be made. 9% of resumes. Find out the Object name from DSSMDOBJNAMES table, using object id found. 4. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. NOTE: To perform this audit, queries are run against the MicroStrategy metadata database. In MicroStrategy 8. MicroStrategy actions (executions, session, etc. x. Next to All Users, click Create a new User . There's a reason we're at the top of the list. The user should locate the VLDB. Open the Warehouse Catalog under the Schema menu. x, select 'Preferences'. x, the correct results were shown even if a user activity metric was on the report. Choose the database and version, click Add driver, browse to the driver setup in step one and click OK as shown below: For all JDBC. In Web, if the browser is set to a language unsupported in MicroStrategy and the user's preferences are set to Default, the date/time and number formatting display in English. 1, you must. Named User Licenses, in which the number of users with access to specific. Open the odbc. In a server (three-tier) environment, Developer metadata connectivity is established through the project source. Before running ScanMD, a database backup of the metadata must be made. MicroStrategy metadata is a repository that stores MicroStrategy object definitions and information about your data warehouse. Along with a backup of the metadata (MD), cache files can be restored on MicroStrategy Technical Support environments to troubleshoot report or document-specific issues. Another case would be where you might have data in particular space in Datasphere whose metadata you don’t want to be available in catalog; like a HR space. Steps: 1) Identify the object ID of the Intelligent cube to be audited by checking the objects Property windowIn MicroStrategy SQL Generation Engine 8. Duplicate your projects into project source. You can choose to assign DNs to MicroStrategy users explicitly. of objects that use that table. For 'Enabled=true' means the user is enabled in metadata while 'Enabled=false' means the user is disabled. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingDatabricks took a pioneering approach with Unity Catalog by releasing the industry's only unified solution for data and AI governance across clouds and data platforms. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. x and newer, the default maximum number of concurrent connections that MicroStrategy Intelligence Server can make to the metadata, is 0x0fffffff. 3%. You can map columns to: Managed object attributes and metrics: Managed objects are created on the fly and only exist in the context of Freeform SQL. The following. In Command Manager, the list of enabled users in the metadata is returned by the following command: LIST LOGIN, ENABLED FOR USERS IN GROUP "Everyone"; This can also be done using MicroStrategy Web SDK 10. Introduction to the REST API. You can create the metadata repository in the database location of your choice. Enter the User Name and Password for the database. Find the folder 'Version Update History' and collect a screenshot of showing all the entries within that folder. Enter the user name and password you wish to use to connect to the Narrowcast Server. Drive revenue growth with memorable app workflows and AI features that really speak to the user. In Platform Analytics, application and schema objects are captured by the object attribute with the. Now, enter your username and hashed password copied from the database and login. x, create a new report with the following definition: Attributes . Ensure a metadata backup is taken prior to performing the below actions. Create a database connection that points to the DSN. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. Chose IBM Cognos Analytics. There is a distributed and highly available database for the MicroStrategy Metadata and Statistics. From the Tools menu in MicroStrategy Developer 9. MicroStrategy has a metadata-driven architecture. Connect the metadata update utility to a three-tier project source pointing to the UNIX Intelligence Server. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. On the Freeform Sources tab, select Create Query Builder report. ODBC is a standard method of communicating with database servers. Click Configure Intelligence Server. x). With the modeling tool, architects can map the physical database schema, model data based on business requirements and terminology, and build complex hierarchies to organize data and better reflect relationships. There's a reason we're at the top of the list. Open the Repository Translation Wizard. EXE ). WCCA, Worcester, Hidden Treasures. MicroStrategy metadata is like a road map or an index to the information that is stored in your data warehouse. The information is stored in a proprietary format within a relational database. • Adopted best practice framework for easy updates without metadata changes • Over 50 defects improved in Critical Update 1. MicroStrategy uses the credentials provided by the user to search for and validate the user in the LDAP directory. If the connection information to the MicroStrategy Repository has changed since the last installation, you are prompted to provide the database login username. The metadata is a central repository, which stores all the objects used by it. In order to get the user names, the metadata table DSSMDOBJINFO should also be referred, follow the below steps to get the user names by querying against statistics table IS_SESSION_STATS and metadata table DSSMDOBJINFO:. If there are many unused managed objects in a project then the object bulk load in project duplication will not take effect and it will cause slow performance for project duplication. How to Analyze the Size of Metadata Tables The MicroStrategy Administrator should work with the DBA to find the tables which consume the largest amount of memory. usherServerConfig:. Always upgrade the Intelligence Server before upgrading client applications such as MicroStrategy Web, Mobile, Library, and Developer. Edit the line within the function that takes your login input. MicroStrategy Tutorial Reporting is a sample MicroStrategy project with a warehouse, and a set of demonstration dossiers, reports, and other objects, designed to illustrate the platform's rich functionality. This will return the 32 - digit GUID for the metadata. x using the MicroStrategy Configuration Wizard. Find an event in a city near you. The ability to import users and groups into the Microstrategy metadata from the Directory Server would be an efficient way to create or update a new MicroStrategy user structure from an existing Directory Server. To view this field, the Intelligent Cube must be published at least once. Runs the client in Prompted mode. To search for managed objects only, select Display Managed Objects Only. Click Show Advanced Options. While trouble shooting cases, sometimes it is helpful to find out the dependencies between objects by running sql directly against the metadata in MicroStrategy DB Query Tool. When a user with MicroStrategy administrative privileges deletes an out of the box folder, such as the ones within the Public Objects folder, metadata inconsistencies might be created. This table is used to store. The MicroStrategy Intelligence Server 9. x products from functioning correctly. Open Windows Services and locate MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. Operations cannot be performed from a newer metadata to an older one. Note: MicroStrategy metadata will be created in the metadata2019 database in MySQL Server. 5. A list of user groups that reside on the Intelligence Server appears. The users' Partition Mapping Table appears in the left window. x product family, the metadata used by the MicroStrategy Intelligence Server(s) will be periodically scanned for the total number of named users assigned for each MicroStrategy component based upon the user privileges assigned in the metadata repository. Lookup tables are usually joined to fact tables to group the numeric facts in the fact table by dimensional attributes in the lookup tables. In the MicroStrategy 9. The timestamp of when the session was opened. Users are defined in the MicroStrategy metadata and exist across projects. Learn more about Collectives. Configuring and Connecting Intelligence Server: After installing and activating MicroStrategy products, you must use the MicroStrategy Configuration Wizard to configure the MicroStrategy metadata repository, statistics tables, history list tables, Intelligence Server, and project sources. microstrategy. 신뢰할 수 있는 AI를 빠르게 확장시키세요. In the MicroStrategy architecture, each object is identified by its unique Object ID. Open Windows Services and locate MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. Run the. Intelligence server and metadata: MicroStrategy Intelligence server and metadata versions should always match. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. Run following SQL: Cloud. Type your MicroStrategy login and password for the selected Intelligence Server and click Connect. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Open the MicroStrategy Configuration Wizard. Stop the MicroStrategy Web application server. Specify a name and location to save the response file, and click Save. x warehouse and statistics tables. Select Configure Intelligence Server, and click Next. With these files, Technical Support can execute reports or documents that have corresponding caches without having to connect to your data warehouse. To specify a database instance, in the Intelligence Server Configuration Editor, select the General subcategory of the Server Definition category, and, in the Database Instance drop-down list, select the database instance to use for the History List. These properties are not specified in the example script provided in Command Manager. Going to the basics, below is the basic outline of the MicroStrategy architecture: I've been working in the past few years with Cognos 10 and Cognos 11 but my company has Microstrategy (I'm a newbie in Microstrategy). In the following sample code, several parameters must be adjusted to match environment specific values, such as project names and login information. Open a browser and access the SAML configuration page with a URL in this format: Copy. bigint(20) connection_time. Click Next. Going to the basics, below is the basic outline of the MicroStrategy. 4. Glossary .