When users run this transaction document through MicroStrategy Mobile 9. Users may need to set input data validation in transaction service document. Navigate to and select a Transaction Services report, then click OK. engages in the provision of enterprise analytics and mobility software. The following steps will clear the text displayed in the popup titlebar:MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. No intermediate file or database is needed. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. KB484838: Best practices for performance tuning based on Azure Synapse AnalyticsWorked as MicroStrategy 9. CAUSE: This is known issue in MicroStrategy Web 9. In MicroStrategy Web there is a project level preference under Preferences > General > Refresh report to either: Retrieve data from the latest valid Intelligence Server cache. 0. Till now this is done in a . Optimal performance for your SQL Server data analysis. In MicroStrategy Web 9. In MicroStrategy Web 10. In MicroStrategy Developer, choose File > New > Report. These columns will be updated once. 4. int Count()void DSSOfflineTransactionCSIInfo::setKey (std::string iKey) void DSSOfflineTransactionCSIInfo::setTransactionCSI (DFCCSITransactionBase *virtual const string& IDSSSourceModelForTransaction::getNodeKey : pure virtual: Implemented in DSSRWNodeModel, DSSRWNodeModel, DSSDataModelBase, and DSSDataModelBase. Think of Dossiers as a dry erase board. To select a date from a Calendar control, click the date. 1. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. – Forms. A document or dashboard can contain data from one or more MicroStrategy reports. A document designer can create a Transaction Services-enabled document to allow analysts to. The Transaction Services document below returns the message below when submitting a transaction even when all inputs have been modified, in MicroStrategy Web 9. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. Companies of all sizes use this platform to assess, visualise, and build dashboards. This procedure assumes that the Transaction Services report that you want to link to the Grid/Graph, text fields, or transaction table has already been created. 3. 3 for iPhoneMicroStrategy comes with a sample project called MicroStrategy Tutorial. A project is the highest-level of intersection of a. ReportServiceCore/Headers/rwd/DSSOfflineTransactionCSIInfo. Right-click the metric for which to add a threshold and choose Thresholds. in database. 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. 1. This knowledge base article describes an intermittent behavior in MicroStrategy Web 10. 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. Expand Administration, and then expand System Monitors. 1:36:01. To learn more about the Required column, refer to article KB207490. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. • Use a slider to select from a range of values. Run the RSD in Presentation Mode and note that. This authentication technique has the added benefit of keeping your MicroStrategy project secure by authenticating upon login, while allowing the use of tokens to avoid the need to include authentication details in every XQuery report. 0. Right-click the grid report, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Ans: Microstrategy OLAP Services is an extension to Microstrategy Intelligence Server that allows Microstrategy Web and Desktop users to manipulate Intelligent Cubes™. “Invalid Input” Message appears and MicroStrategy app hangs when Executing a Transaction Services Document in MicroStrategy iOS app 10. This will remain until the user clicks within the text. Introduction. Click OK. Click More in the upper right corner of the visualization and choose Configure Transaction. Using additive the seasonal relapse for Revenue F. MSTR The key specified is the truer key for the war. Example A user created a transaction report with SQL per this instruction. 27 it issued and sold 218,575 shares for $46. In MicroStrategy Developer, open a report. There's a reason we're at the top of the list. Related Topics. This is fixed in MicroStrategy Mobile Android application 10. Achieve they get the genuine potential of Transaction Services, one of MicroStrategy's flagship features? Find out what it is, what you can do using it, and what you need to implement it. Is MicroStrategy dossiers, the date format for visualizations (including date filters) is controlled via the Web Language preferences and can be changed at the user or project level. Create a transaction services document with a submit button. If the User is logging in via typing Guest, the button appears correctly and can be used to execute the transaction. 0:00 / 9:26 Using MicroStrategy Transaction Services MicroStrategy Community 4. The user privileges that take up a Transaction Services license are denoted by 4 asterisks (*) in the User Editor. Starting in MicroStrategy 2019 Update 3, both ODBC and JDBC drivers are supported. The transaction was aborted. 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. h> Public Member Functions. Jobs may include scheduled or ad-hoc report or document executions. Advanced MicroStrategy users can take full advantage of SQL Server SQL capabilities, such as querying data based on a table index. x, prompted text cannot be displayed in a Report Services document unless the prompt is in the dataset of the document. Note: If a user enters more than 15 digits for a. MicroStrategy is not responsible for errors or omissions. 5. In the example shown above the syntax is incorrect as the call executed did not include the full list of necessary parameters. We, within BestInBI, use this capability for task and project management, time entry, assignments, and resume updates. The most common examples where transaction services are used are some of the following: – Stock Management. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 4. 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 will learn how to add and manipulate data, charts, graphs, images, and other elements to design interactive and informative documents. On Team; Careers: work in a business intelligence consultant; ServicesMicroStrategy is a vendor of business intelligence (BI) application software. For example, a scheduled report executes which shows the Revenue by day for the past week. The MicroStrategy Library can be accessed via the MicroStrategy Library App available on the Apple Store (for iOS) and Google Play Store (for Android). The pre-defined sort definition can be observed. x-10. "Too many simultaneous transactions" and "Access Logging step has failed. 9 product when trying to run a Transaction Services report in which a grid is being used to configure the transaction. ; In the Source area, select the database instance for the data source to be updated using Transaction Services. This document shows how list control works when option "Show by default" is checked or unchecked in transaction documents in MicroStrategy Mobile 10. JSON Data API Demo - Streaming data from 600 IoT devices to a map by Robert Prochowicz. x-10. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. x to change password for login of. ACTION. Do you know the true potentiality of Transaction Services, one of MicroStrategy's flagship features? Find outgoing what it is, what it can do with it, and what you require to implement it. 10 Transaction Services Documents where the height of List Pull-Down selectors on a grid may increase progressively from left to right on the grid. When configuring transaction services documents in MicroStrategy Web 9. Create one document with text box. engages in the provision of enterprise analytics and mobility software. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. MicroStrategy also disclosed Wednesday that between Oct. h:36. 12K subscribers 14K views 5 years ago Building Reports and Documents In this video tutorial, Doug Terbush from. 74 by $9. If the Action Type choices are Submit, Recalculate, and Discard Changes, you are working with a. These tools and functions include highly formatted reports, harmful queries, interactive dashboards, scorecards, and. If you opened the Quick Thresholds Editor, select the Advanced Thresholds Editor link to open the Advanced Thresholds Editor. Some MicroStrategy actions do not have jobs. Starting in MicroStrategy 10, the element order will obey the pre-defined attribute sort order by default. 46 million for the quarter, compared to analyst. This Knowledge Base article describes a known issue that calendar in Transaction Services set to Spanish reverts to English on MicroStrategy Android Mobile 10. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. For sellers, this means staying ahead by preparing an. command is one of the commands from the list below. In MicroStrategy Web 10. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. To republish a dataset. MicroStrategy is not responsible for errors or omissions. The big number: MicroStrategy stock surges with bitcoin. x and 9. 7/9 videos | 5H 34M 40S total runtime. If the transaction services enabled grid is long enough, like shown above, as the user scrolls. 1. The impact is limited to MicroStrategy Desktop 9. com, to provision on our MicroStrategy for AWS provisioning console, and via the respective app stores for iOS and Android. Transaction Services and Pixel Perfect output, Dossiers are now more than capable of handling almost all your Business User needs. 27 DFCCSITransactionBase* mpTransactionCSI;. This article will show you how to create data alerts in MicroStrategy. In the Source area, select the database instance for the data source to be updated using Transaction Services. x users must now click twice to cancel a change in a Transaction Services formIn a Transaction Services document, users can configure a textbox to use one attribute form as the Display Form and a different one as the Writeback Form. Menu. microstrategy. – Control panels. 98) earnings per share for the quarter, missing analysts' consensus estimates of $0. Transaction service provides customers a way to modify data online through MicroStrategy Transaction Service documents. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. While database instances commonly point to a relational database, you can also create Freeform SQL. 4. 1. The issue occurs anytime two or more rows are updated with different values and the 'submit' button is clicked. Create a transaction report to insert data into Table B. About Uses. In MicroStrategy Developer, from the File menu, select New, and then choose Report. This issue has been classified as a defect by MicroStrategy. Transaction Services provide customers a way to modify data in a SAP HANA database online via MicroStrategy Transaction Service documents. 10. 26 std::map<int, DSSColumnMappingInfo*> mColumnMap;. 1. MicroStrategy Incorporated is an American company that provides business intelligence (BI), mobile software, and cloud-based services. pdf. 4. You must have the Web Configure Transaction privilege. Client - Reporter: A consumer license that allows ends. 4 HF5 and 10. This data is positioned and formatted, resulting in a single display of presentation quality. To Create a Transaction Services Report In MicroStrategy Developer, choose File > New > Report. You must create. In some situations, users may want to remove the MicroStratey branding from this popup. Use the URL API with "hiddensections=dockTop" to run the document. The Republish dialog opens. 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. In the Operator list, select a comparison operator (Greater Than, Less Than. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformDefinition: ReportServiceCore/Headers/manipulation/DSSCManipulationDiscardTransaction. For instructions, see the MicroStrategy Web Help or the MicroStrategy Mobile Analysis Help. The same document works normally in Mobile. • You must have the Web. Pull down list selectors in Transaction Services documents always display the first element of a search result as the selection made by the user, regardless of which element was selected in MicroStrategy Analytics Enterprise 9. By this, I mean that we can disable, hide or validate the values that users are setting. In this environment, buyers must identify the path to create value, mitigate risk and do it faster than ever before or risk losing out on the bid. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 0. For a transaction services grid, attribute elements with the same value seem to. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. 4. 3 Architect on project iManage (a single point BI Application Management and Reporting Portal) Responsibilities: • Acquired experience in working with transaction. 1 Update 1, where a date submitted through a transaction services document is stored in an unexpected format in the transaction database table. In MicroStrategy Web, create a dataset report that includes the attributes and metrics you added to the Transaction Services report above. ACTION: 1) Right mouse click on the transaction grid, choose Thresholds->Advanced. The dossier. Go to the properties of the Action Selector's properties > General > Display Text as shown below. Select the appropriate options to define conditions for each action, as described above. Number of Views 630. For information on conditional formatting in Report Services documents, which is similar to report thresholds, see Formatting conditional values in documents. MicroStrategy 11. Instead, element order was always determined by attribute ID. If a user who does not have. – Sales register. MicroStrategy is an enterprise BI application software. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. virtual const string& IDSSSourceModelForTransaction::getNodeKey : pure virtual: Implemented in DSSRWNodeModel, DSSRWNodeModel, DSSDataModelBase, and DSSDataModelBase. Learn more nearly how we can help get corporate growing of visiting our blog: Transaction Services in MicroStrategy Mobile. Transaction 2 is crediting each account with a 10% interest payment. 4. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. Teradata 16. The latest innovation from the product labs, MicroStrategy Insights fundamentally transforms how users interact with data. Create a transaction document, as is shown below: 7. Create mobile applications with write-back enabled functionality (transactions) for extended business value. 2. Dataflix is a software company focused switch emerging technological. Using documents in MicroStrategy Web. This prompt is used in a filter. With MicroStrategy’s Dossier, making quick, on-the-fly visuals is easier than ever. 5. This article describes an issue hen submitting a modification after editing a flag and a metric in different rows of a Transaction Services document, the flag is updated for both recordsInputs by predictive key in Microstrategy; MSTR Passthough Function; Applysimple, ApplyCompa. If both transactions are submitted together, there is no. SettingsVCMode This mode implies the settings screen. x-10. pdf. Watch this live session on all things dossier and the power of compelling design. In MicroStrategy Web, edit or execute a report. 2. On the Freeform Sources tab, select Create Transaction report. Transaction Services Calendar has no arrows to change months in MicroStrategy WebThere's a reason we're at the top of the list. MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is sent to the MicroStrategy Intelligence. 1 product only with Transaction Services Documents using the "Mark rows for selection" option. 6/9 videos | 5H 34M 40S total runtime. Unlike in MicroStrategy Web 9. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. 3. Thresholds can make analyzing large amounts of data easier because images are easy to locate and different colors are quickly identified. 4. 4. . LLC and. 2. You can create a Transaction Services document in Web and MicroStrategy Developer. Create a transaction report with Category@ID as input. #include <DSSTransactionReport. Video Tutorial - Visualizations in MicroStrategy Dossier, Part 2: The Editor Panel. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. Set these 3 panel stacks as the target and enable "Submit transaction in order". This is fixed in MicroStrategy Mobile 10. x, exporting to Excel 2007 is also subject to the limitation (1,048,576 rows by 16,384 columns). Yes, we can update the tables in warehouse using microstrategy. Transaction-enabled Documents. However, i n MicroStrategy Mobile 9. To set a column to be optional, configure the transaction in MicroStrategy Web and uncheck the option ‘Input is required’. Visit the data visualization and data dashboard galleries for inspiration. 28 public:MicroStrategy, MicroStrategy 10, MicroStrategy 10 Secure Enterprise, MicroStrategy 9, MicroStrategy 9s, MicroStrategy Analytics, MicroStrategy Analytics Platform, MicroStrategy Desktop, MicroStrategy Operations Manager, MicroStrategy Analytics Enterprise, MicroStrategy Evaluation Edition, MicroStrategy Secure Enterprise,. Founder Michael Saylor explained how bitcoin has helped the company's stock compete. You can perform the following manipulations on the data in a dossier without adding a new dataset: Different data. 4. Below are the new features exclusive to. In these cases, default values are applied. to carry out transactions and to profile users in order to. Transaction lets Business Users submit transactions via custom forms on documents, dossiers, or via interactive grids. Below is an example of ACID property in DBMS: Transaction 1: Begin X=X+50, Y = Y-50 END Transaction 2: Begin X=1. Navigate to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy Transaction Services. x-10. 1. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. 4, however, the text appears in one line when the Report Services Document is exported to PDF. 47:25. This article describes an issue hen submitting a modification after editing a flag and a metric in different rows of a Transaction Services document, the flag is updated for both recordsThere's a reason we're at the top of the list. MicroStrategy Cloud offers both a Platform as a Service (PAAS) known as MicroStrategy Cloud Platform, and Software as a Service (SAAS) models known as MicroStrategy Cloud Personal and MicroStrategy Cloud Express and a small scale Infrastructure offering to support business intelligence. We were able to show these comments in the. . Then set the min and max values, as seen below. 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. There's a reason we're at the top of the list. MicroStrategy Telemetry Store: This service consumes all telemetry data from MicroStrategy Services layer, and do ETL process for the Platform Analytics project, also named as Platform Analytics Consumer. In MicroStrategy 2021 Update 6, dossier users with the proper privileges can modify data and submit data changes to the database. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. In a Transaction Services document, users can configure a textbox to use one attribute form as the Display Form and a different one as the Writeback Form. There should be Input objects and Output objects for each transaction (each transaction will have separate transaction report) 5. Sales Engineer, Michal Janowski will walk through using Snowflake as a data source to MicroStrategy and show how the two products work together to provide high performance at lower cost for customers. 9, the “Invalid argument” erro…In this video tutorial, Doug Terbush from our Customer Education team describes the process of building a Transaction Services-enabled document. MicroStrategy transactions do not have desktops and, therefore, always map to a default value. MicroStrategy Incorporated (NASDAQ:MSTR) announced its quarterly earnings data on Wednesday, November, 1st. The job is stored in the fact_access_transaction_view fact table. Users may configure a transaction field to be used as a calendar picker in MicroStrategy Web 9. Financial Services Healthcare Retail Government Resources Connect Events World 2024 Community & Support Partner Network. void DSSOfflineTransactionCSIInfo::setKey (std::string iKey) void DSSOfflineTransactionCSIInfo::setTransactionCSI (DFCCSITransactionBase *DSSTransactionReport Class Reference. Build workflows with stored procedures, input dependent text, and transactional SQL. Then create… To Create a Transaction Services Report. Self-Service Analytics with Amica. Login to MSTR Developer then go to: User Manager > User Definition > Project Access. MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. 1. This new feature allows to push data directly into in-memory cubes. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. Despite being a virtual conference, this did not lessen the number of important product announcements made at the event. There's a reason we're at the top of the list. The report can be executed in MicroStrategy Web. x, the last. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The solution is provided along with screenshots and the specific values for each number of stars. This report must contain the input object for each value that you want to allow users to change. There's a reason we're at the top of the list. Numerous elements on its main platform are intended to support businesses in making data-driven choices and streamlining operational procedures. The Configure Transactions Editor opens. 1No values are displayed when "Show by default" is used in Transaction Services in MicroStrategy Mobile 9. When you import data into MicroStrategy Web, the corresponding dataset is stored with the dossier. Slowly changing dimensions (SCDs) are a common characteristic in many business intelligence environments. Documents and dashboards allow you to display your business data in a user. Proactive. txt file>. 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. Go to the documentation of this file. Save the FreeForm SQL and Run the report. Create three dataset reports, each with the testAnswer attribute and an attribute created from Table B. 72. In a Transaction Services document, the Action Selector Button behaves differently when logging in via the Guest user who has the necessary “Execute Transaction” privilege. MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. Differences between the "Input is required" check box in Web and the "Required" drop down in MicroStrategy Developer and above when used with Transaction Services. If an Universal version of the Intelligence Server is used, the Query Engine is a 64-bit component and will not encounter the same memory limitation as the 32-bit version of the Query Engine that. A document designer can create a Transaction Services-enabled document to allow analysts to approve requests, track business activity, and execute business decisions by editing their business data in the document and sending those interactions back to the data sources. In this video tutorial, Doug Terbush from our Customer Education team describes the process of building a Transaction Services-enabled document. com, to provision on our MicroStrategy for AWS provisioning console, and via the respective app stores for iOS and Android. MicroStrategy Telemetry Manager: This layer is the synchronization service between Telemetry Server(s),which is using Apache Zookeeper. Prerequisite: 1. To select a date from a Calendar control, click the date. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . DSSTransactionReport Class Reference. The fuel for business dashboards is data, so each one needs to have one or more data sources. 4. There's a reason we're at the top of the list. 6 and 10. MicroStrategy is not responsible for errors or omissions. 1*X, Y=1. Our experts make it easier than ever to migrate and modernize your analytics on the MicroStrategy Cloud. You must create Transaction Service reports used to execute Transaction Service documents in Web. 1 iOS app. 3. 1 that supports write-back (Insert, Update and Delete) from a Report Services Document to a Data Warehouse or Transaction Database. MicroStrategy Transaction Services lets you embed write-back functionality into reports and dashboards for the purposes of decision-making or initiating a transaction. The problem does not exist in prior and newer versions. This technical note documents an issue with MicroStrategy Mobile app Android 9. x, they are presented with an iOS-styled calendar picker that allows users to scroll through the month, day, and year. 4, presentation. In MicroStrategy Developer, log into a project source. – Surveys. Starting in MicroStrategy ONE Update 11, under Format Panel > Transaction Configuration tab > Configure Transaction, you can click Use SQL. It is a. Provide the necessary information in the following order: Old password: Enter the old password (the password you are changing). 1. MicroStrategy Technical Support has tested a workaround to this issue which can be implemented by creating a separate Transaction Report for each panel on the panel stack. You may have noticed that when you right-click on an object that has a transaction configured, the “Transaction Conditions” option appears. The " Re - run " ( Re -execute) button. #include <DSSTransactionReport. ACTION: 1) Right mouse click on the transaction grid, choose Thresholds->AdvancedWhy MicroStrategy Why MicroStrategy; Customer Stories; PlatformDiscover MicroStrategy – the modern, open, enterprise platform that connects every user and every application to all your data. 4-XX. To view the selector properties for a Transaction Services selector, see Properties and Formatting Dialog Box: Selector. Prerequisites • You must have Transaction Services. In fact administration most as often as possible offered due intelligence. This means that a different set of Freeform SQL is sent to the warehouse for each panel. Users are able to create editable transaction services grids in MicroStrategy Web 9. 4, presentation. Then fill in with the necessary connection parameters. This is on top of many other enhancements available for Workstation. Learn more Enterprise Data Management. If a name is not specified,. Web Professional. The following options are available: Ø Transaction Mapping options. Transaction Services Document data is not updated after making changes in MicroStrategy Web 9. " errors received when running reports in MicroStrategy Developer 9. It collects real-time data (also known as telemetry) which is generated by different components of the MicroStrategy platform like the Intelligence Server. Transaction Services Calendar has no arrows to change months in MicroStrategy WebMicroStrategy, Inc. The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform's rich functionality. 5. Viewing and interacting with. This report must contain the input object for each value that you want to allow users to change. x, users will come across two similar settings in Developer and Web in regards to. Upgrade to this release to take advantage of this fix. Grid columns with zero width still appear on a Transaction Services Document in MicroStrategy Web 9. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. 2) Choose the End Date and set a qualification as End Date less than Start Date as seen below: 3) Double click on the threshold and check Replace Data, type a. Run document, select "Hootie & Blowfish" from the drop-down, click submit, issue observed. Notice it runs successfully. In MicroStrategy Web 10. Analytics Processing) rather than OLTP (Online Transaction Processing). Third party code/SQL: MicroStrategy Technical Support does not provide customized SQL queries.