This is fixed in MicroStrategy Mobile Android application 10. MicroStrategy supports Transaction Services with SQL Server 2017 ODBC and JDBC driver in 11. The transformation ensures that reporting on MicroStrategy metadata content is feasible. This knowledge base article outlines the row and column limit displaying and exporting grid reports in MicroStrategy Developer 9. For example, End Date should be later than the Start Date, otherwise the input is invalid. . In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. The MicroStrategy Tutorial project includes examples of Transaction Services. 9. Video Tutorial - Visualizations in MicroStrategy Dossier, Part 2: The Editor Panel. Please refer to below example to see the behavior. 5. Prior to the 10. Menu. The "User login" prompt in report filters. Meaning of MicroStrategy. 4. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Creation of system documentation and status reports. An example of an options. Example: Hive, Salesforce, MongoDB. Introduction. With MicroStrategy Transactions services support for SQL Server, users can record selections in a SQL Server table. 1 has a defect when updating or deleting more than one row using parameterized queries. . ; On the Freeform Bezugsquellen tab, selected Create Exchange report. In MicroStrategy Developer, from the File menu, select New, and then choose Report. Optimal performance for your SQL Server data analysis. 3. In MicroStrategy Developer, edit the Hive database instance used for transaction service and click Upgrade . 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. Browse and incorporate these templates into your own data dashboards. . Using linear and seasonal regression fork Revenue F. 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. Here t he transaction document shows the editable elements and the submit button. DELETE FROM TRANSACTION_TEST WHERE. What does MicroStrategy mean?. 12K subscribers 14K views 5 years ago Building Reports and Documents In this video tutorial, Doug Terbush from. 1. Example for using live connection with MicroStrategy 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. The options available in the Transaction Conditions Editor vary depending on the type of control that you are modifying. Month-to-Date dynamic dates can be created by choosing the 'Between' operator in the filter editor and by using the Date Editor to create two dates. txt file. For SaaS gateways, like Salesforce, consider using traditional MicroStrategy document and transaction reports to use XQuery and submit SOAP or REST calls to update data. open a physical space/door) a default ID will be mapped. ; In aforementioned Source area, select the database instance for the data source on be updated using Transaction Professional. “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. Advanced MicroStrategy users can take full advantage of SQL Server SQL capabilities, such as querying data based on a table index. Use Transaction Services in your apps and documents to update data, write new information to your warehouse, or delete existing records. On Monday, MicroStrategy (NASDAQ: MSTR) revealed that it purchased 6,455 BTC for USD 150M since mid-February. – Sales register. ; On the Freeform Sources tab, select Build Transaction report. The following options are available: Ø Transaction Mapping options. It allows users to update data, insert new information or delete existing records from the database. MicroStrategy 11. Think of Dossiers as a dry erase board. Distribution Services: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. Visualizations in MicroStrategy Dossier, Part 4: The Presentation Layer. In MicroStrategy Developer, choose File > Newer > Report. On Team; Careers: work in a business intelligence consultant; ServicesThe DECODE function is another implementation of the 'if. For example: INSERT INTO TRANSACTION_TEST VALUES (#0, #1, #2, #3,. ; Enter the XQuery assertion required to connect to the. 1) When I execute the STored Procedure by setting it in PreSQL. Create a new report with attributes Customer State, Region, Month and Comment on the rows and save as "Update Comment Report. 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). The third-party product(s) discussed in this article is manufactured by vendors independent of MicroStrategy. The dossier transaction feature cannot be used with them. The demo is using the latest addition to MicroStrategy: JSON DATA API. For example, a scheduled report executes which shows the Revenue by day for the past week. About Us. The following options are available: Ø Transaction Mapping options. 10. Microstrategy Developer. A sample of transaction types (i. 1 Update 1. Version 10. For example, add web service account of Data Source1 (admin1) to guest user as shown below: • Create a new project source or modify an existing project source to use database authentication as shown below: For additional details on supporting database authentication in MicroStrategy, see the System Administration Guide. x. For example, you can filter based on the attribute element's ID form, one of its description forms, or the DATE form if the. ; To that Freeform Sources tab, select Creation Transaction report. Connectivity via DSN. You agree to use the Communication Services only to post, send and receive messages and material that are proper and, when applicable, consistent with MicroStrategy’s intended purpose for the particular Communication Service. The document is available in PDF. KB41651: When updating multiple rows at one time in a transaction services report in MicroStrategy Web 9. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Create a freeform SQL with Select CAT_ID, SUB_CAT_ID, MONTH_ID, SALES, SALES * [?ValuePrompt] 2. blogspot. Run the Monthly Regional Sales Targets Planning document. Example A user created a transaction report with SQL per this instruction. 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. Motivation: Direct and concise slice of data utilizing the power of BigQuery. Below is some information on stored procedure execution for some major databases: DB2. Navigate to and select a Transaction Services report, then click OK. Similar to FFSQL reports, you can map an attribute form or a metric to a column of a table in the datasource. Autotext code/macros in Microstrategy Document/dashboard. 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. 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 Guide. x-10. To use the options file on a silent installation, specify -silent -options <FileName> as a command line argument to the wizard, where <FileName> is the name of this options file, for example, options. This will remain until the user clicks within the text box and manually deletes the text. In fact administration most as often as possible offered due intelligence. Select "Switch" from the Control Style drop-down; Click the Properties icon . 7. Analysts use these input object controls to edit the data displayed in a document. Ø Local Transaction options. If user wants to add more connection parameters other than above, they can manually. However, the Action Selector button's formatting does not persist when the same report is rendered in MicroStrategy Mobile. . In this case, the design services are taxable because the. In MicroStrategy Web 10. This is expected behavior. Depending on your MicroStrategy product and licensing. x. To Add a Target Visualization to Your Dossier: Open the dossier with the visualization. MicroStrategy Mobile can be used to support business activities, including the following examples:. MSTR Transformation Metal with no aggreagation;. SQL. Hee-Wei Tan (Inactive) · May 1, 2017 ·. SYMPTOM: When the option "Input is required" is unchecked for the radio input, a. An example of an options. Save the options file as options. It lists all sales opportunities in the pipeline, and it groups those opportunities. For example, a global bank will want to see financial transactions grouped by country, then zoom into the billions of individual points for further analysis. R Integration, MicroStrategy Report Services, MicroStrategy SDK, MicroStrategy System Manager, MicroStrategy Transaction Services, MicroStrategy Usher, MicroStrategy Web, MicroStrategy Workstation, MicroStrategy World, Usher, and Zero-Click Intelligence. Transaction . Version 9. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. You can still access our MicroStrategy Community knowledge base and contact Support for assistance with any issues. Use MicroStrategy Library, MicroStrategy Application, or MicroStrategy Workstation to view or edit this doddier. The sample procedures are stored in the Command Manager directory, in OutlinesProcedure_OutlinesUser_Procedures. About MicroStrategy Cloud Environment The MicroStrategy Cloud Environment (“MCE” or “MCE Service”) is a Platform-as-a-Service (“PaaS”) Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. . Press the "Tab" key. These examples include all the reports, documents, and other objects and configurations that are required to use Transaction Services. Web Services Security (WS-Security) provides web services authentication, as defined in the WS-Security standard. Instead, element order was always determined by attribute ID. Meet the Transaction Conditions and add more pizzazz to get dashboards while providing einer extra layer of security to the transaction. 6: Link Items are objects that link two or more other objects. 4 HF5 and 10. ; On the Freeform Sources tab, select Create Transaction report. Click on the calendar selector to expand the. For enhanced security, starting from MicroStrategy version 2021 Update 4, for all the certified gateways, all SQL executions triggered from transaction services reports and transaction-enabled documents will be secured through parameterized queries. II. When modeling a database inside MicroStrategy there are a few methods to try when mapping data. For background, we will give a brief introduction about each. MicroStrategy Transaction Services, MicroStrategy OLAP Services, MicroStrategy Distribution Services, and MultiSource Option. Please submit "rock star" candidates. Completing a Silent Installation. ; In the Source area, select the database instances used the data source to be revised using Transaction Support. This feature is available when you install Transaction Services. A product called MicroStrategy Transaction Services will allow mobile applications to talk to transactional systems back at the home office. sh -silent -options <path of the options. For steps, see Starting MicroStrategy Web. 1, after insert, update, delete operations, but the data is not updated. CUSTOMER CASE STUDY: SERVICES Why mobilize with the MicroStrategy platform Scott Salter, Senior Director of Enterprise Data and Shared Services, states, “We have used MicroStrategy for a long time on our desktop and our research indicated that MicroStrategy was on the leading edge of mobile so we decided to go with MicroStrategy. . . 4. 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. MicroStrategy Transaction Services, MicroStrategy Visual Insight, MicroStrategy Web Reporter, MicroStrategy Web Analyst, MicroStrategy Web. " 8. active=<Value> For example, to select MicroStrategy Transaction Services for installation, use: TransactionServices. For example, an analyst can view a list of employees with time off requests. Transaction Services Duration''Document Analysis MicroStrategy Key April 29th, 2018 - The Document and Dashboard Analysis Guide contains instructions for business analysts to execute and analyze a document in MicroStrategy Desktop and MicroStrategy Web building on basic concepts about projects and reportsIn MicroStrategy 2021 Update 2, secure parameterized queries are enabled in transaction services documents for improved user information and data warehouse security. ; Click OK. ; Inbound this Source area, select the database instance for the data source to be updated through Transaction Services. x If the issue is observed with transaction configured to update ID forms for attributes, this might be a known limitation in MicroStrategy 10. The below image is an example of how this may look in an affected document: Steps to reproduce #Creat transaction services photo uploader #transaction services; #Create Email Subscription in Microstrategy #email subscription; #Create your own Open source Agile boards; #Creates a schedule Microstrategy #schedule; #Creating a . The loginMode parameter in the. MicroStrategy transactions do not have. To Create a Transaction Services Story. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. A sale includes a transfer of title or possession for a price or. You use the authorization token returned in step 1 as the value for X-MSTR-AuthToken and provide the project ID. ; Enter the XQuery statement. For example, a security filter will link together a user and a metric. To see a sample project, access the MicroStrategy Tutorial provided with the MicroStrategy platform. Every 5 minutes, MicroStrategy will check for the threshold and. For example, you design custom goods (e. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Follow KB39222: How to configure MicroStrategy 9. Web Professional. Save the changes to the options. The web server stores the token for the Intelligence Server in a token file, called ". 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. DELETE FROM TRANSACTION_TEST WHERE. Last updated: Apr 12, 2019. 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. There are multiple components and services replying on MicroStrategy Messaging Services. txt file>. ACTION: 1) Right mouse click on the transaction grid, choose Thresholds->Advanced 6. Teradata 16. 29. Transaction-enabled Documents. You can use the example as a template and replace italicized text with your own information. 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. 0:00 / 9:26 Using MicroStrategy Transaction Services MicroStrategy Community 4. In this video tutorial, Doug Terbush from our Customer Education team describes the process of building a Transaction Services-enabled document. txt. This is the way the real challenge lies for transaction management in Microservices. For example, say a corporation that follows IFRS purchased 1 BTC for $50,000 in 2021. Services, MicroStrategy SDK, MicroStrategy System Manager, MicroStrategy Transaction Services, MicroStrategy Usher, MicroStrategy Web, MicroStrategy Workstation, MicroStrategy World, Usher,. 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. A value of -2147483648 is seen in the WHERE clause of the UPDATE statement instead of the correct value. About Uses. MicroStrategy Transaction Services and XQuery allow you to access and update information available in third-party web services data sources. MicroStrategy Transaction Services lets you embed write-back functionality into documents for the purposes of decision-making or initiating a transaction. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. The XQuery Success Code VLDB property lets you validate Transaction Services reports that use XQuery. For example, the YR_CATEGORY_SLS table includes the attributes Year and Category, along with facts such as Revenue, Cost, Profit, and so on. 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. Repository. Transaction. These tables include a combination of attribute and fact definitions. The following steps will clear the text displayed in the popup titlebar:Users may need to set input data validation in transaction service document. To do this, go to transaction conditions and select “disable” everything that does not belong to this subcategory: Once this is done, we will see that, when running the document, it will not be possible to edit anything that does not meet the condition mentioned above: For example, if we are going to use the hide functionality, we can set. 1. 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. 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. MicroStrategy World 2021 is over for another year. 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 MicroStrategy, a security filter is a filter object that is used to narrow down the result set that users or groups can view when they execute reports or browse elements. txt file is provided in Example of an Options File below. This prompt is used in a filter. Data Architecture;This article describes what the Transaction Type "Collect Garbage" means in the Change Journal logs. Video Tutorial - How to Use MicroStrategy Transaction Services. Our Team; Careers: employment as one business intelligence consultant; Services. x-10. TradingView. Article explains where the calendar picker in MicroStrategy Web collects the different pieces of information. 05/2010 - 07/2016. MSTR The key specified is the truer key for the war. This guide covers the features, benefits, and limitations of OLAP Services, as well as the steps to create, manage, and. 29. select the attribute form to base the qualification on. The Transaction Services Document is configured to refresh the current document in MicroStrategy Web 9. Create a new report with attributes Customer State, Region, Month and Comment on the rows and save as "Update Comment Report. No MicroStrategy Technical Support Case: DE60307: Barcode font Interleaved 2 of 5 (i2of5txt. Both enabling and disabling logs are covered. Click Insert Visualization . 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. This raw data must be processed further to support administrative analysis and reporting requirements. Create query reports using Freeform SQL 10. This technical note is intended to show examples on different databases to use stored procedures within Freeform SQL reports in MicroStrategy . The steps below show you how to create a Transaction Services report using the Freeform SQL Editor. 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. You want to add a record with the values "12/31/2022",. /setup. Click in “Add new data”. The below image is an example of how this may look in an affected document: Steps to. Completing a Silent Installation. 3) Click on Browsing. Is Team; Careers: work as a business news consultant; Services. In Design Mode for that document, configure the transaction so that the Opportunity Size field has the option "Input is required," as shown below:while MicroStrategy maintains the supporting cloud-based infrastructure. 4. Once you’ve downloaded the example excel sheet, we will proceed to explain step by step how to import our file. 2. 1. ; In the Source area, select the database instance for the data source to be updated using Transaction Services. Usually assigned by administrators, security filters control what warehouse data users can see within MicroStrategy. g. visible=<Value> The selection state of MicroStrategy Transaction Services. It allows users to update data, insert new information or delete existing records from the database. Design intuitive analytics reports with MicroStrategy ONE. IS_REP_COL_STATS: Statistics table containing information about column-table combinations used in the SQL during report executions. The following steps will clear the text displayed in the popup titlebar: 6. Save the transaction services report. Within MicroStrategy Developer, choose File > New > Report. Create a button that uses panel stack 76 as its information windows. ) UPDATE TRANSACTION_TEST SET. example of a Report Services dashboard is shown below: MicroStrategy Report Services | Michael Sandberg's. ACTION: 1) Right mouse click on the transaction grid, choose Thresholds->Advanced MicroStrategy Transaction Services lets you embed write-back functionality into documents for the purposes of decision-making or initiating a transaction. From the Visualizations panel, select Grid . These examples include all the reports, documents, and other objects and configurations that are required to use Transaction Services. 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,. Many companies that are using MicroStrategy don’t fully. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. For example, solutions for a facilities team at a large manufacturing company might include sensors to measure the temperature of key equipment to optimize maintenance schedules. MSTR The key specified is the true key for that war. x and 11. 1. Numeric prompt: Users enter a specific number, up to 15 digits, which is then used as part of a filter, or within a metric, to look for specific numeric data. 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,An example of such a field is an object GUID. For example, End Date should be later than the Start Date, otherwise the input is invalid. e ('Call [SP]') it does not. Motivation: Customers can access data fasterTransaction services updated the data unexpected when multiple records are modified and submitted in MicroStrategy Web 10. Data ArchitectureInputs for predictive metrics inches Microstrategy; MSTR Passthough Functions; Applysimple, ApplyCompa. You could use the ODBC Test Tool to test the validity of the procedure before creating the Freeform SQL report. Request a demo. 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. x supports INSERT, UPDATE, and DELETE DML statements. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. Then create…Transaction-enabled Documents. . Hire Type: Contract, no. Save the FreeForm SQL and Run the report. 9 product when trying to run a Transaction Services report in which a grid is being used to configure the transaction. For example, if provided a list of values ranging from 1 to 12, CaseV might return January for a value of 1, February for a value of 2, etc. As outlined in technical note TN41359, a session with Intelligence Server must be established before a trust relationship can be created through the MicroStrategy Office configuration. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. Number of Views190. ACTION. Click OK. Select the “File from Disk” option. 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. XQuery is a language for processing XML data. You can connect to third-party web services to retrieve data and report on that data within MicroStrategy. You must have the Web Configure Transaction privilege. IS_REP_FACT: Fact table for report job executions. In MicroStrategy Web right click on the "Update Comment Report" and. The steps to create a Transaction Services report using XQuery are provided in the Advanced Reporting Help. With increasing consumer expectations and new digital channels, competitive retailers are looking for better ways to manage their inventory, improve marketing strategies, and provide superior customer service to help drive more revenue. ; In the Source domain, select the database instance for the data source up be updated using Transaction Services. This issue has been classified as a defect by MicroStrategy. 3. pass as Prompt answer. 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. Create 2nd freeform SQL (This is going to be transaction report); 4. See the below series of screenshots for a sequential example of this issue: 1) Example Transaction Report in Developer . Introduction to MicroStrategy Transaction Services 9. Under Development. 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. 2. x, the last. The retail store sells electronics, books, movies, and music. 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 see sample dashboards in MicroStrategy Web. 7. Version 10. Published: May 9, 2017. – Warehouse control. The MicroStrategy Tutorial project includes examples of Transaction Services. The Tutorial project includes sample data, such as actual customer names and items purchased. Sending sample services. Video Tutorial - Visualizations in MicroStrategy Dossier, Part 2: The Editor Panel. ; Click OK. Right-click on the metric header to apply the condition or threshold and select 'Alerts': Specify the conditions to meet for the delivery to be triggered in the filter editor: Expand the Delivery Settings section. Action Types ) includes: logging into a project, executing a report, republishing a cube, creating a history list message or scanning a Badge QR Code. You can review these Transaction Services example in the following MicroStrategy Tutorial project location: MicroStrategy TutorialPublic ObjectsReportsMicroStrategy Platform CapabilitiesMicroStrategy. 9. If a user who does not have. Apply now! Skip to. So for example, if users try to export a report with rows and columns lower than 1,048,576 and 16,384, but the export memory consumption is more than 2 GB then the export fails. (for example, architecture reviews by security professionals,. You can be agile as well as interactive and find unexpected results in your data; Deliver quick stories to leadership committees, or. This knowledge base article describes an intermittent behavior in MicroStrategy Web 10. Users can use the Freeform SQL editor on Developer to create Transaction Service reports and then trigger the reports through documents. x and 11. 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. Set proper transaction section in transaction report so that multiple records could be updated. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more. Here we have compiled a set of MicroStrategy interview questions asked in top organizations around the world. The Freeform SQL Editor opens. NET app using an ORM, but is it possible to integrate it with MicroStrategy?. In MicroStrategy Developer, from the File menu, select New,. Create a new report with attributes Customer State, Region, Month and Comment on the rows and save as "Update Comment Report. Motivation: Customers can access data faster Transaction services updated the data unexpected when multiple records are modified and submitted in MicroStrategy Web 10. Use Transaction Services in your apps and documents to update data, write new information to your warehouse, or delete existing records. Released in the 10. MicroStrategy Transaction Services Attribute element selections for transactions: Allows. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. The. 4. User can either click “Test” to verify the connectivity or just go ahead and click “Finish” to complete the DSN creation. Under menu View enable the Show Column Data Type option as below: 3. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library;. Contents Report. MobileServerASPSelect.