Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformFirst of all, in order to connect, you will need to specify on the ZappySys JSON Driver the path of the local JSON file: Configure a JSON file connection with ODBC. 1. Configure Metadata Connection. LDAP passwords are not stored in the MicroStrategy metadata. The Snowflake API call we used, for example, get Tables (null, null,. metadata_connection_string The connection string Intelligence server uses to connect to the metadata database. The transformation ensures that reporting on MicroStrategy metadata content is feasible. Select the. By default, MicroStrategy Web supports the following authentication modes for verifying the user's credentials. This video walks users through the process of installing and running the mstrbak tool and how to use it. On Metadata Repository Connection Information, click Apply. 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. 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. MicroStrategy metadata. Incentivized. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. Information on the MicroStrategy Tutorial project is provided in the Project Design Help. ), it is the IP address of the machine from which the session was created. Regards DipankerMicroStrategy SQL Generation Engine 10 can automatically detect tables where the same column is used to create two different attributes; Business Case Scenario:. x when configuring Intelligence Server via Configuration Wizard on Windows OS to point to a metadata in PostgreSQL 9. There's a reason we're at the top of the list. Create an Amazon Redshift DSN using the MicroStrategy Connectivity Wizard. <. Open the MicroStrategy Configuration Wizard. x. 11. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Starting in MicroStrategy 2019 it is possible for administrators to track the state and usage of subscriptions through Platform Analytics. Enable SAML authentication for 2021 Update 1: In the Default Properties section of the Web Administrator page, enable SAML authentication and click Save. When a Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. Launch the Configuration wizard and choose to create repositories then select metadata. Specify a name and location to save the response file, and click Save. 3% of resumes. However, a report with only the "User" attribute will list out all the users, regardless of their activity. Change the password of the account. Following is the architecture of MicroStrategy: 1. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. Named User Licenses, in which the number of users with access to. Create a new two-tier project source using the DSN created. Set Data Retrieval Mode to the setting Allow Native API at the report level: 2. In the screenshot above, the SQL is being logged to the metadata SQL. Oracle Data Pump Export is a utility for unloading data and metadata into a set of operating system files that are called a dump file set . Configure Intelligence Server with restored metadata with Configuration Wizard 8-2. The objects stored in the metadata are reusable. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. Select the Include extra fields in output (precision, city, country, etc. KB441192: Configuration Wizard fails when configuring the MicroStrategy Intelligence Server 10. Go to the component 'Database Classes' and dispatcher 'SQL Trace'. They are the bridge between MicroStrategy reporting environment and data warehouse. 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. It is used by MicroStrategy Developer and other client interfaces to build, interact, and manage the contents of the MicroStrategy metadata. There is a dialog that includes fields to define how to create your metadata tables and where they should be stored. Click Next and Finish. Glossary . Click Next. Hover over the Properties column and click Open Intelligence Server Administration Portal . This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. Open MicroStrategy Desktop, Click Add new Data -> Database -> Add new data source. Click Next. Open Windows Services and locate MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. x-10. For example, users might want to create a dossier that shows all dossiers and the component datasets on dossiers. Each login mode specifies a particular mechanism or authority to be used for authentication. This is the same information required for report cache restoration. The MicroStrategy Intelligence Server 9. Select the database instance. The data loading process gathers and prepares data for analysis and reporting in the Enterprise Manager project. The destination project must be of the same or greater metadata version as the source project. The most fundamental objects stored in the metadata are schema objects. MicroStrategy uses the credentials provided by the user to search for and validate the user in the LDAP directory. Open the ODBC Administrator and edit the pre-created Amazon Redshift DSN. 1. cube files corresponding to the cube instance ID; The complete set of *. Platform Analytics consumer performs a standardization. There's a reason we're at the top of the list. objects. For each Table object, right click on the table and choose 'Search. Cloudera CDH Hadoop Gateway System. x metadata repository to a newer version. ODBC is a standard method of communicating with database servers. However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. WCCA, Worcester, Hidden Treasures. Click Next. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. 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. x does not return full c…What is MicroStrategy Metadata? The Metadata is where all the MicroStrategy definition is stored. x to PostgreSQL 9. They typically consist of descriptions of dimensions. Set Encryption Method = “1-SSL”. MicroStrategy remains ranked #1 in Portfolio Capabilities in the 2023 edition of the BARC Score. This demo will guide you through creating a Data Source Name, and a database connection to a Microsoft SQL Server Database in both Developer and Web. is stored in the. 0 and above Topic location: C:Program Files (x86)MicroStrategyMessaging Services mpkafka-logs. In some cases, users may want to see the direct object dependencies of objects in the MicroStrategy metadata. Create a database connection that points to the DSN. Access the database using MicroStrategy Desktop for Mac. 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. 신뢰할 수 있는 AI를 빠르게 확장시키세요. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. AdditionalDSNs. Input Location; BakFileLocation. Connect the metadata update utility to a two-tier project source whose Data Source Name (DSN) points to the metadata. For 'Enabled=true' means the user is enabled in metadata while 'Enabled=false' means the user is disabled. 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. The project source is a configuration object which represents a connection to a metadata repository. To list out all the users, perform an outer join of the attribute based on the report template. Once a security filter is created for. There's a reason we're at the top of the list. 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. Schema objects are logical objects that relate application. The Snowflake API call we used, for example, get Tables (null, null,. Generate SAML Configuration Files. I have below following all the required. Open the Photos app and find the photo you want to view the metadata for. You can retrieve subscriptions by filtering for Object Type = Subscriptions/Schedule. If you click the link for the Narrowcast Services SDK Guide, a File Download dialog box opens. You have the option to connect to. ) check box to. x, select 'Preferences'. Now, enter your username and hashed password copied from the database and login. If MicroStrategy Platform Analytics was selected in a previous installation, it is automatically selected in Select Components. The DSN should provide a unique description of the data, for example, Payroll_Project_Metadata or Payroll_Warehouse. On Windows from the command line, perform the following steps: From the Windows Start menu, select Run. Third Party Software Installation: WARNING: The third-party product(s) discussed in this technical note is manufactured by vendors independent of MicroStrategy. With these files, Technical Support can execute reports or documents that have corresponding caches without having to connect to your data warehouse. Launch Configuration Wizard and choose to create repositories then select metadata, you will see a page includes fields to define how to create your metadata tables and where they should be stored. Defines whether to upgrade the metadata, as determined by the following. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Create a DSN named "MS Access Shell" for Microsoft Access database with MicroStrategy Connectivity Wizard. The Scan MD tool searches for logical errors and fixes them within the platform object structure. Click 'Browse. You can choose to assign DNs to MicroStrategy users explicitly. To configure:-. Before running ScanMD, a database backup of the metadata must be made. Then click 'OK'. microstrategy. If any problems arise see section on Troubleshooting. comCreate a DSN using the steps below: Launch the MicroStrategy Connectivity Wizard. The metadata also stores the definitions of all objects created with MicroStrategy Developer and Web such as templates, reports, metrics, facts, and so on. 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. In MicroStrategy Developer, choose File > New > Report. The project default level preferences are accessed by the Web server at connection time. Security Filters. 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. It also stores other types of objects that. 1. MicroStrategy manages the mapping between the logical table and the physical tables. In some business scenarios, it is required to duplicate a project's metadata to a Microsoft Access file. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. Select Display Managed Objects. However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. MicroStrategy actions (executions, session, etc. Type todbcx. TABLES WHERE table_schema =. Select Metadata, History List and Statistics Repository Tables and click Next. An example of such a field is an object GUID. If the Configuration Wizard detects an existing metadata repository in the database location you specified, a message is displayed on whether to re-create the metadata tables. In Web: Go to MicroStrategy > Preferences > Languages > Show Advanced Options. 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. Go to the 'Schema Objects' folder. 4. exe. The project source stores the location of the. In MicroStrategy 10. The Freeform SQL functionality allows you to use your own SQL statements to generate reports, instead of using the MicroStrategy Engine-generated SQL. . Runs the client in Prompted mode. 4. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. Go to Project access, to give Public/Guest basic access to the project. Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. It also demonstrates what the Patch Installer is and how to download it. To support the use of a graphical user interface for MicroStrategy tools and installing MicroStrategy products on Red Hat Enterprise Linux 6, you must install the libstdc++-4. x-10. Select the group in which to create a user. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Exported data files can be later used in dossier for further analytics or visualization. The MicroStrategy Intelligence Server 9. Runs the client in Prompted mode. x to 9. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. MicroStrategy also supports using API calls to retrieve catalog information. Under Desktop/Developer browsing options, choose 'Display hidden objects'. A connection to a metadata repository is achieved in one of two ways: Direct or two-tier mode. Type N and click Enter to provide different. x has the capability to authenticate and import users and groups from an existing LDAP Server into the MicroStrategy Metadata. Download the software from the MicroStrategy download site. 4-XX. x to PostgreSQL 9. On the otherway, you can try every object used in the report checking the location of each object one-by-one (Report Objects, Filters used etc. This KB article describes how on Windows and Linux systems. The user should locate the last <Setting> XML entry in the file similar to the following entries:<Setting>MicroStrategy is an enterprise BI application software. User Name: Enter the user name for the user that can connect to the data. 3%. This document describes how to configure MicroStrategy ASP Web to support SAML using Shibboleth Service Provider for IIS. 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. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. If you are working on a report that has already been saved, a confirmation message appears. In the available columns, select the Last Month ID column (Prev_Month_ID in MicroStrategy Tutorial) and drag and drop it into the expression field on the left, as shown below: Click 'OK' and save the transformation: For details on how to. Using MicroStrategy Enterprise Manager 9. 4. The recipient_id column is recorded along with job executions in MicroStrategy. (in case you have xml file prepared, you can use it to initialize the wizard) Select project source and enter credentials. MicroStrategy Reporting Suite is a complete business intelligence platform that covers all the data analysis needs of an enterprise. Open the odbc. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. How to Update the Database User Password. Connecting to the metadata in DB Query tool shows all metadata tables, but no server definition can be found in the tables. Usually assigned by administrators, security filters control what warehouse data users can see within MicroStrategy. In the Platform Analytics directory, located in C:Program Files (x86)MicroStrategyPlatform Analytics, open the bin folder. x, the correct results were shown even if a user activity metric was on the report. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. For detailed information, query the INFORMATION_SCHEMA. The INFORMATION_SCHEMA. Click Create Environment. Additional DSNs require the same credential and server location as the metadata. In a server (three-tier) environment, Developer metadata connectivity is established through the project source. In the menu, go to 'Tools -> Options'. The most fundamental objects stored in the metadata are schema objects. Exported data files can be later used in dossier for further analytics or visualization. , Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the, metadata. This mode asks the user for information about the location of various. Select Configure Intelligence Server, and click Next. 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. Related articles from the Community: Knowledge Base: MicroStrategy 2020 Patch Installer; Knowledge Base: Patch installer cannot find the principle. x, the correct results were shown even if a user activity metric was on the report. The utility is found under Program. 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. Select the desired Project Source (Data Source) and click on Next, as shown below: Upon clicking Next, the following window shows the versions of the projects found in the metadata. All schema objects, application objects, configuration objects, and project settings are stored in the MicroStrategy metadata. 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. Select the data source from the Data Source Name drop-down list. This table is used for defining some property values which will be used in certain DS tables. This example assumes the metadata includes three projects that are using three different database instances with different DBMS and using different quoting patterns. Enter the following information for the rest of the text fields. MicroStrategy Schema Modeling. KB35809: Using ScanMD to fix known logical metadata inconsistencies in the MicroStrategy Product Suite 9. Smart. On the Freeform Sources tab, select Create Query Builder report. All schema objects, application objects, configuration objects, and project settings are stored in the MicroStrategy metadata. In the bottom section, under Destination note the location of. In direct connection deployments, client products (such as MicroStrategy Developer) should also be. Click User Manager . From the Home menu, select one of the following: To save a report, select Save. In the Platform Analytics directory, located in C:\Program Files (x86)\MicroStrategy\Platform Analytics\, open the bin folder. Open the Workstation window with the Navigation pane in smart mode. xml file in the "Program Files (x86)Common FilesMicroStrategy" folder on a machine with MicroStrategy Developer installed and create a backup of this file, and then edit it. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. TO LEARN MORE: To Learn More about Enterprise Manager, please see Chapter 17 in the System Administrator's Guide. The User Editor opens. MicroStrategy users need connectivity to the metadata so that they can access projects, create objects, and execute reports The username of a metadata user with full administrative privileges (Administrator is recommended). It is designed to help developers build data-driven client applications quickly and easily. KB20171: How to Search for Folders in the Metadata Using the MicroStrategy Java Web SDK 9. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. Select the object that will replace the dependee, the object type must be the same. Step 1. Overview of Freeform SQL reports. Click the folder icon to browse to and select a response file. " It is usually a file or database that describes another set of data or information. From the DSN drop-down list, select the DSN for your statistics and Enterprise Manager repositories. 825. This setting is ideal if you have numerous. <None>. On the next screen the DSN information will be pre-populated. Run the following. Intelligence server and metadata: MicroStrategy Intelligence server and metadata versions should always match. Although it is possible to use the Microsoft Access database. 11. And by this, I mean all objects: Attributes, tables, names, users, states, object information, etc. Click on OK to save the preferences. MicroStrategy has a metadata-driven architecture. 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. This GUID is created at the time of Metadata creation, and is unique to each metadata. Find MicroStrategy’s public API in Postman and make your own copy (Fork). Restart the Web server. x? 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. This tech note is an explanation of how to check the size (row count) of a table in MicroStrategy 9. Once a table is moved from left to right, its definition is saved in. A database connection supports connecting to data sources through the use of DSNs, as well as through DSNless. Here is a link to the documentation, which is much clearer and provides the opportunity to test out some of the code using MicroStrategy's demo server:The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Go to the. It connects to Metadata, downloads all needed information and creates four CSV files with information needed to visualize user structure. The MicroStrategy metadata contains all the information needed for a MicroStrategy project to function, including data warehouse connection information, project settings and MicroStrategy object definitions. For more details about implementing single sign-on in MicroStrategy, see Enabling Single Sign-On Authentication. In warehouse partition mapping, a table in the warehouse associates attribute elements with the table names of the individual partitions. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. From the Language drop-down list, specify the language in which to display MicroStrategy Web pages. 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. The MicroStrategy system uses the metadata to know where in the data warehouse it should look for information. TABLES view. 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. Our top marks in this year’s new category follow 3+ years of #1 ratings in the now-retired Enterprise Analytics use case. On the Metadata Connection page, type the DSN, database login, and database password to access the MicroStrategy metadata. Click on OK to save the preferences. 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. TABLES view contains one row for each table or view in a dataset. 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. KB442628: Platform Analytics Kafka Topics and mapping tables in MicroStrategy 11. x. Run the file mstr-repo-ondemand-dba-operations. With active data management, you’ll gain access to advanced. Select an Environment from the upper-left drop-down. Change the system locale to English-US or another supported locale by running the command: ocalectl set-locale LANG=en_US. In the Navigation pane, click Users and Groups. The DSN is the name for a pointer used by a client application (in this case MicroStrategy) to find and connect to a data source. That you can find from your metadata. 1) • Support extended through June 30, 2019. The two known languages that have this issue are English-New Zealand and English. In the Open drop-down list, type cmd and click OK. So in most scenarios, deadlocks in the MicroStrategy metadata are overcome since the transaction will be retried 3 times. You can find the list of supported RDBMS. The Page level option only provides a snapshot of each page. If the connection information to the MicroStrategy Repository has changed since the last installation, you are prompted to provide the database login username. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. Set Data Retrieval Mode to the setting Allow Native API at the report level: 2. Always upgrade the Intelligence Server before upgrading client applications such as MicroStrategy Web, Mobile, Library, and Developer. Manually editing values in the MicroStrategy Metadata incorrectly may cause serious, project-wide. Unlike major releases and service packs, hotfixes and patches are differential updates of the product, meaning that only a few of the binaries are rebuilt and re-stamped with the hotfix or patch version. Only executions related to subscriptions will have a valid recipient. ) 3. This embedded repository is. A flag is any character allowed by the database. Open the key named 'LOCATION'. Define the statistics and enterprise warehouse database. DSN: Select the data source name for your metadata repository. If necessary, enter the database you wish to use for this Narrowcast Server. config. Go to the following path: HKEY_LOCAL_MACHINE\Software\Wow6432Node\MicroStrategy\Data Sources\CastorServer . Add the following parameter to the file: For a native Postgre driver: ConnSettings=SET SEARCH_PATH to 'test'. Thus, while the engine attribute role option makes it more convenient to use. Named User Licenses, in which the number of users with access to specific. In the MicroStrategy architecture, each object is identified by its unique Object ID. Note: MicroStrategy metadata will be created in the metadata2019 database in MySQL Server. The latest innovation from the product labs, MicroStrategy Insights fundamentally transforms how users interact with data. How to display a list of users that are currently enabled in the MicroStrategy metadata using MicroStrategy Enterprise Manager In MicroStrategy Enterprise Manager 9. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. The results will appear in grid which is more readable. Select the table that was created in Step #1 (or the lookup table where the Last Month column was added). For 'Enabled=true' means the user is enabled in metadata while 'Enabled=false' means the user is disabled. Platform Analytics uniquely identifies metadata using a combination of the following fields: metadata_guid The GUID generated by MicroStrategy when the metadata is created. bat. Steps: 1) Identify the object ID of the Intelligent cube to be audited by checking the objects Property windowIn MicroStrategy SQL Generation Engine 8. log and contact MicroStrategy Technical Support in this case. 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:. Right-click on the project "MicroStrategy Tutorial" and select Project Configuration. In the image above, the SQL is being logged to. 5. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend >and integrate the MicroStrategy business intelligence functionality into other applications. For more details about implementing single sign-on in MicroStrategy, see Enabling Single Sign-On Authentication. ServerDefTo set up MicroStrategy Intelligence Server. MicroStrategy environments 2020 and onward use PostgreSQL. Click OK. a relationship table. Collect this file along with the DUMMYMDT DSSErrors. The password of a metadata user with full administrative privileges (Administrator is recommended). 02:41 01:34 Still need help? Open a support case Watch this video on how to upgrade the Microstrategy 10. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. Go to Database Instances > Authentication > Metadata. Recipient_ids are shared with lu_entity. Under Desktop/Developer browsing options, choose 'Display hidden objects'. folder. Right-click each service and select Stop. If in some extreme scenarios, the deadlock still occurs after the. If you are running MicroStrategy Developer on Windows for the first time, run it as an administrator. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The steps to create the MicroStrategy metadata are: Open the MicroStrategy Configuration Wizard ( macfgwizw. Open Windows Services and start MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. 8. Lookup tables are usually joined to fact tables to group the numeric facts in the fact table by dimensional attributes in the lookup tables. Click on 'Browse . On the Metadata Connection page, enter the database password to access the MicroStrategy metadata. If this is not the correct path, you can find the path by running locate MSIReg. ; Create a new Data Source Name on the MicroStrategy Intelligence Server 9. Cloud. Select the database instance. *; This customization is provided as a convenience to. From MicroStrategy documentation: "Project sources represent a connection to a metadata database or a MicroStrategy Intelligence Server. *; import com. Select the Statistics & Enterprise Manager Repository check box and click Next. Run MicroStrategy Backup. In order to track each delivery being process on the MicroStrategy Intelligence Server, users can track the entries on ‘. For information on how to create a Configuration Wizard response file, see. Click Yes. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. A Server Definition Object. 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). In the MicroStrategy Enterprise Manager 9. Users are defined in the MicroStrategy metadata and exist across projects.