For this point admins need to try the three options and see which one has better performance. MicroStrategy uses advanced analytics, reporting, data visualizations, embedded. x-10. 4, presentation. To connect to MicroStrategy manually, do the following: Start MicroStrategy Workstation. In the MicroStrategy Tutorial project, go to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy Transaction Services. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. Instead, element order was always determined by attribute ID. When configuring transaction services documents in MicroStrategy Web 9. Right click on the "Units Requested". 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. Create a report with attribute Category. The input data validation can be achieved with threshold in MicroStrategy web. Use your MicroStrategy credentials. 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,. You may have noticed that when you right-click on an object that has a transaction configured, the “Transaction Conditions” option appears. This is fixed in MicroStrategy Mobile 10. engages in the provision of enterprise analytics and mobility software. Without data, the dashboard will not show the user anything. To Create a Transaction Services Report In MicroStrategy Developer, choose File > New > Report. Connect to MicroStrategy manually. In MicroStrategy Web 10. 1 and above, any changes to the Fill color of an Action Selector Button are not reflected when running the document in Express Mode. Watch this live session on all things dossier and the power of compelling design. Select the appropriate options to define conditions for each action, as described above. We have an option in Microstrategy called Transaction services where we could capture the user responses on their performances and those comments were updated to our DB. The dossier. 9 product when trying to run a Transaction Services report in which a grid is being used to configure the transaction. However, since a text prompt cannot be directly incorporated in a report object, it. Detailed steps to create a Transaction Services-enabled document are below. There is not workaround available for this issue in MicroStrategy 9. Steps to apply thresholds to a metric on a report. x, after the "Mark Rows for Selection" option is enabled. x-10. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. This article outlines that Hive does not fully support transaction services, and MicroStrategy does not allow the use of transaction services for Hive. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. MSTR The key specified is the truer key for the war. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. Login to MSTR Developer then go to: User Manager > User Definition > Project Access. Re - run against the warehouse. 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. 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. 0:00 / 9:26 Using MicroStrategy Transaction Services MicroStrategy Community 4. The input data validation can be achieved with threshold in MicroStrategy web. Interacting with data sources. 5. MicroStrategy is an enterprise business intelligence ( BI) application software vendor. There's a reason we're at the top of the list. Navigate to and select a Transaction Services report, then click OK. KB442534: In MicroStrategy Web, a Transaction Services text box inside a Document shows the value ‘(NULL)’. x / 10. Web Professional. The retail store sells electronics, books, movies, and music. Right-click the metric for which to add a threshold and choose Thresholds. The following options are available: Ø Transaction Mapping options. 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. 1 that supports write-back (Insert, Update and Delete) from a Report Services Document to a Data Warehouse or Transaction Database. Save the FreeForm SQL and Run the report. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe user privileges that take up a Transaction Services license are denoted by 4 asterisks (****) in the User Editor. 74 by $9. Conditions can vary in complexity depending upon the type of threshold that is created. 12K subscribers 14K views 5 years ago Building Reports and Documents In this video tutorial, Doug Terbush from. Design intuitive analytics reports with MicroStrategy ONE. You can still access our MicroStrategy Community knowledge base and contact Support for assistance with any issues. The third-party product(s) discussed in this article is manufactured by vendors independent of MicroStrategy. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. KB441987. We were able to show these comments in the. Transaction-enabled Documents. Introduction. MicroStrategy, Inc. Plus, it connects business apps while integrating data. In these cases, default values are applied. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. While dossiers are a great proposition when self-service, collaboration, responsive design, and fast content creation are key requirements; documents are still your best. 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. 0. Ø Local Transaction options. 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. 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 prompt is used in a filter. 59:11. 6 and 10. When you import data into MicroStrategy Web, the corresponding dataset is stored with the dossier. 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. The condition is based on either an attribute or metric. You will learn how to add and manipulate data, charts, graphs, images, and other elements to design interactive and informative documents. This could be MicroStrategy user in the metadata or an external contact added by a MicroStrategy user. #include <DSSTransactionReport. Similar to FFSQL reports, you can map an attribute form or a metric to a column of a table in the datasource. ) The dashboards I prepared were connected to the Ticketing system called Zendesk, where we would capture a team's performance. Configure the Submit button. For instructions, see the MicroStrategy Web Help or the MicroStrategy Mobile Analysis Help. 4-XX. The Tutorial project includes sample data, such as actual customer names and items purchased. Financial Services Healthcare Retail Government Resources Connect Events World 2024 Community & Support Partner Network. MicroStrategy Incorporated is an American company that provides business intelligence (BI), mobile software, and cloud-based services. 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. Video Tutorial - Visualizations in MicroStrategy Dossier, Part 2: The Editor Panel. 1. x. 27 DFCCSITransactionBase* mpTransactionCSI;. There's a reason we're at the top of the list. txt. Released in the 10. . STEPS TO REPRODUCE: Create a Transaction Services document that uses a Calendar control style for one of the inputs. To select a date from a Calendar control, click the date. 4-5: Records when saving one or more objects. 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. Using the 'Tab' key on the grid will navigate to the next available editable cell on the grid. 3. This issue does not occur when using the MicroStrategy Mobile 9. These grids can extend past the length of the panel they are contained in, thus creating a scroll bar on the grid. Configure a Transaction Grid. 4 HF5 and 10. 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. While database instances commonly point to a relational database, you can also create Freeform SQL. If the transaction services enabled grid is long enough, like shown above, as the user scrolls. Depending on the way the document is designed, you may be able to manipulate data in the following ways: • Edit text or numerical values in a text box. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. This new feature allows to push data directly into in-memory cubes. Another common scenario is when users need to review the content and accept it without making any changes to it. There's a reason we're at the top of the list. ReportServiceCore/Headers/rwd/DSSOfflineTransactionCSIInfo. x, they are presented with an iOS-styled calendar picker that allows users to scroll through the month, day, and year. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The output parameter needs a placeholder. Then create… To Create a Transaction Services Report. Create a transaction services document with a submit button. Analytics means optimized for working with large amounts of data, and complex operations such as aggregation and joins against disparate data, whereas OLTP largely focuses on operations performing single row insertions and deletions, transactions, and locking, etc. In MicroStrategy Web 10. DOSSIER – Main Feature. Below are some performance considerations which will help you achieve better performance with MicroStrategy. 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. Note: Make these modifications and re-publish the cube to find out which combination gives better performance. Numerous elements on its main platform are intended to support businesses in making data-driven choices and streamlining operational procedures. Use the Freeform SQL editor via MicroStrategy Developer to create transaction services reports and then trigger the reports through documents. Transaction Services: Transaction services are third party services gave by an professional service firm, or a venture bank when a business exchange happens. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. All articles. With MicroStrategy Transactions services support for SQL Server, users can record selections in a SQL Server table. x, a transaction that updates multiple rows at one time will repeat the the last entry updated for all other updated rows. in trading Thursday. Here we have compiled a set of MicroStrategy interview questions asked in top organizations around the world. 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. The software maker reported ($8. Create 2nd freeform SQL (This is going to be transaction report); 4. 1 and above. x-10. 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,. Below is an example of ACID property in DBMS: Transaction 1: Begin X=X+50, Y = Y-50 END Transaction 2: Begin X=1. int LoadDefnFromBinary(DSSBinaryDataReader *ipReader) DSSOfflineTransactionCSIInfos::Count. Set these 3 panel stacks as the target and enable "Submit transaction in order". The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. Description. 4. Choose Grid > Grid (Modern). KB40413: How does user security work in a Report Services transaction document. In MicroStrategy Mobile 9. 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. The same document works normally in Mobile. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. Number of Views 630. Right-click the text field, Grid/Graph object, action selector link, or action selector button to define actions for and select Transaction Conditions. 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. pdf. Go to the documentation of this file. 4. Microstrategy Dossiers With the release of MicroStrategy 10. Visualizations in MicroStrategy Dossier, Part 4: The Presentation Layer. MicroStrategy is not responsible for errors or omissions. Or embed self-service capabilities for users to visualize key drivers or what-if scenarios. 72. 4. 5. Run document, select "Hootie & Blowfish" from the drop-down, click submit, issue observed. 98) earnings per share for the quarter, missing analysts' consensus estimates of $0. 2. MicroStrategy Telemetry Manager: This layer is the synchronization service between Telemetry Server(s),which is using Apache Zookeeper. There's a reason we're at the top of the list. There are few ways. Transaction Services provide customers a way to modify data in a SAP HANA database online via MicroStrategy Transaction Service documents. x where users need to click outside of the Info Window only once to close it, In MicroStrategy Web 9. There's a reason we're at the top of the list. However, users should also consider the maximum memory consumption limit for exporting to Excel. 3. Do you see the true potential of Transaction Aids, one of MicroStrategy's flagship features?In some situations, users may want to remove the MicroStratey branding from this popup. This is fixed in MicroStrategy Mobile Android application 10. • Select values from a drop-down list. x-10. To view the selector properties for a Transaction Services selector, see Properties and Formatting Dialog Box: Selector. To access, follow these steps: Log into Web. To learn more about the Required column, refer to article KB207490. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. Related Topics. Apr 12, 2019. x-10. The Thresholds. Upgrade to this release to take advantage of this fix. 4. 1*Y END. 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). 3. The issue has been classified as a defect by MicroStrategy. Most frequent use cases. 1 for iPad, users can setup a transaction services document to read a barcode, using the barcode scanner input, then to submit the value scanned to the database. Continue to the steps provided in To select a configuration task. 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,. – Control panels. ; In the Source area, select the database instance for the data source to be updated using Transaction Services. 4, presentation. The format of the DECODE function is as follows: DECODE (<value>, <statement1>, <directive1>, <directive_default>) To understand the meaning of and the construction of DECODE, look at how the previous query would have been written using. On the Freeform Sources tab, select Create Transaction report. SettingsVCMode This mode implies the settings screen. Using Transaction Services-enabled documents. 29KB. “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. txt file>. 4 million under a previously announced sales agreement with Cowen and Co. It allows users to update data, insert new information or delete existing records from the database. Micro Strategy also supports mobile BI. For steps to create a Transaction Services report, see the Advanced Reporting Guide. New password: Enter the new password. 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. This technical note is intended to show examples on different databases to use stored procedures within Freeform SQL reports in MicroStrategy . 2. Refer to the Advanced Reporting Guide for more information on Transaction Services reports. This issue has been classified as a defect by MicroStrategy. , the New York store is part of the Northeast Region. II. MicroStrategy Incorporated (NASDAQ:MSTR) announced its quarterly earnings data on Wednesday, November, 1st. MicroStrategy deployments with real-time telemetry capabilities. Transaction 2 is crediting each account with a 10% interest payment. A project is the highest-level of intersection of a. 4 HF2. Once the best combination is determined, admins can test the deletion and see if the performance improves there. 0. KB438774: When running a Transaction Services document in MicroStrategy Web 10. Note: If a user enters more than 15 digits for a. Data alerts work as a function of thresholding. 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 MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. MicroStrategy provides ETL, data warehousing and data mining for data analysis. For example, type the command: . It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. The big number: MicroStrategy stock surges with bitcoin. When users run this transaction document through MicroStrategy Mobile 9. h> Public Member Functions DSSTransactionReport (GUID &iID, EnumDSSReportType iType): virtualDSSOfflineTransactionCSIInfos Class Reference. Upgrade to this release to take advantage of this fix. 4. com, to provision on our MicroStrategy for AWS provisioning console, and via the respective app stores for iOS and Android. engages in the provision of enterprise analytics and mobility software. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. x. In MicroStrategy Web, edit or execute a report. This is fixed in MicroStrategy Mobile Android application 10. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. View AllFiles. x-10. Open the document in Presentation Mode. Here t he transaction document shows the editable elements and the submit button. There's a reason we're at the top of the list. 4. MicroStrategy Transaction Services lets you embed write-back functionality into documents for the purposes of decision-making or initiating a transaction. A threshold is made up of two parts: the condition and the formatting you apply to the values that meet the condition. For steps to create a Transaction Services report, see the Advanced Reporting Guide. In MicroStrategy Developer 9. Starting with 9. Calling Stored Procedures from Microstrategy. This report must contain the input object for each value that you want to allow users to change. Users may configure a transaction field to be used as a calendar picker in MicroStrategy Web 9. Users would like to change the text of the Submit button for a Transactions Services report in MicroStrategy Web or Mobile 9. 6/9 videos | 5H 34M 40S total runtime. 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. 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. to carry out transactions and to profile users in order to. 9 and 10. MicroStrategy 11. This is on top of many other enhancements available for Workstation. This technical note documents an issue with MicroStrategy Mobile app Android 9. Open a dossier without data. 1. 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. h> Public Member Functions DSSTransactionReport (GUID &iID, EnumDSSReportType iType): virtualFile List; File Members; DSSCManipulationDiscardTransaction. The impact is from the MicroStrategy Web 10. 1. Go to the properties of the Action Selector's properties > General > Display Text as shown below. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. x-10. 2. MicroStrategy Document Creation Guide is a comprehensive manual that teaches you how to create and format various types of documents using MicroStrategy tools. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. h:36. Prerequisite: 1. 1, users can now execute a transaction without modifying values. x, prompted text cannot be displayed in a Report Services document unless the prompt is in the dataset of the document. Open the document in Presentation Mode. x. For a transaction services grid, attribute elements with the same value seem to. Using documents in MicroStrategy Web. This will remain until the user clicks within the text. Click More in the upper right corner of the visualization and choose Configure Transaction. pdf. If both transactions are submitted together, there is no. In MicroStrategy 2021 Update 6, dossier users with the proper privileges can modify data and submit data changes to the database. 4. MicroStrategy Transaction Services lets you embed write-back functionality into reports and dashboards for the purposes of decision-making or initiating a transaction. x-10. 4. There's a reason we're at the top of the list. 4, presentation. h:28. Create three dataset reports, each with the testAnswer attribute and an attribute created from Table B. MicroStrategy stock is up roughly 246% in 2023, and jumped more than 6% on Thursday. It is a. This supports the scenario that a user only wants to update values for certain metrics or attributes, while leaving the other. The Transaction Conditions Editor opens. 10. 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. h> Public Member Functions. 68 billion USD,. Run the document using the MicroStrategy Mobile 9. Below are the new features exclusive to. This technical paper discusses direct transactions with the database using the Freeform SQL. 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. There's a reason we're at the top of the list. MSTR Transformation Metal with no aggreagation; MSTR Delineate sets of privileges: Security roles; MSTR VLDB SQL. • Use a slider to select from a range of values. 3. Companies of all sizes use this platform to assess, visualise, and build dashboards. MicroStrategy 11. Select the corresponding option from the. This is on top of many other enhancements available for Workstation. This report must contain the input object for each value that you want to allow users to change. Run the report services document on iPad against MicroStrategy Mobile 10. 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. 1 Update 1, where a date submitted through a transaction services document is stored in an unexpected format in the transaction database table. If the User is logging in via typing Guest, the button appears correctly and can be used to execute the transaction. 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. x and Google BigQuery Whitepaper. 4 and 10. x-10. If this cell falls below the end of. There's a reason we're at the top of the list. User can either click “Test” to verify the connectivity or just go ahead and click “Finish” to complete the DSN creation. In some situations, users may want to remove the MicroStratey branding from this popup. By default, "Export to Excel" max memory usage is set to 100 MB. 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. h. In MicroStrategy Developer, choose File > New > Report. then. 1 iOS Update 3, the barcode scanner input will not update the value of the textbox with that of the scanned barcode. 1. Introduction. LLC and. 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. By this, I mean that we can disable, hide or validate the values that users are setting. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 28 public:MicroStrategy Workstation lets you control how MicroStrategy Intelligence Server manages joins, metric calculations, query optimizations, and more for reports, documents, and dossiers. Run the transaction document and submit data. In fact administration most as often as possible offered due intelligence. This feature is available when you install Transaction Services. 1. i686 패키지를 설치해야. 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. Example user without Execute transaction privilege. Transaction Services Calendar has no arrows to change months in MicroStrategy WebMicroStrategy, Inc. void DSSOfflineTransactionCSIInfo::setKey (std::string iKey) void DSSOfflineTransactionCSIInfo::setTransactionCSI (DFCCSITransactionBase *MicroStrategy 소프트웨어를 설치하려면 MicroStrategy 다운로드 사이트에서 다운로드합니다. But in reality, many of these dimensional relationships change over time. Open "Item Order Form" in design mode. 1 iOS app. MicroStrategy finds answers, information, and insights for business data analysis. 3 for iPhoneMicroStrategy comes with a sample project called MicroStrategy Tutorial. bigint(20) recipient_id . el6. MicroStrategy Transaction Services lets you embed write-back functionality into documents and dashboards for the purposes of decision-making or initiating a transaction. ACTION: 1) Right mouse click on the transaction grid, choose Thresholds->Advanced. g. 4. A workaround is available in the current document. 0, a grid can be configured so that the user can input values to an attribute column. 4. Notice it runs successfully. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. 1, the "Editable" checkbox is grayed out for a Smart compound metric. Users may need to set input data validation in transaction service document. In MicroStrategy Developer, open a report.