This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. Organizations can now deploy MicroStrategy to a wider set of users across the enterprise, and get it into the hands of everyone – regardless of skillset, and for the first time, delivers the means to accelerate. 4. x to write data back to Salesforce. The Configure Transactions Editor opens. For background, we will give a brief introduction about each. For an introduction to Transaction Services, see the Advanced Reporting Guide. Description For enhanced security, starting from MicroStrategy version 2021 Update 4, for all the certified gateways, all SQL executions triggered from transaction services. Starting in MicroStrategy 2021 Update 8, you can use REST API requests to retrieve, create, and update the transaction reports. In this example, you execute a document called "Casino Analysis" (located in MicroStrategy Tutorial>Shared Reports>MicroStrategy Platform Capabilities>MicroStrategy Report Services>Visual Insight). For an introduction to Transaction Services, see the Advanced Reporting Guide. Do thee know the true potential from Transaction Services, one of MicroStrategy's flagship face? Find out what it is, what she could do with it, and thing you need to implement this. The MicroStrategy Tutorial project includes examples of Transaction Services. Example: Hive, Salesforce, MongoDB. ; Click OK. 3. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. If a user who does not have. For steps, see Starting MicroStrategy Web. Microstrategy Dossiers With the release of MicroStrategy 10. Right-click the Transaction object. It also includes predesigned sample reports. But in reality, many of these dimensional relationships change over time. It also includes predesigned sample reports. But in reality, many of these dimensional relationships change over time. Create an alert-based subscription in MicroStrategy Distribution Services on Web Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. For now, it only supports ODBC drivers on both Windows and Linux platforms. Run the Monthly Regional Sales Targets Planning document. It allows users to update data, insert new information or delete existing records from the database. Till now this is done in a . x If the issue is observed with transaction configured to update ID forms for attributes, this might be a known limitation in MicroStrategy 10. Hire Type: Contract, no. Selectors A selector can be displayed as a button bar, a drop-down list, radio buttons and much more. Duration: 2 months plus . Usually assigned by administrators, security filters control what warehouse data users can see within MicroStrategy. One is known as a transaction data model setup. Enable the option "Flag cells with modifed data" as shown in the. ; In the Source area, select the database instance for the data source to be updated using Transaction Services. This will remain until the user clicks within the text box and manually deletes the text. MSTR The key specified is the true key for that war. To help you explore the features of the MicroStrategy platform, sample reporting applications called MicroStrategy Tutorial and the Human Resources Analytics Module are provided. active=<Value> For example, to select MicroStrategy Transaction Services for installation, use:. The certificate confirms that the collector has paid and remitted all outstanding. The dossier transaction feature cannot be used with them. 3 release MicroStrategy did not ship a driver for Google BigQuery. 2. TradingView. Its tools and services are designed to be user-friendly and intuitive for both end users and BI professionals to perform such tasks as data discovery, data wrangling,. Is Team; Careers: work as a business news consultant; Services. Here the transaction document grid is not an editable element and the submit button is hidden. It can be used to perform transformations on a metric. select the attribute form to base the qualification on. 0:00 / 9:26 Using MicroStrategy Transaction Services MicroStrategy Community 4. It lists all sales opportunities in the pipeline, and it groups those opportunities. Example: Use live connect if you're trying to look at certain transaction details, such as transactions between 11:20AM UTC – 11:25AM UTC that originated from Virginia, and the product category Electronics. As a result the report throws. In MicroStrategy Developer, choose File > New > Report. Please submit "rock star" candidates. Authenticate a user and create an HTTP session on the web server where the user’s MicroStrategy sessions are stored. " 8. sh -silent -options <path of the options. On Monday, MicroStrategy (NASDAQ: MSTR) revealed that it purchased 6,455 BTC for USD 150M since mid-February. Navigate to and select a Transaction Services report, then click OK. MicroStrategy Transaction Services lets you embed write-back functionality into documents for the purposes of decision-making or initiating a transaction. Using MSTR Transaction Services one can leverage its power to create single UI and use it to register, organize operation services data, notifications, incidents etc. Select "Switch" from the Control Style drop-down; Click the Properties icon . These examples include all the reports, documents, and other objects and configurations that are required to use Transaction Services. MicroStrategy 10 is an optimized easy-to-use analytics platform that consolidates analytics, mobility, and security in a single integrated platform and delivers dashboards and compelling visualizations to enable data driven decision making to organizations and end-users through the AWS market place. The format of the DECODE function is as follows: DECODE (<value>, <statement1>, <directive1>, <directive_default>) To understand the meaning of and the construction of DECODE, look at how the previous query would have been written using. The third-party product(s) discussed in this article is manufactured by vendors independent of MicroStrategy. Do you know an true potential of Real Services, one of MicroStrategy's flagship features? Finds away what it is, what you canister do with it, and what yourself need to implement it. Refer to the Advanced Reporting Guide for more information on Transaction Services reports. Most customers take advantage of quick response time offered by dossiers or reports by querying a direct and concise slice of data utilizing the power of Snowflake. For example, users can type text in a text field, turn a switch on and off to specify a numeric value, select a value from a list, and so on. This request returns an authorization token (X-MSTR-AuthToken) which will be submitted with subsequent requests. If M1 does not equal any of the values in the list, then it returns a default value. 1) When I execute the STored Procedure by setting it in PreSQL. . You can review these Transaction Services example in the following MicroStrategy Tutorial project location: MicroStrategy Tutorial\Public Objects\Reports\MicroStrategy Platform Capabilities\MicroStrategy. blogspot. MicroStrategy Transaction Services lets people act on business information from a mobile device such as the iPad and iPhone, as well as from a dashboard on any web browser. MicroStrategy is an enterprise BI application software. No MicroStrategy Technical Support Case: DE60307: Barcode font Interleaved 2 of 5 (i2of5txt. MicroStrategy's mobile intelligence platform helps companies and organizations build, deploy, and maintain mobile apps across a range of solutions by embedding intelligence, transactions, and. The CaseV function takes a numeric value M1 as input and compares it to another numeric value V1. Save the transaction services report. In 2022, this BTC is worth. Determine what type of input object control is displayed to users when they view the Transaction Services-enabled document. A document designer can create a Transaction Services-enabled document to allow analysts to. You could use the ODBC Test Tool to test the validity of the procedure before creating the Freeform SQL report. In MicroStrategy Developer, choose Line > Fresh > Reports. – Sales register. Example: Use live connect if you're trying to look at certain transaction details, such as transactions between 11:20AM UTC – 11:25AM UTC that originated from Virginia, and the product category Electronics. Transaction service provides customers a way to modify data online through MicroStrategy Transaction Service documents. ' 24 Hrs In Crypto. Interacting with data sources. Below is some information on stored procedure execution for some major databases: DB2. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. In a transaction services document in MicroStrategy Web 9. Source: MicroRooster. updating tables, facts, or perhaps even the database itself, certain inconsistencies may be found (such as, for example, an invoice pointing to two different tables appearing as a duplicate invoice). It allows users to update data, insert new information or delete existing records from the database. And leverage the Page-By function to focus your analysis on one element. It all starts with the highly anticipated debut of the transactional grid for Dossier, providing actionable analytics for improved efficiency and. In MicroStrategy Web right click on the "Update Comment Report" and. “MCE Service” means the MicroStrategy Cloud Environment service, a platform-as-a service offering that we manage on your behalf in an Amazon Web Services or Microsoft Azure environment that includes access to,Self-Service Analytics with Amica. MicroStrategy transactions do not have. 3, March 2016. For MicroStrategy transactions, the unique Device configuration is tracked. Refer to the following technical note for instructions on how to use stored procedures within Freeform SQL reports specifically against Oracle and DB2 UDB databases:Calling Stored Procedures from Microstrategy. The example below shows the analysis for a MySQL Metadata: SQL to find the tables in a given schema SELECT table_name FROM information_schema. ; On to Freeform Sources tab, select Create Transaction report. 4) Mark the Display hidden objects checkbox and click on OK:Business intelligence vendor focuses on mobile, cloud, social and visual analysis amid a tight battle with SAP, Oracle, QlikTech and Tableau. First, let’s create a dummy dataset with an attribute like. You can still access our MicroStrategy Community knowledge base and contact Support for assistance with any issues. STEPS TO REPRODUCE: This issue can be reproduced in MicroStrategy Tutorial, with an English (United Kingdom) operating system, where the date format should be dd/mm/yyyy . We, within BestInBI, use this capability for task and project management, time entry, assignments, and resume updates. . An example of an options. Data is not successfully updated when executing a transaction in MicroStrategy Transaction Services. 5. Report Services dashboards and documents. 2. Version 9. Note: The user also needs to have View access in the transaction report’s ACL. – Surveys. Under menu View enable the Show Column Data Type option as below: 3. Please refer to below example to see the behavior. Hear see about methods wee can help your company grow by visitation the blog: Transaction Services in MicroStrategy Mobiles. . ) UPDATE TRANSACTION_TEST SET. x-10. Course 107 provides a general introduction to transaction services, and teaches you how to use a wide range of transactional input forms to change and add ne. This knowledge base article explains how to display a prompted value into a Report Services document in MicroStrategy Developer 9. For a detailed overview of Transaction Services, including example images and steps to configure different types of controls in a Transaction Services-enabled document, see the Document Creation Help. MicroStrategy 11. For example, quick and efficient claims processing increases customer satisfaction, optimizes settlements, and minimizes expenses. x If the issue is observed with transaction configured to update ID forms for attributes, this might be a known limitation in MicroStrategy 10. x. Click the text field or grid cell of the value to edit, then do one of the following: To edit a value in a Text Field or Text Area control, type a value in the field, then press Enter. When a new attribute form is created in a Transaction Services report, although its form format type is set to Number, the Data Type is automatically set to Integer. Number of Views 630. ; Enter the XQuery statement required in connect to. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more. which can be created by adding an extra variable to the same. The Tutorial project includes sample data, such as actual customer names and items purchased. MicroStrategy Transaction Services is a very powerful tool that provides write-back capabilities from Report Services Documents both through Mobile BI Apps and Web-based DHTML documents. ; In aforementioned Source area, select the database instance for the data source on be updated using Transaction Professional. For instructions on how to view or edit. 1 Update 1. Your input has a data type of "Date", "Date Time", and "Time" to a MySQL database. How to find business scenarios and. To Create a Purchase Services Report. Last updated: Apr 12, 2019. Teradata 16. x-10. MSTR The key specified is the truer key for the war. MicroStrategy Transaction Services, MicroStrategy Visual Insight, MicroStrategy Web Reporter, MicroStrategy Web Analyst, MicroStrategy Web Universal, MicroStrategy Office, MicroStrategy Data Mining Services, MicroStrategy Narrowcast Server, MicroStrategy Health Center, MicroStrategy. Ideally you can design an attribute/metric label in any style; in this example we are making a basic capsule style label. After analyzing market trends in the industry, as well as the needs of most of our customers, MicroStrategy is announcing the end-of-life for the MicroStrategy Application for Windows and macOS, with MicroStrategy 2021 Update 10 being the last version available on the MicroStrategy download site. bulk transaction, the purchaser should ensure that they have a clearance certificate issued by us. From the drop-down list next to the check box, select the metric that contains the number that you want to display next to the application icon. Sending sample services. Definition of MicroStrategy in the Definitions. This is a single-value function. Update application badge with the value of this metric: Select this option to update the badge next to the MicroStrategy Mobile application icon on a mobile device when the threshold condition is met. 4. ACTION. This is where the main fact/driving table has a transaction key column which is mapped as a child of all the different real attributes for the different hierarchies present on the driving table. Save the transaction services report. Type Public (NASDAQ: MSTR) Industry Business intelligence FoundedIn MicroStrategy Developer, sometimes users wish to call a procedure that will manipulate the data after the execution of a data mart report. custom furniture) that you manufacture to your customer’s specifications. This function. To Create an Transaction Services Report. Maintain compliance with company's systems and controls methodologies. To Create a Transaction Services Story. MicroStrategy Transaction Services allows users to perform any of the following three actions:. MicroStrategy Transaction Services, MicroStrategy OLAP Services, MicroStrategy Distribution Services, and MultiSource Option. Map the Attribute Forms and Metrics from the dataset to the Transaction Services Report "Insert Item Order". II. This article will show you how to create data alerts in MicroStrategy. The values for transactions can be put straight into the SQL or passed through value prompts. Analysts use these input object controls to edit the data displayed in a document. A database table used to store sales data (revenue, profit, cost, and so on) at different logical levels. 1 has a defect when updating or deleting more than one row using parameterized queries. The Configure Transactions Editor opens. txt file attached to this document, to a directory (for example, /opt/MicroStrategy) on the Linux Intelligence Server machine where the MicroStrategy Google BigQuery ODBC driver DSN will be created, and rename it to. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. One is known as a transaction data model setup. We discuss the firm's acquisition of BTC in the AM's '24 Hrs in Crypto. 4. If M1 equals V1, then a specified value can be returned. The Control Properties screen will display. A professional Microstrategy Consultant Resume mentions the following core roles and responsibilities – delivering billing consulting services, understanding the business. With this release, MicroStrategy modernizes the interface by focusing on making the product easier-to-use and more intuitive. For example, if the datatype of column3 supports 10 digits, but the desired value of column3 contains 11. An example transaction is shown below:. MultiSource, MicroStrategy OLAP Services, MicroStrategy Intelligence Server, MicroStrategy Distribution Services, MicroStrategy Report Services, MicroStrategy Transaction Services, MicroStrategy Visual Insight, MicroStrategy Web Reporter, MicroStrategy Web Analyst, MicroStrategy Office,This issue has been classified as a defect by MicroStrategy. 1 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the software version showMicroStrategy Customer Services, MicroStrategy Education, MicroStrategy University, MicroStrategy Managed Services, MicroStrategy Business Intelligence QuickStrike, BI QuickStrike, Mobile QuickStrike, Transaction Services QuickStrike, Retail Vendor Portal, Perennial Education Pass,Services, MicroStrategy Education, MicroStrategy University, MicroStrategy Managed Services, BI QuickStrike, Mobile QuickStrike, Transaction Services QuickStrike Perennial Education Pass, MicroStrategy Web Based Training (WBT), MicroStrategy World, Best in Business Intelligence, Pixel Perfect, Global Delivery Center, Direct Connect, Enterprise. KB37380: Transaction Services Document data is not updated after making changes in MicroStrategy Web 9. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. Built on the open and flexible architecture of MicroStrategy Report Services™ as Report Services Template (RST) files, templates provide a quick and intuitive method for designing dashboards. 3. 23. example usage and translations of the word. How to display object. Under Development. Examples of this include, when you create and manage a user account via our website, join or connect with a network, request technical support services, request information or support from us, communicate with us by email, telephone, or online chat, upload information through the MicroStrategy Offerings, subscribe to newsletters or. A product bundle (including Web, Intelligence, Analytics, and Distribution) designed to meet the specific needs of power users who create, design, analyze, share, and save MicroStrategy Dossiers, reports, and documents. 1. x. ; Click OK. Press the "Tab" key. ; Enter the XQuery assertion required to connect to the. How to identify the MicroStrategy user that updated record using Transaction Services? When running a transaction services report it could be desired to store which user is performing said activity. SYMPTOM: When the option "Input is required" is unchecked for the radio input, a. Completing a Silent Installation. Create an alert-based subscription in MicroStrategy Distribution Services on Web Subscription to a report or Report Services document which will be executed when a certain conditional threshold is met based on another executing report. Motivation: Customers can access data faster Transaction services updated the data unexpected when multiple records are modified and submitted in MicroStrategy Web 10. 4, presentation. MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. The Tutorial project includes sample data, such as actual customer names and items purchased. . ACTION: 1) Right mouse click on the transaction grid, choose Thresholds->Advanced. then. 4. The firm's treasury now holds 138,955 BTC, purchased at an average price of USD ~29,817 per coin. . 1 and laterToward Create a Transaction Ceremonies Account. Some examples of how you can use Transaction Services are: • Users may need to set input data validation in transaction service document. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. PST applies to the sale of goods, software, and telecommunication services, unless a specific exemption applies. For example, you design custom goods (e. – Warehouse control. x. ; On the Freeform Sources tab, select Build Transaction report. 1, after insert, update, delete operations, but the data is not updated. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 1. When using a Transactions Services document in MicroStrategy Web, users may encounter an issue in which the value '(NULL)' is displayed within an input text box. In this video tutorial, Doug Terbush from our Customer Education team describes the process of building a Transaction Services-enabled document. Creating a custom label on the grid requires a basic understanding of HTML. The retail store sells electronics, books, movies, and music. Example of Panel Stack panel stack to provide the Corporate, Regional, and Detail Data views. SQL for Oracle (PL/SQL) MicroStrategy Mobile Dashboard development. Statement in VLDB Properties i. 1. UPDATE, and DELETE DML statements. Arrow Format Arrow format helps with performance. Using MSTR Transaction Services one can leverage its power to create single UI and use it to register, organize operation services data, notifications, incidents etc. For more information on dedicated SQL pool architecture please refer to Azure Synapse Analytics online documentation. See the below series of screenshots for a sequential example of this issue: 1) Example Transaction Report in Developer . You use the authorization token returned in step 1 as the value for X-MSTR-AuthToken and provide the project ID. 7. If M1 does not equal V1, then M1 is compared to the next value V2 in the list. A MicroStrategy Report Services document contains datasets from one or more reports. ; Enter the XQuery command need to connect to that. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. Create a new report with attributes Customer State, Region, Month and Comment on the rows and save as "Update Comment Report. MicroStrategy Transaction Services is a very powerful tool that provides write-back capabilities from Report Services Documents both through Mobile BI Apps and Web-based DHTML documents. MicroStrategy Dashboard Templates facilitate dashboard design by providing you with preformatted customized templates. Data can be connected through an API, flat file, or database. For example, the MicroStrategy report shown below returns city, area code, and zip code information for cities in the state of Virginia. Introduction. A case of a business exchange would be the Merger or Acquisition of an organization. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingThe date inserted in a transaction services table does not have the expected format, when using MicroStrategy Mobile app Android 9. The report is located under MicroStrategy TutorialPublic ObjectsReportsMicroStrategy Platform CapabilitiesMicroStrategy Transaction ServicesDatasets. Copy the get_refresh_token. SQL scripts transform the statistics data into a form that can be useful for administrative reporting. Here t he transaction document shows the editable elements and the submit button. For an introduction to Transaction Services, see the Advanced Reporting Guide. In some situations, users may want to remove the MicroStratey branding from this popup. 7. visible=<Value> The selection state of MicroStrategy Transaction Services. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. 9. Once you’ve downloaded the example excel sheet, we will proceed to explain step by step how to import our file. To Creates a Transaction Aids Report. The input data validation can be achieved with threshold in MicroStrategy web. IS_REP_COL_STATS: Statistics table containing information about column-table combinations used in the SQL during report executions. 2. 1. Universal, MicroStrategy Distribution Services, MicroStrategy Report Services, MicroStrategy Transaction Services, MicroStrategy Visual Insight, MicroStrategy Web Reporter, MicroStrategy Web Analyst, MicroStrategy Office, MicroStrategy Data Mining Services, MicroStrategy Narrowcast Server,. The "User login" prompt in report filters. SQL. Transaction service provides customers a way to modify data online through MicroStrategy Transaction Service documents. See Defining Input-Dependent SQL or XQuery Syntax and Using XQuery to Retrieve Data from a Web Service for more information. The following options are available: Ø Transaction Mapping options. IS_SESSION: Lookup table for session objects. 4-5: Records when saving one or more objects. 2. In the MicroStrategy Tutorial project, go to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy Transaction Services. On Team; Careers: work in a business intelligence consultant; ServicesThe DECODE function is another implementation of the 'if. In the top-right pane, type your SQL query. Updating Data by Using a Transaction Services-Enabled Document. Web Professional. These transactions can include one-click approvals and denials, notes for tracking and directing business activity, and write-back to data sources in real time. txt file. Open the Document in Design Mode. e. 06K KB41651: When updating multiple rows at one time in a transaction services report in MicroStrategy Web 9. Both enabling and disabling logs are covered. 1 and later Number of Views 3. This means that while the user sees the attribute form set as Displayed Form, behind the scenes, the transaction will use the Writeback form to submit the data. The steps below show you how to create a Transaction Services report using the Freeform SQL Editor. The MicroStrategy Tutorial project includes examples of Transaction Services. This technical note is intended to show examples on different databases to use stored procedures within Freeform SQL reports in MicroStrategy . Similar to FFSQL reports, you can map an attribute form or a metric to a column of a table in the datasource. Examples of how you can use Transaction Services are: A Corporate Request Center (CRC) app with selectors that allow users to approve or deny. Organizations can now deploy MicroStrategy to a wider set of users across the enterprise, and get it into the hands of everyone – regardless of skillset, and for the first time, delivers the means to accelerate the. Upgrade to this release to take advantage of this fix. 3) Click on Browsing. The steps below shows you select to create a Transaction Solutions report using which Freeform SQL Executive. /setup. This article explains why Presto does not work well with MicroStrategy transaction service. These can be VERY handy for automating your data into a call to action for your users! We will setup a threshold alert on a metric value and set it on a schedule for 5 minutes. , the New York store is part of the Northeast Region. ; In the Source area, select the database instances used the data source to be revised using Transaction Support. In MicroStrategy Web 10. " 8. ; On the Freeform Sources tab, select Create Transaction report. DOSSIER. Data ArchitectureInputs for predictive metrics inches Microstrategy; MSTR Passthough Functions; Applysimple, ApplyCompa. SYMPTOM: A Transaction Services configuration that works with another supported DB instance, when reconfigured to point to an Impala instance, will cause MicroStrategy to stay in the “loading” state indefinitely and the same line will be written to the database repeatedly. MicroStrategy Transaction Services is a very powerful tool that provides write-back capabilities from Report Services Documents both through Mobile BI Apps and Web-based DHTML documents. element requests, simple grids (select * from), complex analytical multi-pass reports, Dashboards that rely on multiple (simple or complex) queries, database write-back from Transaction Services, and Cube reports designed to fill MicroStrategy In-Memory Cubes. MicroStrategy Customer Services, MicroStrategy Education, MicroStrategy University, MicroStrategy Managed Services, MicroStrategy Business Intelligence QuickStrike, BI QuickStrike, Mobile QuickStrike, Transaction Services QuickStrike, Retail Vendor Portal, Perennial Education Pass,To set a column to be optional, configure the transaction in MicroStrategy Web and uncheck the option ‘Input is required’. Arrow Format Arrow format helps with performance. Use Transaction Services in your apps and documents to update data, write new information to your warehouse, or delete existing records. A value of -2147483648 is seen in the WHERE clause of the UPDATE statement instead of the correct value. Interacting with data sources. The. TransactionServices. An example of an options. The output parameter needs a placeholder. Transaction service provides customers a way to modify data online through MicroStrategy Transaction Service documents. MicroStrategy World 2021 is over for another year. Run the document in Express mode. A blank visualization appears in the dossier. Using either SQL for databases, or XQuery for Web Services applications, transactions trigger new business processes, re-allocate resources, and accelerate business activity. For example, a scheduled report executes which shows the Revenue by day for the past week. x and 11. Navigate to and select a Transaction Services report, then click OK. ; Enter the XQuery statement required to. Some examples of how you can use Transaction Services. TransactionServices. To Create adenine Transaction Services Report. Example user without Execute transaction privilege Here the transaction document grid is not an editable element and the submit button is hidden. About Us. When modeling a database inside MicroStrategy there are a few methods to try when mapping data. Then create… MicroStrategy Transaction Services lets you embed write-back functionality into documents for the purposes of decision-making or initiating a transaction. " 8. KB442424: Best Practices for MicroStrategy Messaging Services. Video Tutorial - Visualizations in MicroStrategy Dossier, Part 2: The Editor Panel. For example, MicroStrategy Distribution Services can distribute reports directly to business users via E-mail who simply need dashboards or static reports and not the full interactivity of MicroStrategy Mobile or Web. For example: INSERT INTO TRANSACTION_TEST VALUES (#0, #1, #2, #3,. open a physical space/door) a default ID will be mapped. Click on the button to reveal the panel stack with transaction items. ; Click OK. The stored procedure must have been created indicating that it has a result set.