How to find microstrategy metadata. " It is usually a file or database that describes another set of data or information. How to find microstrategy metadata

 
" It is usually a file or database that describes another set of data or informationHow to find microstrategy metadata  MicroStrategy Backup Preparations

and run another dependency search and so on. MicroStrategy remains ranked #1 in Portfolio Capabilities in the 2023 edition of the BARC Score. From the drop-down menu, choose the database instance against which the user ID should be verified. On Metadata Repository Connection Information, click Apply. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. MicroStrategy Schema Modeling. How to Update the Database User Password. 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. Verify the components you want to upgrade and click Next . However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. If MicroStrategy Platform Analytics was selected in a previous installation, it is automatically selected in Select Components. From the Metadata drop-down list, specify the language in which to display the. 3 Metadata and Statistics tables implemented in Microsoft SQL Server. Platform Analytics. This tool will let you create a MicroStrategy metadata, configure an Intelligence Server,. Thus, while the engine attribute role option makes it more convenient to use. 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. This approach makes it easier for you to specify a flexible partitioning. Before running ScanMD, a database backup of the metadata must be made. The Freeform SQL functionality allows you to use your own SQL statements to generate reports, instead of using the MicroStrategy Engine-generated SQL. If in some extreme scenarios, the deadlock still occurs after the. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend >and integrate the MicroStrategy business intelligence functionality into other applications. The NCS Authentication dialog box opens. The two known languages that have this issue are English-New Zealand and English. The DSN should provide a unique description of the data, for example, Payroll_Project_Metadata or Payroll_Warehouse. Enter the User Name and Password for the database. Named User Licenses, in which the number of users with access to specific. When working in 3-tier, the user will need to modify the project source definition by going to Configuration Wizard and choosing 'Set up MicroStrategy Intelligence Server'. This video shows basic steps of MD upgrade process. AdditionalDSNs. How to Update the Database User Password. x warehouse and statistics tables. Open the key named 'LOCATION'. x and 10. The destination project must be updated first. 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. Generate SAML Configuration Files. sh file when the home and install paths are differentFor steps to complete various configurations tasks with the Configuration Wizard, see the sections listed below: Once you reach the Summary page for a configuration, click Save. Under Desktop/Developer browsing options, choose 'Display hidden objects'. mstrio: Simple and Secure Access to MicroStrategy Data . Open the registry on the machine where users installed MicroStrategy Intelligence Server. 9. Open both folders in which the user is located for each project source. cube files corresponding to the cube instance ID; The complete set of *. Third Party Software InstallationTo create to a direct project source. metadata_connection_string The connection string Intelligence server uses to connect to the metadata database. Open the exported excel file in Microsoft Excel and sort the results by column 'Enabled'. The following steps generate the application metadata ( SPMetadata. Select an Environment from the upper-left drop-down. 11. 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. To help you determine the time limit, use Enterprise Manager to find out the average and maximum report execution times for your system. KB484282: MicroStrategy Db2 connection times out after Db2 backup and restore. However, when using the Configuration Wizard via the console administrators are not presented with a list of server definitions to choose from nor is. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. You are now positioned to run the MicroStrategy Backup client. xml) for configuring SAML. The RDBMS for the metadata and warehouse do not need to be the same. objects. Dependencies. In the Platform Analytics directory, located in C:\Program Files (x86)\MicroStrategy\Platform Analytics\, open the bin folder. VIEWS view. reg as this file will only exist in the MicroStrategy install path. 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. If a matching user is found, the project. Last updated: Apr 12, 2019. x - 9. Intelligence Server uses ODBC to connect to and communicate with all database servers in the system. Enable users to interact with personalized chat for further product discovery. The metadata repository is a collection of tables that contain the definitions for nearly all MicroStrategy objects including database logins, server definitions, database instances and connections, reports, metrics, facts, and so on. )3. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. Although it is possible to use the Microsoft Access database. You link this imported data to define attributes and metrics. x metadata Number of Views 2. When an Administrator reconfigures the Intelligence. The Scan MD tool executes tests to detect inconsistencies in the metadata. Define the statistics and enterprise warehouse database. MSTRPwd. Introduction to the REST API. From MicroStrategy documentation: "Project sources represent a connection to a metadata database or a MicroStrategy Intelligence Server. Set up the Enterprise Manager. If the connection information to the MicroStrategy Repository has changed since the last installation, you are prompted to provide the database login username. 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. The following information assists you in setting up ODBC between Intelligence Server and your metadata database and data warehouse. The utility is found under Program FilesCommon FilesMicroStrategy. Only the database names listed in DBAdminConfig. 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. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. In the following sample code, several parameters must be adjusted to match environment specific values, such as project names and login information. Tables are created through the MicroStrategy Warehouse Catalog. This video walks users through the process of installing and running the mstrbak tool and how to use it. csv - information about every user group in the metadata. MicroStrategy actions (executions, session, etc. import com. The MicroStrategy system uses the metadata to know where in the data warehouse it should look for information. For instructions on using. Platform Analytics uniquely identifies metadata using a combination of the following fields: metadata_guid The GUID generated by MicroStrategy when the metadata is created. x metadatas that may prevent MicroStrategy 9. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. MicroStrategy uses the credentials provided by the user to search for and validate the user in the LDAP directory. x metadata Number of Views 2. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. Note: MicroStrategy metadata will be created in the metadata2019 database in MySQL Server. Run MicroStrategy Backup. 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. 1. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. For steps to create a project source, see the. There's a reason we're at the top of the list. ; Go to Connection Type > Direct (2-tier), and click Next. i686 package included with your install media. On the next screen do not enter any password, just click Next. x has the capability to authenticate and import users and groups from an existing LDAP Server into the MicroStrategy Metadata. 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). 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. MicroStrategy is configured, and a user is able to run the report and retrieve the data via ODBC. /mstrcfgwiz. Edit the line within the function that takes your login input. So I want to create an embedded query to know which last objects were modified by an user and that sort of things. MicroStrategy metadata is like a road map or an index to the information that is stored in your data warehouse. Database Instance. Run MicroStrategy Backup. Cube details, projects, folders or events in the json request can be discovered by GUID or name, since MSCT will search the MicroStrategy metadata for the objects it needs to complete the request and find any missing data; Logging of all json request messages, updated versions of requests and status of requests that are executed;. The Enterprise Manager project can be created on a machine with your production metadata. The server definition is a set of settings stored in the metadata which contain information about configuration locations, governing settings, and other system and project specific settings. Contact MicroStrategy Technical. 1, you must. Windows NT authentication: The Windows NT SID. ServerDefTo set up MicroStrategy Intelligence Server. The Metadata Update Utility is a utility responsible for updating the metadata with the latest project information based on the version of MicroStrategy Developer from the machine on which the utility is installed and. However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. To do this, from the Start menu, point to All Programs, then MicroStrategy Tools, then select Repository Translation Wizard. From the Tools menu in MicroStrategy Developer 9. Stop the MicroStrategy Intelligence Server 9. Schema objects are logical objects that relate application. One of the following situations is possible: There is one and only one match: That matching metric is used as the input. Select Metadata, History List and Statistics Repository Tables and click Next. You can retrieve subscriptions by filtering for Object Type = Subscriptions/Schedule. Security Filters. 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. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. MicroStrategy also supports using API calls to retrieve catalog information. MicroStrategy metadata is like a road map or an index to the information that is stored in your data warehouse. Change the system language for the machine. 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. Drive revenue growth with memorable app workflows and AI features that really speak to the user. 4. x-10. x, the correct results were shown even if a user activity metric was on the report. <None>. Named User Licenses, in which the number of users with access to. Administrators on MicroStrategy Intelligence Server Universal 9. The REST API is designed to help developers build data-driven client applications quickly. The MicroStrategy Intelligence Server 9. 842 views. A metadata management solution becomes even more valuable when it is active. MicroStrategy has a metadata-driven architecture. All articles. It is a database where the whole “skeleton” of the tool is located. Type, Subtype and extType parameters of objects can be used to narrow down the search. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. SQL queries in this document have been written for MicroStrategy 9. Before running ScanMD, a database backup of the metadata must be made. ' (or something like that. 3%. Configuration Wizard fails when configuring the MicroStrategy Intelligence Server. MicroStrategy metadata. The following sample code shows how to search for "My Reports" folder inside MicroStrategy. /mstrcfgwiz. 4. 2) Run the following SQL against Metadata Tables: Sql select PROP_VAL from DSSMDOBJPROP. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. There's a reason we're at the top of the list. x and above. Click Configure Intelligence Server. Runs the client in Prompted mode. 825. 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. ). The diagram below illustrates three-tier metadata connectivity between the MicroStrategy metadata database (tier one), Intelligence Server (tier two), and Developer (tier three). This table is used for defining some property values which will be used in certain DS tables. The Mapping pane in the Freeform SQL Editor is where you map the columns in your SQL query to attributes and metrics that will appear in a MicroStrategy report. log file. 02:41 01:34 Still need help? Open a support case Watch this video on how to upgrade the Microstrategy 10. Learn more. The users' Partition Mapping Table appears in the left window. Follow these guidelines when you search by a. If this is not the correct path, you can find the path by running locate MSIReg. Click on 'Browse . You are now positioned to run the MicroStrategy Backup client. 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. Mapping columns to metadata objects. The password of a metadata user with full administrative privileges (Administrator is recommended). For detailed information, query the INFORMATION_SCHEMA. 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. A flag is any character allowed by the database. Open the MicroStrategy Configuration Wizard. Select “MicroStrategy SDK”. exe. Select Configure Intelligence Server, and click Next. Access MDUpdateUtil. Note: This setting has to be check for every MicroStrategy project logging statistics. Follow these steps in a 3-tier. yaml are backed up by this tool. The MicroStrategy Repository Administration tool’s backup operation is based on the database information in DBAdminConfig. This approach makes it easier for you to specify a flexible partitioning. Create a new DSN using the new connection from step 1 using MicroStrategy Connectivity Wizard. The DSN and Login ID are provided based on the server configuration that you did previously. Find out the Object name from DSSMDOBJNAMES table, using object id found. Open the ODBC Administrator and edit the pre-created Amazon Redshift DSN. In MicroStrategy Developer, choose File > New > Report. Under Collections, click on the the “…” next to. Prompts guide you through testing your ODBC. The destination project must be updated first. In order to use the provided MicroStrategy Enterprise Manager reports and documents, the Enterprise Manager project must be created in a Metadata. Users of MicroStrategy Web can also connect to data sources using database connections. MicroStrategy is usable in both forms, web and desktop tools, whereas Cognos is a web-based reporting tool mechanism. Enter the connection information for the SQL Server and click Finish. Now available for feature release—MicroStrategy 10. Companies traditionally store user data in a database, a Windows domain, or a directory server. Learn how to use an external REST client to run MSTR related REST requests. The data loading process gathers and prepares data for analysis and reporting in the Enterprise Manager project. Under Desktop/Developer browsing options, choose 'Display hidden objects'. Set Data Retrieval Mode to the setting Allow Native API at the report level: 2. MicroStrategy is configured, and a user is able to run the report and retrieve the data via ODBC. Input Location; BakFileLocation. , Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the, metadata. Select Configure Intelligence Server, and click Next. There is more than one match: You are prompted to select the metric to use. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. Metadata is stored in a relational database with a predefined structure. The TABLES and TABLE_OPTIONS views also contain high-level information about views. Find the folder 'Version Update History' and collect a screenshot of showing all the entries within that folder. Manage and Verify Your Licenses. a relationship table. REL_. The INFORMATION_SCHEMA. Refer to the following MicroStrategy Knowledge. Enter the User Name and Password for the database. For example: Some objects' dependencies cannot be searched or do not appear through Desktop, like a Database Instance. An example of such a field is an object GUID. For each Table object, right click on the table and choose 'Search. Ans: Statistics tables contain data on the MicroStrategy system’s usage and performance and are populated by all projects that are configured to log statistics. Users can do it from MicroStrategy Desktop > Project Configuration > Statistics > General. In the Navigation pane, click Users and Groups. Transform description: This transform displays project status on the Projects page. Open the key named 'LOCATION'. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. List the names of any additional DSNs that will be needed in the new environment. Click Next. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Go to Project access, to give Public/Guest basic access to the project. And by this, I mean all objects: Attributes, tables, names, users, states, object information, etc. Highlight the table and select the arrow pointing to the right. To search for managed objects only, select Display Managed Objects Only. After you install an ODBC driver, you can define one or more data sources for it. Click on OK to save the preferences. Parallel Upgrade or Metadata Migration with Platform Analytics. 825. Click the link for the desired manual or other documentation source. Click the New User icon on the toolbar. Defines whether to upgrade the metadata, as determined by the following. By default, the mstr database. From the drop-down menu, choose the database instance against which the user ID should be verified. In a report using application-level partitioning (MicroStrategy metadata or warehouse partitioning), the SQL submitted to the database depends on the results of "pre-queries" that identify the partitions which are relevant to the report filter. Only executions related to subscriptions will have a valid recipient. The user can also write the SQL Trace to a new log file by selecting the option from the drop down. There's a reason we're at the top of the list. In the Source drop-down list, select Google. Runs the client in Prompted mode. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. For example, if you want to create a new user in the Web Reporter group, click the Web Reporter group link. MicroStrategy metadata. This procedure provides the steps on how to return the latitude and longitude for a single address. x, an attribute form called 'Enabled Status' has. 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. If you. 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). Different properties of a MicroStrategy metadata object that can be listed using Command Manager 9. 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. How To Perform an Upgrade with MicroStrategy Backup. The Save dialog box opens. Open Windows Services and locate MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. MicroStrategy supports multiple languages, whereas Cognos provides a customizable dashboard. UTF-8 . Type N and click Enter to provide different. TABLES WHERE table_schema =. 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. ), by default returns all tables in all databases and schemas. Intelligence server and metadata: MicroStrategy Intelligence server and metadata versions should always match. I know which tables to query because I googled it and I found this blog entry, but I don't know. Beginning in MicroStrategy 2020, there is a new feature, Unified Quoting, that can help in all of the above situations. MSTRInstallPath: By default, on cloud environments it is /opt/mstr/MicroStrategy/. 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 the drop down for the corresponding 'File Log' and choose the log file to which the SQL Trace needs to be written into. 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:. MicroStrategy does not pass the report back and forth between the engines, returning to the SQL. 23K. A command prompt opens. The Object Telemetry dossier contains a great deal of subscripton information. Additional flat files will be restored to a single directory. Follow steps below to find out all the Freeform SQL Reports in a project in MicroStrategy Developer: Go to Tools > Options > Enable "Show 'Contains' and 'Contained by ' tabs" as shown below: Click OK > Go to "Contains" tab and select Logical Table for "Contains any object of this type" as shown below: Then go to Object Types tab and select. Regardless of your synchronization settings, if a user's password is modified in the LDAP directory, a user must log in to MicroStrategy with the new password. If the metadata server instance is shutting down unexpectedly, very likely a core file will exist in the MicroStrategy folder structure. 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. 5. 1. There's a reason we're at the top of the list. These are discussed below. Our top marks in this year’s new category follow 3+ years of #1 ratings in the now-retired Enterprise Analytics use case. Connect the metadata update utility to a two-tier project source whose Data Source Name (DSN) points to the metadata. A Project Source could be defined as a direct or indirect access point to the metadata. Ensure a metadata backup is taken prior to performing the below actions. To do this, select the first option in MicroStrategy Configuration Wizard and follow the steps from there. In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager. Right mouse click the grid and choose 'Export Results -> to Excel'. Use the project duplication function to duplicate only the Tutorial project to your metadata. To query the. Additional DSNs require the same credential and server location as the metadata. 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. x. 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. Each login mode specifies a particular mechanism or authority to be used for authentication. The most fundamental objects stored in the metadata are schema objects. 5/5 videos | 17M 9S total runtime. To view this field, the Intelligent Cube must be published at least once. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. Watch this video on how to upgrade the Microstrategy 10. From the Home menu, select one of the following: To save a report, select Save. To set up MicroStrategy Intelligence Server. 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). 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. Using MicroStrategy Enterprise Manager 9. MicroStrategy licenses are managed differently according to the license type that is purchased. 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. properties file stores the values of how often caches are loaded into memory. Enter the User Name and Password for the database. 4. Click Next. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Within the Registry Editor go to: 32 bits: HKEY_LOCAL. Select the group in which to create a user. There's a reason we're at the top of the list. bigint(20) connection_time. In my opinion, MicroStrategy has a better product architecture. 2 Enterprise Architecture Enterprise Architecture consists of a two to eight node highly available cluster for MicroStrategy Intelligence Server, Web, Mobile, Collaboration, and Identity. 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. metadata_connection_string The connection string Intelligence server uses to connect to the metadata database. Refer to your MicroStrategy contract and any accompanying contract documentation for descriptions of the different MicroStrategy license types. Create a new two-tier project source using the DSN created. 8. This mode asks the user for information about the location of various. Choose the. If user A belongs to group A and B at the same time but user B and C belong to only one of groups, a report filter as 'User Group = Group A, B' in a report in MicroStrategy Enterpriser Manager 9. After this change, when creating a metadata via the Configuration Wizard, the test schema will be used. Below are the new features exclusive to. Then click 'OK'. exe and click Enter. x to PostgreSQL 9. The modeling tool allows architects to transform a complex enterprise data environment. Third Party Software Installation: WARNING: The third-party product(s) discussed in this technical note is manufactured by vendors independent of MicroStrategy. 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. . This Knowledge Base article describes a known issue in MicroStrategy 10. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Enter user information in the Create New User dialog. In some business scenarios, it is required to duplicate a project's metadata to a Microsoft Access file. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformScan MD. The diagram below illustrates three-tier metadata connectivity between the MicroStrategy metadata database (tier one), Intelligence Server (tier two), and Developer (tier three). x using the MicroStrategy Configuration Wizard. In this instance, find the one associated with SQL Server. Steps: 1) Identify the object ID of the Intelligent cube to be audited by checking the objects Property windowIn MicroStrategy SQL Generation Engine 8. MicroStrategy recommends that you always create the response file through the GUI mode of the Configuration Wizard. 93K KB428983: The “List_Server_Config_Properties_Outline” script in MicroStrategy Command Manager 10. 4. In the Source area, select the database instance for your Excel file. With a backup of the metadata in place, proposed fixes should only be accepted if the full impact of the fix is understood. Platform Analytics consumer performs a standardization. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. The MicroStrategy configuration wizard is used to upgrade the metadata from 8. Sample folders named as below:. On the Metadata Connection page, enter the database password to access the MicroStrategy metadata. The transformation ensures that reporting on MicroStrategy metadata content is feasible. x. Smart. 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. On the next screen the DSN information will be pre-populated. To create a metadata repository. You can retrieve subscriptions by filtering for Object Type = Subscriptions/Schedule. x products from functioning correctly. The back up and restoration of files requires your discretion. Connect the metadata update utility to a three-tier project source pointing to the UNIX Intelligence Server. Identify those objects in their own folders. Third Party Software Installation Warning: The third-party product(s) discussed in this technical note is manufactured by vendors independent of MicroStrategy. If necessary, enter the database you wish to use for this Narrowcast Server. You can find the list of supported RDBMS.