what is transaction services in microstrategy. x. what is transaction services in microstrategy

 
xwhat is transaction services in microstrategy Transactions from Transaction Services are not Getting Inserted to the Data Warehouse, but MicroStrategy Web Shows that it was Successful

• You must have the Web. Financial Services Healthcare Retail Government Resources Connect Events World 2024 Community & Support Partner Network. KB442534: In MicroStrategy Web, a Transaction Services text box inside a Document shows the value ‘(NULL)’. Welcome to this new #BestInMicro article! This is a space where I will be writing about different topics related to MicroStrategy, its use, best practices, and functionalities to get the most out of it. 1) Start- all programs - microstrategy -Tools -DB Queries There we can write the SQL queries accordingly to get the change in datawarehoouse. In the Operator list, select a comparison operator (Greater Than, Less Than. Open a dossier. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. 0. (A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. 1 app on an iOS device. MicroStrategy 11. Create one document with text box. Self-Service Analytics with Amica. MicroStrategy Telemetry Manager: This layer is the synchronization service between Telemetry Server(s),which is using Apache Zookeeper. Using either SQL for databases, or XQuery for Web Services applications, transactions trigger new business processes, re-allocate resources, and accelerate business activity. Despite being a virtual conference, this did not lessen the number of important product announcements made at the event. MicroStrategy is not responsible for errors or omissions. 1 and laterMicroStrategy owns 158,245 bitcoins as of September 24, 2023, at a total cost of $4. This report must contain the input object for each value that you want to allow users to change. 4. Founded in 1989 by Michael J. MicroStrategy is an enterprise BI application software. You can perform the following manipulations on the data in a dossier without adding a new dataset: Different data. There's a reason we're at the top of the list. Transaction Services and Pixel Perfect output, Dossiers are now more than capable of handling almost all your Business User needs. To retrieve a list of services on a machine, use the command mstrctl -m machinename ls. The DECODE function is another implementation of the 'if. ; In the Untitled Dossier window, in the Datasets panel, click New Data. x-10. The issue occurs anytime two or more rows are updated with different values and the 'submit' button is clicked. Configure transaction to the grid. 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. Click on "Configure Transaction". All articles. Request a demo. x, the last. A workaround is available in the current document. 0 is available to download from software. The transaction was aborted. 6. • Use a slider to select from a range of values. ACTION: 1) Right mouse click on the transaction grid, choose Thresholds->Advanced. KB441987. 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. It. The Transaction Conditions Editor opens. This knowledge base article describes an issue in MicroStrategy Mobile App for android where it still shows" MicroStrategy Mobile " in the confirmation pop-up message. Its flagship platform contains multiple features designed to help enterprises make data -driven decisions and optimize business processes. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. End users can use the Freeform SQL editor in Developer to create Transaction Service reports and then trigger the reports through documents. 5. void setTransactionCSI(DFCCSITransactionBase *ipTransactionCSI) DSSBinaryDataReader. is a business consulting services firm. The impact is from the MicroStrategy Web 10. There's a reason we're at the top of the list. 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. 4 HF2. Slowly Changing Dimensions. This is fixed in MicroStrategy Mobile Android application 10. Using Transaction Services-enabled documents. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. In the example shown above the syntax is incorrect as the call executed did not include the full list of necessary parameters. It is a. 4, presentation. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. Teradata 16. Select the corresponding option from the. 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. This document shows how list control works when option "Show by default" is checked or unchecked in transaction documents in MicroStrategy Mobile 10. Users are able to create editable transaction services grids in MicroStrategy Web 9. 4. x. "Too many simultaneous transactions" and "Access Logging step has failed. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Detailed steps to create a Transaction Services-enabled document are below. In fact administration most as often as possible offered due intelligence. If projects are distributed asymmetrically across the cluster, when you assign an event-triggered schedule to a project, make sure you trigger the event on all nodes on which that project is loaded. For steps to create a Transaction Services report, see the Advanced Reporting Guide. Right-click Change Journal Transactions and select Manage Change Journal. 0. x-10. Below record is found from DSSErrors log:There's a reason we're at the top of the list. The solution is provided along with screenshots and the specific values for each number of stars. Workstation is a unified tool that brings the power of administration and design together for the individual business user. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. Upgrade to this release to take advantage of this fix. MicroStrategy deployments with real-time telemetry capabilities. 4. Transaction Types: 1-3: Change Journaling will record any time the user turns it on, off or want to delete the history of the journal. LLC and. Similar to FFSQL reports, you can map an attribute form or a metric to a column of a table in the datasource. Without data, the dashboard will not show the user anything. It designs, develops, markets, and sells software platform through licensing arrangements and cloud-based subscriptions and related services. instancename is the name of a server instance, where required. 1 and above. 1*Y END. This technical note documents an issue with MicroStrategy Mobile app Android 9. Users would like to change the text of the Submit button for a Transactions Services report in MicroStrategy Web or Mobile 9. which can be created by adding an extra variable to the same package in which the cursor resides, as shown below:MicroStrategy (MSTR), the business software vendor that was co-founded by crypto proponent Michael Saylor, has added to its bitcoin ( BTC) stockpile, purchasing about 2,395 bitcoins for $42. 4. 27 it issued and sold 218,575 shares for $46. 6: Link Items are objects that link two or more other objects. When configuring transaction services documents in MicroStrategy Web 9. In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. 2. x-10. The Tutorial project includes sample data, such as actual customer names and items purchased. Instead, element order was always determined by attribute ID. Unlike in MicroStrategy Web 9. . 2. The combination of MicroStrategy and Google BigQuery enables end users to run ad-hoc analyses on massive datasets, query petabytes of. ACTION: The issue has been fixed in MicroStrategy Web 10. Think of Dossiers as a dry erase board. Upgrade to this release to take advantage of this fix. 4. Introduction. 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. Note: The user also needs to have View access in the transaction report’s ACL. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. #include <DSSTransactionReport. To access, follow these steps: Log into Web. L'infrastructure serveur complète est l'épine dorsale de toute implémentation MicroStrategy et offre tous les services de la plateforme principale, notamment:Enumerator; ObjectVCMode This mode implies an object such as a folder, report or document. In the Based On list, select the object to base the threshold on. Open "Item Order Form" in design mode. In MicroStrategy Developer 9. MicroStrategy also disclosed Wednesday that between Oct. Create a transaction document, as is shown below: 7. There's a reason we're at the top of the list. First up, Report Services Documents (or just “documents”) continue to remain an essential part of the MicroStrategy portfolio. 4. Dataflix is a software company focused switch emerging technological. Transaction Services supports write-back back (Insert, Update and Delete) from a Report Services Document to a Data Warehouse or Transaction Database (either directly or via a Web Service). 4. This is fixed in MicroStrategy Mobile Android application 10. Throughout the workflow of setting up and using a Transaction Services document in MicroStrategy 9. x supports INSERT, UPDATE, and DELETE DML. See lu_desktop for more details. 4 HF5 and 10. The combination of difficult markets and intricate deals presents risks and challenges that require a new set of skills, tools and insights. The latest innovation from the product labs, MicroStrategy Insights fundamentally transforms how users interact with data. in trading Thursday. A sales team might use a business dashboard to connect. ACTION. Updating Data by Using a Transaction Services-Enabled Document. In MicroStrategy Mobile 9. Or embed self-service capabilities for users to visualize key drivers or what-if scenarios. 47:25. The impact is limited to MicroStrategy Desktop 9. 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. The following steps will clear the text displayed in the popup titlebar:MicroStrategy said in a Twitter post Thursday that the $205 million loan it took out with Silvergate in March 2022 using its own bitcoin holdings as collateral is not due until the first quarter. You can perform these tasks directly from the document in Express Mode in MicroStrategy Web, and when you view the document on a mobile device with MicroStrategy Mobile. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. Use Transaction Services in your apps and documents to update data, write new information to your warehouse, or delete existing records. 1*X, Y=1. Number of Views 630. Visit the data visualization and data dashboard galleries for inspiration. ReportServiceCore/Headers/rwd/DSSOfflineTransactionCSIInfo. (BI), mobile software, and cloud-based services. pdf. Go to the documentation of this file. These tools and capabilities include interactive dashboards, scorecards, ad hoc queries, automated report distribution. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. 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,. The Configure Transactions Editor opens. About Uses. 1. Transaction service provides customers a way to modify data online through MicroStrategy Transaction Service documents. Dataflix is a software society focused on emerging products. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. else' logic in SQL by the ORACLE database. Example user without Execute transaction privilege. – Surveys. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. MicroStrategy provides ETL, data warehousing and data mining for data analysis. • Select values from a drop-down list. Transaction Services Calendar has no arrows to change months in MicroStrategy WebMicroStrategy, Inc. In the MicroStrategy Tutorial project, go to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy Transaction Services. Video Tutorial - Visualizations in MicroStrategy Dossier, Part 2: The Editor Panel. While dossiers are a great proposition when self-service, collaboration, responsive design, and fast content creation are key requirements; documents are still your best. void DSSOfflineTransactionCSIInfo::setKey (std::string iKey) void DSSOfflineTransactionCSIInfo::setTransactionCSI (DFCCSITransactionBase *MicroStrategy 소프트웨어를 설치하려면 MicroStrategy 다운로드 사이트에서 다운로드합니다. Our experts make it easier than ever to migrate and modernize your analytics on the MicroStrategy Cloud. 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. JSON Data API Demo - Streaming data from 600 IoT devices to a map by Robert Prochowicz. This technical paper discusses direct transactions with the database using the Freeform SQL. There's a reason we're at the top of the list. Transaction Services Calendar has no arrows to change months in MicroStrategy WebThere's a reason we're at the top of the list. 4 and 10. Users may need to set input data validation in transaction service document. 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. By this, I mean that we can disable, hide or validate the values that users are setting. Click OK. x, a transaction that updates multiple rows at one time will repeat the the last entry updated for all other updated rows. To select a date from a Calendar control, click the date. 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. Micro Strategy also supports mobile BI. There's a reason we're at the top of the list. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. 3. Click the arrow icon at the top right of the title bar to display a list of options, then select one of the following: To use the selector to. 4 HF5 and 10. 3. 10. If the Datasets pane is not visible, in the. 3. h. 20 — The high share price for Tysons software company MicroStrategy Inc. 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. 26 std::map<int, DSSColumnMappingInfo*> mColumnMap;. In Design Mode for that document, configure the transaction so that the Opportunity Size field has the option "Input is required," as shown below:Follow the steps below to reproduce the issue with MicroStrategy Tutorial project: 1. Data alerts work as a function of thresholding. Prerequisites • You must have Transaction Services. 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. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. 4, line breaks appear when viewing a Report Services Document in MicroStrategy Web 10. Then fill in with the necessary connection parameters. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. The dossier transaction configuration automatically generates the basic INSERT, UPDATE, and DELETE SQL statements with tokens according to the mapping view configuration. This report must contain the input object for each value that you want to allow users to change. The user privileges that take up a Transaction Services license are denoted by 4 asterisks (*) in the User Editor under User Manager > User Definition > Project. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more. 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. In MicroStrategy Web, edit or execute a report. CAUSE: This is known issue in MicroStrategy Web 9. In MicroStrategy Web 10. It allows users to update data, insert new information or delete existing records from the database. A project is the highest-level of intersection of a. Create three dataset reports, each with the testAnswer attribute and an attribute created from Table B. Connectivity via DSN. A dataset enables you to dynamically manipulate the data that appears on a dossier, without having to import a new dataset. x, a transaction that updates multiple rows at one time will repeat the the last entry updated for all other updated rows. DBMS Update Note: The new setting is only applicable if you are upgrading from MicroStrategy 2021 Update 2 to MicroStrategy 2021 Update 3. Transaction Services provide customers a way to modify data in a SAP HANA database online via MicroStrategy Transaction Service documents. Run the document using the MicroStrategy Mobile 9. Third party code/SQL: MicroStrategy Technical Support does not provide customized SQL queries. – Sales register. Another common scenario is when users need to review the content and accept it without making any changes to it. KB40413: How does user security work in a Report Services transaction document. STEPS TO REPRODUCE: Create a Transaction Services document that uses a Calendar control style for one of the inputs. 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. MicroStrategy cloud based services. x / 10. The software maker had revenue of $129. Browse courses: Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. Transaction Services Calendar has no arrows to change months in MicroStrategy WebThe message "()" appears after submitting a data change transaction via transaction services in MicroStrategy Web 9. ; On the Freeform Sources tab, select Create Transaction report. x-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. MicroStrategy is not responsible for errors or omissions. These columns will be updated once. There's a reason we're at the top of the list. 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. microstrategy. 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. Go to Preferences > Language. 9 product when trying to run a Transaction Services report in which a grid is being used to configure the transaction. 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. The job is stored in the fact_access_transaction_view fact table. Notice it runs successfully. x-10. 1 /*26 std::map<int, DSSColumnMappingInfo*> mColumnMap;. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. h> Public Member Functions DSSTransactionReport (GUID &iID, EnumDSSReportType iType): virtualDSSOfflineTransactionCSIInfos Class Reference. In the top toolbar, click Insert Visualization . Distribution Services: MicroStrategy provides ETL, data warehousing and data mining for data analysis. NET app using an ORM, but is it possible to integrate it with MicroStrategy?. Founder Michael Saylor explained how bitcoin has helped the company's stock compete. A document designer can create a Transaction Services-enabled document to allow analysts to. 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. Open the document in Presentation Mode. A transaction services document displays the value from a transaction with a manual input upon exporting to Excel, even though the label is what displays when viewed in MicroStrategy Web 9. h> Public Member Functions. Right-click the text field, Grid/Graph object, action selector link, or action selector button to define actions for and select Transaction Conditions. View AllFiles. 2) Data marting can be some times very helpfull in this situation( its just alternate way but not recomended )A blog on Microstrategy development and issues faced during development, deployment and maintenance. There is not workaround available for this issue in MicroStrategy 9. When users run this transaction document through MicroStrategy Mobile 9. 1 and Dec. The dossier. Starting in MicroStrategy 2021 Update 8, you can use REST API requests to retrieve, create, and update the transaction reports. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. KB438774: When running a Transaction Services document in MicroStrategy Web 10. MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. There's a reason we're at the top of the list. 4. Using additive the seasonal relapse for Revenue F. However, users should also consider the maximum memory consumption limit for exporting to Excel. 9 and 10. MSTR Transformation Metal with no aggreagation; MSTR Delineate sets of privileges: Security roles; MSTR VLDB SQL. h. The software maker reported ($8. product documentation and applicable. 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. i686 패키지를 설치해야. This is relevant to MicroStrategy Web 9. x, users will come across two similar settings in Developer and Web in regards to. 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. The same document works normally in Mobile. This Knowledge Base article describes a known issue that calendar in Transaction Services set to Spanish reverts to English on MicroStrategy Android Mobile 10. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. The issue occurs anytime two or more rows are updated with different values and the 'submit' button is clicked. Introduction MicroStrategy Transaction Services (TS) is a new feature in MicroStrategy 9. You must have the Web Configure Transaction privilege. Save the FreeForm SQL and Run the report. The output parameter needs a placeholder. In the image below, the first column from the left is the ID of the attribute in the second column. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. It visualises interactive dashboards, charts and graphs and improves analytics and. x, they are presented with an iOS-styled calendar picker that allows users to scroll through the month, day, and year. 4. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Then set the min and max values, as seen below. 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. “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, MicroStrategy creates optimized SQL for Snowflake and it is always recommended to be on the latest MicroStrategy release to take advantage of the most optimal performance. There's a reason we're at the top of the list. The same document works normally in Mobile. Here the transaction document grid is not an editable element and the submit button is hidden. This knowledge base article describes an intermittent behavior in MicroStrategy Web 10. Web Professional. MicroStrategy Incorporated is an American company that provides business intelligence (BI), mobile software, and cloud-based services. virtual const string& IDSSSourceModelForTransaction::getNodeKey : pure virtual: Implemented in DSSRWNodeModel, DSSRWNodeModel, DSSDataModelBase, and DSSDataModelBase. 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. pdf. x-10. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. 29KB. • while MicroStrategy maintains the supporting cloud-based infrastructure. 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. Client - Reporter: A consumer license that allows ends. Transactions from Transaction Services are not Getting Inserted to the Data Warehouse, but MicroStrategy Web Shows that it was Successful. This article outlines that Hive does not fully support transaction services, and MicroStrategy does not allow the use of transaction services for Hive. The report can be executed in MicroStrategy Web. Right-click the grid report, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. 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. MicroStrategy transactions do not have desktops and, therefore, always map to a default value. MicroStrategy Intelligence Server MicroStrategy Server はすべてのユーザー ロールにとって有益です。 完全な機能を備えたインフラストラクチャは、すべての MicroStrategy 実装の土台であり、次のようなコア プラットフォーム サービスを提供します。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,. The input data validation can be achieved with threshold in MicroStrategy web. 4. x. When users run this transaction document through MicroStrategy Mobile 9. 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. KB442534: In MicroStrategy Web, a Transaction Services text box inside a Document shows the value ‘(NULL)’ Description. This means that a different set of Freeform SQL is sent to the warehouse for each panel. By default, "Export to Excel" max memory usage is set to 100 MB. . This is on top of many other enhancements available for Workstation. 1. A Job is any request to the system submitted by users from the MicroStrategy platform. Designed with automatic alerts, Insights is powered by machine learning (ML) models to analyze data behind the scenes and surface key trends, outliers, or anomalies. 3. 1 product only with Transaction Services Documents using the "Mark rows for selection" option. New password: Enter the new password. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Transaction. II. 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 new data such as text and number inputs, calendar, camera, GPS, switches, steppers, star ratings and sliders. Transaction Services provide customers a way to modify data in a SAP HANA database online via MicroStrategy Transaction Service documents. There's a reason we're at the top of the list. For steps to create a Transaction Services report, see the Advanced Reporting Guide. However, since a text prompt cannot be directly incorporated in a report object, it. 98) earnings per share for the quarter, missing analysts' consensus estimates of $0. View the following image for reference: Why is this happening? Smart Metric calculations take place in the Analytical Engine, while all transactions must, by definition, take place on the database. 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,. These grids can extend past the length of the panel they are contained in, thus creating a scroll bar on the grid. Click the MicroStrategy icon at the top of the page and select Preferences. Select the appropriate options to define conditions for each action, as described above.