Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. 0:Scan MD. , Unified. If necessary, enter the database you wish to use for this Narrowcast Server. Named User Licenses, in which the number of users with access to specific. 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. All articles. 3% of resumes. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. On the Select Components page, select the check boxes for each Intelligence Server you want to upgrade. Select Configure Intelligence Server, and click Next. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. To do this, select the first option in MicroStrategy Configuration Wizard and follow the steps from there. Each user has a unique profile folder in each project. To search for managed objects only, select Display Managed Objects Only. List the names of any additional DSNs that will be needed in the new environment. mstrio: Simple and Secure Access to MicroStrategy Data . The Scan MD tool executes tests to detect inconsistencies in the metadata. Find the folder 'Version Update History' and collect a screenshot of showing all the entries within that folder. x does not return full c…What is MicroStrategy Metadata? The Metadata is where all the MicroStrategy definition is stored. 825. Click "Next". If you are in compliance, a message appears. ), by default returns all tables in all databases and schemas. yaml. Download the software from the MicroStrategy download site. This will return the 32 - digit GUID for the metadata. Detail Levels You can now select the level of detail exported from your dossier. 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. TO LEARN MORE: To Learn More about Enterprise Manager, please see Chapter 17 in the System Administrator's Guide. log and contact MicroStrategy Technical Support in this case. For information on how to create a Configuration Wizard response file, see. The metadata ID for which the user session was connected. MicroStrategy support connects you to the most helpful & experienced technical experts in the industry. MicroStrategy AI is here. The Import feature in MicroStrategy Developer looks in the metadata for metrics that match that name. x, the correct results were shown even if a user activity metric was on the report. The diagram below illustrates three-tier metadata connectivity between the MicroStrategy metadata database (tier one), Intelligence Server (tier two), and Developer (tier three). Information on the MicroStrategy Tutorial project is provided in the Project Design Help. mdb" and located at: "<install_drive. Go to the. This project contains out-of-the-box reports to demonstrate the various features of MicroStrategy ONE. From the DSN drop-down list, select the DSN for your statistics and Enterprise Manager repositories. By definition, a metadata is "data about the data. MicroStrategy Tutorial Reporting. The Scan MD tool searches for logical errors and fixes them within the platform object structure. The user can also write the SQL Trace to a new log file by selecting the option from the drop down. MicroStrategy Workstation puts the full capabilities of your MicroStrategy environment just a couple of clicks away. Windows NT authentication: The Windows NT SID. This table is used to store. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. log and contact MicroStrategy Technical Support in this case. It will not show users whose number of jobs is 0. metadata_connection_string The connection string Intelligence server uses to connect to the metadata database. You are returned to the Summary page. 4. 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. You can create the metadata repository in the database location of your choice. 1. Locate the web. Only the database names listed in DBAdminConfig. 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 Source area, select the database instance for your Excel file. This table is used for defining some property values which will be used in certain DS tables. In the Open drop-down list, type cmd and click OK. These automatic aliases are not saved into the metadata and cannot be edited in MicroStrategy Developer. When a Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. Enter the connection information for the SQL Server and click Finish. In order to create an ODBC DSN in MicroStrategy Intelligence Server Universal, it is possible to use the utility mstrconnectwiz. Right click the database and under “Tasks” choose “Backup”. There's a reason we're at the top of the list. 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;. . While some duplicate columns in a MicroStrategy schema are necessary or benign, a user may experience issues that require the assistance of Technical Support in. MicroStrategy is configured, and a user is able to run the report and retrieve the data via ODBC. In MicroStrategy 10. These two tables are introduced for mobile push notification to store information for mobile device key. This GUID is created at the time of Metadata creation, and is unique to each metadata. There's a reason we're at the top of the list. 93K KB428983: The “List_Server_Config_Properties_Outline” script in MicroStrategy Command Manager 10. exe. On Windows from the command line, perform the following steps: From the Windows Start menu, select Run. When a new distribution services message is received with a recipient, a new entry is added into lu_recipient and fact_access_transaction table. x, MDMover should be used to migrate the Metadata database between database server. In the MicroStrategy architecture, each object is identified by its unique Object ID. log file. 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. AdditionalDSNs. KB484282: MicroStrategy Db2 connection times out after Db2 backup and restore. ; Go to Connection Type > Direct (2-tier), and click Next. 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. The objects stored in the metadata are reusable. The user should locate the VLDB. 4. It supports for all new and updated features in MicroStrategy. Type your MicroStrategy login and password for the selected Intelligence Server and click Connect. Type, Subtype and extType parameters of objects can be used to narrow down the search. x and newer, the default maximum number of concurrent connections that MicroStrategy Intelligence Server can make to the metadata, is 0x0fffffff. In the Platform Analytics directory, located in C:Program Files (x86)MicroStrategyPlatform Analytics, open the bin folder. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. Configure Metadata Connection. ) 3. For 'Enabled=true' means the user is enabled in metadata while 'Enabled=false' means the user is disabled. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Click on OK to save the preferences. x. Createa new metadata shell. From the Windows Start menu, go to Programs > MicroStrategy Tools > DB Query Tool. Designed with automatic alerts, Insights is powered by machine learning (ML) models to analyze data behind the scenes and surface key trends, outliers, or anomalies. Users of MicroStrategy Web can also connect to data sources using database connections. Intelligence Server uses ODBC to connect to and communicate with all database servers in the system. Learn more about Collectives. Select Configure Intelligence Server, and click Next. 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 direct connection deployments, client products (such as MicroStrategy Developer) should also be. The most fundamental objects stored in the metadata are schema objects. a. The DSN and Login ID are provided based on the server configuration that you did previously. MicroStrategy has a metadata-driven architecture. exe. The relationship between the LDAP user and the MicroStrategy user is maintained using a link in the MicroStrategy metadata, which is in the form of a Distinguished Name (DN) specified for the user. MicroStrategy is configured, and a user is able to run the report and retrieve the data via ODBC. Connect the metadata update utility to a three-tier project source pointing to the UNIX Intelligence Server. 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 MicroStrategy configuration wizard is used to upgrade the metadata from 8. exe and click Enter. Manually editing values in the MicroStrategy Metadata incorrectly may cause serious, project-wide. Start the Command Manager graphical interface: In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. Find MicroStrategy’s public API in Postman and make your own copy (Fork). On the metadata Connection page, enter the database password to access the MicroStrategy metadata. It also stores other types of objects that allow you to access that information. csv - information about every user in the metadata. Your MicroStrategy Backup is restored on your new environment. The destination project must be updated first. If MicroStrategy Platform Analytics was selected in a previous installation, it is automatically selected in Select Components. Find the folder 'Version Update History' and collect a screenshot of showing all the entries within that folder. 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. Choose MicroStrategy ODBC Driver for Microsoft SQL Server. Where is the connection information stored? The diagram below illustrates three-tier metadata connectivity between the MicroStrategy metadata database (tier one),. Metadata is stored in a relational database with a predefined structure. This opens a Quick View of the Intelligent Cube information and usage statistics. Type, Subtype and extType parameters of objects can be used to narrow down the search. Restoring with MicroStrategy Backup allows you to create mirror environments to test new projects, create disaster recovery environments, migrate current MicroStrategy deployment to the cloud, and more in a same or newer MicroStrategy version. MicroStrategy also supports using API calls to retrieve catalog information. The DSN and Login ID are provided based on the server configuration that you did previously. log and MicroStrategy License Manager is the version of the base build installed in that machine. You do not have to define users for every project you create in a single metadata repository. | Meet MicroStrategy AI on the road. For example: Some objects' dependencies cannot be searched or do not appear through Desktop, like a Database Instance. ini file. Companies traditionally store user data in a database, a Windows domain, or a directory server. KB441856: In MicroStrategy 10. For each project requiring database authentication: Open Project Configuration. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. 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. This tool will let you create a MicroStrategy metadata, configure an Intelligence Server,. Learn more. Enter the User Name and Password for the database. xml file located in the WEB-INF folder of the MicroStrategy Web installation directory. The search will provide you a list. x when configuring Intelligence Server via Configuration Wizard on Windows OS to point to a metadata in PostgreSQL 9. Within the Registry Editor go to: 32 bits: HKEY_LOCAL. Create an empty metadata shell in a Microsoft Access file. x - 9. Configuration Wizard fails when configuring the MicroStrategy Intelligence Server. If a matching user is found, the project. This mode asks the user for information about the location of various. VIEWS view. Change the value ' md5 ($#####) ' with ' $##### ', (aka removing the md5hashing of your input). The following information assists you in setting up ODBC between Intelligence Server and your metadata database and data warehouse. The "Find and Replace" tool can be found in the "Tools" menu of MicroStrategy Developer: To replace an object, follow these steps: Select the object to be replaced (dependee). The two known languages that have this issue are English-New Zealand and English. Delete the first and the last line of the web. 1) Create a DSN that connects to the MicroStrategy 9. Reload the login page. Select the data source from the Data Source Name drop-down list. The users' Partition Mapping Table appears in the left window. 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. Input Location; BakFileLocation. The metadata also stores the definitions of all objects created with MicroStrategy Developer and Web such as templates, reports, metrics, facts, and so on. The Backup file can only be restored to environments with the same or higher version numbers. Host Bill Safer helps you learn how to find that hidden antique or collectible that just may add cash to your life at either a yard,. el6. Click Next. Number of Views 8. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. In MicroStrategy Developer, choose File > New > Report. On the Summary page, review the upgrade choices and click. From the Metadata drop-down list, specify the language in which to display the. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. 4. If any problems arise see section on Troubleshooting. Under Desktop/Developer browsing options, choose 'Display hidden objects'. Regards DipankerMicroStrategy SQL Generation Engine 10 can automatically detect tables where the same column is used to create two different attributes; Business Case Scenario:. The following is a standalone Java example to check the different preferences level for a given user's session. Select Export Translations as a translation action and click Next. However, in the cases where there is an existing MicroStrategy user structure and fewer users, a simpler strategy would be to link. The MicroStrategy Intelligence Server 9. <!--. This knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. Click Next. Right-click on the project "MicroStrategy Tutorial" and select Project Configuration. Object layers contain and store the objects created in MicroStrategy. 4. Tables are created through the MicroStrategy Warehouse Catalog. It is used by MicroStrategy Developer and other client interfaces to build, interact, and manage the contents of the MicroStrategy metadata. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. Enter the User Name and Password for the database. Click User Manager . The Metadata is where all the MicroStrategy definition is stored. You link this imported data to define attributes and metrics. The Save dialog box opens. This chapter addresses the processes necessary to. ; Create a new Data Source Name on the MicroStrategy Intelligence Server 9. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. 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. This is a Microsoft Access file called "EM_Proj_MD. 5. Micro Strategy also supports mobile BI. MSTRInstallPath: By default, on cloud environments it is /opt/mstr/MicroStrategy/. The number of users assigned will be compared against the. For information on how to create a Configuration Wizard response file, see. Required Status to Perform Action. A Project Source could be defined as a direct or indirect access point to the metadata. 8. If desired, select the Do not ask me again checkbox to avoid showing this message for any dossiers, documents, or reports in the future. 825. Click on 'Browse . 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. This KB article describes how on Windows and Linux systems. You can use MicroStrategy Web to import data from different data sources into MicroStrategy metadata with minimum project design requirements. Selected. Create a new database instance. This data can be used to create a dataset or to modify an existing dataset in a Data Import cube. 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. On the General tab, type the following information:The PAConsumerConfig file consists of the following parts: paParentConfig: Common configurations for the Telemetry Server (Kafka) and Telemetry Manager (Zookeeper) across TopicsGroups. It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct. When setup successfully, it is recommended to follow. MicroStrategy has a metadata-driven architecture. 1. Beginning in MicroStrategy 2020, there is a new feature, Unified Quoting, that can help in all of the above situations. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. Go to Project access, to give Public/Guest basic access to the project. Attempting to access /MicroStrategy or /MicroStrategyMobile should redirect the user to first authenticate. Manage and Verify Your Licenses. Before discussing the details of the LDAP integration the following commonly used terms are explored in some detail: MicroStrategy on AWS: Metadata Backup and Restore. There's a reason we're at the top of the list. A Server Definition Object. MicroStrategy users need connectivity to the metadata so that they can access projects, create objects, and execute reports. TABLES WHERE table_schema = "TEST_md" Database Administration Tool. After this change, when creating a metadata via the Configuration Wizard, the test schema will be used. Database Instance. The diagram below illustrates three-tier metadata connectivity between the MicroStrategy metadata database (tier one), Intelligence Server (tier two), and Developer (tier three). In this document, you will find a database function “MSTRUID” used in multiple places. Platform Analytics is a telemetry tool that supports telemetry capture from multiple MicroStrategy deployments simultaneously. All schema objects, application objects, configuration objects, and project settings are stored in the MicroStrategy metadata. Find an event in a city near you. MicroStrategy actions (executions, session, etc. From the DSN drop-down list, select the DSN for your statistics and Enterprise Manager repositories. Although it is possible to use the Microsoft Access database. MSTRPwd. Manually editing values in the MicroStrategy Metadata incorrectly may cause serious, project-wide. Users are defined in the MicroStrategy metadata and exist across projects. You can retrieve subscriptions by filtering for Object Type = Subscriptions/Schedule. On the next screen do not enter any password, just click Next. 1 Answer. Intelligence server and metadata: MicroStrategy Intelligence server and metadata versions should always match. LU_Groups. Click tab 'Display' and select 'Results to grid' in the dropdown list. paEtlConfig: Configuration for the Telemetry Store (Platform Analytics Consumer) to perform data processing. Select Display Managed Objects. In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager. To set up MicroStrategy Intelligence Server. To add or modify a given object translation, currently existing translation needs to be exported first. The Repository Translation Wizard allows users to set flags in the translations table to control which strings are imported back into the metadata. Proactive. After establishing the new DSN, open Configuration Wizard to configure a new metadata. Select an Environment from the upper-left drop-down. There's a reason we're at the top of the list. In my opinion, MicroStrategy has a better product architecture. When querying against its metadata database, MicroStrategy is coded to detect deadlocks and will retry the transaction 3 times before aborting it. There's a reason we're at the top of the list. The destination project must be updated first. The value of this key is the name of the DSN that MicroStrategy Intelligence Server uses to connect to the Metadata. Project default level preferences are set at the MicroStrategy Intelligence Server 8. The update utility, like Desktop, can use an Intelligence Server on any supported operating system interchangeably. The following procedure describes how to achieve this. Click Configure Intelligence Server. Organizations can use Unity Catalog to securely discover, access, monitor and collaborate on files, tables, ML models, notebooks and dashboards across any data platform or cloud. In Platform Analytics, application and schema objects are captured by the object attribute with the. MicroStrategy is usable in both forms, web and desktop tools, whereas Cognos is a web-based reporting tool mechanism. KB442629: How to check topic data in Linux for MicroStrategy Platform Analytics 11. 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. Ensure telemetry service is enabled by running below query in Command Manager: LIST ALL PROPERTIES FOR SERVER CONFIGURATION;Click Next. x metadatas that may prevent MicroStrategy 9. x-10. The update utility, like Desktop, can use an Intelligence Server on any supported operating system interchangeably. Smart. The metadata repository is a collection of tables that contain the definitions for nearly all MicroStrategy objects including database logins, server definitions, database instances. x, fact tables may be partitioned using warehouse partition mapping tables or metadata partition mapping tables. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. Warehouse Catalog. Defining DSNs. The version displayed in the DSSErrors. The Scan MD tool executes tests to detect inconsistencies in the metadata. Become a More Intelligent Enterprise. There's a reason we're at the top of the list. mstrio provides a high-level interface for Python and R and is designed to give data scientists, developers, and administrators simple and secure access to their MicroStrategy environment. Database requests from either the MicroStrategy metadata or the data warehouse; SQL generation; Analytical Engine processing (subtotals, cross tabulation, analytic functions). MicroStrategy - Architecture. x, the statistics tables and warehouse creation process is all handled by Configuration Wizard via the Create Metadata, History List and Enterprise Manager Repositories option. Create a new two-tier project source using the DSN created. 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. In addition,. If the connection information to the MicroStrategy Repository has changed since the last installation, you are prompted to provide the database login username. Stop the MicroStrategy Intelligence Server 9. (in case you have xml file prepared, you can use it to initialize the wizard) Select project source and enter credentials. Enter the User Name and Password for the database. Enter the user name and password you wish to use to connect to the Narrowcast Server. Named User Licenses, in which the number of users with access to. 4. From the Tools menu in MicroStrategy Developer 9. Each login mode specifies a particular mechanism or authority to be used for authentication. In the Navigation pane, click Users and Groups. Additional DSNs require the same credential and server location as the metadata. However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. TABLES view. From the Language drop-down list, specify the language in which to display MicroStrategy Web pages. Open Windows Services and locate MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. Follow these steps in a 3-tier. Open the terminal and run the command locale to check the current system locale. Configure and store credentials for the login. 0. Open the ODBC Administrator and edit the pre-created Amazon Redshift DSN. MicroStrategy | 4 4. To list out all the users, perform an outer join of the attribute based on the report template. Hive. User Name: Type the user name for the user that can connect to the data source. ODBC is a standard method of communicating with database servers. This setting is ideal if you have numerous. And by this, I mean all objects: Attributes, tables, names, users, states, object information, etc. Exported data files can be later used in dossier for further analytics or visualization. SQL scripts transform the statistics data into a form that can be useful for administrative reporting. 3 Metadata and Statistics tables implemented in Microsoft SQL Server. There's a reason we're at the top of the list. The sample code explains the necessary steps to retrieve all User Groups and Security Roles exsting in a Metadata by using the MicroStrategy Intelligence Server API in MicroStrategy SDK 9. xml) for configuring SAML. Refer to the following MicroStrategy Knowledge. Next to All Users, click Create a new User . Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. There's a reason we're at the top of the list. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 4. Launch the Configuration wizard and choose to create repositories then select metadata. This approach makes it easier for you to specify a flexible partitioning. import com. The Freeform SQL functionality allows you to use your own SQL statements to generate reports, instead of using the MicroStrategy Engine-generated SQL. The MicroStrategy architecture is a meta-driven type where metadata is the central repository of all the objects and can be used by all of the MicroStrategy products. On Metadata Repository Connection Information, click Apply. Set up the Enterprise Manager. Select the Statistics & Enterprise Manager Repository check box and click Next. Run following SQL: Cloud. Windows NT authentication: The Windows NT SID (security identifier) is validated against the NT logon context stored in the MicroStrategy metadata repository. 4. However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. 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. The RDBMS for the metadata and warehouse do not need to be the same. Choose “Save to Files. If the database authentication is successful, MicroStrategy will look for a user object in the metadata with the same database login name. ). Go to Database Instances > Authentication > Metadata. x, select 'Preferences'. The information is stored in a proprietary format. Select the object that will replace the dependee, the object type must be the same. yaml are backed up by this tool. Click "Configuration" , Advanced, then "Analytical Engine VLDB Settings" under Project Definition-> Details. folder. x to PostgreSQL 9. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. The DSN and Login ID are provided based on the server configuration that you did previously. Dependencies. 신뢰할 수 있는 AI를 빠르게 확장시키세요. For steps to create a project source, see the. NOTE: To perform this audit, queries are run against the MicroStrategy metadata database. When an Administrator reconfigures the Intelligence. Select the Statistics & Enterprise Manager Repository check box and click Next. Object Layer. This example assumes the metadata includes three projects that are using three different database instances with different DBMS and using different quoting patterns. After the PostgreSQL failover is finished successfully, the end user experience will depend on the Metadata connection timeout setting. Open the Repository Translation Wizard. Platform Analytics. ImpalaThe failure point is indicated in the Enterprise Manager Dataload log, mstrmigration. Platform Analytics has a unique way to identify each metadata connection to the Intelligence Server. Glossary . x using the MicroStrategy Configuration Wizard. These are discussed below. 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:.